how to retrieve the new ID of the auto_increment column

[Keya Shah]

I am using mysql database.
In my jsp page, after inserting a record in the mysql table, I need to get back the new ID generated for the auto_increment primary key column. How do I get this value?

Any help appreciated.

[Bear Bibeault]

Not a JSP question; moving along to the JDBC forum.

[Roberto Spier]

Hello, Keya,

I do it this way:

      
      String[] keys = {"id"}; // define an array of table's primary keys
      stmt.executeUpdate(sql, keys );
      ResultSet rs = stmt.getGeneratedKeys();
      if (rs.next()) {
        id = rs.getInt(1);
      }
  

HTH
Roberto