treemanager.java

组织结构树的实现

package com.model;

import java.io.IOException;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.jsp.JspWriter;
import com.vo.depVo;

public class TreeManager 
	{ 
   
       
       public String url="/transTree/main.jsp";//节点的连接路径
	   
		public ArrayList getAllNods(){
			
			List list = new ArrayList();
			ResultSet  rs = null;
			Statement stmt = null;
			Connection conn = null;
			try {
				//注册
				 Class.forName("oracle.jdbc.driver.OracleDriver");
				//取得连接
				 conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:icss","test","test");
				//创建Statement
				 stmt = conn.createStatement();
				//执行取得结果集(查询)
				 rs = stmt.executeQuery("select * from treetest");
				//遍历结果集
				// User user=null;
				while(rs.next()){
					//
					 depVo dep=new depVo();
					 dep.setId(rs.getInt("id"));
					 dep.setPid(rs.getInt("pid"));
					 dep.setName(rs.getString("name"));
					//System.out.println(rs.getString("username"));
					list.add(dep);
					
				}
				
				//System.out.println("conn="+conn);
			} catch (Exception e) {
				e.printStackTrace();
			}finally{
				
				try {
					rs.close();
					stmt.close();
					conn.close();
				} catch (SQLException e) {
					
					e.printStackTrace();
				}
			}
			
			return (ArrayList) list;
		}
	
		public void creatTree(int id,List tree,JspWriter out,int cengflag,String target)throws ServletException, IOException  
		{  
			
			if(target.equals("")){
			 target="mainFrame";//节点连接要在那个框架中打开
			}	
					if(id==0){
							for(int i=0;i<tree.size();i++)
							{
									depVo dep=(depVo)tree.get(i);  
										if(dep.getPid()==id)
										{      
											String title="<B>";
											String titleEnd="</B>";
											System.out.println("addtree('"+title+dep.getName()+titleEnd+"');");
											out.println("addtree('"+title+dep.getName()+titleEnd+"');");
											creatTree(dep.getId(),tree,out,cengflag+1,target);	
												
										}
							}
						}
   
					else{
						String firstr=""; 
	       
							for(int j=0;j<cengflag;j++)
								firstr+="-";
	  	    
							for(int j=0;j<tree.size();j++)
							{
								depVo dep=(depVo)tree.get(j);
								if(dep.getPid()==id)
								{
	  		
								System.out.println("addtree('"+firstr+dep.getName()+"','"+url+"?flag="+dep.getId()+"','"+target+"');");        
								out.println("addtree('"+firstr+dep.getName()+"','"+url+"?flag="+dep.getId()+"','"+target+"');");
								creatTree(dep.getId(),tree,out,cengflag+1,target);
								
								}
							}
	  		
	  	  
						}
	    	}
	}