IBatis常用操作

公司技术较老，使用的iBatis，即MyBatis 曾经的版本，整理了以下常用操作，方便索引：

组装in语句，参数为数组

<select id="selectOrgIdByNameStr" resultClass="Integer">
SELECT id
FROM org
WHERE name IN
<iterate close=")" open="("  conjunction=",">
    <![CDATA[
             #[]#
        ]]>
</iterate>
</select>

@Override
public List<Integer> selectOrgIdByNameStr(String[] orgArchArr) {
    return baseDao.queryForList("org.selectOrgIdByNameStr", orgArchArr, String.class);
}

组装in语句，参数为List对象

<select id="searchWaiters" parameterClass="java.util.List" resultClass="com.chat.domain.zone.WaiterCgExt">
    SELECT *
    FROM waiter w, org o
    WHERE o.id = w.org_id
        AND w.id IN <iterate open="(" close=")" conjunction=",">
            #wid[]#
        </iterate>
</select>

@Override
public List<WaiterCgExt> searchWaiters(ModAccManVo vo) {
    List<Integer> widList = baseDao.queryForList("zone.waiter.searchWaitersId", vo, Integer.class);
    if(CollectionUtils.isEmpty(widList)) {
        return new ArrayList<WaiterCgExt>();
    }
    return baseDao.queryForList("zone.waiter.searchWaiters", widList, WaiterCgExt.class);
}

组装in语句，参数为List复杂元素类型

<select id="selectWaitersByOrgList" resultClass="com.chat.domain.zone.Waiter" parameterClass="java.util.List">
    SELECT id, pin as userName
    FROM waiter
    WHERE org_id IN
        <iterate open="(" close=")" conjunction=",">
            #list[].id#
        </iterate>
</select>

组装in语句，参数为map，其某个元素为List

<select id="query" resultClass="BopEntityTag" parameterClass="map">
    Select *
    FROM ***_tag
    WHERE tag_value != 0
    <isNotNull property="q.codeSet" prepend="AND"> code IN
        <iterate open="(" close=")" conjunction="," property="q.codeSet"> #q.codeSet[]# </iterate>
    </isNotNull>
</select>

@Override
public List<BopEntityTagDO> query(***TagDO query) {
    Map<String, Object> params = new HashMap<String, Object>();
    params.put("q", query);
    ......
    return queryForList(getStatementName("query"), params);
}

参考

• https://blog.csdn.net/bruce128/article/details/22098795