Hi. I just started studying JSP and I need help creating a drop down list that would use database (Access/SQL) information for the options.

example table would be:

Names Number
erin 1
keira 2
jack 3
april 4


I would use the Names (erin, keira, etc) for the drop down list. And also, I would have to use the names and pass the value of the selected name to the page that would process the data.

Thank you!

Do as follows
1. Call a servlet which will query the db and get the rows in the table and generates an ArrayList object with the names and values [For example a bean called NameValuesBean which will have one integer and one String objects and getter and setter method for it]. For every row you'll create an instance of a custom bean [NameValuesBean] and add them to the ArrayList.
2. Set the this arrayList to the request attribute and forward to the jsp.
3. In the JSP get the request attribute and and loop through the ArrayList in the jsp and generate the <option> tags with the name and values.

Thats it your done.


- Rakesh