mybatis 中的foreach标签

映射xml文件中：

    <select id="select3" resultType="Dept" parameterType="integer">
        select * from dept where  deptno in
    <foreach collection="list" open="(" separator="," close=")" item="item">
        #{item}
    </foreach>
    </select>

    <select id="selectByArray" parameterType="integer" resultType="dept">
        select * from dept where deptno in
        <foreach collection="array" item="id" open="(" separator="," close=")">
            #{id}
        </foreach>
    </select>

 接口中方法：

    public List<Dept> select3(List<Integer> list);
    public List<Dept> selectByArray(Integer[] array);

测试方法：

        SqlSession sqlSession = SqlSessionGet.GetSqlSession(true);
        DeptDao deptDao = sqlSession.getMapper(DeptDao.class);



        List<Integer> list=new ArrayList();
        list.add(100);
        list.add(200);
        for (Dept dept : deptDao.select3(list)) {
            System.out.println(dept);
        }


        for (Dept dept : deptDao.selectByArray(new Integer[]{100, 200,10})) {
            System.out.println(dept);
        }