mybatis查询通过List参数查询表数据mapper写法
java:
List<String> ids = new ArrayList<String>();
dao.findIds(ids);
mapper:
<if test="ids!= null and ids.size() > 0">
AND a.id in
<foreach item="item" collection="ids" separator="," open="(" close=")" index="">
#{item}
</foreach>
</if>

浙公网安备 33010602011771号