1.select中传入map,map中包含list
后台代码:
List<String> bhList = ztryArchivesMapper.queryZjbhsByQcd(queryMap);
paramsMap.put("bhList", bhList);
PageHelper.startPage(pageNum, pageSize);
List<Ztry> list = ztryMapper.queryZtryListByCondition(paramsMap);
xml种的代码:
<if test="bmList != null and bmList.size != 0">
AND zjhm in
<foreach close=")" collection="bmList" item="listItem" open="(" separator=",">
#{listItem}
</foreach>
</if>
解释:collection对应的就是map种list的key。
2.insert中传入list
xml中错误的写法:
<insert id="insertGz" parameterType="java.util.Map">
insert into ${tableName} (user_id,field_id)
values
<foreach item=