不用迭代算法而快速实现的jsp树结构算法数据结构JSPXPSQL

程序员文章站 2022-07-12 16:27:05

...

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD><TITLE>不用迭代算法而快速实现的jsp树结构</TITLE>
<META http-equiv=Content-Type content=text/html;charset=gb2312>
<META content=360doc name=classification>
<META content=不用迭代算法而快速实现的jsp树结构 name=keywords>
<META content=不用迭代算法而快速实现的jsp树结构 name=description>
<META content=www.360doc.com name=author>
<STYLE>.Title01 {
FONT-SIZE: 12px; COLOR: #004499; LINE-HEIGHT: 20px; FONT-FAMILY: arial, helvetica
}
.Title01 A {
COLOR: #0077cc; TEXT-DECORATION: none
}
.Title01 A:hover {
COLOR: #997722; TEXT-DECORATION: none
}
.Title01 A:visited {
TEXT-DECORATION: none
}
.TitleDate {
FONT-WEIGHT: bold; FONT-SIZE: 10px; COLOR: #999999; FONT-FAMILY: arial, helvetica
}
.TitleContent {
FONT-SIZE: 12px; COLOR: #000000; LINE-HEIGHT: 20px; FONT-FAMILY: arial, helvetica
}
.TitleContent A {
COLOR: #0077cc; TEXT-DECORATION: none
}
.TitleContent A:hover {
COLOR: #997722; TEXT-DECORATION: none
}
.TitleContent A:visited {
TEXT-DECORATION: none
}
.p2 {
FONT-SIZE: 12px; LINE-HEIGHT: 24px
}
.p2 A:visited {
COLOR: #261cdc
}
.p3 {
FONT-FAMILY: arial
}
.p3 {
FONT-SIZE: 9pt; LINE-HEIGHT: 18px
}
</STYLE>

<SCRIPT language=javascript>

</SCRIPT>

<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY text=#000000 bottomMargin=0 vLink=#261cdc link=#261cdc bgColor=#ffffff
topMargin=1>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
 <TD><A href="http://duduwolf.360doc.com/index.aspx" target=_blank><IMG
 src="不用迭代算法而快速实现的jsp树结构.files/iDocumentBanner.gif" border=0></A></TD>
 <TD align=middle><A href="http://duduwolf.360doc.com/index.aspx"
 target=_blank><IMG src="不用迭代算法而快速实现的jsp树结构.files/360docAd.gif"
 border=0></A></TD></TR>
<TR>
 <TD align=middle height=3></TD></TR>
<TR>
 <TD colSpan=2>
 <TABLE height=22 cellSpacing=0 cellPadding=0 width="100%" border=0
 valign="top">
 <TBODY>
 <TR bgColor=#fffcf4 height=22>
 <TD class=p2>不用迭代算法而快速实现的jsp树结构（转载）&05.11.14 &from <A
 href="http://duduwolf.360doc.com/UserHome/677.aspx">smoking_boy</A>　<A
 href="http://www.chinaitpower.com/A/2005-06-16/150031.html">来源</A>　
 </TD>
 <TD class=p2 align=right width=120><A
 href="http://duduwolf.360doc.com/showWeb/0/1/31209.aspx">上一篇</A>&&&&<A
 href="http://duduwolf.360doc.com/showWeb/0/1/30257.aspx">下一篇</A>&&&&</TD></TR></TBODY></TABLE>
 <TABLE height=22 cellSpacing=0 cellPadding=0 width="100%" border=0
 valign="top">
 <TBODY>
 <TR bgColor=#fdf9e7 height=22>
 <TD class=p2></TD>
 <TD class=p2 align=right>这篇文章不错，<A
 href="http://duduwolf.360doc.com/ReSaveMenu.aspx?ArticleID=30580">我也要收藏</A>&&&&
 </TD></TR></TBODY></TABLE></TD></TR>
<TR></TR></TBODY></TABLE>
<TABLE>
<TBODY>
<TR>
 <TD>
 在web页面上实现树状结构,有点麻烦. 在最近的一个MIS<A
 href="http://www.chinaitpower.com/System/index.html"
 target=_blank>系统</A>的开发中,我们项目组大量用到了树结构:比如人员的选择,单位的选择等待. 这个MIS<A
 href="http://www.chinaitpower.com/System/index.html"
 target=_blank>系统</A>所用的<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>是oracle 9i.& oracle 9i 的<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>支持迭代查询.我们的树是由牛人彭越写的,不过 也参照了<A
 href="http://www.chinaitpower.com/Net/index.html"
 target=_blank>网络</A>上比较著名的xtree(可以到此下载:http://webfx.eae.net/),他的树算法支持无限级的树结构,不过性能好像 很慢.我持保留态度. 他用到的关键技术就是这句话: String
 <A href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A> = "select dwxh,dwbh,dwmc,dwfxh,level cc from xt_dw
 connect by& prior dwxh = dwfxh start with dwfxh = 0"; 可是许多<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>不支持迭代查询,并且迭代查询速度真是不能忍受.有什么更好的办法呢.下面说说我的解决方案.
 一:需求的提出 1:客户需要一个关于部门人员的树结构,<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>为my<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>4.1 2:<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>实现 二:建表: 1: 用户信息表: 各字段为:用户序号,用户编号,用户名称,单位序号,密码,用户登陆号 create
 table XT_YH ( & YHXH& INT(9) NOT NULL auto_increment
 PRIMARY KEY, & YHBH& VARCHAR(30), & YHMC&
 VARCHAR(30), & DWXH& INT(9), & PWD&&
 VARCHAR(20), & YHDLH VARCHAR(30) ) --插入三条测试数据: --insert
 into xt_yh(yhbh,yhmc,dwxh,pwd,yhdlh)
 values('licl','李春雷',2,'password','licl') --insert into
 xt_yh(yhbh,yhmc,dwxh,pwd,yhdlh)
 values('fengx','冯欣',2,'password','fengx') --insert into
 xt_yh(yhbh,yhmc,dwxh,pwd,yhdlh)
 values('wangqx','王庆香',6,'password','wangqx') 2: 单位部门表 各字段为:单位序号,单位编号,单位名称,单位父序号 create
 table XT_DW ( & DWXH& int(9) NOT NULL auto_increment
 PRIMARY KEY, & DWBH& VARCHAR(10), & DWMC&
 VARCHAR(30), & DWFXH int(9) ) --插入5条测试数据 --insert into
 xt_dw(dwbh,dwmc,dwfxh) values('0100000000','武汉科技局',0); --insert into
 xt_dw(dwbh,dwmc,dwfxh) values('0101000000','人事处',1); --insert into
 xt_dw(dwbh,dwmc,dwfxh) values('0102000000','后勤处',1); --insert into
 xt_dw(dwbh,dwmc,dwfxh) values('0101010000','人事处son1',2); --insert into
 xt_dw(dwbh,dwmc,dwfxh) values('0101020000','人事处son2',2); --insert into
 xt_dw(dwbh,dwmc,dwfxh) values('0102010000','后勤处son1',3);
 注意: 为了实现快速的树结构实现,我需要充分利用单位编号DWBH,DWBH才有10位编码,其中,第一第二位表示一级单位,第三第四位表示二级单位, 第五六位表示三级单位...那么10位编码就可以实现五级单位的树结构. 比如:测试数据的树结构如下: &
 1& 武汉科技局: &2& 人事处 &&3&
 人事处son1 &&3& 人事处son2 &2&
 后勤处 &&3后勤处son1
 其实XT_DW表中的父序号是多余的.不过如果你要用迭代算法来实现,就是必须的 才有10位编码,我只需要一句简单快速的<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>语句就可以实现树结构: String <A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A> = "select dwxh,dwbh,dwmc,dwfxh from xt_dw order by
 dwbh" 这句<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>在几乎所有的<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>平台都能执行,速度也快. 下面贴出采用xtree,用10位编码而不是迭代算法实现的树:
 /*******Constants.<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>**********/
 package com.lcl.common;
 public class Constants { & &public static final String
 DBDRIVER = "com.my<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>.jdbc.Driver";&&&
 //MYSQL驱动 & &public static final String DBUrl="jdbc:my<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>://localhost/beauoa"; //<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>url & &public static final String
 USERNAME="root";&&&&&&&&&&&&&&&&&&&&&&
 //<A href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>用户名 & &public static final String
 PASSWORD="root";&&&& //<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>密码 & & }
 /**********DbAccess.<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>****************/
 package com.lcl.common;
 import <A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>.<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>.*; import <A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>.lang.*;
 /** &* @author 李春雷 &* &* TODO
 要更改此生成的类型注释的模板，请转至 &* <A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>访问类 &*/ public class DbAccess {&
 &String strDBDriver = Constants.DBDRIVER; &String
 strDBUrl = Constants.DBUrl; &String username =
 Constants.USERNAME; &String password =
 Constants.PASSWORD; &private Connection conn =
 null; &private Statement stmt = null; &ResultSet
 rs=null; &//注册<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>驱动<A
 href="http://www.chinaitpower.com/Dev/index.html"
 target=_blank>程序</A> &public DbAccess() &{&
 &&try &&{&
 &&&Class.forName(strDBDriver); &&} &&//异常处理 &&catch(
 <A href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>.lang.ClassNotFoundException
 e) &&{ &&&System.err.println("DbAccess():"+e.getMessage()); &&} &} &//建立<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A>连接及定义数据查询 &public ResultSet
 executeQuery(String <A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>) &{ &&rs=null; &&try &&{ &&&conn=DriverManager.getConnection(strDBUrl,username,password); &&&stmt=conn.createStatement(); &&&rs=stmt.executeQuery(<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>); &&} &&catch(SQLException
 ex) &&{ &&&System.err.println("ap.executeQuery:"+ex.getMessage()); &&} & &&return
 rs; &} &//定义数据操库作 &public void
 executeUpdate(String <A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>) &{ &&stmt=null; &&rs=null; &&try &&{ &&&conn=DriverManager.getConnection(strDBUrl,username,password); &&&stmt=conn.createStatement(); &&&stmt.executeQuery(<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>); &&&stmt.close(); &&&conn.close(); &&} &&catch(SQLException
 ex) &&{ &&&System.err.println("ap.executeQuery:"+ex.getMessage()); &&} &} &//关闭<A
 href="http://www.chinaitpower.com/Dev/DataBase/index.html"
 target=_blank>数据库</A> &public void
 closeStmt() &{ &&try &&{ &&&stmt.close(); &&} &&catch(SQLException
 e) &&{ &&&e.printStackTrace(); &&} &} &public
 void
 closeConn() &{ &&try &&{ &&&conn.close(); &&} &&catch(SQLException
 e) &&{ &&&e.printStackTrace(); &&} &} &public
 static void main(String[]
 args){ &&System.out.println("hello,it's
 test"); &&DbAccess dbaccess = new
 DbAccess(); &&String <A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A> = "select * from xt_yh"; &&ResultSet rs
 = dbaccess.executeQuery(<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>); &&try &&{ &&&while(rs.next()){ &&&&System.out.print(rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+rs.getString(5)+rs.getString(6)); &&&&System.out.println(); &&&} &&dbaccess.closeStmt(); &&dbaccess.closeConn(); &&}
 &&catch (SQLException e)
 &&{ &&&// TODO 自动生成 catch
 块 &&&e.printStackTrace(); &&} &} &}
 &/*********DepEmplConfig.jsp************/
 &&%@ page contentType="text/html; charset=gb2312" language="<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>" import="<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>.<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>.*,com.lcl.common.*" errorPage=""
 %& &!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
 "<A
 href="http://www.w3.org/TR/html4/loose.dtd">http://www.w3.org/TR/html4/loose.dtd</A>"& &html& &head& &meta
 http-equiv="Content-Type" content="text/html;
 charset=gb2312"& &title&无标题文档&/title& &HEAD& &script
 type="text/<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>script"
 src="../resources/xDataTree.js"&&/script& &link
 type="text/css" rel="stylesheet" href="../resources/xtree.css"
 /& &style type="text/css"&
 body
 { &background:&white; &color:&&black; } &/style& &TITLE&
 New Document &/TITLE& &META NAME="Generator"
 CONTENT="EditPlus"& &META NAME="Author"
 CONTENT=""& &META NAME="Keywords" CONTENT=""& &META
 NAME="Description" CONTENT=""& &/HEAD& &script
 type="text/<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>script"&&
 webFXTreeConfig.rootIcon&&=
 "../resources/images/xp/folder.png"; webFXTreeConfig.openRootIcon&=
 "../resources/images/xp/openfolder.png"; webFXTreeConfig.folderIcon&&=
 "../resources/images/xp/folder.png"; webFXTreeConfig.openFolderIcon&=
 "../resources/images/xp/openfolder.png"; webFXTreeConfig.fileIcon&&=
 "../resources/images/xp/file.png"; webFXTreeConfig.lMinusIcon&&=
 "../resources/images/xp/Lminus.png"; webFXTreeConfig.lPlusIcon&&=
 "../resources/images/xp/Lplus.png"; webFXTreeConfig.tMinusIcon&&=
 "../resources/images/xp/Tminus.png"; webFXTreeConfig.tPlusIcon&&=
 "../resources/images/xp/Tplus.png"; webFXTreeConfig.iIcon&&&=
 "../resources/images/xp/I.png"; webFXTreeConfig.lIcon&&&=
 "../resources/images/xp/L.png"; webFXTreeConfig.tIcon&&&=
 "../resources/images/xp/T.png"; webFXTreeConfig.blankIcon&&&&&&
 = "../resources/images/blank.png";
 var tree = new WebFXTree("单位人员基本情况","R0"); var child; var
 nodeToAddPerson;
 function addDeptTreeNode(preNodeLevel,curNodeLevel,dispLabel,sKey,sTag)
 { & if(curNodeLevel==1) { &&&& child =
 tree.add(new WebFXTreeItem(dispLabel,sKey,sTag)); & } &
 else { &&& if(curNodeLevel==preNodeLevel)
 { &&&&&&
 if(child.parentNode) &&&&&&& child =
 child.parentNode.add(new
 WebFXTreeItem(dispLabel,sKey,sTag)); &&&
 } &&& if(curNodeLevel&preNodeLevel)
 { &&&&&& child = child.add(new
 WebFXTreeItem(dispLabel,sKey,sTag)); &&&
 } &&& if(curNodeLevel&preNodeLevel)
 { &&&&&&&
 for(i=0;i&preNodeLevel-curNodeLevel+1;i++)
 &&&&&&&&&& child =
 child.parentNode; &&&&&&& child =
 child.add(new WebFXTreeItem(dispLabel,sKey,sTag)); &&&
 } & } & return child; }
 function treeClick() { &if(tree.getSelected())
 { &&&&
 if(tree.getSelected().childNodes.length==0&&tree.getSelected().key!="R0")
 &&&&&& cmdDelete.disabled =
 false; &&&& else
 &&&&&& cmdDelete.disabled = true;
 &&&& if(tree.getSelected().key.substr(0,2)=="RZ")
 { &&&&&& cmdAddDept.disabled =
 true; &&&&&& cmdAddPeople.disabled =
 true; &&&&&& var
 strYhxh; &&&&&& strYhxh =
 tree.getSelected().key.substr(2); &&&&&&
 //window.open("../userAdm/editYh.do?yhxh="+strYhxh,"main"); &&&&
 } &&&& else
 if(tree.getSelected().key.substr(0,2)=="RB")
 { &&&&&& cmdAddDept.disabled =
 false; &&&&&& cmdAddPeople.disabled =
 false; &&&&&& var
 strDwxh; &&&&&& strDwxh =
 tree.getSelected().key.substr(2); &&&&&&
 //window.open("../userAdm/editBm.do?dwxh="+strDwxh,"main"); &&&&
 } &&&& else
 { &&&&&& cmdAddDept.disabled =
 false; &&&&&& cmdAddPeople.disabled =
 true; &&&&&&
 //window.open("yhroot.jsp","main"); &&&&
 } &} }
 function addPeople() { &&& var
 strDwxh; &&& if(tree.getSelected()) { && if
 (tree.getSelected().key.substr(0,2)=="RB")
 { &&&&&&& strDwxh =
 tree.getSelected().key.substr(2); &&//window.open("../userAdm/addYh.do?dwxh="+strDwxh,"main"); &&alert("addPeople"); &&
 } &&& } }
 function addDept() { &&& var
 strDwxh; &&& if(tree.getSelected()) { && if
 (tree.getSelected().key.substr(0,2)=="RB")
 { &&&&&&& strDwfxh =
 tree.getSelected().key.substr(2); &&//window.open("../userAdm/addBm.do?dwfxh="+strDwfxh,"main"); &&
 &alert("addDept"); &&
 } &&&&& else if(tree.getSelected().key=="R0")
 { &&&&&&&
 //window.open("../userAdm/addBm.do?dwfxh=0","main"); &&&&&&&
 alert("addDept"); &&&&&
 } &&& } }
 function deleSelected() { &
 if(!confirm("确认删除该节点吗？")) &&&&&
 return; & if(tree.getSelected()) { &&&
 if(tree.getSelected().key.substr(0,2)=="RB")
 { &&&&&& var
 strDwxh; &&&&&& strDwxh =
 tree.getSelected().key.substr(2); &&&&&&
 //window.open("../userAdm/delBm.do?dwxh="+strDwxh,"main"); &&&&&&
 alert("deleSelected"); &&& } &&& else
 if(tree.getSelected().key.substr(0,2)=='RZ')
 { &&&&&& var
 strYhxh,strYhbh; &&&&&& strYhxh =
 tree.getSelected().key.substr(2); &&&&&&
 strYhbh = tree.getSelected().tag; &&&&&&
 //window.open("../userAdm/delYh.do?yhxh="+strYhxh+"&yhbh="+strYhbh,"main"); &&&&&&
 alert("deleSelected"); &&& } & } }
 function removeNode() { & if(tree.getSelected())
 { &&& var node =
 tree.getSelected(); &&& node.remove(); &
 } }
 function addPeopleNode(strParentKey,strKey,strText,strTag) { &
 if(tree.getSelected()) { &&& var node =
 tree.getSelected(); &&& var
 childNode; &&& //node.expand(); &&&
 childNode = node.add(new
 WebFXTreeItem(strText,strKey,strTag,"","","../resources/images/people1.png")); &&&
 node.expand(); //why I do so? I dont want to tell
 you,hah! &&& childNode.focus(); &&&
 treeClick(); & } }
 function addDeptNode(strParentKey,strKey,strText,strTag) { &
 if(tree.getSelected()) { &&& var node =
 tree.getSelected(); &&& var
 childNode; &&& childNode = node.add(new
 WebFXTreeItem(strText,strKey,strTag)); &&&
 node.expand(); &&&
 childNode.focus(); &&& treeClick(); & } }
 function updateDeptNode(strTag,strText) { &
 if(tree.getSelected()) { &&& var node =
 tree.getSelected(); &&& node.text =
 strText; &&& node.tag& =
 strTag; &&& node.focus(); & } }
 function updatePeopleNode(strTag,strText) { &
 if(tree.getSelected()) { &&& var node =
 tree.getSelected(); &&& node.text =
 strText; &&& node.tag& =
 strTag; &&& node.focus(); &
 } } &/script& &% int dwxh; int dwfxh; int
 yhxh; String dwbh = null; String dwmc = null; String yhmc =
 null; String yhbh = null; int preLevel =1; int level =
 1; DbAccess dbaccess = new DbAccess(); String <A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A> = "select dwxh,dwbh,dwmc,dwfxh from xt_dw order by
 dwbh"; ResultSet rs = dbaccess.executeQuery(<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>); try { &while(rs.next()) &{ &&&&&&&
 dwxh = rs.getInt(1); &&&&&&& dwbh =
 rs.getString(2); &&&&&&& dwmc =
 rs.getString(3); &&&&&&& dwfxh =
 rs.getInt(4); //通过单位编号计算level &&String last =
 dwbh.substring(9,10); &&int i =
 9; &&while(last.equals("0") &&
 i&0){ &&&i--; &&&last =
 dwbh.substring(i,i+1); && &&} && &&if(i==0
 || i==1) level =1; &&if(i==2 || i==3) level
 =2; &&if(i==4 || i==5) level =3; &&if(i==6 ||
 i==7) level =4; &&if(i==8 || i==9) level
 =5; // &&%& &&&&&&&&&&
 &script type="text/<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>script"&& &&&&
 nodeToAddPerson =
 addDeptTreeNode(&%=preLevel%&,&%=level%&,"&%=dwmc%&","RB&%=dwxh%&","&%=dwbh%&"); &&&&&&&
 &/script&&& && &&&% &&preLevel
 = level; &&String sub<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A> = "select yhxh,yhmc,yhbh from xt_yh where dwxh =
 "+Integer.toString(dwxh); &&ResultSet subRs =
 dbaccess.executeQuery(sub<A
 href="http://www.chinaitpower.com/Dev/DataBase/MsSql/index.html"
 target=_blank>sql</A>); &&&&&&
 while(subRs.next())
 { &&&&&&&&&&&&&
 yhxh =
 subRs.getInt(1); &&&&&&&&&&&&&
 yhmc =
 subRs.getString(2); &&&&&&&&&&&&&
 yhbh = subRs.getString(3);
 &&%& &&&&&&&&&&&&
 &script type="text/<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>script"&& &&&&
 nodeToAddPerson.add(new
 WebFXTreeItem("&%=yhmc%&","RZ&%=yhxh%&","&%=yhbh%&","","","../resources/images/people1.png")); &&&&&&&
 &/script& &&&&
 &% &&} && &} &dbaccess.closeStmt(); &dbaccess.closeConn(); } catch(Exception
 e) {
 } %&
 
 &base target="_self"& &META HTTP-EQUIV="PRAGMA"
 CONTENT="NO-CACHE"& &/head& &body& &table
 border="0" width="100%" cellspacing="0" cellpadding="0"& &
 &tr& &&& &td width="273"
 colspan="2"& &&&&&& &font face="宋体"
 size="3"&&&&&
 &&&&&&
 &/font& &&& &/td& &
 &/tr& & &tr& &&& &th width="33%"
 align="center" nowrap& &&&&& &p
 align="center"& &&&&& &INPUT
 id=cmdAddDept name="AddDept" type=button value="增加部门" onclick="addDept()"
 style="FONT-FAMILY: 楷体_GB2312; FONT-SIZE: 12pt; FONT-WEIGHT: bold; HEIGHT:
 24px; WIDTH: 80px" & &&&&&
 &/p& &&& &/th& &&& &th
 width="33%" align="center" nowrap& &&&&&
 &p align="center"& &&&&& &INPUT
 id=cmdAddPeople name="AddPeople" type=button value="增加用户"
 onclick="addPeople()" style="FONT-FAMILY: 楷体_GB2312; FONT-SIZE: 12pt;
 FONT-WEIGHT: bold; HEIGHT: 24px; WIDTH: 80px"
 & &&&&& &/p& &&&
 &/th& &&& &th width="33%" align="center"
 nowrap& &&&&& &p
 align="center"& &&&&& &INPUT
 id=cmdDelete name="Delete" type=button value=" 删除 "
 onclick="deleSelected()" style="FONT-FAMILY: 楷体_GB2312; FONT-SIZE: 12pt;
 FONT-WEIGHT: bold; HEIGHT: 24px; WIDTH: 80px"
 disabled& &&&&&
 &/p& &&& &/th& &
 &/tr& & &tr& &&& &td width="273"
 height="8"&
 colspan="2"&&nbsp; &&&&&
 &&& &/td& &
 &/tr& &/table& &/body& &div
 onclick="treeClick()"& &script type="text/<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>script"&&
 &document.write(tree); &/script& &/div& &/HTML&
 //其中jsp页面上的几个<A
 href="http://www.chinaitpower.com/Dev/Programme/Java/index.html"
 target=_blank>java</A>script函数为同事牛人彭越所写,我没改动,在此说明. </TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
 <TD class=p2 align=right bgColor=#fdf9e7 height=22><A
 href="http://duduwolf.360doc.com/showWeb/0/1/31209.aspx">上一篇</A>&&&&<A
 href="http://duduwolf.360doc.com/showWeb/0/1/30257.aspx">下一篇</A>&&&&（<A
 href="http://duduwolf.360doc.com/UserHome/677.aspx">smoking_boy</A>的分类目录[<A
 href="http://duduwolf.360doc.com/UserArt.aspx?UserID=677&CategoryID=1&GroupID=-1">我的图书馆</A>]*136篇）&&
 </TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
 <TD class=p2 bgColor=#fffcf4>发表评论</TD></TR>
<TR>
 <TD align=middle height=2></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=1 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
 <TD vAlign=top></TD>
 <TD vAlign=top>
 <FORM id=showWeb name=showWeb
 action=30580.aspx?Cream=0&CategoryID=0&ArticleID=30580
 method=post><INPUT type=hidden
 value=dDwtMTMzMjE3NjQ2Njt0PDtsPGk8MD47PjtsPHQ8QDA8cDxwPGw8RGF0YUtleXM7XyFJdGVtQ291bnQ7PjtsPGw8PjtpPDA+Oz4+Oz47Ozs7Ozs7Oz47Oz47Pj47PrMJmOXAYvkRKoedUaZNexdcdOy3
 name=__VIEWSTATE>
 <TABLE cellSpacing=0 cellPadding=0 width="90%" border=0>
 <TBODY>
 <TR>
 <TD class=p2 align=middle colSpan=2>游客请<A
 href="http://duduwolf.360doc.com/login.aspx?type=14&ArticleID=30580">登录</A>后再发表评论！
 </TD></TR></TBODY></TABLE></FORM></TD></TR></TBODY></TABLE></BODY></HTML>

相关标签：算法数据结构 JSP XP SQL

上一篇： OpenSearch最新功能介绍算法阿里巴巴工作

下一篇： 18位身份证号码校验码的算法（JAVA）- - Java算法

不用迭代算法而快速实现的jsp树结构 算法数据结构JSPXPSQL