採用 隱藏 iframe + JavaScript DOM 操作 + JSP 動態生成子樹 HTML 方案:
parentid = 0)ExpandNode()loaded='no'),隱藏 iframe 請求 subtree.jsp?PID=節點ID&PNode=節點DOM_IDsubtree.jsp 查詢子節點,輸出 HTML 片段寫入父頁面對應 <div>loaded='yes' 避免重複請求<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'> 正在載入 ...</div>
<% i++; } %>
<%
String ParentNode = request.getParameter("PNode");
int level = ParentNode.length() - ParentNode.replace("_", "").length(); // 計算層級
String indent = "";
for (int k = 0; k < level; k++) indent += " ";
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(" 正在載入 ...</div>");
i++;
}
out.print(html.toString());
%>
CREATE TABLE tree (
id AUTOINCREMENT PRIMARY KEY,
parentid LONG, -- 父節點 ID,根節點為 0
remark TEXT -- 顯示文字
);