mybatis 传参是list ,array, map

最新推荐文章于 2023-06-15 13:43:09 发布

原创最新推荐文章于 2023-06-15 13:43:09 发布 · 369 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java

mybatis java 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了使用MyBatis进行批量查询的方法，包括通过List、Array及Map参数进行的批量查询实现方式。针对不同类型的输入参数，展示了如何利用<foreach>标签来构建SQL IN子句，从而提高查询效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<select id="getEmployeesListParams" resultType="Employees">
        select *
        from EMPLOYEES e
        where e.EMPLOYEE_ID in
        <foreach collection="list" item="employeeId" index="index"
            open="(" close=")" separator=",">
            #{employeeId}
        </foreach>
    </select>

    
    <select id="getEmployeesArrayParams" resultType="Employees">
        select *
        from EMPLOYEES e
        where e.EMPLOYEE_ID in
        <foreach collection="array" item="employeeId" index="index"
            open="(" close=")" separator=",">
            #{employeeId}
        </foreach>
    </select>

    
    <select id="getEmployeesMapParams" resultType="Employees">
        select *
        from EMPLOYEES e
        <where>
            <if test="departmentId!=null and departmentId!=''">
                e.DEPARTMENT_ID=#{departmentId}
            </if>
            <if test="employeeIdsArray!=null and employeeIdsArray.length!=0">
                AND e.EMPLOYEE_ID in
                <foreach collection="employeeIdsArray" item="employeeId"
                    index="index" open="(" close=")" separator=",">
                    #{employeeId}
                </foreach>
            </if>
        </where>
    </select>