# LAST_INSERT_ID() 与 Connector/J: 示例

__*LAST_INSERT_ID*__
__*RETURN_GENERATED_KEYS*__

+ 对于 Statement 或 PreparedStatement,将 Statement.RETURN_GENERATED_KEYS 参数传递给 executeUpdate() 
  + 例如:`statement.executeUpdate("INSERT ...", Statement.RETURN_GENERATED_KEYS)` 
+ 获取 `Statement.getGeneratedKeys()` 返回值后调用以遍历结果集
```
long last_id;
ResultSet generatedKeys = ~!@statement.getGeneratedKeys()@!~;
if (generatedKeys.next()){
  last_id = generatedKeys.getLong(1);
}
generatedKeys.close();
statement.close();
```
-----------------------------------------------------------------
[no notes]