二级联动菜单

 <xml id="doc"> <data>
              <%
set rs=server.createobject("adodb.recordset")
sql="select * from bigtype"
rs.open sql,conn,1,1

if rs.eof then%>
              无大类
              <%
else

do while not rs.eof%>
              <province name="<%=rs("bigtype")%>">
              <%

set rs1=server.createobject("adodb.recordset")
sql1="select * from type where bigtype='"&rs("bigtype")&"'"
rs1.open sql1,conn,1,1

do while not rs1.eof
%>
              <city><%=rs1("type")%></city>
              <%rs1.movenext
loop

rs1.close
set rs1=nothing
%>
              </province>
              <%
rs.movenext
loop

rs.close
set rs=nothing

end if
%>
              </data> </xml> <select name="bigtype" id=prov onchange="docity()">
                <option value="0">--- 请选择大类 ---</option>
              </select> <select id=city name="type">
              </select> <script language="JavaScript">
function init(){
 var v1 = doc.getElementsByTagName("province");
 for(var i =0; i<v1.length;i++){
  var e = document.createElement("OPTION");
  e.innerText = e.value = v1[i].getAttribute("name");
  form2.prov.appendChild(e);
 }
}
function docity(){
 var sf = form2.prov.value;
 var str="//province[@name='"+sf+"']";
 var v = doc.selectSingleNode(str);
 if(!v){ alert("没有符合条件的记录！");return;}
 form2.city.innerHTML = "";
 var v1 = v.selectNodes("city")
 for(var i =0; i<v1.length;i++){
  var e = document.createElement("OPTION");
  e.innerText = e.value = v1[i].text;
  form2.city.appendChild(e);
 }
}
init();
</script>