daima.rar_jsp通讯录_企业通

package jead.chap5.addresslist; import java.sql.ResultSet; import java.util.List; import java.util.ArrayList; public class OrgQuery { // 获取下一级组织的ID的List public List getChildren(int iOrgID) { ArrayList list = new ArrayList(); DBAgent dba = null; try { dba = new DBAgent(); ResultSet rs = dba .getResult("select _id from organize where _fatherid=" + iOrgID); while (rs.next()) { list.add(new Integer(rs.getInt(1))); } } catch (Exception e) { list = null; e.printStackTrace(); } finally { try { if (dba != null) dba.close(); } catch (Exception e) { e.printStackTrace(); } } return list; } // 获取一个组织以及下属组织构成的Tree，这个Tree是HTML的，放置在网页中就可显示。该方法通过递归构造出一个TREE。strSubmitJSP是这个TREE中点击一个组织后提交的JSP链接。 public String getOrgTree(int iOrgID, String strSubmitJSP) { String tree = ""; tree += "var tree = new WebFXTree('Root');\n"; tree += "tree.setBehavior('explorer');\n"; tree += createOrgTree(iOrgID, strSubmitJSP, null, 0); tree += "document.write(tree);\n"; return tree; } /** 该方法采用递归完成组织树的构造，采用xtree1.17作为网页树结构的构造器 * * @param iOrgID，组织ID * @param strSubmitJSP，在网页中点击组织时的链接 * @param strFather，在网页中父结点的名称 * @param level，第几级 * @return，返回构造树状结构JavaScript代码 */ private String createOrgTree(int iOrgID, String strSubmitJSP, String strFather, int level) { String tree = ""; DBAgent dba = null; try { dba = new DBAgent(); ResultSet rs = dba .getResult("select * from organize where _fatherid=" + iOrgID); while (rs.next()) { String objname = "" + createNameByLevel(level) + rs.getInt("_id"); tree += "var " + objname + " = new WebFXTreeItem('" + rs.getString("_orgname") + "','" + strSubmitJSP + "?orgid=" + rs.getInt("_id") + "&orgname=" + rs.getString("_orgname") + "');\n"; if (strFather != null) tree += strFather + ".add(" + objname + ");\n"; else tree += "tree.add(" + objname + ");\n"; // 递归调用，构造下属组织 tree += createOrgTree(rs.getInt("_id"), strSubmitJSP, objname, level + 1); } } catch (Exception e) { tree = null; e.printStackTrace(); } finally { try { if (dba != null) dba.close(); } catch (Exception e) { e.printStackTrace(); } } return tree; } //生成构造Tree的Javascript的对象名称的前缀 private char createNameByLevel(int level) { return (char) ('a' + level); } //根据组织id查询组织的名称 public String getOrgName(int iOrgID) { String name = ""; DBAgent dba = null; try { dba = new DBAgent(); ResultSet rs = dba .getResult("select _orgname from organize where _id=" + iOrgID); if (rs.next()) { name = rs.getString(1); } } catch (Exception e) { name = null; e.printStackTrace(); } finally { try { if (dba != null) dba.close(); } catch (Exception e) { e.printStackTrace(); } } return name; } }