jdbc spring

 

public static void main(String[] args) {

// ApplicationContext apc = new ClassPathXmlApplicationContext("spring.xml");

// JdbcTemplate jdbc = apc.getBean(JdbcTemplate.class);

//

// Map<String, String> params = new HashMap<String, String>();

// NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(jdbc);

// params.put("show_name", "liuwen");

// params.put("pro_id", "CCF546B93ABC13D1E040007F010015F1");

//

// String sql = "UPDATE T_BUSINESS_076_SHOW_ACTIVITY Set SHOW_NAME =:show_name WHERE PRO_ID=:pro_id";

// int oprCount = namedParameterJdbcTemplate.update(sql, params);

//

// System.out.println(oprCount);

ApplicationContext apc = new ClassPathXmlApplicationContext("spring.xml");

JdbcTemplate jdbc = apc.getBean(JdbcTemplate.class);

 

Map<String, String> params = new HashMap<String, String>();

NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(

jdbc);

params.put("show_name", "liuwen");

params.put("pro_id", "CCF546B93ABC13D1E040007F010015F1");

 

String sql = "SELECT * FROM T_BUSINESS_076_SHOW_ACTIVITY WHERE PRO_ID=:pro_id";

 

Map<String, Object> aa = namedParameterJdbcTemplate.queryForMap(sql, params);

for (String string : aa.keySet()) {

System.out.println(string + "=" + aa.get(string));

}

}