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

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>