在mybatis(mybatis-3.4.5)的官方文档中,给了仅仅这么一个例子:
<select id="selectPostIn" resultType="domain.blog.Post">
SELECT *
FROM POST P
WHERE ID in
<foreach item="item" index="index" collection="list"
open="(" separator="," close=")">
#{item}
</foreach>
</select>
这里的collection可以是:array,list,map,set,这里试验一下array:
1)准备数据
2)一次性删去几个数据
a)映射文件
<delete id="deleteUser">
delete from t_user where id in
<foreach collection="array" item="id" open="(" close=")" separator=",">
#{id}
</foreach>
</delete>
b)java代码
SqlSession session=null;
try {
session=myBatisUtil.getSqlSession();
Integer[] ids = new Integer[]{1,3,4,5};
session.delete("deleteUser",ids);
session.commit();
} catch (Exception e) {
e.printStackTrace();
session.rollback();
}finally{
session.close();
}
3)结果:
2018-09-30 15:33:02 DEBUG x.y.z.deleteUser:159 - ==> Preparing: delete from t_user where id in ( ? , ? , ? , ? , ? )
2018-09-30 15:33:02 DEBUG x.y.z.deleteUser:159 - ==> Parameters: 1(Integer), 3(Integer), 4(Integer), 5(Integer), 8(Integer)
2018-09-30 15:33:02 DEBUG x.y.z.deleteUser:159 - <== Updates: 4
4)查下数据: