萬盛學電腦網

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

JSP + JavaScript 實現 MSDN 風格無限級導航樹:動態載入子節點

樹形導航交互原理

採用 隱藏 iframe + JavaScript DOM 操作 + JSP 動態生成子樹 HTML 方案:

  1. 首次載入僅渲染根節點(parentid = 0)
  2. 用戶點擊展開圖標(+),觸發 ExpandNode()
  3. 若子節點未載入(loaded='no'),隱藏 iframe 請求 subtree.jsp?PID=節點ID&PNode=節點DOM_ID
  4. subtree.jsp 查詢子節點,輸出 HTML 片段寫入父頁面對應 <div>
  5. 切換顯示/隱藏狀態,標記 loaded='yes' 避免重複請求

核心代碼結構

Tree.jsp - 主樹頁面

<iframe width="100%" height="100" id="hiddenframe"></iframe>
<script>
function ExpandNode(ParentNode, ParentId) {
    var NodeX = document.getElementById(ParentNode.id + '_0');
    if (NodeX.style.display == 'none') {
        NodeX.style.display = 'block';
        if (NodeX.getAttribute('loaded') == 'no') {
            document.frames['hiddenframe'].location.replace(
                "subtree.jsp?PID=" + ParentId + "&PNode=" + ParentNode.id);
            NodeX.setAttribute('loaded', 'yes');
        }
    } else {
        NodeX.style.display = 'none';
    }
}
</script>

<%-- 根節點查詢 --%>
<%
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  ResultSet rs = DriverManager.getConnection(
      "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=e:/resin-2.1.6/doc/examples/Tree/tree.mdb",
      "admin", "").createStatement()
      .executeQuery("SELECT *, (SELECT COUNT(*) FROM tree WHERE parentid = T.id) AS children FROM tree T WHERE parentid = 0");
  int i = 0;
  while (rs.next()) {
      int children = rs.getInt("children");
      int ID = rs.getInt("id");
%>
<div id='Node_<%= i %>'>
  <a href='#' <% if (children > 0) { %> onClick='ExpandNode(Node_<%= i %>, <%= ID %>)'>+</a> <% } else { %>>-</a><% } %>
  <a href='#' <% if (children > 0) { %> onDblClick='ExpandNode(Node_<%= i %>, <%= ID %>)' <% } %>>
    <%= rs.getString("remark") %></a>
</div>
<div id='Node_<%= i %>_0' style='display:none' loaded='no'>&nbsp;&nbsp;正在載入 ...</div>
<% i++; } %>

SubTree.jsp - 子樹片段生成

<%
  String ParentNode = request.getParameter("PNode");
  int level = ParentNode.length() - ParentNode.replace("_", "").length(); // 計算層級
  String indent = "";
  for (int k = 0; k < level; k++) indent += "&nbsp;&nbsp;";

  ResultSet rs = DriverManager.getConnection(...).createStatement()
      .executeQuery("SELECT *, (SELECT COUNT(*) FROM tree WHERE parentid = T.id) AS Children FROM tree T WHERE parentid = " + request.getParameter("PID"));

  StringBuilder html = new StringBuilder();
  int i = 0;
  while (rs.next()) {
      int children = rs.getInt("Children");
      int ID = rs.getInt("id");
      String nodeId = ParentNode + "_" + (i + 1);
      html.append("<div id='").append(nodeId).append("'>").append(indent);
      html.append("<a href='#' ");
      if (children > 0) html.append("onClick='ExpandNode(").append(nodeId).append(",").append(ID).append(")'>+");
      else html.append(">-");
      html.append("</a><a href='#' ");
      if (children > 0) html.append("onDblClick='ExpandNode(").append(nodeId).append(",").append(ID).append(")'");
      html.append(">").append(ID).append(": ").append(rs.getString("remark")).append("</a></div>");
      if (children > 0) html.append("<div id='").append(nodeId).append("_0' style='display:none' loaded='no'>").append(indent).append("&nbsp;&nbsp;正在載入 ...</div>");
      i++;
  }
  out.print(html.toString());
%>

資料表結構

CREATE TABLE tree (
  id AUTOINCREMENT PRIMARY KEY,
  parentid LONG,          -- 父節點 ID,根節點為 0
  remark TEXT             -- 顯示文字
);

現代化改造建議

  • 前端改用 zTree / jsTree / Ant Design Tree 等成熟組件
  • 後端提供 RESTful API 返回 JSON,採用 遞歸/遞歸+緩存 構建樹結構
  • 資料庫改用 遞歸 CTE 或 Closure Table 儲存層級關係
  • 棄用 JDBC-ODBC Bridge(Java 8 已移除),改用 UCanAccess 或遷移至 MySQL/PostgreSQL
copyright © 萬盛學電腦網 all rights reserved