Spring Boot get insert row id using JDBCTemplate

1
2
3
4
5
6
7
8
9
10
11
12
13
14
// import org.springframework.jdbc.core.JdbcTemplate;
// import org.springframework.jdbc.support.GeneratedKeyHolder;
// import org.springframework.jdbc.support.KeyHolder;
// import java.sql.Statement;

String sqlQuery = "INSERT INTO `my_table` (`column_1`, `column_2`) VALUES ('aaa', 'bbb')";

KeyHolder keyHolder = new GeneratedKeyHolder();
int insertsCount = this.jdbcTemplate.update(c -> c.prepareStatement(sqlQuery, Statement.RETURN_GENERATED_KEYS), keyHolder);

if (insertsCount == 1) {
    Number assignedKey = keyHolder.getKey();
    long rowId = assignedKey.longValue();
}