<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 ");//讀取數(shù)據(jù) 
 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%>");//產(chǎn)生數(shù)組 
 <% 
 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('選擇子行業(yè)分類',''); 
 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">選擇行業(yè)分類:</td> 
 <td width="320"> 
 <select name="selhy" onChange="changelocation(document.form1.selhy.options[document.form1.selhy.selectedIndex].value)" size="1" > 
 <option value="2">請(qǐng)選擇行業(yè)分類</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">選擇子行業(yè)分類:</td> 
 <td> 
 <select name="selzhy" > 
 <option value="" selected>請(qǐng)選擇子行業(yè)分類</option> 
 </select> 
 </td> 
 </tr> 
</table>

<form name=form1> 
 <select name=province onchange="cityName(this.selectedIndex)"> 
  <option value="">請(qǐng)選擇省名</option> 
 </select> 
 <select name=city> 
  <option value="">請(qǐng)選擇城名</option> 
 </select> 
 </form> 
 
 <script language=javascript> 
 var city1 = ["杭州", "寧波", "溫州", "紹興", "金華", "湖州"]; 
 var city2 = ["南京", "蘇州", "無(wú)錫", "常州", "鎮(zhèn)江", "徐州"]; 
 var city3 = ["合肥", "翕縣", "黃山", "祁門", "休寧"]; 
 var city4 = ["南昌", "九江", "贛州", "上饒", "新余", "景德鎮(zhèn)"];  
 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); //得到城市的數(shù)組名 
   for (var i=0; i<a.length; i++) e.options.add(new Option(a[i], a[i])); 
 } 
 function window.onload() 
 { 
   province(); //初始時(shí)給省名下拉菜單賦內(nèi)容 
 } 
 </script>