oracle mybatis 注解

@Insert({
         "<script>",
         "MERGE INTO shhl.gq_report_data A1 ",
         " USING(",
           "<foreach close='' collection='reportDataList' index='index' item='item' open='' separator='union'>",
             "select #{item.serialNumber} serialNumber,#{item.reportNumber} reportNumber,#{item.rowName} rowName,#{item.C1,jdbcType=VARCHAR} c1,",
                  "#{item.C2,jdbcType=VARCHAR} c2,#{item.C3,jdbcType=VARCHAR} c3,#{item.C4,jdbcType=VARCHAR} c4,#{item.C5,jdbcType=VARCHAR} c5,#{item.C6,jdbcType=VARCHAR} c6,#{item.C7,jdbcType=VARCHAR} c7,#{item.C8,jdbcType=VARCHAR} c8,#{item.C9,jdbcType=VARCHAR} c9,",
                  "#{item.C10,jdbcType=VARCHAR} c10,#{item.C11,jdbcType=VARCHAR} c11,#{item.C12,jdbcType=VARCHAR} c12,#{item.C13,jdbcType=VARCHAR} c13,#{item.C14,jdbcType=VARCHAR} c14,#{item.C15,jdbcType=VARCHAR} c15,#{item.C16,jdbcType=VARCHAR} c16,#{item.C17,jdbcType=VARCHAR} c17,",
                  "#{item.C18,jdbcType=VARCHAR} c18,#{item.C19,jdbcType=VARCHAR} c19,#{item.C20,jdbcType=VARCHAR} c20,#{item.C21,jdbcType=VARCHAR} c21,#{item.C22,jdbcType=VARCHAR} c22,#{item.C23,jdbcType=VARCHAR} c23,#{item.C24,jdbcType=VARCHAR} c24,#{item.C25,jdbcType=VARCHAR} c25,",
                  "#{item.C26,jdbcType=VARCHAR} c26,#{item.C27,jdbcType=VARCHAR} c27,#{item.C28,jdbcType=VARCHAR} c28,#{item.C29,jdbcType=VARCHAR} c29,#{item.C30,jdbcType=VARCHAR} c30,#{item.C31,jdbcType=VARCHAR} c31,#{item.C32,jdbcType=VARCHAR} c32,#{item.C33,jdbcType=VARCHAR} c33,",
                  "#{item.C34,jdbcType=VARCHAR} c34,#{item.C35,jdbcType=VARCHAR} c35,#{item.C36,jdbcType=VARCHAR} c36,#{item.C37,jdbcType=VARCHAR} c37,#{item.C38,jdbcType=VARCHAR} c38,#{item.C39,jdbcType=VARCHAR} c39,#{item.C40,jdbcType=VARCHAR} c40,#{item.C41,jdbcType=VARCHAR} c41,",
                  "#{item.C42,jdbcType=VARCHAR} c42,#{item.C43,jdbcType=VARCHAR} c43,#{item.C44,jdbcType=VARCHAR} c44,#{item.C45,jdbcType=VARCHAR} c45,#{item.C46,jdbcType=VARCHAR} c46,#{item.C47,jdbcType=VARCHAR} c47,#{item.C48,jdbcType=VARCHAR} c48,#{item.C49,jdbcType=VARCHAR} c49,",
                  "#{item.C50,jdbcType=VARCHAR} c50,#{item.C51,jdbcType=VARCHAR} c51,#{item.C52,jdbcType=VARCHAR} c52,#{item.C53,jdbcType=VARCHAR} c53,#{item.C54,jdbcType=VARCHAR} c54,#{item.C55,jdbcType=VARCHAR} c55,#{item.C56,jdbcType=VARCHAR} c56,#{item.C57,jdbcType=VARCHAR} c57,",
                  "#{item.C58,jdbcType=VARCHAR} c58,#{item.C59,jdbcType=VARCHAR} c59,#{item.C60,jdbcType=VARCHAR} c60",
             "FROM dual",
         "</foreach>",
         ") A2",
         "ON(",
             "A1.serial_number = A2.serialNumber and A1.report_Number=A2.reportNumber",
          ")",
          " WHEN MATCHED THEN",
                "UPDATE SET A1.row_name = A2.rowName,A1.C1=A2.c1,A1.C2=A2.c2,A1.C3=A2.c3,A1.C4=A2.c4,A1.C5=A2.c5,A1.C6=A2.c6,A1.C7=A2.c7,A1.C8=A2.c8,",
                           "A1.C9=A2.c9,A1.C10=A2.c10,A1.C11=A2.c11,A1.C12=A2.c12,A1.C13=A2.c13,A1.C14=A2.c14,A1.C15=A2.c15,A1.C16=A2.c16,A1.C17=A2.c17,A1.C18=A2.c18,",
                           "A1.C19=A2.c19,A1.C20=A2.c20,A1.C21=A2.c21,A1.C22=A2.c22,A1.C23=A2.c23,A1.C24=A2.c24,A1.C25=A2.c25,A1.C26=A2.c26,A1.C27=A2.c27,A1.C28=A2.c28,",
                           "A1.C29=A2.c29,A1.C30=A2.c30,A1.C31=A2.c31,A1.C32=A2.c32,A1.C33=A2.c33,A1.C34=A2.c34,A1.C35=A2.c35,A1.C36=A2.c36,A1.C37=A2.c37,A1.C38=A2.c38,",
                           "A1.C39=A2.c39,A1.C40=A2.c40,A1.C41=A2.c41,A1.C42=A2.c42,A1.C43=A2.c43,A1.C44=A2.c44,A1.C45=A2.c45,A1.C46=A2.c46,A1.C47=A2.c47,A1.C48=A2.c48,",
                           "A1.C49=A2.c49,A1.C50=A2.c50,A1.C51=A2.c51,A1.C52=A2.c52,A1.C53=A2.c53,A1.C54=A2.c54,A1.C55=A2.c55,A1.C56=A2.c56,A1.C57=A2.c57,A1.C58=A2.c58,",
                           "A1.C59=A2.c59,A1.C60=A2.c60",
          "WHEN NOT MATCHED THEN",
              "INSERT (A1.serial_number,A1.report_Number,A1.row_name,A1.C1,A1.C2,A1.C3,A1.C4,A1.C5,A1.C6,A1.C7,A1.C8,A1.C9,A1.C10,A1.C11,A1.C12,A1.C13,A1.C14,A1.C15,",
                      "A1.C16,A1.C17,A1.C18,A1.C19,A1.C20,A1.C21,A1.C22,A1.C23,A1.C24,A1.C25,A1.C26,A1.C27,A1.C28,A1.C29,A1.C30,A1.C31,A1.C32,A1.C33,A1.C34,A1.C35,",
                      "A1.C36,A1.C37,A1.C38,A1.C39,A1.C40,A1.C41,A1.C42,A1.C43,A1.C44,A1.C45,A1.C46,A1.C47,A1.C48,A1.C49,A1.C50,A1.C51,A1.C52,A1.C53,A1.C54,A1.C55,",
                      "A1.C56,A1.C57,A1.C58,A1.C59,A1.C60)",
               "VALUES(A2.serialNumber,A2.reportNumber,A2.rowName,A2.c1,A2.c2,A2.c3,A2.c4,A2.c5,A2.c6,A2.c7,A2.c8,A2.c9,A2.c10,A2.c11,A2.c12,A2.c13,A2.c14,A2.c15,",
                      "A2.c16,A2.c17,A2.c18,A2.c19,A2.c20,A2.c21,A2.c22,A2.c23,A2.c24,A2.c25,A2.c26,A2.c27,A2.c28,A2.c29,A2.c30,A2.c31,A2.c32,A2.c33,A2.c34,A2.c35,",
                      "A2.c36,A2.c37,A2.c38,A2.c39,A2.c40,A2.c41,A2.c42,A2.c43,A2.c44,A2.c45,A2.c46,A2.c47,A2.c48,A2.c49,A2.c50,A2.c51,A2.c52,A2.c53,A2.c54,A2.c55,",
                      "A2.c56,A2.c57,A2.c58,A2.c59,A2.c60)",
         "</script>"
        })
    public int  batchSaveReportData(@Param(value="reportDataList") List<ReportDataEntity> reportDataList);

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值