JavaFX中ListView无法显示SQL查询结果问题排查求助

Let's break down why your ListView isn't showing any data and fix it step by step:

The Root Cause #

Your current code has two key issues:

1. No Dynamic Binding Between ArrayList and ObservableList: When you create ObservableList<String> list = FXCollections.observableArrayList(arr);, you're only copying the current empty contents of arr into the ObservableList. Later, when you add data to arr in dispalyData(), the ObservableList has no idea about these changes—so the ListView never gets updated.
2. No Refresh Trigger After Loading Data: Even if the ObservableList had the data, you never tell it to refresh after fetching results from the database.

Fixed Code Solutions #

Solution 1: Use ObservableList Directly (Simplest Approach) #

Ditch the separate ArrayList and use ObservableList directly. ObservableLists automatically notify the ListView when items are added/removed, so your UI will update instantly:

// Replace the ArrayList with an ObservableList
ObservableList<String> list = FXCollections.observableArrayList();

@FXML
public void dispalyData(){
    String sql = "SELECT cus_id, cus_name, cus_email FROM customer_detail";
    try{
        Connection conn = DataConnect.connect();
        PreparedStatement pst = conn.prepareStatement(sql);
        ResultSet rs = pst.executeQuery();
        
        // Clear existing data to avoid duplicates on reloading
        list.clear();
        
        while(rs.next()){
            // Add directly to the ObservableList
            list.add(rs.getInt("cus_id") +"\t"+ rs.getString("cus_name") +"\t"+ rs.getString("cus_email"));
        }
        System.out.println(list); // Verify data is loaded
    } catch(SQLException e){
        System.out.println(e.getMessage());
    }
}

@Override
public void initialize(URL url, ResourceBundle rb) {
    // Bind the ObservableList to the ListView once
    viewlist.setItems(list);
}

Solution 2: Keep ArrayList (If You Need It for Other Logic) #

If you must retain the ArrayList, manually update the ObservableList after fetching data:

ArrayList<String> arr = new ArrayList<>(10);
ObservableList<String> list = FXCollections.observableArrayList();

@FXML
public void dispalyData(){
    String sql = "SELECT cus_id, cus_name, cus_email FROM customer_detail";
    try{
        Connection conn = DataConnect.connect();
        PreparedStatement pst = conn.prepareStatement(sql);
        ResultSet rs = pst.executeQuery();
        
        arr.clear(); // Clear old data first
        while(rs.next()){
            arr.add(rs.getInt("cus_id") +"\t"+ rs.getString("cus_name") +"\t"+ rs.getString("cus_email"));
        }
        
        // Update the ObservableList to reflect new data
        list.clear();
        list.addAll(arr);
        System.out.println(arr); // Check if data is present
    } catch(SQLException e){
        System.out.println(e.getMessage());
    }
}

@Override
public void initialize(URL url, ResourceBundle rb) {
    viewlist.setItems(list);
}

Additional Checks #

• Ensure dispalyData() is Called: Double-check that this method is actually triggered (e.g., via a button click with a proper FXML binding). If it never runs, no data will load.
• Verify SQL Query Returns Data: The System.out.println in your original code should print non-empty results. If it's empty, debug your database connection, SQL syntax, or confirm the customer_detail table has data.
• Optional: Improve Display: Using \t for column separation can look messy. For better multi-column display, consider creating a custom Customer class and using a CellFactory to render each field neatly in the ListView.

内容的提问来源于stack exchange，提问作者Nikhil Musale