employee.java

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

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

package hrms.employee;

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

public class Employee {

	public String EmployeeID, UserName, Sex, Branch, NativePlace, Marriage,
			IdentityID, Politics, Folk, Education, Department, University,
			AccumulateID, AdministrationLevel, Duty, Position, ForeignLanguage,
			FLLevel, ComputerLevel, Phone, MobilePhone, Address, Incumbency,
			IncumbencyType, Resume;

	public java.sql.Date Birthday, GraduateDate;

	public Employee() {
	};

	public String getEmployeeID() {
		return EmployeeID;
	}

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

	public String getUserName() {
		return UserName;
	}

	public void setUserName(String s) {
		this.UserName = s;
	}

	public String getSex() {
		return Sex;
	}

	public void setSex(String s) {
		this.Sex = s;
	}

	public String getBranch() {
		return Branch;
	}

	public void setBranch(String s) {
		this.Branch = s;
	}

	public String getNativePlace() {
		return NativePlace;
	}

	public void setNativePlace(String s) {
		this.NativePlace = s;
	}

	public String getMarriage() {
		return Marriage;
	}

	public void setMarriage(String s) {
		this.Marriage = s;
	}

	public String getIdentityID() {
		return IdentityID;
	}

	public void setIdentityID(String s) {
		this.IdentityID = s;
	}

	public String getPolitics() {
		return Politics;
	}

	public void setPolitics(String s) {
		this.Politics = s;
	}

	public String getFolk() {
		return Folk;
	}

	public void setFolk(String s) {
		this.Folk = s;
	}

	public String getEducation() {
		return Education;
	}

	public void setEducation(String s) {
		this.Education = s;
	}

	public String getDepartment() {
		return Department;
	}

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

	public String getUniversity() {
		return University;
	}

	public void setUniversity(String s) {
		this.University = s;
	}

	public String getAccumulateID() {
		return AccumulateID;
	}

	public void setAccumulateID(String s) {
		this.AccumulateID = s;
	}

	public String getAdministrationLevel() {
		return AdministrationLevel;
	}

	public void setAdministrationLevel(String s) {
		this.AdministrationLevel = s;
	}

	public String getDuty() {
		return Duty;
	}

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

	public String getPosition() {
		return Position;
	}

	public void setPosition(String s) {
		this.Position = s;
	}

	public String getForeignLanguage() {
		return ForeignLanguage;
	}

	public void setForeignLanguage(String s) {
		this.ForeignLanguage = s;
	}

	public String getFLLevel() {
		return FLLevel;
	}

	public void setFLLevel(String s) {
		this.FLLevel = s;
	}

	public String getComputerLevel() {
		return ComputerLevel;
	}

	public void setComputerLevel(String s) {
		this.ComputerLevel = s;
	}

	public String getPhone() {
		return Phone;
	}

	public void setPhone(String s) {
		this.Phone = s;
	}

	public String getMobilePhone() {
		return MobilePhone;
	}

	public void setMobilePhone(String s) {
		this.MobilePhone = s;
	}

	public String getAddress() {
		return Address;
	}

	public void setAddress(String s) {
		this.Address = s;
	}

	public String getIncumbency() {
		return Incumbency;
	}

	public void setIncumbency(String s) {
		this.Incumbency = s;
	}

	public String getIncumbencyType() {
		return IncumbencyType;
	}

	public void setIncumbencyType(String s) {
		this.IncumbencyType = s;
	}

	public String getResume() {
		return Resume;
	}

	public void setResume(String s) {
		this.Resume = s;
	}

	public String getBirthday() {
		if (this.Birthday != null)
			return DataConvert.sqlDateToStr(Birthday);
		else
			return "";
	}

	public void setBirthday(String strBir) {
		if (strBir != null)
			this.Birthday = DataConvert.StrTosqlDate(strBir);
		else
			this.Birthday = null;
	}

	public String getGraduateDate() {
		if (this.GraduateDate != null)
			return DataConvert.sqlDateToStr(GraduateDate);
		else
			return "";
	}

	public void setGraduateDate(String strBir) {
		if (strBir != null)
			this.GraduateDate = DataConvert.StrTosqlDate(strBir);
		else
			this.GraduateDate = null;
	}

	/*
	 * Find Employee by ID
	 */
	public static Employee FindByID(String _EmployeeID) {
		DBConnect dbc = null;
		Employee employee = new Employee();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM employee WHERE EmployeeID = ?");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				employee.setEmployeeID(rs.getString("EmployeeID"));
				employee.setUserName(rs.getString("UserName"));
				employee.setSex(rs.getString("Sex"));
				employee.setBranch(rs.getString("Branch"));
				employee.setBirthday(rs.getString("Birthday"));
				employee.setNativePlace(rs.getString("NativePlace"));
				employee.setMarriage(rs.getString("Marriage"));
				employee.setIdentityID(rs.getString("IdentityID"));
				employee.setPolitics(rs.getString("Politics"));
				employee.setFolk(rs.getString("Folk"));
				employee.setEducation(rs.getString("Education"));
				employee.setDepartment(rs.getString("Department"));
				employee.setGraduateDate(rs.getString("GraduateDate"));
				employee.setUniversity(rs.getString("University"));
				employee.setAccumulateID(rs.getString("AccumulateID"));
				employee.setAdministrationLevel(rs
						.getString("AdministrationLevel"));
				employee.setDuty(rs.getString("Duty"));
				employee.setPosition(rs.getString("Position"));
				employee.setForeignLanguage(rs.getString("ForeignLanguage"));
				employee.setFLLevel(rs.getString("FLLevel"));
				employee.setComputerLevel(rs.getString("ComputerLevel"));
				employee.setPhone(rs.getString("Phone"));
				employee.setMobilePhone(rs.getString("MobilePhone"));
				employee.setAddress(rs.getString("Address"));
				employee.setIncumbency(rs.getString("Incumbency"));
				employee.setIncumbencyType(rs.getString("IncumbencyType"));
				employee.setResume(rs.getString("Resume"));
			} else {
				employee = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				employee = null;
			}
		}
		return employee;

	}

	/*
	 * Add Employee
	 */
	public static String Add(String _EmployeeID, String _UserName, String _Sex,
			String _Branch, String _NativePlace, String _Marriage,
			String _IdentityID, String _Politics, String _Folk,
			String _Education, String _Department, String _University,
			String _AccumulateID, String _AdministrationLevel, String _Duty,
			String _Position, String _ForeignLanguage, String _FLLevel,
			String _ComputerLevel, String _Phone, String _MobilePhone,
			String _Address, String _Incumbency, String _IncumbencyType,
			String _Resume, String _Birthday, String _GraduateDate) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();

			dbc
					.prepareStatement("INSERT INTO employee (EmployeeID,UserName,Sex,Branch,NativePlace,"
							+ "Marriage,IdentityID,Politics,Folk,Education,Department,University,AccumulateID,"
							+ "AdministrationLevel,Duty,Position,ForeignLanguage,FLLevel,ComputerLevel,Phone,"
							+ "MobilePhone,Address,Incumbency,IncumbencyType,Resume,Birthday,GraduateDate) VALUES "
							+ "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");

			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _UserName);
			dbc.setString(3, _Sex);
			dbc.setString(4, _Branch);
			dbc.setString(5, _NativePlace);