Mybatis List列表In查询实现

最新推荐文章于 2025-02-10 17:34:59 发布

热火得很

最新推荐文章于 2025-02-10 17:34:59 发布

阅读量1.6k

点赞数

分类专栏： mybatis

mybatis 专栏收录该内容

3 篇文章

订阅专栏

a 当查询的参数只有一个时

findByIds(List<Long>ids)

1.a如果参数的类型是List, 则在使用时，collection属性要必须指定为 list

 <select id="findByIdsMap" resultMap="BaseResultMap">
        Select <include refid="Base_Column_List" /> from jria where ID in
        <foreach item="item" index="index" collection="list" open="(" separator="," close=")">#{item}</foreach>
 </select>

b 如果参数的类型是Array,则在使用时，collection属性要必须指定为 array

findByIds(Long[]ids)

<select id="findByIdsMap"resultMap="BaseResultMap">
        select<include refid="Base_Column_List" />
        from jriawhere ID in
       <foreach item="item" index="index" collection="array" open="(" separator="," close=")"> #{item} </foreach>
  </select>

2.这种情况需要特别注意，在传参数时，一定要改用Map方式, 这样在collection属性可以指定名称
findByIds(String name, Long[] ids)

Map<String, Object> params = new HashMap<String, Object>(2);
       params.put("name", name);
       params.put("ids", ids);
       mapper.findByIdsMap(params);

<select id="findByIdsMap"resultMap="BaseResultMap">
        select <include refid="Base_Column_List" />
         from jria where ID in
        <foreach item="item" index="index" collection="ids" open="(" separator="," close=")"> #{item} </foreach>
   </select>

List<Jria>findByIds(Long... ids);

<select id="findbyIds" resultMap="BaseResultMap">
        select<include refid="Base_Column_List" />
        from jriawhere ID in
       <foreach item="item" index="index" collection="array" open="(" separator="," close=")"> #{item} </foreach>
  </select>