MyBatis传入参数为list、数组、map写法

最新推荐文章于 2022-09-08 09:26:21 发布

原创最新推荐文章于 2022-09-08 09:26:21 发布 · 257 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java

Mybatis 专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了在MyBatis中如何使用List、数组及Map作为参数进行SQL查询的方法。通过具体的代码示例展示了不同类型的参数如何应用于XML映射文件中的SQL语句，帮助开发者更好地理解和掌握MyBatis的参数传递技巧。

public interface EmployeesMapper {   

    List<Employees> getEmployeesListParams(List<String> employeeIds);  

    List<Employees> getEmployeesArrayParams(String[] employeeIds);  

    List<Employees> getEmployeesMapParams(Map<String,Object> params);  
}

public class Employees {  
    private Integer employeeId;  
    private String firstName;  
    private String lastName;  
    private String email;  
    private String phoneNumber;  
    private Date hireDate;  
    private String jobId;  
    private BigDecimal salary;  
    private BigDecimal commissionPct;  
    private Integer managerId;  
    private Short departmentId;  
}

<!--List:forech中的collection属性类型是List,collection的值必须是:list,item的值可以随意,Dao接口中参数名字随意 -->  
    <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>  

    <!--Array:forech中的collection属性类型是array,collection的值必须是:list,item的值可以随意,Dao接口中参数名字随意 -->  
    <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>  

    <!--Map:不单单forech中的collection属性是map.key,其它所有属性都是map.key,比如下面的departmentId -->  
    <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>

[url]http://blog.youkuaiyun.com/s592652578/article/details/52871884[/url]
[size=medium][color=red][b]深入了解MyBatis参数[/b][/color][/size]
[url]http://blog.youkuaiyun.com/isea533/article/details/44002219[/url]

[color=green][b]推荐的MyBatis传参方式List、数组等[/b][/color]
[url]http://blog.51cto.com/13523664/2060417[/url]