<script language = \"JavaScript\"> 
 var onecount; 
 onecount=0; 
 subcat = new Array(); 
 <% 
 int count = 0; 
 java.sql.ResultSet rs1 = DBManage.executeQuery(\"select hydm,zhydm,zhymc from zhy \");//读取数据 
 while(rs1.next()) 
 { 
 String selhydm=rs1.getString(\"hydm\").trim(); 
 String zhydm=rs1.getString(\"zhydm\").trim(); 
 String zhymc=rs1.getString(\"zhymc\").trim(); 
 %> 
 subcat[<%=count%>] = new Array(\"<%=zhydm%>\",\"<%=selhydm%>\",\"<%=zhymc%>\");//产生数组 
 <% 
 count = count + 1; 
 } 
 if(rs1!=null) DBManage.closeCOnn(); 
 %> 
 onecount=<%=count%>; 
 function changelocation(id) 
 { 
 document.form1.selzhy.length = 0; 
 var hydm=id; 
 var i; 
 document.form1.selzhy.options[0] = new Option(\'选择子行业分类\',\'\'); 
 for (i=0;i < onecount; i++) 
 { 
 if (subcat[i][1] == hydm) 
 { 
 document.form1.selzhy.options[document.form1.selzhy.length] = new Option(subcat[i][2], subcat[i][0]); 
 }   
 } 
 } 
</script> 
<table width=\"500\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"> 
 <tr> 
 <td width=\"180\" height=\"20\" align=\"right\">选择行业分类:</td> 
 <td width=\"320\"> 
 <select name=\"selhy\" onChange=\"changelocation(document.form1.selhy.options[document.form1.selhy.selectedIndex].value)\" size=\"1\" > 
 <option value=\"2\">请选择行业分类</option> 
 <% 
 rs = DBManage.executeQuery(\"select * from hy\"); 
 while(rs.next()) 
 { 
  String hydm=rs.getString(\"hydm\").trim(); 
  String hymc=rs.getString(\"hymc\").trim(); 
 %> 
 <option value=\"<%=hydm%>\"><%=hymc%></option> 
 <% 
 } 
 if(rs!=null) DBManage.closeCOnn(); 
 %> 
 </select> 
 </td> 
 </tr> 
 <tr> 
 <td height=\"20\" align=\"right\">选择子行业分类:</td> 
 <td> 
 <select name=\"selzhy\" > 
 <option value=\"\" selected>请选择子行业分类</option> 
 </select> 
 </td> 
 </tr> 
</table>

<form name=form1> 
 <select name=province onchange=\"cityName(this.selectedIndex)\"> 
  <option value=\"\">请选择省名</option> 
 </select> 
 <select name=city> 
  <option value=\"\">请选择城名</option> 
 </select> 
 </form> 
 
 <script language=javascript> 
 var city1 = [\"杭州\", \"宁波\", \"温州\", \"绍兴\", \"金华\", \"湖州\"]; 
 var city2 = [\"南京\", \"苏州\", \"无锡\", \"常州\", \"镇江\", \"徐州\"]; 
 var city3 = [\"合肥\", \"翕县\", \"黄山\", \"祁门\", \"休宁\"]; 
 var city4 = [\"南昌\", \"九江\", \"赣州\", \"上饶\", \"新余\", \"景德镇\"];  
 var provinceName = [\"浙江\", \"江苏\", \"安徽\", \"江西\"]; 
 function province() 
 { 
   var e = document.form1.province; 
   for (var i=0; i<provinceName.length; i++) 
    e.options.add(new Option(provinceName[i], provinceName[i])); 
 } 
 function cityName(n) 
 { 
   var e = document.form1.city; 
   for (var i=e.options.length; i>0; i--)  e.remove(i); 
   if (n == 0) return; 
   var a = eval(\"city\"+ n); //得到城市的数组名 
   for (var i=0; i<a.length; i++) e.options.add(new Option(a[i], a[i])); 
 } 
 function window.onload() 
 { 
   province(); //初始时给省名下拉菜单赋内容 
 } 
 </script>