mybatis中关于in的使用方法及说明

目录

• mybatis in的使用方法
• mybatis使用in做范围查询的坑
错误展示
改法1
改法2
• 总结

//上面省略
xxxxx
WHERE ROLE_ID in
        <foreach collection="list" item="item" index="index" open="(" separator="," close=")">
            #{item}
        </foreach>

List<WmRecommendpic> selectPicListByMap(@Param("recommendIds")String recommendIds);
<select id="selectPicListByMap" resultType="xx.xx.WmRecommendpic"     parameterType="java.util.Map">
        
        SELECT * FROM `WmRecommendpic` 
        WHERE type_id IN (
            SELECT DISTINCT type_id FROM `wm_relationship` 
            WHERE recommend_id IN (#{recommendIds})
            AND is_valid=TRUE)
        AND is_valid=TRUE
        ORDER BY id ASC
</select>

<select id="selectPicListByMap" resultType="xx.xx.WmRecommendpic"     parameterType="java.util.Map">
        
        SELECT * FROM `WmRecommendpic` 
        WHERE type_id IN (
            SELECT DISTINCT type_id FROM `wm_relationship` 
            WHERE recommend_id IN (${recommendIds})
            AND is_valid=TRUE)
        AND is_valid=TRUE
        ORDER BY id ASC
</select>

List<WmRecommendpic> selectPicListByMap(Map<String,Object> map);

Map<String,Object> map = new HashMap<>();
map.put("recommendIds", recommendId.split(","));

return this.dao.selectPicListByMap(map);

<select id="selectPicListByMap" resultType="cn.smarthse.modules.platform.entity.apps.WmRecommendpic" parameterType="java.util.Map">

  SELECT * FROM `wm_recommendpic` 
  WHERE type_id IN (
   SELECT DISTINCT type_id FROM `wm_relationship` 
   WHERE recommend_id IN 
   <foreach item="recommendId" index="index" collection="recommendIds"   open="(" separator="," close=")">  
               #{recommendId}   
      </foreach> 
   AND is_valid=TRUE)
  AND is_valid=TRUE
  ORDER BY id ASC
</select>

Mybatis中使用in()查询的方式详解
Mybatis用注解写in查询的实现
mybatis 查询sql中in条件用法详解(foreach)