转自:http://java.mblogger.cn/zhipingch/posts/15336.aspx
类似 MSDN CSDN 导航树效果,JSP + JavaScript 实现!
New Document
'> 0)
{%>
onClick='ExpandNode(Node_,)'>+
>-
0)
{%>
onDblClick='ExpandNode(Node_,)'
>
_0' style='display: none' loaded='no'>
正在加载 ...
New Document
<%
String ParentNode = request.getParameter("PNode");
int i;
int j;
String nSpace="";
j= ParentNode.length()- ParentNode.replaceAll("_","").length();
for (i=0;i nSpace = nSpace + " "; String sHTML =""; i=0; java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // java.sql.Connection ConnectionX = java.sql.DriverManager.getConnection("jdbc:ODBC:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\Resin\doc\examples\Tree\tree.mdb","admin", ""); // java.sql.Statement StatementX = ConnectionX.createStatement(); java.sql.ResultSet ResultSetX = java.sql.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 = " + request.getParameter("PID")); int children; int ID; while (ResultSetX.next()) { children=ResultSetX.getInt("children"); ID=ResultSetX.getInt("id"); sHTML = sHTML + " " + nSpace + " if (children >0) sHTML = sHTML + " onClick='ExpandNode(" + ParentNode + "_" + (i + 1) + "," + ID + ")'>+"; else sHTML = sHTML + ">-"; sHTML = sHTML + "\n" + " if (children >0) sHTML = sHTML + " onDblClick='ExpandNode(" + ParentNode + "_" + (i + 1) + "," + ID + ")'"; sHTML = sHTML + ">" + ID + ": " + ResultSetX.getString("remark") + ""; if (children >0) sHTML = sHTML + " " + nSpace + " 正在加载 ..."; %>

