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

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 methodapplication-beans.xml dataSource bean