<selectid="getOnlineUser"resultMap="OnlineUserMap">
SELECT <includerefid="OnlineUser_Column_List"/>
FROM SYS_LOGIN_LOG WHERE SESSION_ID IN
<foreachcollection="sessions"item="session"index="index"open="("separator=","close=")">
#{session}
</foreach>
AND STATE = 'ONLINE'
</select>
修改后
<selectid="getOnlineUser"resultMap="OnlineUserMap">
SELECT <includerefid="OnlineUser_Column_List"/>
FROM SYS_LOGIN_LOG WHERE SESSION_ID IN
<trimsuffixOverrides=" OR SESSION_ID IN()"><foreachcollection="sessions"item="session"index="index"open="("close=")"><iftest="index != 0"><choose><whentest="index % 1000 == 999">) OR SESSION_ID IN (</when><otherwise>,</otherwise></choose></if>
#{session}
</foreach></trim>
AND STATE = 'ONLINE'
</select>