Need help on combox and jsp
Hello every body,
I plan to develop small web application .In that i have two combo boxes named services and service categories.
when i select perticular service in service combobox automatically fill catagories in service categories table.
i wrote in my jsp:
<td>Services</td>
<%ArrayList list=(ArrayList)session.getAttribute("datalist");
ServiceVO svo=null;
%>
<td><form method="post" name="NewRequest"><select name="services" id="services">
<option value="Select">Select</option>
<%for(int i=0;i<list.size();i++){
svo=(ServiceVO)list.get(i);
%>
<option value="<%svo.getServiceid();%>" ><%=svo.getService()%></option>
<%
}
%>
</select></form>
<%ArrayList list1=(ArrayList)session.getAttribute("datalist1"); %>
<form method="post" name="NewRequest1"><select name="categories">
<option value="Select">Select</option>
<%for(int i=0;i<list1.size();i++){
CategoryVO cvo=(CategoryVO)list1.get(i);
%>
<option value="<%cvo.getCategoryid(); %>" ><%=cvo.getCategory() %></option>
<%} %>
</select>
In servlet i wrote:
rs=st.executeQuery("select * from tb_service");
while(rs.next())
{
ServiceVO svo=new ServiceVO();
svo.setServiceid(rs.getInt("serviceid"));
svo.setService(rs.getString("service"));
datalist.add(svo);
}
session.setAttribute("datalist", datalist);
rs1=st.executeQuery("select * from tb_category tc join tb_linkservicecategory l on l.scategoryid = tc.scategoryid where l.serviceid =1");
//rs1=st.executeQuery("select * from tb_category tc join tb_linkservicecategory l on l.scategoryid = tc.scategoryid ");
while(rs1.next())
{
CategoryVO cvo=new CategoryVO();
cvo.setCategoryid(rs1.getInt("scategoryid"));
cvo.setCategory(rs1.getString("scategory"));
datalist1.add(cvo);
}
session1.setAttribute("datalist1", datalist1);
When i select perticalar service how can pass that serviceid to servlet.
Plz help me...
very urgent..
