mybatis传入List参数或者单个String 参数等问题

一：在Userdao里面定义一个方法

 public int deleteBatch(List<String>  ids);

在对应的UserDao.xml

错误写法

<delete id="deleteBatch">
DELETE FROM s_user
WHERE id in
<foreach item="ids" collection="ids" open="(" separator="," close=")">
#{ids}
</foreach>
</delete>

错误原因是：

你可以传递一个 List 实例或者数组作为参数对象传给 MyBatis。当你这么做的时候,MyBatis 会自动将它包装在一个 Map 中,用名称在作为键。List 实例将会以“list” 作为键,而数组实例将会以“array”作为键。

 

 

正确写法

<delete id="deleteBatch">
DELETE FROM s_user
WHERE id in
<foreach item="ids" collection="list" open="(" separator=","close=")">
#{ids}
</foreach>
</delete>

 

2：你也可以使用@Param("ids") 来指定参数名称，如以下写法正确

 

Userdao.java

 public int deleteBatch(@Param("ids")List<String>  ids);

UserDao.xml

<delete id="deleteBatch">
DELETE FROM s_user
WHERE id in
<foreach item="ids" collection="ids" open="(" separator=","close=")">
#{ids}
</foreach>
</delete>

这样则正确。

 

二：如果你的入参只有一个参数并且类型是String，则需要注意：

UserDao,java

public int delete(String  id);

在对应的UserDao.xml

错误写法

<delete id="delete">
DELETE FROM s_user
WHERE id =#{id}
</delete>

正确写法

<delete id="delete">
DELETE FROM s_user
WHERE id =#{_id}
</delete>

原因是：Mybatis 对于传入的参数是单个string类型的参数的时候，明确表示要用：#{_parameter}这样的格式才能够获取到传入参数的值。

 

2.你还可以@Param("id") 来指定参数名称，如以下写法正确

 

Userdao.java

 public int delete(@Param("id")String id);

UserDao.xml

<delete id="delete">
DELETE FROM s_user
WHERE id =#{id} 
</delete>

 

 

 

 

===========

转自https://www.cnblogs.com/zfzf1/p/6910231.html

<!--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>

Mapper类:
public interface EmployeesMapper { 

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

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

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