experience.java

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

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

package hrms.extra;

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

import hrms.util.*;

public class Experience {

	public String EmployeeID, Company, Department, Duty, Remark;

	public java.sql.Date StartDate, EndDate;

	public int ExperienceNO;
	
	public Experience() {
	};

	public String getEmployeeID() {
		return EmployeeID;
	}

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

	public String getCompany() {
		return Company;
	}

	public void setCompany(String s) {
		this.Company = s;
	}

	public String getDepartment() {
		return Department;
	}

	public void setDepartment(String s) {
		this.Department = s;
	}

	public String getDuty() {
		return Duty;
	}

	public void setDuty(String s) {
		this.Duty = s;
	}

	public String getRemark() {
		return Remark;
	}

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

	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;
	}

	public void setExperienceNO(int i) 
	{
		this.ExperienceNO = i;
	}
	
	public String getExperienceNO() 
	{
		return DataConvert.IntToStr(ExperienceNO);
	}

	/*
	 * Find Experience by No
	 */
	public static Experience FindByNO(String _ExperienceNO) {
		DBConnect dbc = null;
		Experience experience = new Experience();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM experience WHERE ExperienceNO = ?");
			dbc.setString(1, _ExperienceNO);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				experience.setExperienceNO(rs.getInt("ExperienceNO"));
				experience.setEmployeeID(rs.getString("EmployeeID"));
				experience.setStartDate(rs.getString("StartDate"));
				experience.setEndDate(rs.getString("EndDate"));
				experience.setCompany(rs.getString("Company"));
				experience.setDepartment(rs.getString("Department"));
				experience.setDuty(rs.getString("Duty"));	
				experience.setRemark(rs.getString("Remark"));
			} else {
				experience = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				experience = null;
			}
		}
		return experience;

	}

	/*
	 * Add Experience
	 */
	public static String Add(String _EmployeeID, String _StartDate, String _EndDate,
			String _Company, String _Department, String _Duty,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("INSERT INTO experience (EmployeeID,StartDate,EndDate,Company,Department,"
							+ "Duty,Remark) VALUES (?,?,?,?,?,?,?)");
			dbc.setString(1, _EmployeeID);
			dbc.setDate(2, DataConvert.StrTosqlDate(_StartDate));
			dbc.setDate(3, DataConvert.StrTosqlDate(_EndDate));
			dbc.setString(4, _Company);
			dbc.setString(5, _Department);
			dbc.setString(6, _Duty);
			dbc.setString(7, _Remark);			
			dbc.executeUpdate();
			dbc.close();
			return "1";

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

	}

	/*
	 * Modify Experience
	 */

	public static String Modify(String _EmployeeNO,String _StartDate, String _EndDate,
			String _Company, String _Department, String _Duty,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("UPDATE experience SET StartDate=?,EndDate=?,Company=?,Department=?,"
							+ "Duty=?,Remark=? WHERE EmployeeNO=?");
			dbc.setDate(1, DataConvert.StrTosqlDate(_StartDate));
			dbc.setDate(2, DataConvert.StrTosqlDate(_EndDate));
			dbc.setString(3, _Company);
			dbc.setString(4, _Department);
			dbc.setString(5, _Duty);
			dbc.setString(6, _Remark);
			dbc.setInt(7, DataConvert.StrToInt(_EmployeeNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

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

	
	/*
	 * search Experience by EmployeeID
	 */
	public Vector SearchByID(String _EmployeeID) 
	{
		DBConnect dbc = null;
		Vector ExperienceVector = new Vector();
		try 
		{
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM experience WHERE EmployeeID=? ORDER BY StartDate ASC");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) 
			{
				Experience experience = new Experience();
				experience.setExperienceNO(rs.getInt("ExperienceNO"));
				experience.setEmployeeID(rs.getString("EmployeeID"));
				experience.setStartDate(rs.getString("StartDate"));
				experience.setEndDate(rs.getString("EndDate"));
				experience.setCompany(rs.getString("Company"));
				experience.setDepartment(rs.getString("Department"));
				experience.setDuty(rs.getString("Duty"));
				experience.setRemark(rs.getString("Remark"));				
				ExperienceVector.add(experience);
			}
		} 
		catch (Exception e) 
		{
			System.err.println(e);
		}
		finally 
		{
			try 
			{
				dbc.close();
			} 
			catch (Exception e) 
			{
				e.printStackTrace();
			}
		}
		return ExperienceVector;

	}

}