mybatis 中in查询的使用

userService:

String [] uidArr = requestForm.getMergeUids().trim().split(",");//被操作uid 逗号拼接的字符串，这里转换为数组
        List<Long> uidList = new ArrayList<Long>();
        for(String uidStr : uidArr){
            uidList.add(Long.parseLong(uidStr));
        }
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("uidList", uidList);
        List<User> userList =  userDao.selectUsersByUids(map);

userDao:

List<User> selectUsersByUids(Map<String, Object> map);

mapp.xml

  <resultMap id="BaseResultMap" type="com.User">
    <id column="uid" jdbcType="BIGINT" property="uid" />
    <result column="name" jdbcType="VARCHAR" property="name" />
  </resultMap>

<select id="selectUsersByUids" parameterType="java.util.Map" resultMap="BaseResultMap">
    select
     uid,name from user
     where uid in
    <foreach collection="uidList" index="index" item="item" open="(" separator="," close=")">
      #{item}
    </foreach>
  </select>