# Auto Generated IDs And Connector/J: Example

__*LAST_INSERT_ID*__
__*RETURN_GENERATED_KEYS*__

+ For Statement or PreparedStatement, pass the Statement.return_generated_keys parameter to executeUpdate( ) 
  + For example: `statement.executeUpdate("INSERT ...", Statement.RETURN_GENERATED_KEYS)`  
+ Call `Statement.getGeneratedKeys()` after getting the return value to iterate over the result set
+ `SELECT LAST_INSERT_ID()`
```
long last_id;
ResultSet generatedKeys = ~!@statement.getGeneratedKeys()@!~;
if (generatedKeys.next()){
  last_id = generatedKeys.getLong(1);
}
generatedKeys.close();
statement.close();
```

------------------------------------------------------------

Demo script for macOS and Linux: https://github.com/pingcap/tidb-course-201-lab/blob/master/scripts/10-demo-jdbc-prepared-statement-returning-01-show.sh