oracel merge into ,insert into

1. merge into

mapper 接口： void insertGenerateData5521(List list); xml-sql: <update id=“insertGenerateData5521” parameterType=“java.util.List”» MERGE INTO tb ci 5521 a using ( ¿foreach collection-“list” index-“index” item-“item” open-“” close-“” separ select #{item- JLXH,jdbCT yPe=DECIMAL) AS JLXH,f{itemZSDM, jdbCType=VARCHARI AS ZSD4,f(item- ZQDM, jdbCT yPe=VARCHARJ AS ZRDM,#{ite- ZQJC, jabCI ype=VARCHAR) AS ZQJC. decode (# (item. SSDD, jdbcIype=VARCHAR), 深圳•口，‘上海”1，•香港，,2) 25 5SDD， #tite_NELX,jdbCIyPe=VA RCHAR} AS WELXftite- JSBZ, I abCIyPE=DECIMAL) AS ISRZ #(item.CZIX, jdbcType-VARCHAR) AS CZIX, (item LIGQS, jabcIype-DECIMAL] AS LIGQ5, (item. QSSJ, jdbcIype=DECIMAL) AS QSSJ, ‡(item. XGTJ, jdbcType-VARCHAR) AS XGIJ, (item. CZFW, jdbcIype=VARCHAR) AS CZFW, (item YWMC, jdbcIype=VARCHAR} AS YWMC, #(item.RIQI, jdbcType=DATE) AS RIQI, (item.IZYZ, jdbeType=DECIMAL} AS IZYZ, ‡(item_WHLB, jdbcT ype=VARCHARI AS WHLB, #(item OB_ROLE_ ID, jdbcIype=DECIMAL AS OB_ROLE_ID, (item. DRBZ, jdbcIype-VARCHAR) AS DRBZ, (item MARKETMARK, jdbcIype-VARCHAR] AS MARKEIMARK,

E1item OE_ ROLE NANE S CbCI VPe VARCHAR AS OP_ROLE_ NANE. ftitem-EZ, jabCI YPe-VARCHARI AS EZ from dual I ) b on to char (a_RIQI, vyyy-mm-dd’) = to_char (b.RIQI, ‘yyyy-man-dd’) and a_OB_ROLE_ID = b_OB ROLE_ID and a.DRBZ = b. DRBZ and a_CZIX = b. CZLX and a_ZSDM = b_ZSDM and a_ZQDM =b_ZQDM ) when matched then update set a. SSDD = b. SSDD, E-WELX - b-WELX, a.JsB2 = b.JsBz, a_LIGQS = b. LIGQS, a.QsSJ = b-QSSJ, a.XGIJ = b.XGIJ, a. CZEW = b. CZFW, a. YWMC = b. YWMC, a.TZYZ = b.IZYZ, a .MARKETMARK = b. MARKETMARK, a.ob role name = b.ob role name, a_BZ = b.BZ when not matched then insert (E-JLXE, =-ZSDM. =-ZQDM, a- ZQJC,a-SSDD, E-WELx, e- JSBZ,a-C2Ix, a-LIGQS.a-QsSJ, a-xGTJ,a-CzET) values (SEQLCI_ID-NEXIVAL,D-2SDM, 5-29D4,5-29JC,b-SSDD.b-MELx,5-JSB2,b-C2Ix,D-LIGQS,b-QSSJ,b.)

2.insert into

1 mapper 接口： insertDividendChange5506(@Param(“table5506List”) List<PublicAlls table! 2.xml-sql: <insert id=“insertDividendChange5506” parameterType=“java.util.List"y T insert into tb ci 5506 JLXH, ZSDM, ZSJC, ZQDM, ZQJC, SSDD, WFIX, JSEZ, CZLX, LIGOS, aSsJ, XGIJ, CZEW, ZSQC, YWMG, TZSZ, RIQI, IZYZ, WHLB, ZRSP, DRBZ, MARKETMARK, OB_ ROLE_ID, createTime select seg ci id nextval as JLKH A from ( <foreach collection=“table5506Iist” item-”publicA11” index-“index” separator="union all"s select #{publicAll.ZSDM, jdbcType=VARCHARI, #fpublicAll.ZSJC, jdbcType=VARCHAR}, #(publicAll.ZQDM, jdbcType=VARCHAR), #{publicAll.ZQJC, jdbcType-VARCHARI, #{publicAll. SSDD, jdbcIype=VARCHAR], ‡(publicAll.WFLX , jdbcType-VARCHAR], #(publicAll.JSBZ, jdbcIvpe=DECIMAL), #(publicAll_CZIX, jdbcType=VARCHAR), #(publicAll.LIGQS, jdbcIype-DECIMAL}, #(publicAll.QSSJ, jdbcType-DECIMAL), #{publicAll.XGIJ , jdbcType-VARCHAR), #(publicAll. CZFW , jdbeType=VARCHAR], #(publicAll_ZSQG, jdbcType-VARCHARI, #{publicAll. YWMC , jabcType=VARCHAR}, #(pub11cA11 IZSZ ,JdbCI YPE-DECIMAL}, #{publicAll. RIQI, jdbolype=DAIE }, #{publicAll.IZIZ, jdbcType-DECIMAL], #{publicAll.WHLB , jdbcType-VARCHAR}, #{publicAll_ZRSP, jdbcType-DECIMAL}, #(publicAll.DRBZ, jdbcType-VARCHAR), #(publicAll.MARKETMARK, jabcType=VARCHARI, #(publicAl1.0B_ROLE_ID, jdbcType-DECIMAL], #{publicAll.createTime, jdbaType=DATE } from dual </foreachs ) A </ifs kif test="table5506List. size ()==0 select sysdate from dual </ifs