前言:批量操作是mybatis 常用的操作,记录一下
批量删除
int batchDelete(List<String> list);
delete from table_name where id in (
<foreach collection="list" item="id" separator=",">
</foreach>
)
批量添加
/**
* 批量修改
* */
int batchUpdate(List<String> idList,String id);
<update id="batchUpdate">
<foreach collection="idList" item="item" index="index" open="" close="" separator=";">
update table-name
set
val=
where id =
</foreach>
</update>
批量新增
int batchInsert(List<entity> list );
<insert id="batchInsert" parameterType="java.util.List">
insert into table(id, name)
values
<foreach collection="list" item="item" index="index" separator=",">
(uuid(),
</foreach>
</insert>