如何在Javafx中更新或删除后刷新数据库表视图？

// 导入必要的类
import javafx.application.Application;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.TableView;
import javafx.scene.layout.VBox;
import javafx.stage.Stage;

import java.sql.*;

public class MainApp extends Application {

    private ObservableList<Person> data = FXCollections.observableArrayList();

    private TableView<Person> tableView = new TableView<>();

    @Override
    public void start(Stage primaryStage) {
        // 创建JavaFX界面
        Button updateButton = new Button("更新数据");
        Button deleteButton = new Button("删除数据");

        VBox vbox = new VBox(updateButton, deleteButton, tableView);

        // 绑定按钮点击事件
        updateButton.setOnAction(e -> updateData());
        deleteButton.setOnAction(e -> deleteData());

        // 显示JavaFX界面
        Scene scene = new Scene(vbox);
        primaryStage.setScene(scene);
        primaryStage.show();
    }

    // 更新数据的方法
    private void updateData() {
        // 连接数据库
        try (Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password")) {
            // 执行更新操作
            try (Statement stmt = conn.createStatement()) {
                stmt.executeUpdate("UPDATE person SET name = 'New Name' WHERE id = 1");
            }

            // 刷新表视图
            data.clear(); // 清空原有数据

            try (Statement stmt = conn.createStatement()) {
                ResultSet rs = stmt.executeQuery("SELECT * FROM person");
                while (rs.next()) {
                    int id = rs.getInt("id");
                    String name = rs.getString("name");
                    int age = rs.getInt("age");
                    data.add(new Person(id, name, age));
                }
            }

            tableView.setItems(data);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    // 删除数据的方法
    private void deleteData() {
        // 连接数据库
        try (Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password")) {
            // 执行删除操作
            try (Statement stmt = conn.createStatement()) {
                stmt.executeUpdate("DELETE FROM person WHERE id = 1");
            }

            // 刷新表视图
            data.clear(); // 清空原有数据

            try (Statement stmt = conn.createStatement()) {
                ResultSet rs = stmt.executeQuery("SELECT * FROM person");
                while (rs.next()) {
                    int id = rs.getInt("id");
                    String name = rs.getString("name");
                    int age = rs.getInt("age");
                    data.add(new Person(id, name, age));
                }
            }

            tableView.setItems(data);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

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

    // Person类用于存储数据
    public static class Person {
        private int id;
        private String name;
        private int age;

        public Person(int id, String name, int age) {
            this.id = id;
            this.name = name;
            this.age = age;
        }

        // 省略getter和setter方法
    }
}