重庆分公司,新征程启航
为企业提供网站建设、域名注册、服务器等服务
前台代码:
目前创新互联建站已为上千余家的企业提供了网站建设、域名、网站空间、网站托管、服务器托管、企业网站设计、仁化网站维护等服务,公司将坚持客户导向、应用为本的策略,正道将秉承"和谐、参与、激情"的文化,与客户和合作伙伴齐心协力一起成长,共同发展。
1、html部分
2、js部分代码:
$knowledgeTree ="";
var setting = {
check: {
enable: false, //显示复选框或者radio
chkStyle: "checkbox", //复选框或者radio
chkboxType: { "Y" : "ps", "N" : "ps" } //控制关系
},
view: {
selectedMulti: false, //true/false分别表示 支持/不支持 同时选中多个节点
showTitle: true, //true/false 分别表示 显示 /隐藏 提示信息(即鼠标移动到节点上时,自动弹出的提示信息图层)
showIcon:false
},
data: {
key: {
name: "name", //设置 zTree 显示节点名称的属性名称
title: "title" //设置 显示节点提示信息的属性名称。[setting.view.showTitle = true 时生效]
},
simpleData: {
enable: true, //是否使用简易JSON格式数据(非父子结构)
idKey: "id", //设置 zTree 显示节点名称的节点名称
pIdKey: "pid", //设置 zTree 简易数据的父节点名称
rootPId: "-1" //最上层父节点
}
},
callback: {
onClick: onClick
}
};
jQuery(document).ready(function(){
$.ajax({
url : localBasePath + "/servlet/KnowledgeToolServlet",
type : "post",
dataType : "json",
success : function(dataObj) {
$knowledgeTree = $.fn.zTree.init($("#knowledgeTree"), setting, dataObj);
}
});
});
3、servlet部分代码:
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
response.setCharacterEncoding("utf-8");
PrintWriter out = response.getWriter();
KnowledgeService ks=new KnowledgeService();
List
String treeNodeJson = JSONSerializer.toJSON(treeNodeList).toString();
out.print(treeNodeJson);
out.flush();
out.close();
}
其中KnowledgeService.searchKonwldgeTree()代码如下:
//查询知识库树
public List
StringBuffer sql = new StringBuffer();
Connection conn = null;
Statement stmt = null;
List
List
ResultSet rs = null;
try {
conn = newdom.getConnection();
stmt = conn.createStatement();
conn.setAutoCommit(false);
sql.append(" select skl.knowid, skl.usedoctype,sed.typename,skl.knowname,skl.knowtext from SBL_KNOWLEDGE_LIB skl,SZD_EMR_DOCTYPE sed ";
sql.append(" order by skl.usedoctype ");
System.out.println(sql.toString());
rs = stmt.executeQuery(sql.toString());
while (rs.next()) {
Knowledge knowledge=new Knowledge();
knowledge.setId(rs.getString("knowid"));
knowledge.setName(rs.getString("knowname"));
knowledge.setDocType(rs.getString("usedoctype"));
knowledge.setDocTypeName(rs.getString("typename"));
knowledge.setContent(rs.getString("knowtext"));
knowlList.add(knowledge);
}
} catch (Exception ex) {
log.error("查询知识库树错误");
ex.printStackTrace();
} finally {
newdom.close(conn, stmt, rs);
}
String typeTemp="";
for(Knowledge knowledge:knowlList){
TreeNode treeNode = new TreeNode();
if(!knowledge.getDocType().equals(typeTemp)){
TreeNode treeNodeParent = new TreeNode();
treeNodeParent.setId(knowledge.getDocType());
treeNodeParent.setName(knowledge.getDocTypeName());
treeNodeParent.setIsParent("true");
treeNodeParent.setChecked("true");
treeNodeParent.setOpen("false");
treeNodeParent.setPid("-1");
treeNodeParent.setTitle(knowledge.getDocTypeName());
treeNodeList.add(treeNodeParent);
}
typeTemp=knowledge.getDocType();
treeNode.setId(knowledge.getId());
treeNode.setName(knowledge.getName());
treeNode.setTitle(knowledge.getName());
treeNode.setContent(knowledge.getContent());
treeNode.setChecked("true");
treeNode.setOpen("true");
treeNode.setIsParent("false");
treeNode.setPid(knowledge.getDocType());
treeNodeList.add(treeNode);
}
return treeNodeList;
}
大致代码如上,实现的思路是将要做成树的数据,按照zTree的指定格式,放到一个list里面,本文中树的内容是表SBL_KNOWLEDGE_LIB ,SZD_EMR_DOCTYPE结合的数据,将这些数据从数据库中查出来,然后按照实际需要组装成所需要的List,然后转换成json格式print出就可以了。这样ajax里面接收到返回的json格式的对象后,直接赋值给zTree就完成了一个树的简单实现。