dynamic drop down boxes

[liliya woland]

Hello everyone,
I have a rather long list of select options, and I also have a mysql table that contains that very same data. I'd like to be able to streamline the data from the table into my select menu.
I know enough of .jsp (and some java) to read data from a table but don't know enough to do something like this. I know that I need to write a bean, but that's about all. Could anyone please refer me to any code examples so I could see what needs to happen? Thanks in advance.

[vjy chin]

Hi,
One simple way is to connect to the database and get the values and store them in an array or arraylist.
The inside the select box, you just need to iterate the array or arraylist.

<select name="frequency">
<%
  for(i=0;i<array.length;i++){
%>
      <option value="<%=array[i]%>">array[i]</option>
<%
 }
%>
      
 </select>
    

Hope this helps

[Bear Bibeault]

Though preferably with the JSTL rather than scriptlets.

[liliya woland]

Hi again,
I did try the code above and for some reason my options get populated with "vOptions.get(i)" instead of data.
I understand the problem has to do with my syntax, but could someone tell me please what syntax to use to get the array data out?
....
Vector vOptions = new Vector();
while(rs.next()){

vOptions.addElement(rs.getString(1));
}
.... then:

<select name="T50">
<%
for (int i = 0; i< vOptions.size(); i++) {
%>
<option value="<%=vOptions.get(i)%>">vOptions.get(i)</option>
<%
}
%>
</select>

[liliya woland]

I got it! ... Just had to do <%=vOptions.get(i)%>

[vjy chin]

OOPS, Sorry I forgot the <%= %> .
Good you noticed it and got the results.

Thanks

[mamidi subrahmanyam]

Hi liliya

Better use ArrayList than Vector.

(if there is no problem with performance issues, then you can continue with Vector also)
[ April 13, 2006: Message edited by: mamidi subrahmanyam ]