certificate.java

这是用java编写的人力资源管理系统

package hrms.extra;

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

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

import hrms.util.*;

public class Certificate {

	public String EmployeeID, CertificateName, CertificateNumber, Organization, Remark;

	public java.sql.Date GetDate, ExpireDate;
	
	public int CertificateNO;

	public Certificate() {
	};

	public String getEmployeeID() {
		return EmployeeID;
	}

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

	public String getCertificateName() {
		return CertificateName;
	}

	public void setCertificateName(String s) {
		this.CertificateName = s;
	}

	public String getCertificateNumber() {
		return CertificateNumber;
	}

	public void setCertificateNumber(String s) {
		this.CertificateNumber = s;
	}

	public String getOrganization() {
		return Organization;
	}

	public void setOrganization(String s) {
		this.Organization = s;
	}

	public String getRemark() {
		return Remark;
	}

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

	public void setCertificateNO(int i) {
		this.CertificateNO = i;
	}

	public String getCertificateNO() {
		return DataConvert.IntToStr(CertificateNO);
	}
	
	public String getGetDate() {
		if (this.GetDate != null)
			return DataConvert.sqlDateToStr(GetDate);
		else
			return "";
	}

	public void setGetDate(String str) {
		if (str != null)
			this.GetDate = DataConvert.StrTosqlDate(str);
		else
			this.GetDate = null;
	}
	
	public String getExpireDate() {
		if (this.ExpireDate != null)
			return DataConvert.sqlDateToStr(ExpireDate);
		else
			return "";
	}

	public void setExpireDate(String str) {
		if (str != null)
			this.ExpireDate = DataConvert.StrTosqlDate(str);
		else
			this.ExpireDate = null;
	}
	
	/*
	 * Find Certificate by NO
	 */
	public static Certificate FindByNO(String _CertificateNO) {
		DBConnect dbc = null;
		Certificate certificate = new Certificate();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM certificate WHERE CertificateNO=?");
			dbc.setString(1, _CertificateNO);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				certificate.setCertificateNO(rs.getInt("CertificateNO"));
				certificate.setEmployeeID(rs.getString("EmployeeID"));
				certificate.setCertificateName(rs.getString("CertificateName"));
				certificate.setCertificateNumber(rs.getString("CertificateNumber"));
				certificate.setGetDate(rs.getString("GetDate"));
				certificate.setExpireDate(rs.getString("ExpireDate"));
				certificate.setOrganization(rs.getString("Organization"));
				certificate.setRemark(rs.getString("Remark"));
			} else {
				certificate = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				certificate = null;
			}
		}
		return certificate;

	}

	/*
	 * Add Certificate
	 */
	public static String Add(String _EmployeeID, String _CertificateName,
			String _CertificateNumber, String _GetDate, String _ExpireDate,
			String _Organization,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO society (EmployeeID,CertificateName,CertificateNumber,GetDate,"
							+ "ExpireDate,Organization,Remark) VALUES (?,?,?,?,?,?,?)");
			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _CertificateName);
			dbc.setString(3, _CertificateNumber);
			dbc.setDate(4, DataConvert.StrTosqlDate(_GetDate));
			dbc.setDate(5, DataConvert.StrTosqlDate(_ExpireDate));
			dbc.setString(6, _Organization);
			dbc.setString(7, _Remark);
			dbc.executeUpdate();
			dbc.close();
			return "1";

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

	}

	/*
	 * Modify Certificate
	 */

	public static String Modify(String _CertificateNO, String _CertificateName,
			String _CertificateNumber, String _GetDate, String _ExpireDate,
			String _Organization,String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE certificate SET CertificateName=?,CertificateNumber=?,GetDate=?,ExpireDate=?,"
							+ "Organization=?,Remark=? WHERE CertificateNO=?");
			dbc.setString(1, _CertificateName);
			dbc.setString(2, _CertificateNumber);
			dbc.setDate(3, DataConvert.StrTosqlDate(_GetDate));
			dbc.setDate(4, DataConvert.StrTosqlDate(_ExpireDate));
			dbc.setString(5, _Organization);
			dbc.setString(6, _Remark);
			dbc.setInt(7, DataConvert.StrToInt(_CertificateNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

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

	/*
	 * search Certificate by EmployeeID
	 */
	public Vector SearchByID(String _EmployeeID) {
		DBConnect dbc = null;
		Vector CertificateVector = new Vector();
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("SELECT * FROM certificate WHERE EmployeeID=? ORDER BY CertificateName ASC");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Certificate certificate = new Certificate();
				certificate.setCertificateNO(rs.getInt("CertificateNO"));
				certificate.setEmployeeID(rs.getString("EmployeeID"));
				certificate.setCertificateName(rs.getString("CertificateName"));
				certificate.setCertificateNumber(rs.getString("CertificateNumber"));
				certificate.setGetDate(rs.getString("GetDate"));
				certificate.setExpireDate(rs.getString("ExpireDate"));
				certificate.setOrganization(rs.getString("Organization"));
				certificate.setRemark(rs.getString("Remark"));
				CertificateVector.add(certificate);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return CertificateVector;

	}

}