JdbcTemplate Retrieving auto-generated keys

InsertDemo.java

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;

public void insert() {
    
    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
}

Reference: http://docs.spring.io/spring/docs/4.3.4.RELEASE/spring-framework-reference/html/jdbc.html#jdbc-auto-genereted-keys