JavaFX: update tableview context by selected combobox(binding)

Question

I want to display data in tableview from database by selecting combobox item. Combobox contains columns from my database which the user can select. I try this, combobox is ok and code works without errors but table is not updated.

Controller Class:

package application;

    import java.io.IOException;
    import java.net.URL;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.util.ResourceBundle;

    import javafx.collections.FXCollections;
    import javafx.collections.ObservableList;
    import javafx.event.ActionEvent;
    import javafx.fxml.FXML;
    import javafx.fxml.FXMLLoader;
    import javafx.fxml.Initializable;
    import javafx.scene.Node;
    import javafx.scene.Parent;
    import javafx.scene.Scene;
    import javafx.scene.control.ComboBox;
    import javafx.scene.control.TableColumn;
    import javafx.scene.control.TableView;
    import javafx.scene.control.cell.PropertyValueFactory;
    import javafx.stage.Stage;

        public class SortareDupaAngajatiController implements Initializable{
            final ObservableList data=FXCollections.observableArrayList();
            final ObservableList optiuni=FXCollections.observableArrayList();
            PreparedStatement intabel=null;
            ResultSet rezultate=null;
            String prequery;
            String postquery;

             @FXML
             public ComboBox meniu;
             @FXML
             TableView tabelangajati;

             @FXML
             private TableColumn numesediucol;

             @FXML
             private TableColumn angajaticol;

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

                comboMeniu();
                insertInTabel();


            }


            public void comboMeniu(){
                try {
                    String query = "SELECT * FROM maginfo";
                    PreparedStatement dindb = Conexiune.conexiuneBd.prepareStatement(query);
                    ResultSet rezultate = dindb.executeQuery();


                    while (rezultate.next()) {
                        optiuni.add(rezultate.getString("nume"));
                        meniu.setItems(optiuni);
                    }
                    dindb.close();
                    rezultate.close();   
            }
            catch (Exception ex) {
                ex.printStackTrace();
            }
            }

            public void insertInTabel(){

        try {
                    prequery="SELECT * FROM sediu where nume='"+meniu.getValue()+"'ORDER BY numarangajati DESC";
                    postquery=prequery;
                    intabel= Conexiune.conexiuneBd.prepareStatement(postquery);
                    rezultate=intabel.executeQuery();

                    while(rezultate.next()){
                        data.add(new tableAngajati(
                                rezultate.getString(2),
                                rezultate.getInt(7)
                                ));


                    }

                    intabel.close();
                    rezultate.close();

                } catch (Exception e) {
                    System.err.println(e);
                }

                numesediucol.setCellValueFactory(new PropertyValueFactory<>("numesediu"));
                angajaticol.setCellValueFactory(new PropertyValueFactory<>("numarangajati"));
                tabelangajati.setItems(null);
                tabelangajati.setItems(data);

            }}

table Class:


    package application;

    public class tableAngajati {
        private String numesediu;
        private int angajati;


        public tableAngajati(String numesediu, int angajati) {
            super();
            this.numesediu=numesediu;
            this.angajati=angajati;
        }

        public String getNumesediu(){
            return numesediu;
        }

        public void setNumesediu(String numesediu){
            this.numesediu=numesediu;
        }

        public int getNumarangajati(){
            return angajati;
        }

        public void setNumarangajati(int angajati){
            this.angajati=angajati;
        }

    }

Thanks a lot!

JavaFX: update tableview context by selected combobox(binding)

Answers (1)

Related Questions