Vfrdtyky

I want to pass a String value of a First ComboBox in a Query to populate a Second ComboBox, therefore the condition in the query is this: SELECT NIT FROM ENTIDAD WHERE NOMBRE='+FirstComboboxStringValue+', so I have two Methods, in the first one I populate Name Value, in the Second one a Nit values, I need to pass the Name value from the first ComboBoxin that query, there are the methods:

public void llenadocombobox2() {

        Connection conn=null;

        try {

            ObservableList<String> listacombonombre= FXCollections.observableArrayList();

            String consulta = "select nombre from entidad";

            conn = DriverManager.getConnection("jdbc:sqlserver://DESKTOP-4JA6SFR:1433;databaseName=GLOSASNINO", "sa", "123");

            PreparedStatement ps =conn.prepareStatement(consulta);

            ResultSet rs = ps.executeQuery();

             while ( rs.next() ) 

             {  

               listacombonombre.add(rs.getString("nombre"));

             }

          entidad.setItems(listacombonombre);  

        } catch (SQLException e) {

            e.printStackTrace();

        }

    }





    public void llenadocombobox3() {

         llenadocombobox2();

        String FirstComboboxStringValue= entidad.getSelectionModel().getSelectedItem();

        Connection conn=null;

        try {

            ObservableList<String> listacombonit= FXCollections.observableArrayList();

            String consulta = "select nit from entidad where nombre='"+FirstComboboxStringValue+"'";

            conn = DriverManager.getConnection("jdbc:sqlserver://DESKTOP-4JA6SFR:1433;databaseName=GLOSASNINO", "sa", "123");

            PreparedStatement ps =conn.prepareStatement(consulta);

             ResultSet rs = ps.executeQuery();

             while ( rs.next() ) 

             {  

               listacombonit.add(rs.getString("nit"));

             }



          nit.setItems(listacombonit);



        } catch (SQLException e) {

            e.printStackTrace();

        }



    }

if anyone can give an orientation here could be helpful. regards.

Here is a demo that covers your problem. You should query the DB based on the first ComboBox selection. Use the results from the query to populate the second ComboBox. <- This part should happen in the first ComboBox valueProperty change listener.

import java.util.ArrayList;

import java.util.List;

import javafx.application.Application;

import javafx.scene.Scene;

import javafx.scene.control.ComboBox;

import javafx.scene.layout.VBox;

import javafx.stage.Stage;



public class ComboBoxExperiments extends Application

{



    @Override

    public void start(Stage primaryStage) throws Exception

    {

        primaryStage.setTitle("ComboBox Experiment 1");



        ComboBox<String> comboBox = new ComboBox();

        comboBox.getItems().add("Choice 1");

        comboBox.getItems().add("Choice 2");

        comboBox.getItems().add("Choice 3");



        ComboBox<String> comboBox2 = new ComboBox();



        comboBox.valueProperty().addListener((observable, oldValue, newValue) -> {

            comboBox2.getItems().setAll(queryFakeDB(newValue));

            comboBox2.getSelectionModel().selectFirst();

        });



        comboBox.getSelectionModel().selectFirst();

        comboBox2.getSelectionModel().selectFirst();



        VBox vBox = new VBox(comboBox, comboBox2);

        Scene scene = new Scene(vBox, 200, 120);

        primaryStage.setScene(scene);

        primaryStage.show();



    }



    public static void main(String args)

    {

        Application.launch(args);

    }



    public List<String> queryFakeDB(String comboBox1Selection)

    {

        //Connect to fake database

        //Query fake database

        //Store results in a List

        //This simulates getting results from db based on combobox1 selection

        List<String> results = new ArrayList();

        switch (comboBox1Selection) {

            case "Choice 1":

                results.add("A");

                results.add("B");

                results.add("C");

                break;

            case "Choice 2":

                results.add("a");

                results.add("b");

                results.add("c");

                break;

            case "Choice 3":

                results.add("X");

                results.add("Y");

                results.add("Z");

                break;

        }



        //return result(s)

        return results;

    }

}