searchdepartment.java

个人办公平台,用JAVA开发的TOMCAT的服务器

/*
 * Created on 2006-9-29
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.skyhawk.richeng.control;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.skyhawk.db.ConnectionFactory;

/**
 * @author Administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class SearchDepartment {

   public ArrayList search(HttpServletRequest request,HttpServletResponse response){
   	ArrayList arraylist1=new ArrayList();
   	Statement stmt = null;
	ResultSet rs1 = null;
	 Connection conn =  ConnectionFactory.getConnection();
	 try {
		stmt=conn.createStatement();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
   	HttpSession sess=request.getSession();
   	String empid2=(String)sess.getAttribute("empid1");
   	String sel="select depid,empid,empname from o_employee where depid=(select depid from o_employee where empid='"+empid2+"')";
   	try {
   		
   		System.out.println("=====1 agent, reader="+sel);
		rs1=stmt.executeQuery(sel);
	} catch (SQLException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}		       
   	try {
		while(rs1.next()){
			 Emp emp=new Emp();
			    emp.setEmpId(rs1.getInt("empid"));
			    System.out.println("=====wh====="+rs1.getInt("empid"));
			 	emp.setEmp(rs1.getString("empname"));
			 	emp.setDepId(Integer.parseInt(rs1.getString("depid")));
			 	arraylist1.add(emp);
			}
	} catch (NumberFormatException e2) {
		//TODO Auto-generated catch block
		e2.printStackTrace();
	} catch (SQLException e2) {
		//TODO Auto-generated catch block
		e2.printStackTrace();
	}

   	HttpSession session=request.getSession();
   	
   	session.setAttribute("arraylist1",arraylist1);
   	
   	return arraylist1;
   	
   }
}