ibatis in查询处理

如果入参就是一个list，可以简单这么写：

    <select id="GamecenterEntity.findByItemIds" parameterClass="java.util.ArrayList" resultMap="entityDOMap">
        SELECT
        <include refid="GamecenterEntity.columns.all" />
        FROM gamecenter_games WHERE ITEM_ID IN
        <iterate conjunction="," open="(" close=")">
            #itemIds[]#
        </iterate>
    </select>

 

如果入参是一个复杂对象的话，可以这么写：

    <select id="IbatisGameServiceAreasDAO.latestOpenAreaList" parameterClass="gameServiceAreasQuery" resultMap="serviceAreasResultMap">
        SELECT
        <include refid="game.service.area.columns.all"/>
        FROM GAME_SERVICE_AREAS
        WHERE BIZ_TYPE = #bizType# AND STATUS = #status#
        <isNotEmpty prepend="AND" property="gameIdList">
            GAME_ID NOT IN
            <iterate conjunction="," open="(" close=")" property="gameIdList">
                #gameIdList[]#
            </iterate>
        </isNotEmpty>
        ORDER BY ONLINE_TIME DESC
        LIMIT #startRow#, #pageSize#
    </select>