JavaMysql获取自增长的字段的值

写在前面

• 指定返回增长的字段的值connection.prepareStatement(sqlString, Statement.RETURN_GENERATED_KEYS);
• 获得增长的字段的结果集preparedStatement.getGeneratedKeys();

详细过程

Class.forName("com.mysql.jdbc.Driver");
Connection connection = Driver.getConnection(url, "用户名", "密码");
String sqlString = "insert into 表名 values(值, 值)";
//指定返回自增长的字段的值
PreparedStatement preparedStatement = connection.prepareStatement(sqlString, Statement.RETURN_CENERATED_KEYS);
preparedStatement.executeUpdate();
ResultSet generatedKeys = preparedStatement.getGeneratedKeys();
while(generatedKeys.next()) {
    generatedKeys.getInt(1);
}
connection.close();
preparedStatement.close();