ListView in JavaFX with data from SQL

Question

I have a FXML file, on which is ListView and next to it TextFields. How can I synchronize ID's from table on ListView with rest records in table?

For example when I click ID "1" on ListView then NAME and LASTNAME from my database (which are rest records with primary key ID "1") appears in TextField1 and TextField2)

@Override
public void initialize(URL location, ResourceBundle resources) {

db.getConnect();
con = db.getConnect();

try {


    pst1 = con.prepareStatement("SELECT idpatient FROM patient");
    rs1 = pst1.executeQuery();

    while(rs1.next())
    {
    ObservableList<String> ids = FXCollections.observableArrayList(rs1.getString("idpatient"));
    patientList.setItems(ids);
    }

This code displays only last row from column "idpatient", but I want to display whole column... how can I do it?

greg-449 · Accepted Answer · 2015-12-22 08:15:58Z

2

You are calling patientList.setItems(ids) for each row returned by the SELECT, so each row throws away the results from the previous row.

You need to accumulate the data from the rows in one list and then call patientList.setItems(ids) after the end of the while(rs1.next()) loop.

Perhaps something like:

List<String> results = new ArrayList<>();

while(rs1.next())
 {
   results.add(rs1.getString("idpatient"));
 }

ObservableList<String> ids = FXCollections.observableArrayList(results);
patientList.setItems(ids);

answered Dec 22, 2015 at 8:15

greg-449

112k235 gold badges112 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ListView in JavaFX with data from SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related