@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);
oracle mybatis 注解
最新推荐文章于 2023-04-14 17:12:32 发布