Display Items from a Database in a JavaFX TableView

Question

Ok, so I'm new to this, and I've been searching for two weeks trying to get an SQL resultset to print to a TableView made by JavaFX Scene Builder. I can print my resultset using System.out.println and the data is correct, but when I try put it into a List, my tableview shows one column with 0s and the other column blank. I'm trying to print the List (println), but I get the object pointer(?) and not the data, so I can't see if I'm passing from the ResultSet to the List incorrectly. Any help would be appreciated ... I want to understand the concept, not just get an answer. Here's my controller code: ``` public class TesterUIController implements Initializable { @FXML private TableView Table; @FXML private Button TestButton; @FXML private TableColumn colKey; @FXML private TableColumn colSalesNo; public static void main (String[] args) { System.out.println("Main has run"); } /** * * @param fxmlFileLocation * @param resources */ @Override…

Accepted Answer

Your Issue

Your table is empty because you never initialize the values of the `dataClass roww` which you create. Try the following code instead:

```
dataClass roww = new dataClass();
roww.setKey(Key);
roww.setSalesNo(SalesNo);
ll.add(roww);
```

An even better idea, may be to provide a constructor for the dataClass which takes the `Key` and `SalesNo` as parameters - that way your `dataClass` instances are guaranteed to be correctly initialized.

```
ll.add(
  new dataClass(
    Key, 
    SalesNo
  )
);
```

Reference Solution

Here's a link to some sample code for accessing a database from JavaFX via JDBC and populating a `ListView` with results. The code was created for the StackOverflow question: javafx connection to mysql.

That code, similar to the code in your question, is simple to understand (which is why I linked it), but suffers from a flaw that the database lookup is done on the JavaFX application thread. This means that the application UI is frozen while the database lookup occurs. That is not optimal. To fix that, I created another background thread based database access sample for the stackoverflow question: JavaFX - Background Thread for SQL Query. This solution, which executes queries on a background thread using a `Task`, is preferable.

Aside

I'd advise following Java naming conventions as it will make your programs easier to be understood by other developers.

Display Items from a Database in a JavaFX TableView

Solution

Problem

Related problems