Figure 13: Java program that uses RETURN_GENERATED_KEYS option

String sql = "INSERT INTO authors (last, first, home) VALUES " +
             "'Shara', 'Ron', 'Minnesota, USA'";
int rows = stmt.executeUpdate(sql, Statement.RETURN_GENERATED_KEYS);

ResultSet rs = stmt.getGeneratedKeys();
if (rs.next()) {
  ResultSetMetaData rsmd = rs.getMetaData();
  int colCount = rsmd.getColumnCount();
  do {
    for (int i = 1; i <= colCount; i++) {
      String key = rs.getString(i);
      System.out.println("key " + i + " is " + key);
    }
  } while (rs.next());
}
else {
  System.out.println("There are no generated keys.");
}