说来这个小小模块颇是我得意之笔,因为这是我实习(或者说参加工作)所独立完成的第一个作品。原来项目中采用dtree加载树形人员目录,因为dtree是一次性加载的,1000多人的时候加载的速度就非常的慢,何况是整个市里3000多人的目录树。于是经理就把这个模块的重开发的任务交给了我。开始感觉这是个多么艰巨的任务啊。因为要重开发,首先就得了解原来的实现方式,好将重开发好的模块嵌入到系统当中。于是,学会了dtree的基本使用,dtree确实是个不错的树形插件,感觉最大的特点就是容易使用,界面效果挺好。网上有很多参考资料,这里就不介绍了。因为原来是一次性加载,所以自然而然就想到动态加载树形目录,在网上看了很多的树形插件,最后决定采用xloadtree。于是三下五除二,啪啪啪,就把基本的效果实现了,写了几个servlet,这里贴一个出来供大家参考。
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String groupguid = request.getParameter("groupguid");
try {
response.setHeader("Cache-Control", "no-cache");
response.setContentType("text/xml; charset=UTF-8");
Document doc = new Document(new Element("tree")); // 创建文档
Element tree = doc.getRootElement();
PrintWriter out = response.getWriter();
Connection conn = null;
Statement stmt2 = null;
Statement stmt3 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
DB db = new DB();
conn = db.getConn();
String sql2 = "select personguid from employee where groupguid='" + groupguid + "' order by tabindex";
stmt2 = conn.createStatement();
rs2 = stmt2.executeQuery(sql2);
while(rs2.next()) {
String personguid = rs2.getString("personguid");
String sql3 = "select e.employee_name,e.employee_mobile from rt_employee e where e.employee_guid='" + personguid + "' order by tabindex";
stmt3 = conn.createStatement();
rs3 = stmt3.executeQuery(sql3);
if(rs3.next()) {
String employeename = rs3.getString("employee_name");
String employmobile = rs3.getString("employee_mobile");
if(employmobile == null) {
employmobile = "无";
}
Element elet2 = new Element("tree").setAttribute("text", employeename).setAttribute("action", "javascript:addPerson('"+employeename+"', '"+employmobile+"')");
tree.addContent(elet2);
}
}
rs2.close();
stmt2.close();
rs3.close();
stmt3.close();
conn.close();
XMLOutputter xmlout = new XMLOutputter();
xmlout.output(doc, out);
out.println();
out.flush();
out.close();
} catch (Exception e) {
loger.error("XML 文档生成失败:/n" + e.getMessage());
e.printStackTrace();
}
}
这样就可以在页面中这样使用xloadtree了。
<script type="text/javascript">
tp1.addTabPage( document.getElementById( "tabPage1" ) );
var tree = new WebFXTree("Root");
tree.add(new WebFXLoadTreeItem("Root", "/myprj/servlet/LoadDeptTreeServlet?groupguid=" + "" + "&time=" + new Date().getTime()));
document.write(tree);
</script>
不写了,还有任务在身,有时间再写。写本文的主要目的是想说明使用xloadtree过程当中遇到的一些问题及解决办法。怎么样使用xloadtree,网上已经很多资料了。