CODEWITHSUNDEEP
javamysqlcombobox
Djehenghizz
Djehenghizz

Reputation: 63

Connecting two columns in two different comboBoxes

I connected MySql database with Java app, I see data from two different columns (Items, Price) but I want to connect them somehow, for example, if choose in first combobox item "Desk" the other combobox should automatic find "Desk" price and display it in second combobox. Anyone have idea how to make that ?

Upvotes: 0

Views: 37

Answers (2)

Shear Plane
Shear Plane

Reputation: 124

First, I think that you don't want to ComboBoxes being correlated in such a way. There must be a better design for your gui.

Is your ComboBox from JFace? There are JFace Data Bindings. Normally, you use them to automatically update your model if someone changes values in the user interface. If your model contains an id from your database, both comboboxes can have a binding to this id.

Upvotes: 0

Zach
Zach

Reputation: 650

You could write a changelistener for the first box, then have it go into another sql query which will populate the second box. Check out this guide, it'll explain to you how to do it

https://docs.oracle.com/javase/tutorial/uiswing/events/changelistener.html

Upvotes: 1

Related Questions