在listview JavaFX中显示sql查询结果

// Main.java
import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Parent;
import javafx.scene.Scene;
import javafx.stage.Stage;

public class Main extends Application {
    @Override
    public void start(Stage primaryStage) throws Exception {
        Parent root = FXMLLoader.load(getClass().getResource("sample.fxml"));
        primaryStage.setTitle("ListView JavaFX Example");
        primaryStage.setScene(new Scene(root, 300, 200));
        primaryStage.show();
    }

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

// Controller.java
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.fxml.FXML;
import javafx.scene.control.ListView;

import java.sql.*;

public class Controller {
    @FXML
    private ListView<String> listView;

    public void initialize() {
        ObservableList<String> data = FXCollections.observableArrayList();

        // Establish database connection
        try {
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // Execute SQL query
            Statement statement = conn.createStatement();
            ResultSet resultSet = statement.executeQuery("SELECT * FROM users");

            // Process query results
            while (resultSet.next()) {
                String name = resultSet.getString("name");
                data.add(name);
            }

            // Close database connection
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

        // Bind data to ListView
        listView.setItems(data);
    }
}

<!-- sample.fxml -->
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.scene.control.ListView?>
<?import javafx.scene.layout.AnchorPane?>

<AnchorPane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="200.0" prefWidth="300.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="Controller">
    <children>
        <ListView fx:id="listView" layoutX="50.0" layoutY="50.0" prefHeight="100.0" prefWidth="200.0" />
    </children>
</AnchorPane>