foreach循环Map
为Map时候需要确认parameterType="java.util.Map",且collection为Map中要便利的key值
Java文件
Map<String,Object> map=new HashMap<String,Object>();
map.put("tikuId", tikuId);
map.put("userIdList",userIdList);
allScored.addAll(scoredMapper.selectAllScoreIsAllError(map));
List<Scored> selectAllScoreIsAllError(Map map);
XML文件
<select id="selectAllScoreIsAllError" parameterType="java.util.Map"
resultMap="ScoreWithCountAndTime">
select DISTINCT tiku_id,user_name,a.user_id
from XXXX a join tb_user b on
a.user_id=b.user_id
where tiku_id=#{tikuId}
<if test="userIdList !=null and userIdList.size()>0">
and a.user_id not in
<foreach collection="userIdList" item="list" index="index"
open="(" close=")" separator=",">
<if test="list!=null">
#{list}
</if>
</foreach>
</if>
</select>
List
int updateVideoTbSetUserBeDeleted(List<String> list);
为List时候需要确认parameterType="Java.util.List",且collection为list
<update id="updateVideoTbSetUserBeDeleted" parameterType="java.util.List">
<if test="list!=null and list.size()>0">
update XXXXX set video_upload_uname='用户消失啦'
where video_id in
<foreach collection="list" item="item" index="index" open="(" close=")" separator=",">
<if test="item!=null">
#{item}
</if>
</foreach>
</if>
</update>