萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> ASP 程式設計

ASP 無限級分類 + JS 收合展開:完整前後端整合實作

ASP 無限級分類樹狀結構:遞迴生成 HTML + JavaScript 互動完整實作

結合 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)             -- 圖示路徑
);

ASP 遞迴生成函數 (完整修正版)

<%
' ==========================================
' 分類樹渲染核心模組
' ==========================================
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 %>

JavaScript 互動模組

<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>

CSS 樣式

<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>

效能優化建議

  1. 單次查詢快取:將所有分類一次查出,存入 Dictionary/陣列,遞迴時在記憶體中查找子節點
  2. 分頁/懶載入:超大分類樹採用 AJAX 載入子節點
  3. 輸出快取:分類樹變動頻率低,可將生成 HTML 快存至 Application/檔案/Redis
  4. 資料庫索引:CREATE INDEX IX_Category_ParentID ON Category(ParentID, U_ID, IsShow)

無障礙支援 (ARIA)

<!-- ASP 生成時加入 ARIA 屬性 -->
catHtml = catHtml & "
  • " catHtml = catHtml & "" ' JS 更新時同步 aria-expanded ' itemLi.setAttribute('aria-expanded', isHidden ? 'true' : 'false'); %>
  • copyright © 萬盛學電腦網 all rights reserved