How to set text in a JavaFX choice box based on selected row in a table

Question

I am developing a ticketing system using JavaFx. When the user selects a particular ticket in the table and clicks the "Edit" button, the data in the selected row is loaded into the corresponding fields in the form below. The user can then make changes and update the information.

However, I am having problems figuring out how to set the text in the choice boxes for "Status" and "Severity" to the text in the selected row. This is the code I have for the edit button so far:

@FXML
    private void editButtonFired(ActionEvent event) {
        try {
            int value = table.getSelectionModel().getSelectedItem().getTicketNum();

            JdbcRowSet rowset = RowSetProvider.newFactory().createJdbcRowSet();
            rowset.setUrl(url);
            rowset.setUsername(username);
            rowset.setPassword(password);
            rowset.setCommand("SELECT * FROM s_fuse_ticket_table WHERE ticket_id = ?");
            rowset.setInt(1, value);
            rowset.execute();



            while(rowset.next()) {
                ticketNumber.setText(rowset.getString(1));
                summary.setText(rowset.getString(2));
            }
        }catch (SQLException e){

        }
    }

I tried using the .setSelectionModel() method but that didn't work. Could someone please assist me? Thank you!

score 1 · Accepted Answer · edited May 23 '17 at 11:45

Call choiceBox.setValue() to set the value of the choice box:

import javafx.scene.control.ChoiceBox;

ChoiceBox cb = new ChoiceBox();
cb.getItems().addAll("item1", "item2", "item3");
cb.setValue("item2");

Answers to follow-up questions

So I have already set the values for the choice box in the fxml

Probably not. Probably you have set the items and not the value (which is fine). For your use case, you couldn't set the value in FXML because the value is not known until the user selects the related line item in your master table.

When I try to use the setValue() method to set the value retrieved from the table I get an error saying: incompatible types: String cannot be converted to CAP#1 where CAP#1 is a fresh type-variable: CAP#1 extends Object from capture of

I have never experienced such an error message before. For what it is worth, there is some info on it here: incompatible types and fresh type-variable, though I confess I do not directly see the relevance to your situation. My guess is that you are not defining the type of items for the ChoiceBox or are defining them as something other than a String. You can set the type explicitly using:

ChoiceBox<String> cb = new ChoiceBox<>();

As you are using FXML, the choicebox definition would not use the new keyword and would just be similar to below:

@FXML
ChoiceBox<String> cb;

If the type of your ChoiceBox is something other than String, then you may need to set a converter on it.

There are too many unknowns from your question to provide a more specific answer.

Thank you for the response! So I have already set the values for the choice box in the fxml. I am using a rowset to get the values from the table. When I try to use the setValue() method to set the value retrieved from the table I get an error saying: incompatible types: String cannot be converted to CAP#1 where CAP#1 is a fresh type-variable: CAP#1 extends Object from capture of ? — shaydoe, Dec 01 '16 at 19:33
Thank you so much! It was just one silly thing I was missing. I did not set the type of my choice box to string. *hides in shame* Thank you so much for pointing that out. — shaydoe, Dec 01 '16 at 19:42

How to set text in a JavaFX choice box based on selected row in a table

1 Answers1