Mybatis批量新增、更新、删除

1.批量删除

<delete id="batchDel" parameterType="java.util.List">
		delete from notice where id in
		<foreach collection="list" index="index" item="item" open="(" close=")" separator=",">
			#{item}
		</foreach>
</delete>
<!-- 参数类型是List<String>,id集合 -->

2.批量更新

<update id="batchUpdate" parameterType="java.util.List">
		<foreach collection="list" item="item" index="index" open="" close="" separator=";">
		update notice
		<set>
			title = #{item.title}, content = #{item.content}
		</set>
		where id = #{item.id}
		</foreach>
</update>
<!-- 参数类型是List<Notice>,实体集合 -->

3. 批量新增

<insert id="batchSave" parameterType="java.util.List">
		insert into notice(title,content) values
		<foreach collection="list" item="item" index="index" separator=",">
			(#{item.title},#{item.content})
		</foreach>
</insert>
<!-- 参数类型是List<Notice>,实体集合 -->