public static String[] insertSqls ={
"INSERT INTO noti_table(LOG_ID, REG_DT) "
+ "SELECT NVL(MAX(LOG_ID), 0) ERROR_LOG_ID , now()\r\n"
+ "from src_table "
+ "where 1=1\r\n"
+ " and DATE_FORMAT(REG_DT, '%Y%m%d') = ? \r\n"
,
"INSERT INTO noti_table(LOG_ID, REG_DT) "
+ "SELECT NVL(MAX(LOG_ID), 0) ERROR_LOG_ID , now() \r\n"
+ "from src_table \r\n"
+ "where REGR_ID = 'API'\r\n"
+ "and RESP_CD != '200'\r\n"
+ "and DATE_FORMAT(REG_DT, '%Y%m%d') = ? "
}
Arrays.asList(insertSqls).forEach((String qry) -> {
System.out.println("qry15:" + qry);
jdbcTemplate.update(qry, requestDate.substring(0 ,8));
});