1. 批量插入
insert into table_A ( ORDER_CODE, PAYMENT_CODE) values
<foreach item="item" index="index" collection="list" separator=","> (#{item.ORDER_CODE},if(#{item.PAYMENT_CODE}='',NULL,#{item.PAYMENT_CODE}))
2.批量更新
update table_A set
PDH_CNT= <foreach collection="list" item="item" index="index" separator=" " open="case EFH_SN" close="end"> when #{item.efhSn,jdbcType=VARCHAR} then #{item.pdhCnt,jdbcType=INTEGER} </foreach> ,DUE_DT= <foreach collection="list" item="item" index="index" separator=" " open="case EFH_SN" close="end"> when #{item.efhSn,jdbcType=VARCHAR} then #{item.dueDt,jdbcType=TIMESTAMP} </foreach> where del_flg=0 and EFH_SN in <foreach collection="list" index="index" item="item" separator="," open="(" close=")"> #{item.efhSn,jdbcType=VARCHAR} </foreach>
3. table_A 数据导入table_B
INSERT INTO table_B (COMPANY_CODE,ORDER_CODE,PAYMENT_CODE,USER_CODE)
SELECT COMPANY_CODE,ORDER_CODE,PAYMENT_CODE,USER_CODE FROM table_A
4.清空表table_A
truncate table table_A