1.批量查询
select id from a where 1=1
and(
<foreach collection="list" item="cus" separator="or">
name = #{cus}
</foreach>
)
2.批量新增
INSERT INTO a(id, name,remark)
VALUES
<foreach collection="List" item="item" index="index" separator=",">
(
#{item.id,jdbcType=VARCHAR},
#{item.name,jdbcType=VARCHAR},
#{item.remark,jdbcType=VARCHAR}
)
</foreach>
3.批量修改
update a set id = '' where 1=1
and id in (
<foreach collection="List" item="id" separator="or">
#{id}
</foreach>
)
4.批量删除
delete a set id = '' where 1=1
and id in (
<foreach collection="List" item="id" separator="or">
#{id}
</foreach>
)