MyBatis 查询条件 in 的实现

MyBatis 查询条件 in 的实现

Mapper配置：

 <!-- 查询已CR 、CR中的记录条数 -->
    <select id="getHasClaimPartAcc" resultType="int">
        select count(1) as ac From t_swcas_bu_qgws_claim where CR_STATUS in ('CR中','已CR') and id  in

        <foreach item="item" index="index" collection="claimIds"
                 open="(" separator="," close=")">
            #{item}
        </foreach>
    </select>

后台代码：

 int getHasClaimPartAcc(@Param("claimIds") List<String> claimIds);

PS：
claimIds 为传入的参数，类型可以是 List ,Map, Set

执行结果如下：

[ DEBUG] [2020-05-29 16:07:32] com.ly.mp.swcas.main.idal.mapper.CrBillMapper.getHasClaimPartAcc [159] - == Preparing: select count(1) as ac From t_swcas_bu_qgws_claim where CR_STATUS in (‘CR中’,‘已CR’) and id in ( ? , ? )
[ DEBUG] [2020-05-29 16:07:32] com.ly.mp.swcas.main.idal.mapper.CrBillMapper.getHasClaimPartAcc [159] - == Parameters: 0001cc019cca11eabf27005056851a28(String), 000381729ccb11eabf27005056851a28(String)
[ DEBUG] [2020-05-29 16:07:32] com.ly.mp.swcas.main.idal.mapper.CrBillMapper.getHasClaimPartAcc [159] - == Total: 1