在带有MySql数据库的NetBeans集成开发环境中，使用USER101、USER102等字符串创建自动增量ID

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50)
);

String name = "USER101";
String insertQuery = "INSERT INTO users (name) VALUES (?)";

try (Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database_name", "username", "password");
     PreparedStatement statement = connection.prepareStatement(insertQuery, Statement.RETURN_GENERATED_KEYS)) {
    statement.setString(1, name);
    statement.executeUpdate();

    ResultSet generatedKeys = statement.getGeneratedKeys();
    if (generatedKeys.next()) {
        int id = generatedKeys.getInt(1);
        System.out.println("Inserted user with ID: " + id);
    }
} catch (SQLException e) {
    e.printStackTrace();
}