xtree在struts下动态加载树

 显示树的页面

 

< script type = " text/javascript " >

var tree  =   new  WebFXLoadTree( " Hello World " ,  "treeView.do " );
tree.write();

</ script >

treeView.do对应的action方法

 

public  ActionForward execute(ActionMapping mapping,
              ActionForm form,
              HttpServletRequest request,
              HttpServletResponse response) ... {
        if(form instanceof TreeForm)...{
            try ...{
                TreeForm f = (TreeForm)form;
                TreeBo bo = new TreeBo();
                bo.getTreeList(f.getDeptNo(),response);
            
            } catch (IOException e) ...{
                e.printStackTrace();
            } catch (NamingException e)...{
                e.printStackTrace();
            } catch (SQLException e)...{
                e.printStackTrace();
            }
        }
        return null;
    }

action调用的方法

 

public   void  getTreeList(String deptNo,HttpServletResponse response)  throws  SQLException,IOException ... {
        Connection t = dataSource.getConnection();
        PreparedStatement p = t.prepareCall("select a.deptname name,a.deptcode code,(select count(b.deptcode)-1 from t_dept b where b.deptcode like a.deptcode||'%') num from t_dept a where length(a.deptcode)=nvl(length(?),0)+4 and a.deptcode like ? || '%'");
        String tmp = deptNo;
        p.setString(1,deptNo);
        p.setString(2,tmp);
        ResultSet set = p.executeQuery();
        response.setCharacterEncoding("gb2312");
        response.setContentType("text/xml charset=gb2312");
        PrintWriter out = response.getWriter();
        out.write("<?xml version="1.0" encoding="gb2312"?>");
        out.write("<tree>");
        while(set.next())...{
            out.write("<tree text="&quot;"+set.getString("name")+"&quot;" "+(set.getInt("num")>0?"src="treeView.do?deptNo="+set.getString("code")+""":"action="xxx.html"")+"/>"); 
        }
        out.write("</tree>");
        out.flush();
        set.close();
        p.close();
        t.close();
    }

通过sql得到此级别的全部元素和每个此级别元素所包含的子元素数量，以便判断在显示层是否需要显示 “+“ 号

欢迎交流