java, String array foreach

java 2021. 1. 27. 17:30
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));
});