Loading contents of a Database into a Combo box

[tyolu]

Pls i need help on loading contents of a database into a combo box by default. The combo box is on a JSP page.

[JavaPF]

Hello tyolu.

What database are you using? You will first need to setup the database connection...

[tyolu]

The database is mysql. I have already connected to the database. More so i'm using Hibernate for mapping my objects to the database.

[JavaPF]

Hello tyolu,

Are you putting the returned SQL results in a Resultset? Please post your code for us to see.

You will need to do something similar to this with a for loop:

<select>
<%
         for(----)
           {
                      String line =  Resultset object
                      out.print("<option>"+line+"   </option>");
 
            }
 
%>
</select>