try{
ArrayListprovince=newArrayList();
while(selectedProvinceName.next())
province.add(newLabelValueBean(selectedProvinceName.getString(2),sprovince));
province.add(newLabelValueBean("请选择所在省/直辖市",000000"));
while(rs.next()){
province.add(newLabelValueBean(rs.getString(2),rs.getString(1)));
}
session.setAttribute("province",province);
}catch(SQLExceptione){
//TODOAuto-
generatedcatchblock
e.printStackTrace();
}
table="city_view";
where="provinceID='"+sprovince+"'";
ArrayListcity=newArrayList();
city.add(newLabelValueBean("请选择所在地级市","000000"));
ResultSetrs2=db.getResultSet(conn,table,where);
try{
while(rs2.next()){
city.add(newLabelValueBean(rs2.getString(2),rs2.getString(1)));
}
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
session.setAttribute("city",city);
ArrayListarea=newArrayList();
area.add(newLabelValueBean("请选择所在地点","000000"));
session.setAttribute("area",area);
}
//当地点下拉框作出变化时
if(sarea!=null){table="area_view";
where="areaID='"+sarea+"'";
ResultSetselectedAreaName=db.getResultSet(conn,table,where);
ArrayListarea=newArrayList();
StringcityID="000000";
try{
while(selectedAreaName.next()){
cityID=selectedAreaName.getString(3);
area.add(newLabelValueBean(selectedAreaName.getString(2),sarea));
}