othersplan.java

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

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

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;
import com.skyhawk.db.DatabaseUtils;
import com.skyhawk.richeng.setagent.Agent;

/**
 * @author Administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class OthersPlan {
	
	public ArrayList viewothers(HttpServletRequest request,HttpServletResponse response) throws SQLException{
		String updata = request.getParameter("updata");
		HttpSession sess=request.getSession();
		String empid1=(String)sess.getAttribute("empid1");
		Statement stmt = null;
		ResultSet rs1 = null;
		 Connection conn =  ConnectionFactory.getConnection();
		 ArrayList arraylist= null;
		 try {
			stmt=conn.createStatement();
		
		
		String viewOthers="select o_readerseter.empid,empname from o_readerseter,o_employee where o_readerseter.agentid='"+empid1+"' and o_employee.empid=o_readerseter.empid";
		
			System.out.println("======viewOthers==="+viewOthers);
		
			rs1=stmt.executeQuery(viewOthers);
			arraylist = new ArrayList();
	
		while(rs1.next()){
			Agent agent = new Agent();
			agent.setAgentId(rs1.getInt("empid"));
			agent.setAgentName(rs1.getString("empname"));
			
			System.out.println("==agent3=="+agent.getAgentName());
			System.out.println("==agent4=="+rs1.getString("empname"));
			arraylist.add(agent);
			
			 }
		
			for(int i = 0;i<arraylist.size();i++){
				Agent agent = (Agent)arraylist.get(i);
				
				System.out.println("==agent2=="+agent.getAgentName());
			}
		}
		catch (Exception e2) {
			e2.printStackTrace();
			}
		
		finally{
		DatabaseUtils coldat =new DatabaseUtils();
		DatabaseUtils.closeObject(rs1,stmt,conn);
		System.out.println("+++++close+++++");
	    }
		
	return arraylist;
}
	
	public ArrayList chakan(HttpServletRequest request,HttpServletResponse response){
		
		HttpSession sess=request.getSession();
		String empid1=(String)sess.getAttribute("empid1");
		Statement stmt = null;
		ResultSet rs1 = null;
		 Connection conn =  ConnectionFactory.getConnection();
		 ArrayList arraylist= null;
		 try {
			stmt=conn.createStatement();
		
		
		String viewOthers="select o_reader.empid,empname from o_reader,o_employee where o_reader.readerid='"+empid1+"' and o_employee.empid=o_reader.empid";
		
			System.out.println("======viewOthers==="+viewOthers);
		
			rs1=stmt.executeQuery(viewOthers);
			arraylist = new ArrayList();
	
		while(rs1.next()){
			Agent agent = new Agent();
			agent.setAgentId(rs1.getInt("empid"));
			agent.setAgentName(rs1.getString("empname"));
			
			System.out.println("==agent3=="+agent.getAgentName());
			System.out.println("==agent4=="+rs1.getString("empname"));
			arraylist.add(agent);
			
			 }
		
			for(int i = 0;i<arraylist.size();i++){
				Agent agent = (Agent)arraylist.get(i);
				
				System.out.println("==agent2=="+agent.getAgentName());
			}
		}
		catch (Exception e2) {
			e2.printStackTrace();
			}
		
		finally{
		DatabaseUtils coldat =new DatabaseUtils();
		DatabaseUtils.closeObject(rs1,stmt,conn);
		System.out.println("+++++close+++++");
	    }
		
	return arraylist;
		
	}
}