updataplan.java

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

/*
 * Created on 2006-9-23
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.skyhawk.richeng.updataplan;

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

import javax.servlet.ServletException;
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
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class UpdataPlan {
	public void execute(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException{
		String updata = request.getParameter("updata");
		Option option = new Option();
		
		if(updata.equals("dayquery")){
			System.out.println("dayquery");
			ArrayList arraylist = new ArrayList();
			HttpSession session=request.getSession();
			String empid=(String) session.getAttribute("empid1");
			arraylist = option.dayquery(request,response,empid);
			DayPlan d=new DayPlan();
			
		
			session.setAttribute("arraylist",arraylist);
		
			try {
				request.getRequestDispatcher("/dataquery.jsp").forward(request,response);
			} catch (ServletException e) {
				e.printStackTrace();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		else if(updata.equals("monthquery")){
			option.monthquery(request,response);
		}
		
		
		else if(updata.equals("newdayplan")){
			try {
				//String empid=request.getParameter("agentid");
				HttpSession session=request.getSession();
				String empid=(String)session.getAttribute("empid4");
				
				option.newdayplan(request,response,empid);
			} catch (SQLException e) {
				e.printStackTrace();
			}
			
			
		}
		else if(updata.equals("delete")){
			String empid=null;
			Option option3 = new Option();
			HttpSession session = request.getSession();
			String empid7=request.getParameter("empid7");
			System.out.println("empid7+++++++++++++"+empid7);
			String empid6=request.getParameter("empid6");
			String mflag=null;
			mflag=request.getParameter("mflag");
			if(mflag.equals("0")){
				empid=empid6;
			}
			else{
				empid=empid7;
			}
			System.out.println("delete"+empid);
			option3.delete(request,response,empid);
			
		
			
		}
		else if(updata.equals("modify2")){
			System.out.println("++++++++++++modify2+++++++++++++");
			String settime = request.getParameter("settime");
			System.out.println("settime========="+settime);
			Statement stmt = null;
			ResultSet rs1 = null;
			 Connection conn =  ConnectionFactory.getConnection();
			try {
				stmt=conn.createStatement();
				String modify = "select empid,content,seterid,starttime,endtime,person,place,settime,remarker from o_dayplan where settime=to_date('"+settime+"','yyyy-mm-dd HH24:MI:SS')";
				System.out.println("modify2+++++++"+modify);
				rs1=stmt.executeQuery(modify);
				while(rs1.next()){
			String empid=rs1.getString("empid");
				/*String connect=rs1.getString("content");
				String remarker=rs1.getString("remarker");
				String seterid=rs1.getString("seterid");
				String settime1=rs1.getString("settime");
				String starttime=rs1.getString("starttime");
				String endtime=rs1.getString("endtime");
				String person=rs1.getString("person");
				String place=rs1.getString("place");*/
					DayPlan dayplan=new DayPlan();
				 	String content=rs1.getString("content");
				 	String person=rs1.getString("PERSON");
				 	String place=rs1.getString("PLACE");
				 	String remarker=rs1.getString("REMARKER");
				 String seterid=rs1.getString("SETERID");
				 	dayplan.setENDTIME(dayplan.cutTime(rs1.getString("ENDTIME")));
				 	String endtime=dayplan.getENDTIME();
				 	
				 	dayplan.setStartTime(dayplan.cutTime(rs1.getString("STARTTIME")));
				 	String starttime=dayplan.getStartTime();
				 	
				 	System.out.println("==========content,person,empid"+content+person+empid+starttime);

				 	
				    System.out.println("==="+rs1.getString("STARTTIME"));
				HttpSession session=request.getSession();
				session.setAttribute("empid55",empid);
				session.setAttribute("content",content);
				session.setAttribute("remarker",remarker);
				session.setAttribute("seterid",seterid);
				session.setAttribute("settime",settime);
				session.setAttribute("starttime",starttime);
				session.setAttribute("endtime",endtime);
				session.setAttribute("person",person);
				session.setAttribute("place",place);
				System.out.println("session==empid,starttime"+session.getAttribute("empid55")+session.getAttribute("starttime"));
				
				
				
				request.getRequestDispatcher("/modify.jsp").forward(request,response);
			}
			}
			 catch (SQLException e) {
				e.printStackTrace();
			}finally{
				DatabaseUtils coldat =new DatabaseUtils();
				DatabaseUtils.closeObject(rs1,stmt,conn);
				System.out.println("+++++close+++++");
			}
			
			 
			 
			 
			 
			 
		}
		else if(updata.equals("modify")){
			Option option4 =new Option();
			/*String nflag=request.getParameter("nflag");
			String empid=null;
			String empid6=request.getParameter("empid6");
			
			//System.out.println();
			String empid7=request.getParameter("empid7");
			if(nflag.equals("0")){
				empid=empid6;
			}
			else{
				empid=empid7;
			}*/
			//System.out.println("modify"+empid);
			HttpSession session = request.getSession();
			String settime=(String)session.getAttribute("settime");
			option4.modify(request,response,settime);
			
		}
		else if(updata.equals("viewothers")){
			OthersPlan othersplan =new OthersPlan();
			ArrayList arraylist=new ArrayList();
			try {
				arraylist=othersplan.viewothers(request,response);
				
				System.out.println("===arraylist==="+arraylist.size());
					for(int i = 0;i<arraylist.size();i++){
						
						Agent agent = (Agent)arraylist.get(i);
						
						System.out.println("===argent=="+agent.getAgentName());
					}
			} catch (SQLException e) {
				e.printStackTrace();
			}
			HttpSession sess=request.getSession();
			sess.setAttribute("arraylist",arraylist);
			request.getRequestDispatcher("/others.jsp").forward(request,response);
		}
		else if(updata.equals("viewotherplan")){
			String empid=request.getParameter("empid");
			ArrayList arraylist = new ArrayList();
			arraylist = option.dayquery(request,response,empid);
			DayPlan d=new DayPlan();
			
		    HttpSession session=request.getSession();
			session.setAttribute("arraylist",arraylist);
		
			try {
				request.getRequestDispatcher("/dataquery1.jsp").forward(request,response);
			} catch (ServletException e) {
				e.printStackTrace();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
			
		
		else if(updata.equals("chakan")){
			OthersPlan othersplan =new OthersPlan();
			ArrayList arraylist8=new ArrayList();
			arraylist8=othersplan.chakan(request,response);
			
			System.out.println("===arraylist==="+arraylist8.size());
				
			HttpSession sess=request.getSession();
			sess.setAttribute("arraylist8",arraylist8);
			request.getRequestDispatcher("/chakan.jsp").forward(request,response);
			
		}
		else if(updata.equals("chakanplan")){
			System.out.println("++++++++++++++++chakan");
			String empid=request.getParameter("empid");
			ArrayList arraylist7 = new ArrayList();
			arraylist7 = option.dayquery(request,response,empid);
			DayPlan d=new DayPlan();
			
		    HttpSession session=request.getSession();
			session.setAttribute("arraylist7",arraylist7);
		
			try {
				request.getRequestDispatcher("/chakanplan.jsp").forward(request,response);
			} catch (ServletException e) {
				e.printStackTrace();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		
	}
	
	
}