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; iprovinceName.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; ia.length; i++) e.options.add(new Option(a[i], a[i])); 
 } 
 function window.onload() 
 { 
   province(); //初始時給省名下拉菜單賦內容 
 } 
 /script>