java + js的树菜单

package com.free.tree; /** * * <p>Title:权限树的构建 </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2007</p> * <p>Company:福瑞网络有限公司 </p> * @author 杨轶 * @version 1.0 */ import java.sql.*; import java.util.List; import java.util.ArrayList; import com.free.DAO.*; public class BuildTree { String html; public BuildTree() { } public String getTreeHtml() { html = "<script language=\"javascript\">\n if (document.getElementById) {"; html += "var tree = new WebFXTree('福瑞医生管理系统');tree.setBehavior('classic');"; buildPowerTree(); String rootname = null; String rootid = null; html += "var Tlogout = new WebFXTreeItem('重新登陆','../welcome.jsp');tree.add(Tlogout);"; html += "document.write(tree);}</script>"; return html; } /** * * <p>buildPowerTree </p> * <p>数据库读取生成菜单树 </p> * <p>Copyright: Copyright (c) 2007</p> * <p>Company:福瑞网络有限公司 </p> * @version 1.0 */ public void buildPowerTree() { SQLDAOcn db = new SQLDAOcn(); db.open(); try { String sql = "select * from fd_tree where t_id=0"; ResultSet rs = db.executeQuery(sql); while(rs.next()) { String id = rs.getString("id"); String fid = rs.getString("t_id"); String url = rs.getString("t_url"); String mname = rs.getString("t_name"); SQLDAOcn db1 = new SQLDAOcn(); db1.open(); String sqlt ="select * from fd_tree where t_id="+id; // String sqlt = "select b.id,t_id,t_name,t_url from power a,fd_tree b where a.mid=b.id and uid="+1+" and t_id="+id; // 等级限制 限制菜单的浏览项目power为权限表 ResultSet temprs = db1.executeQuery(sqlt); int node = 10; boolean isadd = true; while(temprs.next()) { if(isadd) { //*********查找跟节点**********/ setHtml("var T"+id+" = new WebFXTreeItem('"+mname+"');"); setHtml("tree.add(T"+id+");"); isadd = false; } node++; setHtml("var T"+node+" = new WebFXTreeItem('"+temprs.getString("t_name")+"','"+temprs.getString("t_url")+"');"); setHtml("T"+id+".add(T"+node+");"); } db1.Close(); } } catch (SQLException ex) { System.out.println(ex); } db.Close(); } public void setHtml(String info) { html += info; } }