ibatis,在oracle中不重复插入可以用一句sql来实现,具体如下:

   

INSERT INTO a (id,CARD,TRADEMONEY,MONEY,FEE,TRADETIME,MERCHANT,TRACEAUDITNO,BATCHNO,CHANNEL_TRACEAUDITNO,flag,INDEXCODE,LQUIDDATE)
SELECT
b_seq_id.nextval,#map9#,#map7#,#qingsuan#,#map8#,#map0#,#map2#,#map4#,'','','0',#map1#,#map81#
FROM DUAL WHERE

#map9#||#map7#||#qingsuan#||#map8#||#map0#

NOT IN (SELECT CARD||TRADEMONEY||MONEY||FEE||TRADETIME FROM a)

posted on 2016-01-25 15:55  kevenYuan  阅读(626)  评论(0编辑  收藏  举报