About ComboBoxes (Urgent)
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   S_Swapna
Posted On:   Monday, February 14, 2005 01:17 AM




We have Three Combo Boxes retreving data dynamically from Database (Connected to Oracle through JDBC-ODBC Driver).

Data in the first ComboBox comes from DataBase when we select an item in the first ComboBox, The data comes from the Database into the Second ComboBox based on the item selected in the first ComboBox.
Similarly for the Third ComboBox based on the item selected in the Second ComboBox.

I DO'T WANT TO STORE IN AN ARRAY, BUT WANT TO RETRIVE THEM FROM THE DATABASE AND STORE IN RESULTSET.I SHOULD BE ABLE TO RETRIVE VALUES FROM THE RESULTSET.


Report | Quote This | Send private message | Reply | Print

Re: About ComboBoxes (Urgent)

Posted By:   Anonymous  
Posted On:   Monday, February 14, 2005 11:10 PM

simple approach:

store the values retreived from db into a Data Structure(like ArrayList or Vector,...)


In this case better to store this data structure in HttpSession(setAttribute() method). Use it whenever needed(using getAttribute() method) and finally delete it from the session(using removeAttribute() method) when it is not required.

Ohterwise,

Each time, all the combo box values should be retrieved from the db.




cheers,
-K.
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact