[JAVA]getBean Test Main

getBean Test Main

public static void main(String[] args) throws Exception{

String tableName = "TOUR_DATA";

StringBuffer query = new StringBuffer();

query.append("SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE  FROM COLS "); 

query.append("\nWHERE TABLE_NAME = '").append(tableName).append("'");

query.append("\nORDER BY TABLE_NAME, COLUMN_ID");

System.out.println(query.toString());

ClassPathXmlApplicationContext applicationContext = new ClassPathXmlApplicationContext("/egovframework/spring/com/context-datasource.xml");

applicationContext.start();

BasicDataSource ds = applicationContext.getBean("dataSource-oracle", BasicDataSource.class); //dataSource-oracle-real_test

JdbcTemplate jdbcTemplate = new JdbcTemplate(ds);

List<Map<String,Object>> columnList = jdbcTemplate.queryForList(query.toString());

System.out.println("\n\n");

CamelCaseTest.convertInsertCC(tableName, columnList);

System.out.println("\n\n");

CamelCaseTest.convertResultMapCC(columnList);

System.out.println("\n\n");

CamelCaseTest.convertUpdateCC(tableName, columnList);

System.out.println("\n\n");

CamelCaseTest.printSelect(tableName, columnList);

System.out.println("\n\n");

CamelCaseTest.printDelete(tableName);

}