Getting the last inserted record id of a database table in java
Getting the last inserted record id of a database table in java The new JDBC-3.0 method getGeneratedKeys() which is now the preferred method to use if you need to retrieve AUTO_INCREMENT keys. PreparedStatement ps = con.prepareStatement("insert into emp values(?,?)", Statement.RETURN_GENERATED_KEYS); ps.setInt(1, e.getId()); ps.setString(2, e.getName()); ps.executeUpdate(); ResultSet rset = ps.getGeneratedKeys(); while (rset.next()) { int i = rset.getInt(1); System.out.println("key=" + i); ...