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 + " 正在加载 ...";

%>