extJs 2异步树 源程序.

package com.lonton.ext_Test; import java.sql.ResultSet; import java.sql.SQLException; public class getDirectChildren { public static String getResultByRoot(String rootId) throws SQLException,Exception { dbConn dbConnect = new dbConn(); String result=""; String orgname=""; String orgid=""; String orgcode=""; Integer orglevel=1; String parentorgid=""; String orgtypeid=""; String isleaf=""; Integer displayorder=1; //查看该节点的相关信息 String strSql="select orgid,orgname,orgcode,orglevel,parentorgid,displayorder,orgtypeid,isleaf from ext_Organization where orgid='"+rootId+"'"; ResultSet rs=dbConnect.query(strSql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); if(rs.next()){ orgname=rs.getString("orgname"); orgid=rs.getString("orgid"); orgcode=rs.getString("orgcode"); orglevel=rs.getInt("orglevel"); orgname=rs.getString("orgname"); parentorgid=rs.getString("parentorgid"); orgtypeid=rs.getString("orgtypeid"); isleaf=rs.getString("isleaf"); displayorder=rs.getInt("displayorder"); }else { rs.close(); return result; } //首先查看该节点是否为叶子节点,即查找子节点是否存在 strSql="select orgid,orgname,orgcode,orglevel,displayorder,orgtypeid,isleaf " + "from Ext_Organization where parentorgid='"+rootId+"'"; ResultSet rs1=dbConnect.query(strSql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); if(rs1.next()){//该节点不为叶子节点，即其下有子节点 result="[" ; /*+"id:'"+rootId+"'," +"text:'"+orgname+"'," +"orgid:'"+orgid+"'," +"iconCls:'folder'," // +"orgcode:"+orgcode+"'," //+"qtip:'"+orglevel+"'," //+"attributes:{orgcode:'" +orgcode+"'}," // +"displayorder:"+displayorder+"'," //+"parentorgid:"+parentorgid+"'," // +"orgtypeid:"+orgtypeid+"'," // +"isleaf:"+((isleaf.equals('0'))?false:true)+"'," +"children:[";*/ //rs1.last(); rs1.beforeFirst(); while(rs1.next()){ orgname=rs1.getString("orgname"); orgid=rs1.getString("orgid"); orgcode=rs1.getString("orgcode"); orglevel=rs1.getInt("orglevel"); orgname=rs1.getString("orgname"); //parentorgid=rs1.getString("parentorgid"); orgtypeid=rs1.getString("orgtypeid"); isleaf=rs1.getString("isleaf"); //displayorder=rs.getInt("displayorder"); System.out.println(isleaf.equals("0")); if(isleaf.equals("0")){ if(!rs1.isLast()) { System.out.println(orgname+"不是叶子,还有兄弟"); result=result+"{"+"id:'"+orgid+"'," +"text:'"+orgname+"'," +"leaf:false," +"orglevel:"+orglevel+"," +"orgid:'"+orgid+ "'},"; } else if(rs1.isLast()) { System.out.println(orgname+"不是叶子，最后节点"); result=result+"{"+"id:'"+orgid+"'," +"text:'"+orgname+"'," +"leaf:false," +"orglevel:"+orglevel+"," +"orgid:'"+orgid+ "'}]"; } } else { if(!rs1.isLast()) { System.out.println(orgname+"是叶子，还有兄弟"); result=result+"{"+"id:'"+orgid+"'," +"text:'"+orgname+"'," +"orgid:'"+orgid+ "'," +"orglevel:"+orglevel+"," +"leaf:true},"; } else if(rs1.isLast()) { System.out.println(orgname+"是叶子，最后节点"); result=result+"{"+"id:'"+orgid+"'," +"text:'"+orgname+"'," +"orgid:'"+orgid+ "'," +"orglevel:"+orglevel+"," +"leaf:true}]"; } } } result=result+""; }else{//该节点为叶子节点 /*System.out.println(orgname+"父节点本身是叶子"); result=result+"{"+"id:"+orgid+"," +"text:'"+orgname+"'," +"orgid:'"+orgid+ "'," +"leaf:true}";*/ } dbConnect.close(); return result; } public static void main(String[]args) { try{ System.out.println(getResultByRoot("1")); } catch(Exception e) { e.printStackTrace(); } } }