通过接口直接执行sql语句
1 获取接口入参dataSourceName获取NamedParameterJdbcTemplate
public NamedParameterJdbcTemplate getJdbcTemplate(String dataSourceName) {
javax.sql.DataSource dataSource = (DruidDataSource) ApplicationContextManager.get().getBean(dataSourceName);
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
return namedParameterJdbcTemplate;
}
2 通过接口获取sql, 取得结果
JdbcOperations jdbcOperations = namedParameterJdbcTemplate.getJdbcOperations();
List<Map<String, Object>> result = jdbcOperations.queryForList(sql);
或者
JdbcOperations jdbcOperations = namedParameterJdbcTemplate.getJdbcOperations();
int update = jdbcOperations.update(sql);
1 获取接口入参dataSourceName获取NamedParameterJdbcTemplate
public NamedParameterJdbcTemplate getJdbcTemplate(String dataSourceName) {
javax.sql.DataSource dataSource = (DruidDataSource) ApplicationContextManager.get().getBean(dataSourceName);
NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
return namedParameterJdbcTemplate;
}
2 通过接口获取sql, 取得结果
JdbcOperations jdbcOperations = namedParameterJdbcTemplate.getJdbcOperations();
List<Map<String, Object>> result = jdbcOperations.queryForList(sql);
或者
JdbcOperations jdbcOperations = namedParameterJdbcTemplate.getJdbcOperations();
int update = jdbcOperations.update(sql);