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>

posted @ 2021-05-19 16:38  修改了思绪~  阅读(524)  评论(0)    收藏  举报