How to dynamically populate

[John Ray Allen]

how can I dynamically populate a dropdown menu in JSP wherein its list will come from a certain column of a table in the database? thanks

[Niki Nono]

connect to the database and form the resultset object.

  
Statement st=connection.createStatement();
Resultset rs=st.executeQuery("//Your Query//");
%>
<select name="">
<%
while(rs.next())
{
    out.println("<option>" + rs.getString(___) + "</option>");
}
%>
</select>

Try the above code with your specific modifications and it will populate the combo box from the table according to the query.

[John Ray Allen]

Thanks niki..i appreciate it alot..