JavaFX Scenebuilder从数据库填充listView

Question

public class Main extends Application {

    @Override
    public void start(Stage primaryStage) throws Exception{
        Parent root = FXMLLoader.load(getClass().getResource("sample.fxml"));

        Connection Conn = null;

        try {
            Conn = DriverManager.getConnection("jdbc:mysql://localhost/hitdossier", "root", "");
            System.out.println("Verbonden met de database");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
            System.out.println("Verbinding met de database is mislukt.");
        }

        Statement stmt = null;
        ResultSet rs = null;
        try {
            stmt = Conn.createStatement();
            rs = stmt.executeQuery("SELECT naam FROM artiest");

            while (rs.next()) {
                System.out.println(rs.getString(1));
            }
        } catch (SQLException e) {

        }

        primaryStage.setTitle("Eindopdracht Java Periode 4");
        primaryStage.setScene(new Scene(root, 700, 650));
        primaryStage.show();
    }

package sample;

import javafx.fxml.FXML;
import javafx.scene.control.ComboBox;
import javafx.scene.control.ListView;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;

public class Controller {
   @FXML
   private ComboBox<String> cboWeek;

}

Answer 1

我将使用以下代码：

首先定义listView和一个可观察的列表（假设fxml中有一个id为“list”的listView）：

@FXML
ListView<String> list;

ObservableList<String> items = FXCollections.observableArrayList();

然后将list视图设置为items列表：

list.setItems(items);

items.add(rs.getString(1));