xml代码
<!-- 批量插入或更新 -->
<insert id="batchInsertOrUpdate" parameterType="java.util.List">
MERGE INTO gb_jcqk t
USING (
<foreach collection="list" item="item" index="index" separator="union" >
SELECT
#{item.id} id,
#{item.gh.gh} gh,
#{item.sj} sj,
#{item.lx} lx,
#{item.jcqk} jcqk,
#{item.fj} fj,
#{item.px} px,
#{item.status} status,
#{item.createBy.id} create_by,
#{item.createDate} create_date,
#{item.updateBy.id} update_by,
#{item.updateDate} update_date,
#{item.remarks} remarks
FROM DUAL
</foreach>
) t1
ON (t.id = t1.id )
WHEN MATCHED THEN
UPDATE SET
t.gh = t1.gh,
t.sj = t1.sj,
t.lx = t1.lx,
t.jcqk = t1.jcqk,
t.fj = t1.fj,
t.px = t1.px,
t.status = t1.status,
t.update_by = t1.update_by,
t.update_date