Reading from database and putting into Combo Box

Hey,
Sorry for disturbing you but im having problems trying to get data from a mysql database and displaying it in a combo box on a jsp page. I had a look at some sample code you gave on the forums, but im still not sure. Im doing an airline booking system. I want to get the list of origins from my database and put it in a combobox on my jsp. then i have a combo-box which should have a list of destinations which changes depending on the origin selected from the drop down list. Im really stuck with this, could you please help me???

Thanks,

Where is the problem?

- In retrieving the data from DB
- In filling the combo box with that data
- filtering the other combo based on origin combo

At the moment its filling the combo box with data. I know how to retrieve data from a table. Would i need to put all the code on the jsp or can i put it in the java class?

Most definitely not in the JSP.

Similar previous topics:

http://www.coderanch.com/t/288857/JSP/java/Populating-html-select-tag-without

http://www.coderanch.com/t/285869/JSP/java/Map-Dropdown-JSTL-EL