如果入参就是一个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>