mybatis--oracle 批量插入，批量插入（存在时不执行）和更新

1.只批量插入：

insert into WXPAY_ACCOUNT
(
id ,
out_trade_no ,
transaction_id
)
select SEQ_WXPAY_ACCOUNT.nextval id,a.* FROM (

SELECT
#{wxpayAccount.outTradeNo ,jdbcType=VARCHAR},
#{wxpayAccount.transactionId ,jdbcType=VARCHAR}
FROM dual

) a

2.批量插入（存在不插入）

merge into WXPAY_ACCOUNT wa using (

SELECT
#{wxpayAccount.outTradeNo ,jdbcType=VARCHAR} as out_trade_no ,
#{wxpayAccount.transactionId ,jdbcType=VARCHAR} as transaction_id
FROM dual
) a ON (
wa.out_trade_no = a.out_trade_no and wa.transaction_id = a.transaction_id
) when NOT MATCHED THEN
INSERT (
id ,
out_trade_no ,
transaction_id
) VALUES (
SEQ_WXPAY_ACCOUNT.nextval ,
a.out_trade_no ,
a.transaction_id
)

3.批量更新：

update wxpay_account w SET CHEC