思路：利用ASP讀取數據庫數據，生成XML文件，然后用JS調入XML數據生成樹型菜單
1.數據結構
表名：InfoClass
字段名稱 數據類型 說明
SID int 類別ID
SName nvarchar(50) 類別名稱
ParentID int 父類ID,根分類父ID為0
2.ASP生成XML文件程序
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
Session.CodePage = "65001"
Response.Charset = "utf-8"
Call InfoClass()
Sub BuildXMLStr(pid,str) ''遞歸類別及其子類別存入字符串
Dim crs,tempStr
Set crs=Server.CreateObject("ADODB.Recordset")
Set crs=cn.Execute("Select SID,SName,ParentID From [InfoClass] Where ParentID="&pid&" Order By ParentID Asc,SID Desc")
Do While (crs.Eof=False)
tempStr = " id=''" & crs("SID") &"''"
If (crs("ParentID") = 0) Then
str = str & "<rootLevel" & tempStr & ">" & vbcrlf
str = str & "<selfName>" & crs("SName") & "</selfName>" & vbcrlf
Else
str = str & "<level" & tempStr & ">" & vbcrlf
str = str & "<selfName>" & crs("SName") & "</selfName>" & vbcrlf
str = str & "<parentID>" & crs("parentID") & "</parentID>" & vbcrlf
End If
Call BuildXMLStr(crs("SID"),str) ''遞歸調用
If (crs("ParentID") = 0) Then
str = str & "</rootLevel>" & vbcrlf
Else
str = str & "</level>" & vbcrlf
End If
crs.MoveNext()
Loop
crs.Close():Set crs=Nothing
End Sub
Sub SaveXMLFile(str)
Dim stream
Set stream = Server.CreateObject("ADODB.Stream")
stream.Type = 2
stream.Mode = 3
stream.Charset = "utf-8"
stream.Open()
stream.WriteText(str)
stream.SaveToFile Server.MapPath("/XML/InfoClass.xml"),2
stream.Close()
Set stream = Nothing
End Sub
Sub InfoClass()
Response.ContentType = "text/xml"
Dim str
str = "<?xml version=''1.0'' encoding=''utf-8''?>" & vbcrlf
str = str & "<menu>" & vbcrlf
Call BuildXMLStr(0,str)
str = str & "</menu>"
Call SaveXMLFile(str)
Response.ContentType = "text/html"
End Sub
%>
3.XML文件結構
<?xml version=''1.0'' encoding=''utf-8''?>
<menu>
<rootLevel id=''2''>
<selfName>美國</selfName>
</rootLevel>
<rootLevel id=''1''>
<selfName>中國</selfName>
<level id=''4''>
<selfName>河南</selfName>
<parentID>1</parentID>
</level>
<level id=''3''>
<selfName>山東</selfName>
<parentID>1</parentID>
<level id=''6''>
<selfName>菏澤</selfName>
<parentID>3</parentID>
<level id=''8''>
<selfName>曹縣</selfName>
<parentID>6</parentID>
</level>
<level id=''7''>
<selfName>東明</selfName>
<parentID>6</parentID>
</level>
</level>
<level id=''5''>
<selfName>濟南</selfName>
<parentID>3</parentID>
</level>
</level>
</rootLevel>
</menu>
4.JavaScript構建樹型菜單
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="//www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>JavaScript + XML樹型菜單</title>
<style type="text/css">
li.plus
{
list-style-type:none;
list-style-image:url(Images/Plus.png); /*展開時圖片,如"+"*/
cursor:hand;
}
li.minus
{
list-style-type:none;
list-style-image:url(Images/Minus.png); /*折疊時圖片,如"-"*/
cursor:hand;
}
li.item
{
list-style-type:none;
list-style-image:url(Images/Item.png); /*無子項目時圖片*/
cursor:hand;
}
</style>
</head>
<body>
<ul id="tree">
<li>樹</li>
</ul>
<script language="javascript" type="text/javascript">
treeMenu("tree"); //樹
function createXMLDom() //創建XMLDOM對象函數，跨瀏覽器解決方案
{
var xmlDom;
if (window.ActiveXObject) //IE
{
xmlDom = new ActiveXObject("Microsoft.XMLDOM");
xmlDom.async = false;
xmlDom.load("/XML/InfoClass.xml");
if (xmlDom.parseError.errorCode != 0)
{
window.alert("XML文件加載錯誤. errorCode：" + xmlDom.parseError.errorCode + " reason：" + xmlDom.parseError.reason);
return false;
}
else
{return xmlDom;}
}
else if (document.implementation && document.implementation.createDocument) //FireFox
{
xmlDom = document.implementation.createDocument("","",null);
xmlDom.async = false;
xmlDom.load("/XML/InfoClass.xml");
return xmlDom;
}
else
{
window.alert("不支持XMLDOM對象");
return false;
}
}
function treeMenu(ulID)
{
var xmlDom = createXMLDom(); //創建XMLDOM對象
var menu = xmlDom.documentElement; //xml文檔根節點
var rootLevels = menu.getElementsByTagName("rootLevel"); //一級分類集合
var ul = document.getElementById(ulID);
for (var i=0;i<rootLevels.length;i++) //循環顯示一級分類
{
var selfID = rootLevels[i].getAttribute("id");
var selfName = rootLevels[i].getElementsByTagName("selfName")[0].firstChild.nodeValue;
var li = document.createElement("li");
li.innerHTML = selfName;
li.id = selfID;
var levels = rootLevels[i].getElementsByTagName("level"); //集合
if (levels.length > 0) //有子類
{
li.className = "plus";
li.onclick = function () {liClick(this,this.id,xmlDom);} //單擊事件
}
else //無子類
{
li.className = "item";
}
ul.appendChild(li);
}
}
function liClick(li,id,xmlDom,event)
{
var childUL = li.getElementsByTagName("ul"); //ul集合
if (childUL.length > 0)//折疊
{closeChild(li,childUL);}
else //展開
{openChild(li,id,xmlDom);}
cancelBuble(event); //plus停止事件冒泡
}
function openChild(li,id,xmlDom) //展開函數
{
li.className = "minus"; //折疊圖標
var levels = xmlDom.documentElement.getElementsByTagName("level"); //level集合
var ul = document.createElement("ul");
for (var m=0;m<levels.length;m++)
{
var selfID = levels[m].getAttribute("id");
var selfName = levels[m].getElementsByTagName("selfName")[0].firstChild.nodeValue;
var parentID = levels[m].getElementsByTagName("parentID")[0].firstChild.nodeValue;
if (id == parentID) //屬于id子類
{
var ulli = document.createElement("li");
ulli.innerHTML = selfName;
ulli.id = selfID;
var childLevels = levels[m].getElementsByTagName("level"); //集合
if (childLevels.length > 0) //有子類
{
ulli.className = "plus";
/*停止事件冒泡，跨瀏覽器解決方案 Start*/
if (window.ActiveXObject) //IE
{ulli.onclick = function () {liClick(this,this.id,xmlDom,event);}} //單擊事件
else //FireFox
{ulli.onclick = function (event) {liClick(this,this.id,xmlDom,event);}} //單擊
/*停止事件冒泡，跨瀏覽器解決方案 End*/
}
else //無子類
{
ulli.className = "item";
/*停止事件冒泡，跨瀏覽器解決方案 Start*/
if (window.ActiveXObject) //IE
{ulli.onclick = function () {cancelBuble(event);}} //item停止事件冒泡
else //FireFox
{ulli.onclick = function (event) {cancelBuble(event);}} //item停止事件冒泡
/*停止事件冒泡，跨瀏覽器解決方案 End*/
}
ul.appendChild(ulli);
}
}
li.appendChild(ul);
}
function closeChild(li,childUL) //折疊函數
{
li.className = "plus"; //展開圖標
for (var j=0;j<childUL.length;j++) //循環刪除ul,ul可能有子ul、li孫ul、li
{childUL[j].parentNode.removeChild(childUL[j]);}
}
function cancelBuble(domEvent) //停止事件冒泡函數,跨瀏覽器解決方案
{
if (window.ActiveXObject) //IE
{domEvent.cancelBubble = true;}
else //FireFox
{domEvent.stopPropagation();}
}
</script>
</body>
</html>
標簽：
本站文章除注明轉載外，均為本站原創或翻譯。歡迎任何形式的轉載，但請務必注明出處、不得修改原文相關鏈接，如果存在內容上的異議請郵件反饋至chenjj@fc6vip.cn
文章轉載自：DIY部落
金喜正規買球 
109次
金喜正規買球相關的文章 
微信
在線咨詢
渝公網安備
50010702500608號
客服熱線