translate.java

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

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

package hrms.action;

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

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

import hrms.util.*;

public class Translate {

	public String EmployeeID, PriorBranch,NextBranch,PriorDuty,NextDuty,HandleName,Remark;

	public java.sql.Date TranslateDate;
	
	public int TranslateNO;

	public Translate() {
	};

	public String getEmployeeID() {
		return EmployeeID;
	}

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

	public String getPriorBranch() {
		return PriorBranch;
	}

	public void setPriorBranch(String s) {
		this.PriorBranch = s;
	}

	public String getNextBranch() {
		return NextBranch;
	}

	public void setNextBranch(String s) {
		this.NextBranch = s;
	}

	public String getPriorDuty() {
		return PriorDuty;
	}

	public void setPriorDuty(String s) {
		this.PriorDuty = s;
	}

	public String getNextDuty() {
		return NextDuty;
	}

	public void setNextDuty(String s) {
		this.NextDuty = s;
	}
	
	public String getHandleName() {
		return HandleName;
	}

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

	public void setRemark(String s) {
		this.Remark = s;
	}
	
	public void setTranslateNO(int i) {
		this.TranslateNO = i;
	}

	public String getTranslateNO() {
		return DataConvert.IntToStr(TranslateNO);
	}
	
	public String getTranslateDate() {
		if (this.TranslateDate != null)
			return DataConvert.sqlDateToStr(TranslateDate);
		else
			return "";
	}

	public void setTranslateDate(String str) {
		if (str != null)
			this.TranslateDate = DataConvert.StrTosqlDate(str);
		else
			this.TranslateDate = null;
	}
	
	/*
	 * Find Translate by NO
	 */
	public static Translate FindByNO(String _TranslateNO) {
		DBConnect dbc = null;
		Translate translate = new Translate();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM translate WHERE TranslateNO=?");
			dbc.setString(1, _TranslateNO);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				translate.setTranslateNO(rs.getInt("TranslateNO"));
				translate.setEmployeeID(rs.getString("EmployeeID"));
				translate.setTranslateDate(rs.getString("TranslateDate"));
				translate.setPriorBranch(rs.getString("PriorBranch"));
				translate.setNextBranch(rs.getString("NextBranch"));
				translate.setPriorDuty(rs.getString("PriorDuty"));
				translate.setNextDuty(rs.getString("NextDuty"));
				translate.setHandleName(rs.getString("HandleName"));
				translate.setRemark(rs.getString("Remark"));
			} else {
				translate = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				translate = null;
			}
		}
		return translate;

	}

	/*
	 * Add Translate
	 */
	public static String Add(String _EmployeeID, String _TranslateDate,
			String _PriorBranch, String _NextBranch, String _PriorDuty,
			String _NextDuty,String _HandleName,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO Translate (EmployeeID,TranslateDate,PriorBranch,NextBranch,"
							+ "PriorDuty,NextDuty,HandleName,Remark) VALUES (?,?,?,?,?,?,?,?)");
			dbc.setString(1, _EmployeeID);
			dbc.setDate(2, DataConvert.StrTosqlDate(_TranslateDate));
			dbc.setString(3, _PriorBranch);
			dbc.setString(4, _NextBranch);
			dbc.setString(5, _PriorDuty);
			dbc.setString(6, _NextDuty);
			dbc.setString(7, _HandleName);
			dbc.setString(8, _Remark);
			dbc.executeUpdate();
			dbc.close();
			return "1";

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

	}

	/*
	 * Modify Translate
	 */

	public static String Modify(String _TranslateNO,String _EmployeeID, String _TranslateDate,
			String _PriorBranch, String _NextBranch, String _PriorDuty,
			String _NextDuty,String _HandleName,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE translate SET EmployeeID=?,TranslateDate=?,PriorBranch=?,NextBranch=?,"
							+ "PriorDuty=?,NextDuty=?,HandleName=?,Remark=? WHERE TranslateNO=?");
			dbc.setString(1, _EmployeeID);
			dbc.setDate(2, DataConvert.StrTosqlDate(_TranslateDate));
			dbc.setString(3, _PriorBranch);
			dbc.setString(4, _NextBranch);
			dbc.setString(5, _PriorDuty);
			dbc.setString(6, _NextDuty);
			dbc.setString(7, _HandleName);
			dbc.setString(8, _Remark);
			dbc.setInt(9, DataConvert.StrToInt(_TranslateNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

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

	/*
	 * search Translate by EmployeeID
	 */
	public static Vector SearchByID(String _EmployeeID) {
		DBConnect dbc = null;
		Vector TranslateVector = new Vector();
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("SELECT * FROM translate WHERE EmployeeID=? ORDER BY TranslateDate ASC");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Translate translate = new Translate();
				translate.setTranslateNO(rs.getInt("TranslateNO"));
				translate.setEmployeeID(rs.getString("EmployeeID"));
				translate.setTranslateDate(rs.getString("TranslateDate"));
				translate.setPriorBranch(rs.getString("PriorBranch"));
				translate.setNextBranch(rs.getString("NextBranch"));
				translate.setPriorDuty(rs.getString("PriorDuty"));
				translate.setNextDuty(rs.getString("NextDuty"));
				translate.setHandleName(rs.getString("HandleName"));
				translate.setRemark(rs.getString("Remark"));
				TranslateVector.add(translate);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return TranslateVector;

	}

	/*
	 * List All Translate
	 */
	public static Vector ListAll() {
		DBConnect dbc = null;
		Vector TranslateVector = new Vector();

		String strSQL = "SELECT * FROM translate ORDER BY EmployeeID,TranslateDate ASC";

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Translate translate = new Translate();
				translate.setTranslateNO(rs.getInt("TranslateNO"));
				translate.setEmployeeID(rs.getString("EmployeeID"));
				translate.setTranslateDate(rs.getString("TranslateDate"));
				translate.setPriorBranch(rs.getString("PriorBranch"));
				translate.setNextBranch(rs.getString("NextBranch"));
				translate.setPriorDuty(rs.getString("PriorDuty"));
				translate.setNextDuty(rs.getString("NextDuty"));
				translate.setHandleName(rs.getString("HandleName"));
				translate.setRemark(rs.getString("Remark"));
				TranslateVector.add(translate);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return TranslateVector;

	}

}