如题:mybatis xml中根据分隔符遍历字符传
demo:
List<TableVo> getTablesByIds(@Param("ids") String ids);
select *
from table
where is_deleted = 0
and id in
<foreach collection="ids.split(',')" item="id"
index="index" open="(" close=")" separator=",">
#{id}
</foreach>
当然也可以先在java代码处理成List
String ids = "1,2,3";
Splitter splitter = Splitter.on(",").trimResults();
List<Integer> ids = splitter.splitToList(ids)