Retrieve Automatically Generated Keys Using a Statement (MySQL)? : MySQL « Database « Java Tutorial

1. Java Tutorial
2. Database
3. MySQL

mysql>  CREATE TABLE yourtable (
    ->          id INT NOT NULL AUTO_INCREMENT,
    ->          name VARCHAR(32) NOT NULL,
    ->          PRIMARY KEY (id)
    ->  );

Solution

stmt.executeUpdate("insert into yourtable (name) values('tiger')");

    rs = stmt.getGeneratedKeys();