如何用数据库数据 javaFX 填充 TableView

问：

我一直在尝试使用从数据库查询的数据加载 TableView，但我似乎无法理解我应该如何将其附加到数据库并将其显示在 TableView 上。注意：我想访问数据库中的多个表

这是数据库连接：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

//dataAccess
public class DBConnect {

    public Connection link;

    public DBConnect(String driverClassName, String dbURL, String user, String password) throws ClassNotFoundException, SQLException {
        Class.forName(driverClassName);
        link = DriverManager.getConnection(dbURL, user, password);
    }

    public void shutdown() throws SQLException {
        if (link != null){
            link.close();
        }
    }

    public List<Data> getDataList() throws SQLException {
        try (Statement stmnt = link.createStatement();
             ResultSet rs = stmnt.executeQuery("select * from fish"); //only connects to fish table
        ){
            List<Data> dataList = new ArrayList<>();
            while (rs.next()) {
                String museum = rs.getString("MuseumID");
                String name = rs.getString("FishID");
                String location = rs.getString("Location");
                String date_found = rs.getString("DateFound");

                Data dataset = new Data(museum, name, location, date_found);
                dataList.add(dataset);
            }
            return dataList ;
        }
    }

}

这是 FXML 脚本

<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.scene.control.Button?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.control.TextField?>
<?import javafx.scene.layout.AnchorPane?>
<?import javafx.scene.layout.BorderPane?>
<?import javafx.scene.layout.Pane?>
<?import javafx.scene.text.Font?>
<?import javafx.scene.text.Text?>

<Pane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="400.0" prefWidth="500.0" xmlns="http://javafx.com/javafx/20.0.1" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.example.nookipediademo.NookController">
   <children>
      <AnchorPane prefHeight="414.0" prefWidth="500.0" style="-fx-background-color: #ece5ce;">
         <children>
            <Button fx:id="btn_insects" layoutX="28.0" layoutY="90.0" mnemonicParsing="false" prefHeight="25.0" prefWidth="89.0" style="-fx-background-color: #c8c8a9;" text="Insects" textFill="#774f38" />
            <Button fx:id="btn_seacreatures" layoutX="29.0" layoutY="55.0" mnemonicParsing="false" style="-fx-background-color: #c8c8a9;" text="Sea Creatures" textFill="#774f38" />
            <Button fx:id="btn_fish" layoutX="28.0" layoutY="22.0" mnemonicParsing="false" prefHeight="25.0" prefWidth="89.0" style="-fx-background-color: #c8c8a9;" text="Fish" textFill="#774f38" />
            <Text fill="#774f38" layoutX="139.0" layoutY="63.0" strokeType="OUTSIDE" strokeWidth="0.0" text="Nook Pack" textAlignment="CENTER" wrappingWidth="334.0000305175782">
               <font>
                  <Font name="Britannic Bold" size="48.0" />
               </font>
            </Text>
            <Button fx:id="btn_search" layoutX="414.0" layoutY="90.0" mnemonicParsing="false" style="-fx-background-color: #c8c8a9;" text="SEARCH" textFill="#774f38" />
            <TextField fx:id="search_input" layoutX="139.0" layoutY="90.0" prefHeight="25.0" prefWidth="263.0" promptText="Search Museum Catalog" />
            <BorderPane layoutX="25.0" layoutY="150.0" prefHeight="250.0" prefWidth="450.0">
               <center>
                  <TableView fx:id="table_display" editable="true" prefHeight="200.0" prefWidth="200.0" style="-fx-background-color: #83af9b;" BorderPane.alignment="CENTER">
                    <columns>
                      <TableColumn id="museum_display" fx:id="museum_display" prefWidth="90.0" style="-fx-background-color: #c8c8a9;" text="Museum" />
                      <TableColumn id="name_display" fx:id="name_display" prefWidth="150.0" style="-fx-background-color: #c8c8a9; -fx-text-color: #774f38;" text="Name" />
                        <TableColumn id="location_display" fx:id="location_display" prefWidth="90.0" style="-fx-background-color: #c8c8a9;" text="Location" />
                        <TableColumn id="datefound_display" fx:id="datefound_display" prefWidth="117.0" style="-fx-background-color: #c8c8a9;" text="Date Found" />
                    </columns>
                  </TableView>
               </center>
            </BorderPane>
         </children>
      </AnchorPane>
   </children>
</Pane>

这是数据信息类

import javafx.beans.property.SimpleStringProperty;
import javafx.beans.property.StringProperty;

public class Data {
    private final StringProperty museum = new SimpleStringProperty();
    private final StringProperty name = new SimpleStringProperty();
    private final StringProperty location = new SimpleStringProperty();
    private final StringProperty date_found = new SimpleStringProperty();

    public StringProperty getMuseum() { return museum; }
    public void setMuseum(String museum) { this.museum.set(museum); }
    public StringProperty getName() {
        return name;
    }
    public void setName(String name) {
        this.name.set(name);
    }
    public StringProperty getLocation() {
        return location;
    }
    public void setLocation(String location) { this.location.set(location);}
    public StringProperty getDate_found() {
        return date_found;
    }
    public void setDate_found(String date_found) { this.date_found.set(date_found); }

    public Data(String museumID, String name, String place, String found_date){
        setMuseum(museumID);
        setName(name);
        setLocation(place);
        setDate_found(found_date);
    }

    public Data(String museumID, String name, String found_date){
        setMuseum(museumID);
        setName(name);
        setDate_found(found_date);
    }
}

控制器当前只有 GUI 名称

import javafx.fxml.FXML;
import javafx.scene.control.TableView;
import javafx.scene.control.Button;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TextField;

public class NookController {

    @FXML
    private Button btn_fish;

    @FXML
    private Button btn_insects;

    @FXML
    private Button btn_seacreatures;

    @FXML
    private TextField search_input;

    @FXML
    private Button btn_search;

    @FXML
    private TableView<Data> table_display;

    @FXML
    private TableColumn<Data, String> datefound_display;

    @FXML
    private TableColumn<Data, String> location_display;

    @FXML
    private TableColumn<Data, String> museum_display;

    @FXML
    private TableColumn<Data, String> name_display;


}

最后，这是我的应用程序，它也拉起了错误

java：不兼容的类型：无法推断 javafx.scene.control.cell.PropertyValueFactory 的类型参数<>

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Scene;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.scene.layout.BorderPane;
import javafx.stage.Stage;

public class NookApplication extends Application {
    private DBConnect connection;

    @Override
    public void start(Stage primaryStage) throws Exception {
        connection = new DBConnect("com.mysql.jdbc.Driver","jdbc:mysql://localhost:3306/Nookipedia","tsc","");

        TableView<Data> dataTable = new TableView<>();
        TableColumn<Data, String> museumCol = new TableColumn<>("Musuem");
        museumCol.setCellFactory(new PropertyValueFactory<>("MuseumID"));
        TableColumn<Data, String> nameCol = new TableColumn<>("Name");
        museumCol.setCellFactory(new PropertyValueFactory<>("FishID"));
        TableColumn<Data, String> locationCol = new TableColumn<>("Location");
        museumCol.setCellFactory(new PropertyValueFactory<>("Location"));
        TableColumn<Data, String> dfCol = new TableColumn<>("Date Found");
        museumCol.setCellFactory(new PropertyValueFactory<>("DateFound"));

        dataTable.getColumns().addAll(museumCol, nameCol, locationCol,dfCol);
        dataTable.getItems().addAll(connection.getDataList());

        BorderPane root = new BorderPane();
        root.setCenter(dataTable);
        Scene scene = new Scene(root, 600, 400);
        primaryStage.setScene(scene);
        primaryStage.show();
        /*FXMLLoader fxmlLoader = new FXMLLoader(NookApplication.class.getResource("NookPack.fxml"));
        Scene scene = new Scene(fxmlLoader.load(), 320, 240);
        stage.setTitle("Nookpedia Backpack");
        stage.setScene(scene);
        stage.show();*/
    }
    @Override
    public void stop() throws Exception {
        if (connection != null){
            connection.shutdown();
        }

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

我一直在阅读所有表视图和数据库连接，足以知道我走在正确的轨道上，但每个人似乎都在应用程序中使表.java同时，我已经在 FXML 中创建了它。难道它不需要以某种方式出现在控制器中吗？为什么我在使用 PropertyValueFactory 时会出错？当我知道我需要它进入可观察列表时？我的知识现在有点混乱。