option.java

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

/*
 * Created on 2006-9-24
 *
 * 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.*;

/**
 * @author Administrator
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class Option {
	            Statement stmt = null;
				ResultSet rs1 = null;
				
	public ArrayList dayquery(HttpServletRequest request,HttpServletResponse response,String empid) {
	
		 String date = request.getParameter("starttime");
		 HttpSession sess=request.getSession();
		 String ownid = (String)sess.getAttribute("empid1");
		 int flag =0;
		 if(!empid.equals(ownid)){
			//date="200607";
			flag = 1;
		}
		 System.out.println(date);	
		ArrayList arraylist = new ArrayList();
		 Connection conn =  ConnectionFactory.getConnection();
		 try {
			stmt=conn.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		String datequery = null;
		if(flag==0){
			
		  datequery ="select content,seterid,starttime,endtime,person,place,settime,remarker from O_dayplan where starttime<to_date('"+date+" 23:59:59','yyyy-mm-dd HH24:MI:SS') and starttime>to_date('"+date+" 00:00:00','yyyy-mm-dd HH24:MI:SS') and empid='"+empid+"'";
		}
		 else if (flag==1){
		 	datequery = "select content,seterid,starttime,endtime,person,place,settime,remarker from O_dayplan where empid='"+empid+"'";
		 }
		System.out.println("===datequery==="+datequery);
		 try {
			//rs1=stmt.executeQuery(datequery);
			rs1=stmt.executeQuery(datequery);
		} 
		catch (SQLException e1) {
			e1.printStackTrace();
		}
		  try {
		  
			while(rs1.next()){
			 DayPlan dayplan = new DayPlan();
			    dayplan.setEMPID(empid);
			 	dayplan.setCONTENT(rs1.getString("CONTENT"));
			 	dayplan.setStartTime(dayplan.cutTime(rs1.getString("STARTTIME")));
			 	System.out.println("==="+rs1.getString("STARTTIME"));
			 dayplan.setSETERID(rs1.getInt("SETERID"));
			 	dayplan.setENDTIME(dayplan.cutTime(rs1.getString("ENDTIME")));
			 	dayplan.setPERSON(rs1.getString("PERSON"));
			 	dayplan.setPLACE(rs1.getString("PLACE"));
			 	dayplan.setSETTIME(dayplan.cutTime(rs1.getString("SETTIME")));
			    dayplan.setREMARKER(rs1.getString("REMARKER"));
		        arraylist.add(dayplan);
			}
		    } catch (SQLException e2) {
			e2.printStackTrace();
			
		}
		finally{
		DatabaseUtils coldat =new DatabaseUtils();
		DatabaseUtils.closeObject(rs1,stmt,conn);
		System.out.println("+++++close+++++");
	}
	     return arraylist;
	}
		 
	public void monthquery(HttpServletRequest request,HttpServletResponse response){
		
	}
	public void newdayplan(HttpServletRequest request,HttpServletResponse response,String empid) throws SQLException{
		Connection conn = ConnectionFactory.getConnection();
		stmt=conn.createStatement();
		String neirong=request.getParameter("neirong");
		String starttime=request.getParameter("starttime");
		String endtime=request.getParameter("endtime");
		String person=request.getParameter("person");
		String place=request.getParameter("place");
		String remarker=request.getParameter("remarker");
		HttpSession sess = request.getSession();
	     String emp1=(String)sess.getAttribute("empid1");
		String empidmy=empid;
		//String empid=(String) sess.getAttribute("empid");
		
		//System.out.println("===emp1==="+emp1);
	
		
		DayPlan dayplan= new DayPlan();
		
		
		System.out.println("===starttime==="+starttime);
		System.out.println("===endtime==="+endtime);
		
		int p=dayplan.passTime(starttime,endtime);
		HttpSession sess6=request.getSession();
		Integer temp = new Integer(p);
		String temp2 = temp.toString();
		sess6.setAttribute("wrongtime1",temp2);
		
		
		int i = dayplan.hadplan(empidmy,starttime);
		if(i==0){
			
    	String insert = "insert into o_dayplan values('"+empidmy+"','1','"+neirong+"','"+remarker+"','"+p+"','"+emp1+"',sysdate,to_date('"+starttime+"','yyyy-mm-dd HH24-MI-SS'),to_date('"+endtime+"','yyyy-mm-dd HH24-MI-SS'),'"+person+"','"+place+"')";
    	
    		
    	try{
    		
    		System.out.println("==insert=="+insert);
    	stmt.execute(insert);
		request.getRequestDispatcher("/succenewplan1.jsp").forward(request,response);
    	}
    	catch (Exception e){
    		e.printStackTrace();
		
    	}
		
		
		DatabaseUtils coldat =new DatabaseUtils();
		DatabaseUtils.closeObject(rs1,stmt,conn);
		System.out.println("+++++close+++++");
		} else{
			System.out.println("++++++++++++++++++++i"+i);
			try {
				request.getRequestDispatcher("/haveplan.jsp").forward(request,response);
			} catch (ServletException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
				finally{
				DatabaseUtils coldat =new DatabaseUtils();
				DatabaseUtils.closeObject(rs1,stmt,conn);
				System.out.println("+++++close+++++");
				}
		}
		
	}
	public void delete(HttpServletRequest request,HttpServletResponse response,String empid){
			Connection conn =  ConnectionFactory.getConnection();
			 try {
				stmt=conn.createStatement();
			
			    String start = request.getParameter("start");
			    String del="delete  from o_dayplan where empid='"+empid+"' and starttime=to_date('"+start+"','yyyy-mm-dd HH24:MI:SS')";
			    System.out.println("del==="+del);
			    int amount = stmt.executeUpdate(del);
			    System.out.println("del==="+amount);
			    
			    request.getRequestDispatcher("/succe.jsp").forward(request,response);
			 } catch (Exception e) {
				e.printStackTrace();
				try {
					try {
						request.getRequestDispatcher("/fail.jsp").forward(request,response);
					} catch (ServletException e2) {
						// TODO Auto-generated catch block
						e2.printStackTrace();
					}
				} catch (IOException e1) {
					e1.printStackTrace();
				}
			}
			 finally{
				DatabaseUtils coldat =new DatabaseUtils();
				DatabaseUtils.closeObject(rs1,stmt,conn);
				System.out.println("+++++close+++++");
				}
	}
	public void modify(HttpServletRequest request,HttpServletResponse response,String settime){
		Connection conn =  ConnectionFactory.getConnection();
		//String start = request.getParameter("starttime4");
		HttpSession sesss=request.getSession();
		String start =(String) sesss.getAttribute("starttime");
		String end = request.getParameter("endtime4");
		String neirong = request.getParameter("content4");
		String remarker = request.getParameter("remarker4");
		String person = request.getParameter("person4");
		String place = request.getParameter("place4");
		String seterid = request.getParameter("seterid4");
		String empid = request.getParameter("empid4");
		System.out.println("empidkdjfkdsl"+empid);
		System.out.println("neirongkdjfkdsl"+neirong);
		HttpSession id=request.getSession();
		String empid1 = (String)id.getAttribute("empid1");
		String empid55 = (String)id.getAttribute("empid55");
		System.out.println("empidkdjfkdsl"+empid55);
		DayPlan dayplan= new DayPlan();
		int p=dayplan.passTime(start,end);
		System.out.println("sdfdfsasfdadf---------->"+p);

		HttpSession sess7=request.getSession();
		Integer temp = new Integer(p);
		String temp2 = temp.toString();
		sess7.setAttribute("wrongtime",temp2);
		int i = dayplan.hadplan(empid55,start);
		//if (i==0){
		try {
			stmt=conn.createStatement();
			
			String update = "update o_dayplan set starttime=to_date('"+start+"','yyyy-mm-dd HH24:MI:SS'),timeover='"+p+"',endtime=to_date('"+end+"','yyyy-mm-dd HH24:MI:SS'),content='"+neirong+"',remarker='"+remarker+"',place='"+place+"',person='"+person+"',settime=sysdate,seterid='"+empid1+"' where settime=to_date('"+settime+"','YYYY-MM-DD hh24:mi:ss')";
			System.out.println("update==="+update);
			
			stmt.executeUpdate(update);
				try {
					request.getRequestDispatcher("/succenewplan.jsp").forward(request,response);
				} catch (ServletException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				} catch (IOException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				};
			
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
		DatabaseUtils coldat =new DatabaseUtils();
		DatabaseUtils.closeObject(rs1,stmt,conn);
		System.out.println("+++++close+++++");
		}
		//}
		/*else{
			try {
				request.getRequestDispatcher("/haveplan.jsp").forward(request,response);
			} catch (ServletException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
           finally{
			DatabaseUtils coldat =new DatabaseUtils();
			DatabaseUtils.closeObject(rs1,stmt,conn);
			System.out.println("+++++close+++++");
           }
		}*/
	}
           
}