結合 ASP 伺服器端遞迴生成巢狀 HTML 結構,搭配 JavaScript 前端收合/展開交互,構建完整的分類管理介面。本文提供完整可執行程式碼,包含資料庫設計、遞迴渲染、JS 互動、樣式與效能優化。
CREATE TABLE Category (
CatID AUTOINCREMENT PRIMARY KEY,
CatName VARCHAR(100) NOT NULL,
ParentID LONG DEFAULT 0, -- 0 為根節點
CatOrder INT DEFAULT 0, -- 同層排序
IsShow YESNO DEFAULT YES, -- 是否顯示
U_ID INT DEFAULT 1, -- 站點/用戶區隔
IconPath VARCHAR(255) -- 圖示路徑
);
<%
' ==========================================
' 分類樹渲染核心模組
' ==========================================
Option Explicit
' 全域變數
Dim conn, catHtml, currentDepth
' 進入點
Sub RenderCategoryTree(rootParentId, siteType, maxDepth)
catHtml = ""
currentDepth = 0
Call BuildTreeRecursive(rootParentId, siteType, maxDepth, 0)
Response.Write catHtml
End Sub
' 遞迴建構樹狀 HTML
Sub BuildTreeRecursive(parentId, siteType, maxDepth, depth)
Dim rs, sql, childCount, hasChildren, displayStyle, iconSrc, linkUrl, cssClass
If depth > maxDepth Then Exit Sub
sql = "SELECT CatID, CatName, ParentID FROM Category " & _
"WHERE ParentID = " & CLng(parentId) & " AND U_ID = " & CLng(siteType) & " AND IsShow = 1 " & _
"ORDER BY CatOrder ASC, CatID ASC"
Set rs = conn.Execute(sql)
If rs.EOF Then Exit Sub
' 開始 UL 容器(根層級)
If depth = 0 Then
catHtml = catHtml & ""
End If
Do While Not rs.EOF
Dim catId, catName, parentIdVal
catId = rs("CatID")
catName = rs("CatName")
parentIdVal = rs("ParentID")
' 計算子節點數
childCount = GetChildCount(catId, siteType)
hasChildren = (childCount > 0)
' 決定顯示狀態與圖示
If depth = 0 Then
displayStyle = "block"
iconSrc = "images/minus.gif" ' 預設展開
ElseIf depth < 2 Then
displayStyle = "block"
iconSrc = IIf(hasChildren, "images/minus.gif", "images/leaf.gif")
Else
displayStyle = "none"
iconSrc = IIf(hasChildren, "images/plus.gif", "images/leaf.gif")
End If
' 產生唯一 ID 前綴
Dim itemId : itemId = "cat_" & catId
' 建構 LI 元素
catHtml = catHtml & "- "
catHtml = catHtml & ""
If hasChildren Then
catHtml = catHtml & "
"
catHtml = catHtml & "" & _
Server.HTMLEncode(catName) & ""
Else
catHtml = catHtml & "
"
catHtml = catHtml & "" & _
Server.HTMLEncode(catName) & ""
End If
catHtml = catHtml & " "
' 遞迴處理子節點(放在父 LI 內部,形成巢狀 UL)
If hasChildren Then
catHtml = catHtml & ""
Call BuildTreeRecursive(catId, siteType, maxDepth, depth + 1)
catHtml = catHtml & "
"
End If
rs.MoveNext
Loop
If depth = 0 Then
catHtml = catHtml & "
"
End If
rs.Close
Set rs = Nothing
End Sub
' 取得子節點數(可優化為單次查詢快取)
Function GetChildCount(parentId, siteType)
Dim rs, sql, count
sql = "SELECT COUNT(*) AS Cnt FROM Category WHERE ParentID = " & CLng(parentId) & " AND U_ID = " & CLng(siteType) & " AND IsShow = 1"
Set rs = conn.Execute(sql)
If Not rs.EOF Then count = rs("Cnt") Else count = 0
rs.Close
GetChildCount = count
End Function
' IIf 輔助函數
Function IIf(cond, trueVal, falseVal)
If cond Then IIf = trueVal Else IIf = falseVal
End Function
%>
<script>
// 分類樹互動控制器
var CategoryTree = {
// 切換展開/收合
toggle: function(catId, childCount) {
var childrenUl = document.getElementById('children_' + catId);
var iconImg = document.getElementById('icon_' + catId);
var itemLi = document.getElementById('cat_' + catId);
if (!childrenUl) return; // 無子節點
var isHidden = (childrenUl.style.display === 'none');
if (isHidden) {
// 展開
childrenUl.style.display = 'block';
iconImg.src = 'images/minus.gif';
itemLi.classList.add('expanded');
itemLi.classList.remove('collapsed');
} else {
// 收合
childrenUl.style.display = 'none';
iconImg.src = 'images/plus.gif';
itemLi.classList.add('collapsed');
itemLi.classList.remove('expanded');
}
// 可選:記憶狀態到 Cookie/LocalStorage
this.saveState(catId, !isHidden);
},
// 儲存狀態
saveState: function(catId, expanded) {
try {
var states = JSON.parse(localStorage.getItem('cat_tree_states') || '{}');
states[catId] = expanded;
localStorage.setItem('cat_tree_states', JSON.stringify(states));
} catch(e) {}
},
// 載入狀態
loadStates: function() {
try {
var states = JSON.parse(localStorage.getItem('cat_tree_states') || '{}');
for (var catId in states) {
var childrenUl = document.getElementById('children_' + catId);
var iconImg = document.getElementById('icon_' + catId);
var itemLi = document.getElementById('cat_' + catId);
if (childrenUl && iconImg) {
if (states[catId]) {
childrenUl.style.display = 'block';
iconImg.src = 'images/minus.gif';
itemLi.classList.add('expanded');
} else {
childrenUl.style.display = 'none';
iconImg.src = 'images/plus.gif';
itemLi.classList.add('collapsed');
}
}
}
} catch(e) {}
},
// 全部展開/收合
expandAll: function() {
var icons = document.querySelectorAll('.toggle-icon');
icons.forEach(function(icon) {
var catId = icon.id.replace('icon_', '');
CategoryTree.toggle(catId, 1);
});
},
collapseAll: function() {
var icons = document.querySelectorAll('.toggle-icon');
icons.forEach(function(icon) {
var catId = icon.id.replace('icon_', '');
var childrenUl = document.getElementById('children_' + catId);
if (childrenUl && childrenUl.style.display !== 'none') {
CategoryTree.toggle(catId, 1);
}
});
}
};
// 頁面載入時恢復狀態
document.addEventListener('DOMContentLoaded', function() {
CategoryTree.loadStates();
});
</script>
<style>
.category-tree {
list-style: none;
padding: 0;
margin: 0;
font-family: "Microsoft JhengHei", sans-serif;
font-size: 14px;
}
.category-tree li {
position: relative;
margin: 2px 0;
line-height: 1.6;
}
.category-tree .indent {
display: inline-block;
/* 左側縮進由 ASP 動態產生 */
}
.category-tree .toggle-icon,
.category-tree .leaf-icon {
width: 16px;
height: 16px;
vertical-align: middle;
margin-right: 4px;
}
.category-link {
text-decoration: none;
color: #2c3e50;
display: inline-block;
padding: 2px 6px;
border-radius: 3px;
transition: background 0.2s;
}
.category-link:hover {
background: #e8f4fd;
color: #3498db;
}
.category-tree li.expanded > .category-link {
font-weight: bold;
background: #e8f4fd;
}
.category-tree ul {
list-style: none;
padding: 0;
margin: 0 0 0 10px;
border-left: 1px dotted #bdc3c7;
}
/* 動畫效果 */
.category-tree ul {
transition: all 0.3s ease;
overflow: hidden;
}
</style>
<!--#include file="conn.asp"-->
<!--#include file="category_tree.asp"-->
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>分類管理</title>
<!-- CSS 內聯或外部引用 -->
</head>
<body>
<div class="container">
<h2>產品分類</div>
<div class="toolbar">
<button onclick="CategoryTree.expandAll()">全部展開</button>
<button onclick="CategoryTree.collapseAll()">全部收合</button>
</div>
<%
' 初始化資料庫連線
Set conn = GetConnection()
' 渲染分類樹(根節點 ParentID=0,站點類型=1,最大深度 4)
Call RenderCategoryTree(0, 1, 4)
Call CloseConnection()
%>
</div>
<!-- JavaScript 內聯或外部引用 -->
</body>
</html>
CREATE INDEX IX_Category_ParentID ON Category(ParentID, U_ID, IsShow)<!-- ASP 生成時加入 ARIA 屬性 -->
catHtml = catHtml & ""
catHtml = catHtml & "
"
' JS 更新時同步 aria-expanded
' itemLi.setAttribute('aria-expanded', isHidden ? 'true' : 'false');
%>