dTree生成部门目录树

在action中使用sql按目录的方式查询出部门记录，其中包括部门名称，部门ID，部门父ID。顶头的记录的部门父ID必须为-1，查询语句如：
select dept_id,dept_name,parent_id from info_dept connect by prior dept_id = parent_id start with dept_id=?

把获得的list记录set到request中，在页面中显示出来。
页面代码如下:

< link  href ="<%=request.getContextPath()%>/gdnumweb/css/dtree.css"  rel ="stylesheet"  type ="text/css" >
< body >
< script  type ="text/javascript"  src ="<%=request.getContextPath()%>/gdnumweb/js/dtree.js" ></ script >

< div  class ="dtree" >
< p >< a  href ="javascript: tree.openAll();" > 展开所有 </ a >  |  < a  href ="javascript: tree.closeAll();" > 关闭所有 </ a ></ p >
< script  language ="javascript"  type ="text/javascript" >
tree  =   new  dTree('tree');
< logic:iterate id = " dept "  name = " list " >
  tree.add( " <bean:write name= " dept "  property= " dept_id " /> " , " <bean:write name= " dept "  property= " parent_id " /> " , " <bean:write name= " dept "  property= " dept_name " /> " ,' <%= path %>/ gdnumUserDept. do ? method = getDeptUserInfo & deptNo =< bean:write name = " dept "  property = " dept_id " /> ','','mainframe');
</ logic:iterate >
document.write(tree);
</ script >

在组合框中输出树形目录
获取列表的java方法
//提取当前用户的部门下拉
  public List getSourceDept(String deptNo) {
    List list = null;
    Connection con = CommonUtils.currentSession().connection();
    ResultSet rs = null;
    ResultSetMetaData rsmd = null;
    java.sql.PreparedStatement ps = null;
    String sql = "select deptno,(tools.buildTree(level)||deptname) deptname from sys_dept "
        + "connect by parent_deptno=prior deptno "
        + "start with deptno=?";
    HashMap map = null;
    try {
      ps = con.prepareStatement(sql);
      ps.setString(1, deptNo);
      rs = ps.executeQuery();
      //System.out.println("rs.size:" + rs.getFetchSize());
      rsmd = rs.getMetaData();
      list = new ArrayList();
      while (rs.next()) {
        map = new HashMap();
        for (int i = 1; i <= rsmd.getColumnCount(); i++) {
          map.put(rsmd.getColumnName(i).toLowerCase(), rs.getString(i));
        }
        list.add(map);
      }
      rs.close();
    }
    catch (Exception ex) {
      log.error("提取当前用户的部门下拉出错 com.unicom.gzmas.reports.bo.getSourceDept:" + ex);
    }
    finally {
      CommonUtils.closeSession();
    }
    return list;
  }

页面输出的代码
    <select id="mbackdept"> <!-- 部门 -->
          <option value="all">-----全部----</option>
          <logic:iterate id="l" name="target">
          <option value="<bean:write name="l" property="deptno"/>"><bean:write name="l" property="deptname"/></option>
          </logic:iterate>
    </select>
构造树的存储过程
  /*构造树*/
    Function Buildtree(In_Level In Number) Return Varchar2 As
        Result Varchar2(4000);
    Begin
        If In_Level = 1 Then
            Return Null;
        End If;
        Return '|' || Incstring('－­', (In_Level - 1) * 2);
    End;