1. 查入数据,获取自增的主键
String shopId = String.valueOf(this.getGeneratedKeysByAdd(shop_sql,param_1));
public int getGeneratedKeysByAdd(final String sql, final List<Object> params) {
KeyHolder keyHolder = new GeneratedKeyHolder();
jdbcTemplate.update(new PreparedStatementCreator() {
public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
PreparedStatement ps = connection.prepareStatement(sql, new String[]{"id"});
for(int i = 1; i <= params.size(); ++i) {
ps.setObject(i, params.get(i - 1));
}
return ps;
}
}, keyHolder);
int key_id = keyHolder.getKey().intValue();
return key_id;
}
2.jdbcTemplate 查询数据的时候,如果直接用 对象 来接值 String str = jdbcTemplate.query(sql,String.class); 如果没有查到数据,会报错,所以最好是直接用 Map<String,Object> 来接收。