Expand|Select|Wrap|Line Numbers
- String coun=request.getParameter("countryddl");ResultSet rs1=stmt.executeQuery("select * from country where countryname='"+coun+"'");
- while(rs1.next())
- {
- Integer counid=Integer.parseInt(rs1.getString("countryid"));
- ResultSet rs= stmt.executeQuery("select * from state where countryid="+counid);
- %> <select name="stateddl">
- <option value="0">Select</option>
- <% while(rs.next())
- {
- %>
- <option><%= rs.getString("statename")%></option>
- <% } %>
- </select>
- <% }
- }
Please help me to complete this program...