train.java

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

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

package hrms.action;

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

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

import hrms.util.*;

public class Train {

	public String EmployeeID, TrainName, TrainWhat, TrainOrgan,TrainResult, Remark;

	public java.sql.Date StartDate, EndDate;
	
	public int TrainNO;

	public Train() {
	};

	public String getEmployeeID() {
		return EmployeeID;
	}

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

	public String getTrainName() {
		return TrainName;
	}

	public void setTrainName(String s) {
		this.TrainName = s;
	}

	public String getTrainWhat() {
		return TrainWhat;
	}

	public void setTrainWhat(String s) {
		this.TrainWhat = s;
	}

	public String getTrainOrgan() {
		return TrainOrgan;
	}

	public void setTrainOrgan(String s) {
		this.TrainOrgan = s;
	}

	public String getTrainResult() {
		return TrainResult;
	}

	public void setTrainResult(String s) {
		this.TrainResult = s;
	}

	public String getRemark() {
		return Remark;
	}

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

	public String getTrainNO() {
		return DataConvert.IntToStr(TrainNO);
	}
	
	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 getEndDate() {
		if (this.EndDate != null)
			return DataConvert.sqlDateToStr(EndDate);
		else
			return "";
	}

	public void setEndDate(String str) {
		if (str != null)
			this.EndDate = DataConvert.StrTosqlDate(str);
		else
			this.EndDate = null;
	}
	
	/*
	 * Find Train by NO
	 */
	public static Train FindByNO(String _TrainNO) {
		DBConnect dbc = null;
		Train train = new Train();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM train WHERE TrainNO=?");
			dbc.setString(1, _TrainNO);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				train.setTrainNO(rs.getInt("TrainNO"));
				train.setEmployeeID(rs.getString("EmployeeID"));
				train.setTrainName(rs.getString("TrainName"));
				train.setTrainWhat(rs.getString("TrainWhat"));
				train.setStartDate(rs.getString("StartDate"));
				train.setEndDate(rs.getString("EndDate"));
				train.setTrainOrgan(rs.getString("TrainOrgan"));
				train.setTrainResult(rs.getString("TrainResult"));
				train.setRemark(rs.getString("Remark"));
			} else {
				train = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				train = null;
			}
		}
		return train;

	}

	/*
	 * Add Train
	 */
	public static String Add(String _EmployeeID, String _TrainName,
			String _TrainWhat, String _StartDate, String _EndDate,
			String _TrainOrgan,String _TrainResult,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO train (EmployeeID,TrainName,TrainWhat,StartDate,"
							+ "EndDate,TrainOrgan,TrainResult,Remark) VALUES (?,?,?,?,?,?,?,?)");
			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _TrainName);
			dbc.setString(3, _TrainWhat);
			dbc.setDate(4, DataConvert.StrTosqlDate(_StartDate));
			dbc.setDate(5, DataConvert.StrTosqlDate(_EndDate));
			dbc.setString(6, _TrainOrgan);
			dbc.setString(7, _TrainResult);
			dbc.setString(8, _Remark);
			dbc.executeUpdate();
			dbc.close();
			return "1";

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

	}

	/*
	 * Modify Train
	 */

	public static String Modify(String _TrainNO,String _EmployeeID, String _TrainName,
			String _TrainWhat, String _StartDate, String _EndDate,
			String _TrainOrgan,String _TrainResult,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE train SET EmployeeID=?,TrainName=?,TrainWhat=?,StartDate=?,EndDate=?,"
							+ "TrainOrgan=?,TrainResult=?,Remark=? WHERE TrainNO=?");
			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _TrainName);
			dbc.setString(3, _TrainWhat);
			dbc.setDate(4, DataConvert.StrTosqlDate(_StartDate));
			dbc.setDate(5, DataConvert.StrTosqlDate(_EndDate));
			dbc.setString(6, _TrainOrgan);
			dbc.setString(7, _TrainResult);
			dbc.setString(8, _Remark);
			dbc.setInt(9, DataConvert.StrToInt(_TrainNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

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

	/*
	 * search Train by EmployeeID
	 */
	public static Vector SearchByID(String _EmployeeID) {
		DBConnect dbc = null;
		Vector TrainVector = new Vector();
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("SELECT * FROM train WHERE EmployeeID=? ORDER BY StartDate ASC");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Train train = new Train();
				train.setTrainNO(rs.getInt("TrainNO"));
				train.setEmployeeID(rs.getString("EmployeeID"));
				train.setTrainName(rs.getString("TrainName"));
				train.setTrainWhat(rs.getString("TrainWhat"));
				train.setStartDate(rs.getString("StartDate"));
				train.setEndDate(rs.getString("EndDate"));
				train.setTrainOrgan(rs.getString("TrainOrgan"));
				train.setTrainResult(rs.getString("TrainResult"));
				train.setRemark(rs.getString("Remark"));
				TrainVector.add(train);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return TrainVector;

	}

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

		String strSQL = "SELECT * FROM train ORDER BY StartDate ASC";

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Train train = new Train();
				train.setTrainNO(rs.getInt("TrainNO"));
				train.setEmployeeID(rs.getString("EmployeeID"));
				train.setTrainName(rs.getString("TrainName"));
				train.setTrainWhat(rs.getString("TrainWhat"));
				train.setStartDate(rs.getString("StartDate"));
				train.setEndDate(rs.getString("EndDate"));
				train.setTrainOrgan(rs.getString("TrainOrgan"));
				train.setTrainResult(rs.getString("TrainResult"));
				train.setRemark(rs.getString("Remark"));
				TrainVector.add(train);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return TrainVector;

	}

	
}