liuzidong
- 浏览: 2271523 次
- 性别:
- 来自: 成都
-
文章分类
- 全部博客 (357)
- J2EE (49)
- JavaScript (40)
- Spring (19)
- Struts (5)
- CSS (8)
- Hibernate (16)
- Java (67)
- DWR (4)
- JSON (3)
- XFIRE (1)
- Tomcat (1)
- Ant (2)
- 设计模式 (2)
- 经典收藏 (2)
- JSP (10)
- Linux (0)
- WebLogic (11)
- myeclipse (13)
- Buffalo (4)
- 文件上传相关 (1)
- oracle (33)
- html (6)
- JSTL (3)
- SVN (2)
- GIT (1)
- 孙卫琴（Java网络编程精解） (1)
- DOM4J (2)
- Swing (1)
- AJAX (1)
- Eclipse (5)
- 日志组件 (3)
- PowerDesigner (1)
- Jquery (22)
- IT技术开发相关网址 (1)
- Nutz (1)
- 其它 (1)
- Velocity (3)
- WebService (1)
- MySql (2)
- Android (1)
- Maven (2)
- Quartz (11)
- Lucene (1)
- springsource (1)
- Junit (1)
- Activiti (0)
最新评论
-
yzlseu：
拼凑，没有营养
Activiti进阶—分配组任务 -
zhangsenhao：
非常赞！代码很清楚
SpringMVC3.0+MyIbatis3.0(分页示例) -
xiamw2000：
分页写得不对，应该是 ： order by ${orderNa ...
SpringMVC3.0+MyIbatis3.0(分页示例) -
sheertewtw：
...
SpringMVC:上传与下载 -
kingtoon：
...
XSS之xssprotect
参考资料
1 spring+struts2+hibernate+json+dtree实现的无限级联树
http://luanmad-java.iteye.com/blog/459960
特别说明：数据库使用了以上这篇文章的表及相关数据
环境：XP+Oracle10i+Myeclipse6.6+JDK1.6
Ztree版本：3.0
工程图片如下：
运行效果如下：
一 前台代码如下：(tree.jsp)
二 后台代码如下：
1 TreeNodeServlet.java
2 树菜单类(BaseTreeNode.java)
3 DAO(TreeDAO.java)
4 工具类(UtilCommon.java)
5 数据库文件(oracle)
A 创建表数据
B 插入数据
参见工程如下
1 spring+struts2+hibernate+json+dtree实现的无限级联树
http://luanmad-java.iteye.com/blog/459960
特别说明：数据库使用了以上这篇文章的表及相关数据
环境：XP+Oracle10i+Myeclipse6.6+JDK1.6
Ztree版本：3.0
工程图片如下：
运行效果如下：
一 前台代码如下：(tree.jsp)
<%@ page language="java" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<HTML>
<HEAD>
<base href="<%=basePath%>">
<TITLE> ZTREE DEMO - Async</TITLE>
<meta http-equiv="content-type" content="text/html; charset=GBK">
<link rel="stylesheet" href="css/demo.css" type="text/css">
<link rel="stylesheet" href="css/zTreeStyle/zTreeStyle.css" type="text/css">
<script type="text/javascript" src="js/jquery-1.4.4.min.js"></script>
<script type="text/javascript" src="js/jquery.ztree.core-3.0.js"></script>
<SCRIPT LANGUAGE="JavaScript">
<!--
var setting = {
async: {
enable: true,
url:"treeNode",
autoParam:["id", "name=n","url"],
expandSpeed:false,
dataFilter: filter
},
callback: {
onClick: onClick,
beforeAsync: beforeAsync,
onCollapse: onCollapse,
onExpand: onExpand
}
};
function getTime() {
var now= new Date(),
h=now.getHours(),
m=now.getMinutes(),
s=now.getSeconds(),
ms=now.getMilliseconds();
return (h+":"+m+":"+s+ " " +ms);
}
function onCollapse(event, treeId, treeNode) {
//alert("onCollapse: " + treeId + "," + treeNode.name + "," + treeNode.id+ "," + treeNode.url);
}
function onExpand(event, treeId, treeNode) {
//alert("onExpand: " + treeId + "," + treeNode.name+ "," + treeNode.id+ "," + treeNode.url);
}
function onClick(event, treeId, treeNode, clickFlag) {
//alert("onClick: " + treeId + "," + treeNode.name + "," + clickFlag+ "," + treeNode.id+ "," + treeNode.url);
}
function filter(treeId, parentNode, childNodes) {
if (!childNodes) return null;
for (var i=0, l=childNodes.length; i<l; i++) {
childNodes[i].name = childNodes[i].name.replace(/\.n/g, '.');
}
return childNodes;
}
function beforeAsync(treeId, treeNode) {
return treeNode ? treeNode.level < 5 : true;
}
$(document).ready(function(){
$.fn.zTree.init($("#treeDemo"), setting);
});
//-->
</SCRIPT>
</HEAD>
<BODY>
<div class="content_wrap" >
<div class="zTreeDemoBackground left">
<ul id="treeDemo" class="ztree"></ul>
</div>
</div>
</BODY>
</HTML>
二 后台代码如下：
1 TreeNodeServlet.java
package net.liuzd.tree.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import net.liuzd.util.StringUtils;
import net.liuzd.util.UtilCommon;
public class TreeNodeServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
{
String pId = request.getParameter("id");
String pName = StringUtils.chineseStrUTF8(request.getParameter("n"));
System.out.println("PID: " + pId + ",pName: " + pName);
// 构造数据，可以从数据库中查询
String str = null;
if (pId == null) {
pId = "0";
}
str = UtilCommon.getChild(pId);
try {
reponse(request, response, str);
} catch (Exception e) {
e.printStackTrace();
}
}
public void reponse(HttpServletRequest request,
HttpServletResponse response, Object msg) throws Exception {
response.setContentType("text/plain");
response.setCharacterEncoding("UTF-8");
PrintWriter out = response.getWriter();
out.write(msg.toString());
out.flush();
out.close();
}
}
2 树菜单类(BaseTreeNode.java)
package net.liuzd.tree;
import java.io.Serializable;
import org.apache.commons.lang.builder.ToStringBuilder;
public class BaseTreeNode implements Serializable {
private static final long serialVersionUID = 1L;
/**定义树控件公共属性*/
/**树控件ID*/
protected String treeId;
/**树控件的名称*/
protected String treeName;
/**树控件的父ID*/
protected String parentId;
/**是否为父项,或者说是否有子项*/
protected boolean isParent;
/**控件标题*/
protected String treeTitle;
public String getTreeId() {
return treeId;
}
public BaseTreeNode setTreeId(String treeId) {
this.treeId = treeId;
return this;
}
public String getTreeName() {
return treeName;
}
public void setTreeName(String treeName) {
this.treeName = treeName;
}
public String getParentId() {
return parentId;
}
public void setParentId(String parentId) {
this.parentId = parentId;
}
public boolean isParent() {
return isParent;
}
public void setParent(boolean isParent) {
this.isParent = isParent;
}
public String getTreeTitle() {
return treeTitle;
}
public void setTreeTitle(String treeTitle) {
this.treeTitle = treeTitle;
}
public BaseTreeNode() {
}
public BaseTreeNode(String treeId, String treeName, String parentId,boolean isParent) {
this.treeId = treeId;
this.treeName = treeName;
this.parentId = parentId;
this.isParent = isParent;
}
public BaseTreeNode(String treeId, String treeName, String parentId,boolean isHasChild,String treeTitle) {
this(treeId,treeName,parentId,isHasChild);
this.treeTitle = treeTitle;
}
@Override
public String toString() {
return ToStringBuilder.reflectionToString(this);
}
}
3 DAO(TreeDAO.java)
package net.liuzd.tree.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import net.liuzd.tree.BaseTreeNode;
public class TreeDAO implements ITree {
public void add(BaseTreeNode tree) {
}
public void del(BaseTreeNode tree) {
}
public BaseTreeNode get(BaseTreeNode tree) {
BaseTreeNode bean = null;
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
String treeId = tree.getTreeId();
String sql = "select * from TREENODES where ID=?";
conn = ConnectionUtils.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, treeId);
rs = ps.executeQuery();
while (rs.next()) {
bean = new BaseTreeNode(rs.getString("ID"), rs
.getString("NAME"), rs
.getString("PID"), isExpand(new BaseTreeNode().setTreeId(treeId)));
}
return bean;
} catch (SQLException e) {
throw new RuntimeException(e.getMessage(), e);
} finally {
try {
if (null != rs) {
rs.close();
rs = null;
}
if (null != ps) {
ps.close();
ps = null;
}
if (null != conn) {
conn.close();
conn = null;
}
} catch (SQLException e) {
throw new RuntimeException("关闭数据库连接出错..." + e.getMessage(), e);
}
}
}
public List<BaseTreeNode> getChildTree(BaseTreeNode tree) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<BaseTreeNode> children = new ArrayList<BaseTreeNode>();
try {
String treeId = tree.getTreeId();
String sql = "select * from TREENODES where PID=?";
conn = ConnectionUtils.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, treeId);
rs = ps.executeQuery();
while (rs.next()) {
treeId = rs.getString("ID");
children.add(new BaseTreeNode(treeId, rs
.getString("NAME"), rs
.getString("PID"), isExpand(new BaseTreeNode().setTreeId(treeId))));
}
return children;
} catch (SQLException e) {
throw new RuntimeException(e.getMessage(), e);
} finally {
try {
if (null != rs) {
rs.close();
rs = null;
}
if (null != ps) {
ps.close();
ps = null;
}
if (null != conn) {
conn.close();
conn = null;
}
} catch (SQLException e) {
throw new RuntimeException("关闭数据库连接出错..." + e.getMessage(), e);
}
}
}
public void update(BaseTreeNode tree) {
}
public boolean isExpand(BaseTreeNode tree) {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
String treeId = tree.getTreeId();
String sql = "select count(1) counts from TREENODES where PID=?";
conn = ConnectionUtils.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, treeId);
rs = ps.executeQuery();
int counts = 0;
while (rs.next()) {
counts = rs.getInt(1);
}
return counts > 0;
} catch (SQLException e) {
throw new RuntimeException(e.getMessage(), e);
} finally {
try {
if (null != rs) {
rs.close();
rs = null;
}
if (null != ps) {
ps.close();
ps = null;
}
if (null != conn) {
conn.close();
conn = null;
}
} catch (SQLException e) {
throw new RuntimeException("关闭数据库连接出错..." + e.getMessage(), e);
}
}
}
}
4 工具类(UtilCommon.java)
package net.liuzd.util;
import java.util.List;
import net.liuzd.tree.BaseTreeNode;
import net.liuzd.tree.dao.ITree;
import net.liuzd.tree.dao.TreeDAO;
public class UtilCommon {
public static String getRoot(String treeId) {
String s = "";
ITree treeDao = new TreeDAO();
BaseTreeNode node = treeDao.get(new BaseTreeNode().setTreeId(treeId));
s = "[";
s += "{\"id\":\"" + node.getTreeId() + "\",\"name\":\"" + node.getTreeName()
+ "\",\"isParent\":" + node.isParent()+ "}";
s = s.substring(0, s.length() - 1);
s += "]";
return s;
}
public static String getChild(String treeId) {
String s = "[";
ITree treeDao = new TreeDAO();
List<BaseTreeNode> children = treeDao.getChildTree(new BaseTreeNode().setTreeId(treeId));
for (BaseTreeNode node : children) {
s += "{\"id\":\"" + node.getTreeId() + "\",\"name\":\"" + node.getTreeName()
+ "\",\"isParent\":" + node.isParent()+ "},";
}
s = s.substring(0, s.length() - 1);
s += "]";
return s;
}
public static void main(String[] args) {
System.out.println(getRoot("513400000000"));
}
}
5 数据库文件(oracle)
A 创建表数据
create table TREENODES ( id NUMBER not null, pid NUMBER not null, name VARCHAR2(200) not null, url VARCHAR2(200) not null, title VARCHAR2(200), target VARCHAR2(20), icon VARCHAR2(200), sort NUMBER not null, fontstylename VARCHAR2(500), iconopen VARCHAR2(80), open CHAR(1) )
B 插入数据
insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(35,0,'aaa','/index.jsp','aaa',NULL,'images/ajax_dtree/folder.gif',10,'font-weight:bold;font-size:14px;color:#0066FF',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(36,0,'bbb','/index.jsp','bbb',NULL,'images/ajax_dtree/folder.gif',2,'font-weight:bold;font-size:14px;color:#009900',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(37,36,'ccc','#','ccc',NULL,'images/ajax_dtree/folder.gif',3,';;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(39,35,'ggg','/index.jsp','ggg',NULL,'images/ajax_dtree/folder.gif',4,'font-weight:bold;font-size:14px;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(40,35,'fff','/index.jsp','fff',NULL,'images/ajax_dtree/folder.gif',5,';;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(92,35,'切实可行','/index.jsp','切实可行',NULL,'images/ajax_dtree/folder.gif',6,';;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(93,92,'优胜劣汰','/index.jsp','优胜劣汰',NULL,'images/ajax_dtree/folder.gif',7,';;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(94,92,'举国欢腾','/index.jsp','举国欢腾',NULL,'images/ajax_dtree/folder.gif',8,';;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(95,35,'基本原理','/index.jsp','基本原理',NULL,'images/ajax_dtree/folder.gif',9,';;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(96,0,'基本功','/index.jsp','基本功',NULL,'images/ajax_dtree/folder.gif',1,'font-weight:bold;font-size:14px;color:#9933CC',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(97,96,'艺术大师','/index.jsp','艺术大师',NULL,'images/ajax_dtree/folder.gif',11,'font-weight:bold;;;color:#999900',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(98,0,'lanmad!','/index.jsp','lanmad!',NULL,'images/ajax_dtree/folder.gif',12,'font-weight:bold;font-size:20px;color:#FF0000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(99,98,'架构与J2EE技术','/index.jsp','架构与J2EE技术',NULL,'images/ajax_dtree/folder.gif',19,'font-weight:bold;;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(100,98,'WEB开发（脚本神功与动态技术）','/index.jsp','WEB开发（脚本神功与动态技术）',NULL,'images/ajax_dtree/folder.gif',18,'font-weight:bold;;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(101,98,'Linux技术','#','Linux技术',NULL,'images/ajax_dtree/folder.gif',13,'font-weight:bold;;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(102,96,'中国','/index.jsp','中国',NULL,'images/ajax_dtree/folder.gif',16,';;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(103,96,'草木灰','#','草木灰',NULL,'images/ajax_dtree/folder.gif',17,';;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(104,98,'官方经典实例','#','官方经典实例',NULL,'images/ajax_dtree/folder.gif',14,'font-weight:bold;;;color:#000000',NULL,NULL); insert into treenodes(id,pid,name,url,title,target,icon,sort,fontStyleName,iconOpen,open) values(105,98,'数据库开发','#','数据库开发',NULL,'images/ajax_dtree/folder.gif',15,'font-weight:bold;;;color:#000000',NULL,NULL);
参见工程如下
分享到：
发表评论
-
jQuery图表（jqPlot,Highcharts）
2012-05-18 00:48 23510jQuery图表在http://www.oschina.net ... -
jQuery之弹出层(用于提示)
2011-10-19 10:26 2255参考了权威指南的部分代码 实现效果:单击按钮显示层,在单击就 ... -
jQuery之get(txt,xml,json二点注意事项)
2011-10-18 14:42 5659参考资料 1 jQuery ajax - get() 方法 h ... -
jQuery之load
2011-10-17 15:33 7704参考资料 1 jQuery ajax - load() 方法 ... -
jQuery之ID选择器
2011-08-23 15:25 9854参考资料 强烈推荐：张子秋 从零开始学习jQuery (二) ... -
jQuery之effect(效果)
2011-08-23 14:59 2556参考资料 从零开始学习jQuery (7) jQuery动画- ... -
jQuery之css
2011-08-23 13:54 1579jQuery W3C文档 http://www.w3schoo ... -
jQuery之select
2011-08-22 16:39 2298话不多说,详见代码吧 网页代码 <div style ... -
jQuery之实战(checkbox,table)
2011-08-19 16:22 3770实现功能如下：参考图片 1 页面加载时效果 2 全选效果 ... -
jQuery之table(隔行变色)
2011-08-19 15:52 2740页面代码如下： <table style=&quo ... -
jQuery之checkbox(复选框)
2011-08-18 17:06 2058业务需求:经常在用户登记中有这样的东西,只选择其中一项或者多项 ... -
jQuery之radio(单选)
2011-08-18 15:41 2425页面代码如下： <inpu ... -
jQuery之get(val,text,html)
2011-08-18 14:53 5982参考资料 1 jquery中，html、val与text三者属 ... -
jQuery之ID选择器
2011-08-18 13:58 16参考资料 强烈推荐：张子秋 从零开始学习jQuery (二) ... -
jQuery之jqzoom(图片放大镜插件)
2011-08-18 11:07 19692参考资料 1 基于jQuery开发的图片放大镜插件 - 淘宝网 ... -
jQuery之DOM
2011-08-17 14:45 1438参考资料 1 跳蚤的小窝:)jQuery对象和DOM对象【jQ ... -
jQuery之入门(ready)
2011-08-17 11:46 2076参考资料 1 jquery $(document).ready ... -
jQuery与Java实现图片的剪切
2011-08-05 15:10 30409一 参考资料 1 jquery Jcrop 头像，logo截图 ... -
jQueryAPI 中文版及相关参考资料
2010-12-24 12:52 1979转载: http://www.css88.com/catego ... -
jQuery对象和DOM对象【jQuery开发注意点(一)】
2010-12-23 16:45 2612转载:jQuery对象和DOM对象【jQuery开发注意点(一 ...
相关推荐
jquery-1.4.4.min.js jquery.ztree.exhide.min.js jquery.ztree.exedit.min.js jquery.ztree.excheck.min.js jquery.ztree.core.min.js jquery.ztree.all.min.js jquery-1.4.4.js jquery.ztree.exhide.js jquery....
ztree demo jquery.ztree,jquery.ztree.core.js,jquery.ztree.core-3.5.min.js,jquery.ztree.excheck-3.5.min.js，jquery.ztree.all.min.js，jquery.ztree.exedit.js，jquery.ztree.exhide.min.js，jquery-1.4.4.min...
ztree实现模糊查询需要的依赖包：jquery.ztree.exhide.js
jquery-zTree插件引用的工具包
jquery-ztree.rar下载
用于生成树形组件，javaScript的一个插件，用于使用树形的下拉组件！
jquery中的ztree包。jquery-ztree.rar压缩包
ztree添加功能，使其支持字体图标，核心文件jquery.ztree.core.js，欢迎下载。
jquery-zTreeAPI 希望可以给你带来一些帮助
非常好用的Jquery-ztree树形菜单代码并适应移动端，可以自动配置图标
jquery 树控件 万能树 拖拽 添 删 改 大数据操作 ajax操作 代码清晰便于重构 修改
jquery ztree 异步动态加载部署直接运行，大数据量，异步是很好的处理方式
1、兼容 IE、FireFox、Chrome 等浏览器 2、在一个页面内可同时生成多个 Tree 实例 3、支持 JSON 数据 4、支持一次性静态生成 和 Ajax 异步加载 两种方式 5、支持多种事件响应及反馈 6、支持 Tree 的节点移动、...
jquery-ztree-2.5.js
jquery_ztree树形下拉框.rar
下面介绍一下zTree 的主要功能：( 演示Demo 请访问 个人站点) 1、兼容 IE、FireFox、Chrome 等浏览器（对于IE 6.0的兼容问题将不做特殊维护） 2、在一个页面内可同时生成多个 Tree 实例 3、支持 JSON 数据 4...
生成树形资源管理的js以及css样式应用，可以有效的管理资源，以及维护
是一个js文件，zTree实现权限分配所需，可去ztree官网自行下载
使用jquery核心，构建一个完整的tree结构