controller 内Java代码:
List ids=new ArrayList();
ids=Arrays.asList(arr);
params.put("ids",ids );
data1=mapper.getTable2(params);
mapper.java 文件查询方法定义:
List getTable2(@Param("params") Map params);
xml内sql遍历list代码:
<if test=" params.ids != null">
and a.product_id in
<foreach item="item" collection="params.ids" separator="," open="(" close=")" index="index">
'${item}'
</foreach>
</if>