mybatis 中 foreach的用法

在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）查下数据：