reward.java

帮助文档打开后可以阅读资源

/**
 *  Title  hrms
 *  @author: dzc
 *  Company: hust
 *  Copyright: Copyright (c) 2005
 *  @version 1.0
 *  Date  :   2006-04
 *  Filename:Reward.java
 **/

package hrms.action;

import hrms.database.DBConnect;
import hrms.util.*;

import java.sql.*;
import java.util.*;

import hrms.util.*;

public class Reward {

	public String EmployeeID, Position, RewardPunish, RewardContent, Reason,
			Branch, HandleName, CancelReason, Remark;

	public java.sql.Date StartDate, CancelDate;

	public int RewardNO;

	public Reward() {
	};

	public String getEmployeeID() {
		return EmployeeID;
	}

	public void setEmployeeID(String s) {
		this.EmployeeID = s;
	}

	public String getPosition() {
		return Position;
	}

	public void setPosition(String s) {
		this.Position = s;
	}

	public String getRewardPunish() {
		return RewardPunish;
	}

	public void setRewardPunish(String s) {
		this.RewardPunish = s;
	}

	public String getRewardContent() {
		return RewardContent;
	}

	public void setRewardContent(String s) {
		this.RewardContent = s;
	}

	public String getReason() {
		return Reason;
	}

	public void setReason(String s) {
		this.Reason = s;
	}

	public String getBranch() {
		return Branch;
	}

	public void setBranch(String s) {
		this.Branch = s;
	}

	public String getHandleName() {
		return HandleName;
	}

	public void setHandleName(String s) {
		this.HandleName = s;
	}

	public String getCancelReason() {
		return CancelReason;
	}

	public void setCancelReason(String s) {
		this.CancelReason = s;
	}

	public String getRemark() {
		return Remark;
	}

	public void setRemark(String s) {
		this.Remark = s;
	}

	public void setRewardNO(int i) {
		this.RewardNO = i;
	}

	public String getRewardNO() {
		return DataConvert.IntToStr(RewardNO);
	}

	public String getStartDate() {
		if (this.StartDate != null)
			return DataConvert.sqlDateToStr(StartDate);
		else
			return "";
	}

	public void setStartDate(String str) {
		if (str != null)
			this.StartDate = DataConvert.StrTosqlDate(str);
		else
			this.StartDate = null;
	}

	public String getCancelDate() {
		if (this.CancelDate != null)
			return DataConvert.sqlDateToStr(CancelDate);
		else
			return "";
	}

	public void setCancelDate(String str) {
		if (str != null)
			this.CancelDate = DataConvert.StrTosqlDate(str);
		else
			this.CancelDate = null;
	}

	/*
	 * Find Reward by NO
	 */
	public static Reward FindByNO(String _RewardNO) {
		DBConnect dbc = null;
		Reward reward = new Reward();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM reward WHERE RewardNO=?");
			dbc.setString(1, _RewardNO);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				reward.setRewardNO(rs.getInt("RewardNO"));
				reward.setEmployeeID(rs.getString("EmployeeID"));
				reward.setPosition(rs.getString("Position"));
				reward.setRewardPunish(rs.getString("RewardPunish"));
				reward.setRewardContent(rs.getString("RewardContent"));
				reward.setReason(rs.getString("Reason"));
				reward.setBranch(rs.getString("Branch"));
				reward.setHandleName(rs.getString("HandleName"));
				reward.setStartDate(rs.getString("StartDate"));
				reward.setCancelDate(rs.getString("CancelDate"));
				reward.setCancelReason(rs.getString("CancelReason"));
				reward.setRemark(rs.getString("Remark"));
			} else {
				reward = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				reward = null;
			}
		}
		return reward;

	}

	/*
	 * Add Reward
	 */
	public static String Add(String _EmployeeID, String _Position,
			String _RewardPunish, String _RewardContent, String _Reason,
			String _Branch, String _HandleName, String _StartDate,
			String _CancelDate, String _CancelReason, String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO reward (EmployeeID,Position,RewardPunish,RewardContent,"
							+ "Reason,Branch,HandleName,StartDate,CancelDate,CancelReason,Remark) VALUES (?,?,?,?,?,?,?,?,?,?,?)");
			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _Position);
			dbc.setString(3, _RewardPunish);
			dbc.setString(4, _RewardContent);
			dbc.setString(5, _Reason); 
			dbc.setString(6, _Branch);
			dbc.setString(7, _HandleName);
			dbc.setDate(8, DataConvert.StrTosqlDate(_StartDate));
			dbc.setDate(9, DataConvert.StrTosqlDate(_CancelDate));
			dbc.setString(10, _CancelReason);
			dbc.setString(11, _Remark);
			dbc.executeUpdate();
			dbc.close();
			return "1";

		} catch (Exception e) {
			System.err.println(e);
			return e.toString();
		}

	}

	/*
	 * Modify Reward
	 */

	public static String Modify(String _RewardNO,String _EmployeeID, String _Position,
			String _RewardPunish, String _RewardContent, String _Reason,
			String _Branch, String _HandleName, String _StartDate,
			String _CancelDate, String _CancelReason, String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE reward SET EmployeeID=?,Position=?,RewardPunish=?,RewardContent=?,Reason=?,"
							+ "Branch=?,HandleName=?,StartDate=?,CancelDate=?,CancelReason=?,Remark=? WHERE RewardNO=?");
			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _Position);
			dbc.setString(3, _RewardPunish);
			dbc.setString(4, _RewardContent);
			dbc.setString(5, _Reason);
			dbc.setString(6, _Branch);
			dbc.setString(7, _HandleName);
			dbc.setDate(8, DataConvert.StrTosqlDate(_StartDate));
			dbc.setDate(9, DataConvert.StrTosqlDate(_CancelDate));
			dbc.setString(10, _CancelReason);
			dbc.setString(11, _Remark);
			dbc.setInt(12, DataConvert.StrToInt(_RewardNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * Delete Reward
	 */
	public static String Delete(String _RewardNO) {
		try {
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("DELETE FROM reward WHERE RewardNO=?");
			dbc.setInt(1, DataConvert.StrToInt(_RewardNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * search Reward by EmployeeID
	 */
	public static Vector SearchByID(String _EmployeeID) {
		DBConnect dbc = null;
		Vector RewardVector = new Vector();
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("SELECT * FROM reward WHERE EmployeeID=? ORDER BY StartDate ASC");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Reward reward = new Reward();
				reward.setRewardNO(rs.getInt("RewardNO"));
				reward.setEmployeeID(rs.getString("EmployeeID"));
				reward.setPosition(rs.getString("Position"));
				reward.setRewardPunish(rs.getString("RewardPunish"));
				reward.setRewardContent(rs.getString("RewardContent"));
				reward.setReason(rs.getString("Reason"));
				reward.setBranch(rs.getString("Branch"));
				reward.setHandleName(rs.getString("HandleName"));
				reward.setStartDate(rs.getString("StartDate"));
				reward.setCancelDate(rs.getString("CancelDate"));
				reward.setCancelReason(rs.getString("CancelReason"));
				reward.setRemark(rs.getString("Remark"));
				RewardVector.add(reward);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return RewardVector;

	}
	/*
	 * List All Reward
	 */
	public static Vector ListAll() {
		DBConnect dbc = null;
		Vector RewardVector = new Vector();

		String strSQL = "SELECT * FROM reward ORDER BY EmployeeID ASC";

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Reward reward = new Reward();
				reward.setRewardNO(rs.getInt("RewardNO"));
				reward.setEmployeeID(rs.getString("EmployeeID"));
				reward.setPosition(rs.getString("Position"));
				reward.setRewardPunish(rs.getString("RewardPunish"));
				reward.setRewardContent(rs.getString("RewardContent"));
				reward.setReason(rs.getString("Reason"));
				reward.setBranch(rs.getString("Branch"));
				reward.setHandleName(rs.getString("HandleName"));
				reward.setStartDate(rs.getString("StartDate"));
				reward.setCancelDate(rs.getString("CancelDate"));
				reward.setCancelReason(rs.getString("CancelReason"));
				reward.setRemark(rs.getString("Remark"));
				RewardVector.add(reward);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return RewardVector;

	}

	
}