如何修改ztree的图标(html实现树形目录结构的展示之二动态绑定数据)
如何修改ztree的图标(html实现树形目录结构的展示之二动态绑定数据)<head><html>额,先看效果图吧前台<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
上一篇我们学习了如何使用zTree对静态数据进行绑定并显示。但是实际运用中数据都是数据库或者经过计算后得到的,所以这一次我们将上次的Demo改为动态绑定。
数据表如下,其中平pId为0的是根节点
上一次讲过zTree的回调事件中可以有许多函数,那么我们就利用点击节点的回调函数进行动态绑定。但是问题来了,首次加载时网页上并没有节点,那么我们如何实现点击节点加载数据呢?思路是这样的,首次加载时用ajax向后台发送一个空请求,点击节点时ajax发送点击节点的id。后台收到请求,将请求参数取出,传入数据库查询方法,此时进行判断,若参数为空说明是首次加载,则执行的sql语句是select * from demo where pId='0' 即取出根节点,然后返回,而参数不为空则说明是点击节点发出的请求,此时sql语句是select * from demo where pId='" id "'" 即取出父节点是我们点击节点的节点。
下面上代码
额,先看效果图吧
前台
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<link rel="stylesheet" href="css/metroStyle.css" type="text/css">
<script type="text/javascript" src="https://img.aigexing.comjs/jquery-1.4.4.min.js"></script>
<script type="text/javascript" src="https://img.aigexing.comjs/jquery.ztree.core.js"></script>
</head>
<body align="center" >
<div id="demotree" style="margin-left:230px;margin-top:50px">
<ul id="treeDemo" class="ztree"></ul>
</div>
</body>
<script type="text/javascript">
var treeNodes;
var setting = {
//外观
view: {
showIcon: true //设置是否显示节点图标
showLine: true //设置是否显示节点与节点之间的连线
showTitle: true //设置是否显示节点的title提示信息
fontCss : {color:"black" size:30}
}
//异步
async:{
enable: true //true代表异步
url: "/Demo/DataProcessing" //异步获取数据的地址
autoParam: ["id=id"]//传递id
}
//数据类型
data: {
simpleData: {
enable: true //设置是否启用简单数据格式(json格式)
idKey: "id" //设置启用简单数据格式时id对应的属性名称(对应json数据中的key)
pidKey: "pId" //设置启用简单数据格式时parentId对应的属性名称 ztree根据id及pid层级关系构建树结构
}
}
//回调事件
callback: {
//点击节点事件
onClick: function(event treeId treeNode clickFlag) {
// 判断是否父节点 ,是父节点则ajax向后台发送节点名称以获取子文件
if(treeNode.isParent){
//判断节点是否折叠,若已折叠则请求子节点的数据,返回后展开
if(treeNode.collapse==true){
//ajax提交请求
$.ajax({
url: "/Demo/DataProcessing" //请求的action路径
type:"post" //提交方式
async:false //同步
dataType:"json" //数据格式是json
data:{'id':treeNode.id} //传递被点击节点的id
error: function(){//请求失败后执行的事件
}
//请求成功后执行事件
success:function(data)
{
var jsondata= data;
//json为空说明没有子节点,不用执行操作
if(jsondata == null || jsondata == ""){ }
//否则子节点添加到父节点
else{
var treeObj = $.fn.zTree.getZTreeObj("demotree");
var parentZNode = treeObj.getNodeByParam("name" treeNode.name null);//获取指定父节点
newNode = treeObj.addNodes(parentZNode jsondata false);
}
}
});
}
}
}
}
};
//首次加载用ajax请求初始化
$(function(){
$.ajax({
async : false
cache:false
type: 'POST'
dataType : "json"
url: "/Demo/DataProcessing" //请求的action路径
error: function () {//请求失败处理函数
alert('请求失败');
}
success:function(data){ //请求成功后处理函数。
treeNodes = data; //把后台封装好的简单Json格式赋给treeNodes
}
});
});
var zTree;
$(document).ready(function(){
$.fn.zTree.init($("#treeDemo") setting treeNodes);
});
</script>
</html>
后台servlet
package myServlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import Db.DbOperate;
import Model.Demo;
import com.alibaba.fastjson.JSON;
/**
* Servlet implementation class DataProcessing
*/
@WebServlet("/DataProcessing")
public class DataProcessing extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public DataProcessing() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request HttpServletResponse response) throws ServletException IOException {
// TODO Auto-generated method stub
}
/**
* @see HttpServlet#doPost(HttpServletRequest request HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request HttpServletResponse response) throws ServletException IOException {
// TODO Auto-generated method stub
String id=request.getParameter("id");
List<Demo> list;
try {
list = new DbOperate().getDemo(id);
String jsonArr = JSON.toJSONString(list);
System.out.println(jsonArr);
//response.setContentType("application/json; charset=UTF-8");
response.setCharacterEncoding("UTF-8");
response.getWriter().print(jsonArr);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
数据库查询
package Db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import Model.Demo;
public class DbOperate {
private static String url = "jdbc:mysql://localhost:3306/dir?rewriteBatchedStatements=true";
private static String user = "root";
private static String password = "";
public List<Demo> getDemo(String id) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
System.out.print("!!!!!!!!!");
Connection conn = DriverManager.getConnection(url user password);
List<Demo> list = new ArrayList<Demo>();
Statement s = null;
String sql;
if(id==null||id==""){
sql= "select * from demo where pId='0'";
}
else{
sql= "select * from demo where pId='" id "'";
}
s = conn.createStatement();
ResultSet rs = s.executeQuery(sql);
while (rs.next()) {
list.add(new Demo(rs.getString("id") rs.getString("name") rs.getString("pId") rs.getInt("isParent")));
}
if (s != null) {
s.close();
}
if (conn != null) {
conn.close();
}
return list;
}
}
实体类
package Model;
public class Demo {
private String id;
private String name;
private String pId;
private int isParent;
public Demo(String id String name String pId int isParent) {
super();
this.id = id;
this.name = name;
this.pId = pId;
this.isParent = isParent;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getpId() {
return pId;
}
public void setpId(String pId) {
this.pId = pId;
}
public int getIsParent() {
return isParent;
}
public void setIsParent(int isParent) {
this.isParent = isParent;
}
}
源码可以私信获取,谢谢支持