<!-- 批量插入 -->
<insert id ="insertBatch" parameterType="java.util.List" useGeneratedKeys="false">
INSERT ALL
<foreach item="item" index="index" collection="list">
INSERT INTO gb_jcqk(
id,
gh,
sj,
lx,
jcqk,
fj,
px,
status,
create_by,
create_date,
update_by,
update_date,
remarks
) VALUES (
#{item.id},
#{item.gh.gh},
#{item.sj},
#{item.lx},
#{item.jcqk},
#{item.fj},
#{item.px},
#{item.status},
#{item.createBy.id},
#{item.createDate},
#{item.updateBy.id},
#{item.updateDate},
#{item.remarks}
)
</foreach>
SELECT 1 FROM DUAL
</insert >
<!-- 批量更新 -->
<update id="updateBatch" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" open="begin" close&
mybatis 批量更新,批量插入,批量更新或插入
最新推荐文章于 2024-07-14 22:26:46 发布