Jdbc PreparedStatement way

• Step1: Prepare RETURN_GENERATED_KEYS statement using insertSql

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

• Step2: Execute insertSql using statement

pstmt.executeUpdate();

• Step3: Retrieve auto-generated keys

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

Spring JdbcTemplate way

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);

For run JUnit Test a greenbar, config db parameters on below places:

JdbcUtilTest.java setUpBeforeClass method
application-beans.xml dataSource bean