使用相同信息更新联系人的JavaFX通讯簿(SQL)

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

public class DatabaseConnection {
    private static final String DB_URL = "jdbc:mysql://localhost:3306/mydatabase";
    private static final String DB_USER = "username";
    private static final String DB_PASSWORD = "password";

    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
    }
}

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

public class ContactDAO {
    private static final String UPDATE_CONTACT_SQL = "UPDATE contacts SET name = ?, email = ? WHERE id = ?";

    public void updateContact(Contact contact) {
        try (Connection connection = DatabaseConnection.getConnection();
             PreparedStatement statement = connection.prepareStatement(UPDATE_CONTACT_SQL)) {
            statement.setString(1, contact.getName());
            statement.setString(2, contact.getEmail());
            statement.setInt(3, contact.getId());
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

import javafx.application.Application;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.TextField;
import javafx.scene.layout.VBox;
import javafx.stage.Stage;

public class JavaFXContactsApp extends Application {
    private ContactDAO contactDAO = new ContactDAO();

    public static void main(String[] args) {
        launch(args);
    }

    @Override
    public void start(Stage primaryStage) {
        TextField nameField = new TextField();
        TextField emailField = new TextField();
        Button updateButton = new Button("Update");

        updateButton.setOnAction(event -> {
            int contactId = 1; // 假设要更新的联系人ID为1
            String name = nameField.getText();
            String email = emailField.getText();
            Contact contact = new Contact(contactId, name, email);
            contactDAO.updateContact(contact);
        });

        VBox root = new VBox(nameField, emailField, updateButton);
        Scene scene = new Scene(root, 300, 200);

        primaryStage.setTitle("JavaFX Contacts App");
        primaryStage.setScene(scene);
        primaryStage.show();
    }
}