dayplan.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.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;

import com.skyhawk.db.ConnectionFactory;


/**
 * @author Administrator
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class DayPlan implements Serializable{

	
	private int KINDID;
	private String KIND;
	/**
	 * @return Returns the startTime.
	 */
	public String getStartTime() {
		return startTime;
		//insert into t_a values(sysdate,2,3);
	}
	/**
	 * @param startTime The startTime to set.
	 */
	public void setStartTime(String startTime) {
		this.startTime = startTime;
	}
	private String EMPID;
	private String CONTENT;
	private String REMARKER;
	private int DELETER;
	private int SETERID;
	private String SETTIME;
	private String startTime;
	private String   ENDTIME;
	private String PERSON;
	private String PLACE;
	public void setKINDID(int KINDID){
		this.KINDID=KINDID;
	}
	public int getKINDID(){
		return KINDID;
	}
	public void setKIND(String KIND){
		this.KIND=KIND;
	}
	public String getKIND(){
		return KIND;
	}
	public void setEMPID(String EMPID){
		this.EMPID=EMPID;
	}
	public String getEMPID(){
		return EMPID;
	}
	public void setCONTENT(String CONTENT){
		this.CONTENT=CONTENT;
	}
	public String getCONTENT(){
		return CONTENT;
	}
	public void setREMARKER(String REMARKER){
	    this.REMARKER=REMARKER;
	}
	public String getREMARKER(){
		return REMARKER;
	}
	public void setDELETER(int DELETER){
		this.DELETER=DELETER;
	}
	public int getDELETER(){
		return DELETER;
	}
	public void setSETERID(int SETERID){
		this.SETERID=SETERID;
	}
	public int getSETERID(){
		return SETERID;
	}
	public void setSETTIME(String settime){

		this.SETTIME=settime;
	}
	public String getSETTIME(){
		return SETTIME;
	}
	public void setENDTIME(String ENDTIME){
		this.ENDTIME=ENDTIME;
	}
	public String getENDTIME(){
		return ENDTIME;
	}
	public void setPERSON(String PERSON){
		this.PERSON=PERSON;
	}
	public String getPERSON(){
		return PERSON;
	}
	public void setPLACE(String PLACE){
		this.PLACE=PLACE;
	}
	public String getPLACE(){
		return PLACE;
	}
	public String cutTime(String Time){
		String rightTime=Time.substring(0,19);
		return rightTime;
	}
	public int passTime(String Time1,String Time2){
		int f=0;
		if(Time1.compareTo(Time2)>0){
		f=0;
		System.out.println(f);
		return f;
		}
		else {
			f=1;
			System.out.println(f);
			return f;
		}
	}
	public int hadplan(String empid,String time){
		int i = 0;
		Statement stmt = null;
		ResultSet rs1 = null;
		System.out.println("hadplanyouempid?"+empid);
		String hadplan="select starttime from o_dayplan where empid='"+empid+"'and starttime=to_date('"+time+"','YYYY-MM-DD HH24:MI:SS')";
		
		System.out.println("===hadplan=="+hadplan);
		Connection conn =  ConnectionFactory.getConnection();
		try {
			stmt=conn.createStatement();
			
			rs1=stmt.executeQuery(hadplan);
	
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
			}
		try {
			if(rs1.next()){
				i=1;
			}
			else {i=0;}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return i;
		
		
		
	}

	
	
}