stringjdbc获取插入数据的id

Java代码

KeyHolder keyHolder = new GeneratedKeyHolder();
jdbcTemplate.update( new PreparedStatementCreator(){
        @Override
       public PreparedStatement createPreparedStatement(Connection conn) throws SQLException{
            PreparedStatement ps = conn.prepareStatement(sql, new String[] {}); 
            ps = conn.prepareStatement(YOUR_SQL_SCRIPT, Statement.RETURN_GENERATED_KEYS);
            ps.setString(1, "TEST");
            ps.setInt(2, 1);
            //...

            return ps;
        }
    },
    keyHolder);
return keyHolder.getKey().intValue();