reward.java

源代码

/**
 *  Title  staff
 *  Filename:Reward.java
 **/

package staff.action;

import staff.database.DBConnect;
import staff.util.*;
import java.sql.*;
import java.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();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();
			ResultSet rs = null;
			rs = stmt.executeQuery("SELECT * FROM reward WHERE RewardNO='"+_RewardNO+"'");

			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;
		
		
		int i=0;
		try {
			dbc = new DBConnect();
			Connection conn =dbc.getDBConnection();
			Statement stmt1 = null;
			Statement stmt2 = null;
			stmt1=conn.createStatement();
			stmt2=conn.createStatement();
			ResultSet rs=null;
			rs=stmt1.executeQuery("SELECT RewardNO FROM reward");
			
			while(rs.next()) 
			{   System.out.println(rs.getInt("RewardNO"));
				i=rs.getInt("RewardNO");
			}
			i++;
			stmt2.executeUpdate("INSERT INTO reward (EmployeeID,Position,RewardPunish,RewardContent,"
							+ "Reason,Branch,HandleName,StartDate,CancelDate,CancelReason,Remark,RewardNO)"
							+"VALUES ('"+_EmployeeID+"','"+_Position+"','"+_RewardPunish+"','"+_RewardContent+"',"
							+"'"+_Reason+"','"+_Branch+"','"+_HandleName+"','"+_StartDate+"','"+_CancelDate+"',"
							+"'"+_CancelReason+"','"+_Remark+"',"+i+")");
			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();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();

			stmt.executeUpdate("UPDATE reward SET EmployeeID='"+_EmployeeID+"',Position='"+_Position+"',RewardPunish='"+_RewardPunish+"',RewardContent='"+_RewardContent+"',Reason='"+_Reason+"',"
							+ "Branch='"+_Branch+"',HandleName='"+_HandleName+"',StartDate='"+_StartDate+"',CancelDate='"+_CancelDate+"',CancelReason='"+_CancelReason+"',Remark='"+_Remark+"' WHERE RewardNO='"+_RewardNO+"'");

						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();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();

			stmt.executeUpdate("DELETE FROM reward WHERE RewardNO='"+_RewardNO+"'");


			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();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();
			ResultSet rs = null;
			rs = stmt.executeQuery("SELECT * FROM reward WHERE EmployeeID='"+_EmployeeID+"' ORDER BY StartDate ASC");

			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();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();
			ResultSet rs = null;
			rs = stmt.executeQuery(strSQL);

			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;

	}


}