populate values from database into ObservableList in javafx

Question

How can I properly populate values from a mysql database to an observableList in javafx? I am using:

ObservableList<String> deptList=FXCollections.observableArrayList("CSE","ME");

to manually populate values to observablelist,but I have no idea how to fetch data from a mysql database and populate into observable list.

TangledUpInBlue · Accepted Answer · 2016-01-21T16:36:55.463

3

In order to get a List from your mysql database, open a database connection to your mysql database and execute your query. (I'm not going to write this one out for you, because there's plenty of good examples online.) Once you have your ResultSet:

List<String> listOfSomething;
ResultSet rs = statement.executeQuery(query);
while (rs.next()) {
    String current = rs.getString("whatever");
    listOfSomething.add(current);
}

You can just get a list from your database and convert it to an observable list:

List listOfSomething = new ArrayList(ofWhatever);
ObservableList<String> observableListOfSomething = FXCollections.observableArrayList(listOfSomething);

edited Jan 21 '16 at 16:36

answered Jan 21 '16 at 16:17

TangledUpInBlue

746
4
13

can you explain bit more?I am new to javafx how to get list from database into arraylist? – Shersha Fn Jan 21 '16 at 16:19
That question relates to your database, not to javafx. What database are you using? – TangledUpInBlue Jan 21 '16 at 16:20
I am using mysql database – Shersha Fn Jan 21 '16 at 16:20

score 0 · Answer 2 · answered Jan 19 '17 at 21:32

This is the code used to populate data intoto a ListView(JavaFX (fxml)).

 private void populateListView {
            try {
                String query = "select * from main_table";
                PreparedStatement prestate = model.getConnection().prepareStatement(query);
                ResultSet result = prestate.executeQuery();

                while (result.next()) {
                    String current = result.getString("title");
                    ObservableList<String> list = FXCollections.observableArrayList(current);
                    listview.getItems().addAll(list);
                }

                prestate.close();
                result.close();     
            } catch (Exception ex) {
                ex.printStackTrace();
            }
        }

score 0 · Answer 3 · edited Jan 13 '18 at 14:12

Thank you. The answer mentioned in this post is working in my case too. I am using postgres as database.

creating a table view

@FXML private TableView<AccountMaster> detailstable;

I am getting the details from DB and storing it in a generic list.

List<Student> list = DatabaseClient.getInstance().studentDetailsSearch(id,name);

creating observable list of generic type and then setting the list values in observable list.

ObservableList<AccountMaster> searchDetailsList = FXCollections.observableArrayList(list );

setting it in table view

detailstable.getItems().addAll(searchDetailsList);

With this we can populate values from database into ObservableList in javafx

populate values from database into ObservableList in javafx

3 Answers3

Linked