mybatis动态sql之foreach补充（二）

发布时间：2020-12-14 18:02:39 所属栏目：大数据来源：网络整理

导读：对于入参为数组： public ListEmployee getEmpByForeach3(Integer [] ids); 我们使collection="array" select id ="getEmpByForeach3" resultType ="com.gong.mybatis.bean.Employee" select * from tbl_employee where id in foreach collection ="array" i

对于入参为数组：

    public List<Employee> getEmpByForeach3(Integer [] ids);

我们使collection="array"

    <select id="getEmpByForeach3" resultType="com.gong.mybatis.bean.Employee">
        select * from tbl_employee where id in
        foreach collection="array" item="item" separator="," open="(" close=")"
            #{item}
        </foreach>
    select>

并直接利用#{}接直接获取对应的值。

            Integer [] arr = {1,2,3};
            List<Employee> es = mapper.getEmpByForeach3(arr);
            for(Employee e:es) {
                System.out.println(e);
            }

输出：

DEBUG 01-21 16:31:10,332 ==>  Preparing: select * from tbl_employee where id in ( ?,?,? )   (BaseJdbcLogger.java:145) 
DEBUG 01-21 16:31:10,371 ==> Parameters: 1(Integer),2(Integer),3(Integer)  (BaseJdbcLogger.java:145) 
DEBUG 01-21 16:31:10,433 ==      Total: 3  (BaseJdbcLogger.java:145) 
Employee [id=1,lastName=dema,1)">genderemail=dema@qq.com,1)">dept=null]
Employee [id=2,1)">=jack,1)">=675544321@qq.com,1)">=3,1)">=小红,1)">=0,1)">=xiaohong@qq.com,1)">=null]

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!