使用DerbyDB在Netbeans中自动增加身份

CREATE TABLE employees (
    id INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    name VARCHAR(100),
    position VARCHAR(100)
);

import java.sql.*;

public class DerbyExample {
    public static void main(String[] args) {
        String driver = "org.apache.derby.jdbc.EmbeddedDriver";
        String protocol = "jdbc:derby:";
        String dbName = "myDB;create=true";

        try {
            Class.forName(driver).newInstance();
            Connection conn = DriverManager.getConnection(protocol + dbName);
            Statement stmt = conn.createStatement();

            String sql = "INSERT INTO employees (name, position) VALUES ('John Doe', 'Developer')";
            stmt.executeUpdate(sql);

            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}