Mybatis批量增加操作的简单实例:
<!-- 批量添加图片 -->
<insert id="saveImageRecordBatch" useGeneratedKeys="true"
parameterType="java.util.List">
insert into tb_images ( content_id, create_time, type,
path, weight, flag)
values
<foreach collection="list" item="item" index="index"
separator=",">
(#{item.contentId},#{item.createTime},#{item.type},#{item.path},#{item.weight},#{item.flag})
</foreach>
</insert>
<!-- 批量添加图片 -->
<insert id="saveImageRecordBatch" useGeneratedKeys="true"
parameterType="java.util.List">
insert into tb_images ( content_id, create_time, type,
path, weight, flag)
values
<foreach collection="list" item="item" index="index"
separator=",">
(#{item.contentId},#{item.createTime},#{item.type},#{item.path},#{item.weight},#{item.flag})
</foreach>
</insert>