Thread: dynamically fetch values from database and display in combo box in jsp

I am making a form in jsp where i have to filter 4 combo boxes one after the other .. the values of the combo box have to be fetched from the database dynamically..
in table there are 5 fields:-
id category subcategory brand price
1 garments jacket adidas 4000
2 garments shirt peter England 1000
3 sports bat BDM 800

my form contains combo boxes namely:
category:
subcategory:
brand:
price:

firstly, category should display only those values in list(on front end) that are present in database.[I have done this with sql query and resultset](e.g- garments,sports)
Now on selecting the category(e.g- garments) only the respective subcategory should be displayed i.e next combo box should contain only- jacket, shirt.
similarly other lists should be filtered..
Please tell me statements should be used.

With the current table structure you can't do it. You need to normalize your table to be able to fetch data as you wish.

Originally Posted by dineshj83

With the current table structure you can't do it. You need to normalize your table to be able to fetch data as you wish.

please tell me how to normalize the table

Please read topics on Database normalization and apply it.

I'm not as smart on database structure as dineshj83, but it occurs to me that your question may be as much about writing the code to react to the user's choice in the combo boxes as it is to program the database query. For that, you could start with simple String arrays and develop your combo box logic. Once that is done, you could transition from the String arrays to the database queries. If you'd like more help with the combo box logic part of the question, let me know.

Originally Posted by GregBrannon

I'm not as smart on database structure as dineshj83, but it occurs to me that your question may be as much about writing the code to react to the user's choice in the combo boxes as it is to program the database query. For that, you could start with simple String arrays and develop your combo box logic. Once that is done, you could transition from the String arrays to the database queries. If you'd like more help with the combo box logic part of the question, let me know.

thanks, I've done with arrays and javascript ..but this is static coz I am manually entering the values in combobox.. But here I have to fetch the values from the database in the combobox.. this is related to multiple resultsets.

Okay, the over to dineshj83 and the magic of normalized databases. Good luck!

Originally Posted by GregBrannon

Okay, the over to dineshj83 and the magic of normalized databases. Good luck!

thank you