orm框架采用mybatis,本博客介绍一下批量合并merge用oracle和mysql来做的区别,
oracle merge合并更新函数的详细介绍可以参考我以前的博客:https://blog.csdn.net/u014427391/article/details/87898729
oracle方法:
MERGE INTO t_tips_config_related A1 USING(select #{itm.seq} seq , #{itm.tipsSeq} tipsSeq , #{itm.relaSeq} relaSeq, #{itm.tipsContent} tipsContent from dual ) A2
ON(A1.tips_seq = A2.tipsSeq and A1.rela_seq = A2.relaSeq)
WHEN MATCHED THEN
UPDATE SET A1.tips_content = A2.tipsContent
WHEN NOT MATCHED THEN
INSERT(seq , tips_seq , rela_seq, tips_content)
VALUES(A2.seq , A2.tipsSeq ,A2.relaSeq, A2.tipsContent)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
mysql方法:
REPLACE INTO t_tips_config_related(seq,tips_seq,rela_seq,tips_content) VALUES(#{itm.seq}, #{itm.tipsSeq}, #{itm.relaSeq}, #{itm.tipsContent})
1
2
3
4
5
6
7
8
9
文章来源: smilenicky.blog.csdn.net,作者:smileNicky,版权归原作者所有,如需转载,请联系作者。
原文链接:smilenicky.blog.csdn.net/article/details/89330496