Fill dropdown list from database

[jackal]

So I want to fill a dropdown list using data from a query. Now I know there are several wayz to do this. I dont however want to put the database connection and processing in the jsp page.(taking the mvc approach)

I was thinking of using tag libraries along with a bean.
Anybody ever do this?

[jackal]

I guess not.Ohh dear.......Anywayz I figured it out still.

[editor]

Create a value object with a name value pair.

If you use standard taglibs you can use the select in conjuction with options collections taglib your code will look something like:

<bean:define id="valCollection" name="beanWithValueObject" property="keyValObj" />
<html:select name="beanWithValueObject" property="selectedValue" >
<htmlptions collection="valCollection" labelProperty="strId" property="description" />
<htmlption value=""></htmlption>
</html:select>