琥珀无限级分类联动菜单AJAX版_jquery

if (window.XMLHttpRequest) { // Mozilla, Safari, …
    http_request = new XMLHttpRequest();
} else if (window.ActiveXObject) { // IE
    http_request = new ActiveXObject(“Microsoft.XMLHTTP”);
}

var linkurl=”http://www.10090.com/demo/hpmenu/ajax_server.asp?classid=”+classid+”&sel=”+str+”&fieldname=”+MenuFieldArr%5Bclassid+1%5D
http_request.open(“GET”,linkurl,false);
http_request.send(null);

//服务器端处理返回的是经过escape编码的字符串.
//在页面显示服务器查询结果

var returntxt=unescape(http_request.responseText)
if(returntxt.length>0)
{document.all,ajax.innerHTML=”服务器返回结果：<font color=’red’>”+returntxt+”</font>   [Powered by AJAX]”}
else
{document.all,ajax.innerHTML=””}

//通过XMLHTTP返回数据,开始构建Select.
BuildSel(returntxt,eval(“document.all.”+MenuIdArr[classid+1]))
//============更改下下级以下菜单为空==============
var kkk
for(kkk=classid+2;kkk<=MenuClass;kkk++)
    {        
    submenu=eval(“document.all.”+MenuIdArr[kkk])    
    submenu.length=1
    submenu.options[0].selected=true
    }
}

function BuildSel(str,sel)
{
/*
*————— BuildSel(str,sel) —————–
* BuildSel(str,sel) 
* 功能:通过str构建Select.
* 参数:str,字符串,由服务端返回的.有特定结构”字符串1|,字符串2,字符串3″
*          也可为”字符串1序号|字符串1文本,字符串2序号|字符串2文本,字符串3序号|字符串3文本”,如本例
* 参数:sel,要构建的Select
* 实例:BuildSel(unescape(oBao.responseText),document.all.sel2)
*————— BuildSel(str,sel) —————–
*/
//先清空原来的数据.
sel.options.length=0;
var arrstr = new Array();
arrstr = str.split(“,”);
//开始构建新的Select.
sel.options.add(new Option( “—–请选择—–“,””));  
if(str.length>0)   
{
for(var i=0;i<arrstr.length;i++)
{
//分割字符串
var subarrstr=new Array
subarrstr=arrstr[i].split(“|”)
//生成下级菜单
sel.options.add(new Option(subarrstr[1],subarrstr[0])); 
}
sel.options[0].selected=true
}

}
</script>

    <form name=”form1″ method=”post” action=””>
        <table width=”90%” border=”0″ align=”center” cellpadding=”2″ cellspacing=”1″ bgcolor=”#CCCCCC”>
          <tr bgcolor=”F1F1F1″>
            <td height=”24″ colspan=”2″ align=”center”>琥珀无限级联动菜单-AJAX版 [HPMenu_AJAX V1.0]</td>
          </tr>
          <tr bgcolor=”#FFFFFF”>
            <td width=”12%” height=”24″ align=”center”>所 在 洲:</td>
            <td><select name=”sel1″ id=”sel1″ >
               <option value=”” selected>—–请选择—–</option>
              <option value=”10″>亚洲</option>
              <option value=”11″>欧洲</option>
            </select></td>
          </tr>
          <tr bgcolor=”#FFFFFF”>
            <td height=”24″ align=”center”>国　　家:</td>
            <td><select name=”sel2″ >
               <option value=”” selected>—–请选择—–</option>
            </select></td>
          </tr>
          <tr bgcolor=”#FFFFFF”>
            <td height=”24″ align=”center”>城　　市:</td>
            <td><select name=”sel3″ id=”sel3″ >
               <option value=”” selected>—–请选择—–</option>
            </select></td>
          </tr>
          <tr bgcolor=”#FFFFFF”>
            <td height=”24″ align=”center”>地　　区:</td>
            <td><select name=”sel4″ id=”sel4″>
               <option value=”” selected>—–请选择—–</option>
            </select></td>
          </tr>
          <tr bgcolor=”F1F1F1″>
            <td height=”24″ colspan=”2″ align=”center” id=”ajax”> </td>
          </tr>
      </table>
       
 
        <table width=”90%”  border=”0″ align=”center” cellpadding=”0″ cellspacing=”0″>
          <tr>
            <td height=”25″ align=”left”>下载地址：<a href=”http://www.10090.com/demo/hpmenu/HPMenu_ajax.rar&#8221; target=”_blank”>请点击这里</a></td>
          </tr>
          <tr>
            <td height=”25″ align=”left”>在线Demo：<a href=”http://www.10090.com/demo/&#8221; target=”_blank”>请点击这里</a></td>
          </tr>
          <tr>
            <td height=”25″ align=”left”>Bug 反馈：<a href=”http://www.10090.com/bbs/index.asp?boardid=60&#8243; target=”_blank”>请点击这里</a></td>
          </tr>
          <tr>
            <td height=”25″ align=”left”>最后更新：2005-10-20 16:18</td>
          </tr>
          <tr>
            <td height=”25″ align=”left”>联系方式：MSN:[email protected]</td>
          </tr>
          <tr>
            <td height=”50″ align=”center”>copyright(c) 2005 <a href=”http://www.10090.com”>Hopesoft Studio</a> </td>
          </tr>
        </table>
        <script language=”javascript”>
        GetResult(document.getElementById(“sel1”).value,1)        
        </script>
</form>
</body>
</html>

  [Ctrl+A 全部选择 提示：你可先修改部分代码，再按运行]
文件ajax_server.asp代码如下：
HTML代码:<% @Language=”JavaScript” %>
<%
function OpenDB(sdbname)
{
/*
*————— OpenDB(sdbname) —————–
* OpenDB(sdbname) 
* 功能:打开数据库sdbname,返回conn对象.
* 参数:sdbname,字符串,数据库名称.
* 实例:var conn = OpenDB(“database.mdb”);
*————— OpenDB(sdbname) —————–
*/
var connstr = “Provider=Microsoft.Jet.OLEDB.4.0; Data Source=”+Server.MapPath(sdbname);
var conn = Server.CreateObject(“ADODB.Connection”);
conn.Open(connstr);
return conn;
}
var oConn = OpenDB(“ajax_data.mdb”);
var sel = Request(“sel”);
var classid = Request(“classid”)
var fieldname = Request(“fieldname”)
var arrResult = new Array();
//var sql = “select “+fieldname+” from Demo where parentid='”+sel+”‘ and classid=”+classid;
var sql = “select id,”+fieldname+” from Demo where parentid='”+sel+”‘”;
//Response.Write(“alert(“+sql+”)”)
var rs = Server.CreateObject(“ADODB.Recordset”);
rs.Open(sql,oConn,1,1);
while(!rs.EOF)
{
//遍历所有适合的数据放入arrResult数组中.
arrResult[arrResult.length] = rs(0).Value+”|”+rs(1).Value;
rs.MoveNext();
}
//escape解决了XMLHTTP。中文处理的问题.
//数组组合成字符串.由”,”字符串连接.
Response.Write(escape(arrResult.join(“,”)));
%>