java向mysql数据库中添加id

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class AddIdToMySQL {
    public static void main(String[] args) {
        // 定义数据库连接参数
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";

        // 声明连接对象和预编译语句对象
        Connection conn = null;
        PreparedStatement pstmt = null;

        try {
            // 加载并注册MySQL JDBC驱动程序
            Class.forName("com.mysql.cj.jdbc.Driver");
            
            // 建立数据库连接
            conn = DriverManager.getConnection(url, username, password);
            
            // 准备SQL语句，指定表名和列名
            String sql = "INSERT INTO mytable (id) VALUES (?)";
            
            // 创建预编译语句对象
            pstmt = conn.prepareStatement(sql);
            
            // 设置要插入的id值
            int id = 1; // 假设要添加的id是1
            pstmt.setInt(1, id);
            
            // 执行SQL语句
            int rowsAffected = pstmt.executeUpdate();
            
            if (rowsAffected > 0) {
                System.out.println("id添加成功！");
            } else {
                System.out.println("id添加失败！");
            }
            
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭连接和释放资源
            try {
                if (pstmt != null) {
                    pstmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}