myBatis拆分字符串参数,分割并遍历

最新推荐文章于 2024-07-08 00:14:00 发布

LifeOases

最新推荐文章于 2024-07-08 00:14:00 发布

阅读量3.2k

点赞数 2

文章标签： myBatis

本文链接：https://blog.csdn.net/qq_43026206/article/details/125766062

版权

String str = "a,b,c,d,e,f"；

select * 
from table
where id in
<foreach collection="str.split(',')"  item="item" index="index" open="(" separator="," close=")">#{item}</foreach>


<if test="acceNum != null and acceNum != ''">
            and acce_num like concat('%', #{acceNum}, '%')
            or acce_num in
            <foreach item="item" index="index" collection="acceNum.split(',')" open="(" separator="," close=")">
                #{item}
            </foreach>
        </if>