StringinsertSql = "insert into t_user (username) values('zhangsan')"; PreparedStatementpstmt = conn.prepareStatement(insertSql, Statement.RETURN_GENERATED_KEYS);

pstmt.executeUpdate();

ResultSetrs = pstmt.getGeneratedKeys(); Assert.assertTrue(rs.getLong(1) > 0);

finalStringinsertSql = "insert into t_user (username) values(?)"; KeyHolderkeyHolder = newGeneratedKeyHolder(); jdbcTemplate.update(newPreparedStatementCreator(){publicPreparedStatementcreatePreparedStatement(Connectionconnection) throwsSQLException{PreparedStatementps = connection.prepareStatement(insertSql, newString[]{"id" }); ps.setString(1, 'zhangsan'); returnps} }, keyHolder); Assert.assertTrue(keyHolder.getKey().longValue() > 0);