mybatis传入多个参数

UserMapper.java

package com.ambow.mapper;

import com.ambow.entity.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface UserMapper {

List<User> findAll();

void addUser(User user);

List<User> findUserRoleName();

List<User> findContions(int[] array);

List<User> findContion(@Param("ids") List<Integer> ids);

List<User> findContionMap(@Param("mps") Map<String,Integer> ids);

}

UserMapper.xml

<select id="findContions" parameterType="int" resultMap="BaseUserMap">
  select * from user where
 <trim prefixOverrides="and">
    <if test="array.length>0">
     and roleid in
     <foreach collection="array" item="roleids" open="(" separator="," close=")">
       #{roleids}
     </foreach>
    </if>

 </trim>


</select>
<!--传list集合-->
<select id="findContion" parameterType="int" resultMap="BaseUserMap">
    select * from user where
    <trim prefixOverrides="and">
        <if test="ids.size()>0">
            and roleid in
            <foreach collection="ids" item="id" open="(" separator="," close=")">
                #{id}
            </foreach>
        </if>

    </trim>


</select>

<!--传map集合参数-->
<select id="findContionMap" parameterType="int" resultMap="BaseUserMap">
select * from user where
<trim prefixOverrides="and">
    <if test="mps.size()>0">
        and roleid in
        <foreach collection="mps.values()" item="id" open="(" separator="," close=")">
            #{id}
        </foreach>
    </if>

</trim>