Mybatis sql编写 in list

方法一、如果实现一个删除 id 在 needDeleteIds 集合中的记录，可按如下实现

1，dao接口：

@Mapper
public interface BizLaunchImageMapper {
  int deleteLaunchImageByIds(List<Long> needDeleteIds);
}

2，mapper Xml配置：

   <delete id="deleteLaunchImageByIds">
        delete from biz_launch_image
        where id in
        <foreach collection="list" index="index" item="needDeleteIds" open="(" separator="," close=")">
            #{needDeleteIds}
        </foreach>

    </delete>

方法二、实现一个根据platform的值在集合platforms中查找：

1，mapper接口：

@Mapper
public interface BizArVersionMapper {
    List<String> getVersionByPlatform(@Param("platforms") List<Integer> platforms);
}

2，xml配置：

    <select id="getVersionByPlatform" resultType="java.lang.String">
        select distinct version
        from biz_ar_version
        where platform in
        <foreach collection="platforms" index="index" item="item" open="(" separator="," close=")">
            #{item}
        </foreach>
    </select>