该
JDBCTemplate.update方法已重载,以获取一个名为GeneratedKeyHolder的对象,您可以使用该对象来检索自动生成的密钥。例如(从此处获取的代码):
final String INSERT_SQL = "insert into my_test (name) values(?)";final String name = "Rob";KeyHolder keyHolder = new GeneratedKeyHolder();jdbcTemplate.update( new PreparedStatementCreator() { public PreparedStatement createPreparedStatement(Connection connection) throws SQLException { PreparedStatement ps = connection.prepareStatement(INSERT_SQL, new String[] {"id"}); ps.setString(1, name); return ps; } }, keyHolder);// keyHolder.getKey() now contains the generated key


