employee.java

基于jsp编写的hr人事管理系统sqlserver数据库 基本HR管理功能

			dbc.setString(6, _Marriage);
			dbc.setString(7, _IdentityID);
			dbc.setString(8, _Politics);
			dbc.setString(9, _Folk);
			dbc.setString(10, _Education);
			dbc.setString(11, _Department);
			dbc.setString(12, _University);
			dbc.setString(13, _AccumulateID);
			dbc.setString(14, _AdministrationLevel);
			dbc.setString(15, _Duty);
			dbc.setString(16, _Position);
			dbc.setString(17, _ForeignLanguage);
			dbc.setString(18, _FLLevel);
			dbc.setString(19, _ComputerLevel);
			dbc.setString(20, _Phone);
			dbc.setString(21, _MobilePhone);
			dbc.setString(22, _Address);
			dbc.setString(23, _Incumbency);
			dbc.setString(24, _IncumbencyType);
			dbc.setString(25, _Resume);
			dbc.setDate(26, DataConvert.StrTosqlDate(_Birthday));
			dbc.setDate(27, DataConvert.StrTosqlDate(_GraduateDate));
			System.out.println(DataConvert.StrTosqlDate(_Birthday));
			System.out.println(DataConvert.StrTosqlDate(_GraduateDate));
			dbc.executeUpdate();
			dbc.close();
			return "1";

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

	}

	/*
	 * Modify Employee
	 */

	public static String Modify(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("UPDATE Employee SET 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=?"
							+ " WHERE EmployeeID=?");
			dbc.setString(1, _UserName);
			dbc.setString(2, _Sex);
			dbc.setString(3, _Branch);
			dbc.setString(4, _NativePlace);
			dbc.setString(5, _Marriage);
			dbc.setString(6, _IdentityID);
			dbc.setString(7, _Politics);
			dbc.setString(8, _Folk);
			dbc.setString(9, _Education);
			dbc.setString(10, _Department);
			dbc.setString(11, _University);
			dbc.setString(12, _AccumulateID);
			dbc.setString(13, _AdministrationLevel);
			dbc.setString(14, _Duty);
			dbc.setString(15, _Position);
			dbc.setString(16, _ForeignLanguage);
			dbc.setString(17, _FLLevel);
			dbc.setString(18, _ComputerLevel);
			dbc.setString(19, _Phone);
			dbc.setString(20, _MobilePhone);
			dbc.setString(21, _Address);
			dbc.setString(22, _Incumbency);
			dbc.setString(23, _IncumbencyType);
			dbc.setString(24, _Resume);
			dbc.setDate(25, DataConvert.StrTosqlDate(_Birthday));
			dbc.setDate(26, DataConvert.StrTosqlDate(_GraduateDate));
			dbc.setString(27, _EmployeeID);
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * Delete Employee
	 */
	public static String Delete(String _EmployeeID) {
		try {
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("DELETE FROM employee WHERE EmployeeID=?");
			dbc.setString(1, _EmployeeID);
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * the Employee exists?
	 */
	public static boolean IsExist(String _EmployeeID) throws Exception {
		DBConnect dbc = null;
		boolean IsExist = false;
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM employee WHERE EmployeeID=?");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			if (!rs.next()) {
				IsExist = false;
			} else {
				IsExist = true;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return IsExist;
	}

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

		String strSQL = "SELECT * FROM employee ORDER BY EmployeeID ASC";

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Employee employee = new Employee();
				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"));
				EmployeeVector.add(employee);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return EmployeeVector;

	}

	
	/*
	 * search Employee
	 */
	public static Vector Search(String _EmployeeID, String _UserName, String _Sex,
			String _Branch, String _NativePlace, String _Marriage,
			String _Politics, String _Folk, String _Education,
			String _AdministrationLevel, String _Duty, String _Position,
			String _Incumbency, String _IncumbencyType) {
		DBConnect dbc = null;
		Vector EmployeeVector = new Vector();

		String strSQL = "SELECT * FROM employee WHERE";

		if ((_EmployeeID.equals("")) & (_UserName.equals("")) & (_Sex.equals(""))
				& (_Branch.equals("")) & (_NativePlace.equals("")) & (_Marriage.equals("")) & (_Politics.equals(""))
				& (_Folk.equals("")) & (_Education.equals("")) & (_AdministrationLevel.equals("")) & (_Duty.equals(""))
				& (_Position.equals("")) & (_Incumbency.equals("")) & (_IncumbencyType.equals(""))) {
			strSQL = "SELECT * FROM employee ";
		} else {
			if (!_EmployeeID.equals(""))
				strSQL = strSQL + " EmployeeID LIKE '%" + _EmployeeID + "%' AND";
			if (!_UserName.equals(""))
				strSQL = strSQL + " UserName='" + _UserName + "' AND";
			if (!_Sex.equals(""))
				strSQL = strSQL + " Sex='" + _Sex + "' AND";
			if (!_Branch.equals(""))
				strSQL = strSQL + " Branch='" + _Branch + "' AND";
			if (!_NativePlace.equals(""))
				strSQL = strSQL + " NativePlace LIKE '%" + _NativePlace + "%' AND";
			if (!_Marriage.equals(""))
				strSQL = strSQL + " Marriage='" + _Marriage + "' AND";
			if (!_Politics.equals(""))
				strSQL = strSQL + " Politics='" + _Politics + "' AND";
			if (!_Folk.equals(""))
				strSQL = strSQL + " Folk LIKE '%" + _Folk + "%' AND";
			if (!_Education.equals(""))
				strSQL = strSQL + " Education='" + _Education + "' AND";
			if (!_AdministrationLevel.equals(""))
				strSQL = strSQL + " AdministrationLevel='" + _AdministrationLevel + "' AND";
			if (!_Duty.equals(""))
				strSQL = strSQL + " Duty='" + _Duty + "' AND";
			if (!_Position.equals(""))
				strSQL = strSQL + " Position='" + _Position + "' AND";
			if (!_Incumbency.equals(""))
				strSQL = strSQL + " Incumbency='" + _Incumbency + "' AND";
			if (!_IncumbencyType.equals(""))
				strSQL = strSQL + " IncumbencyType='" + _IncumbencyType + "' AND";

			strSQL = strSQL + " 1=1 ";
		}

		strSQL = strSQL + "ORDER BY EmployeeID ASC";

		System.out.println(strSQL);

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Employee employee = new Employee();
				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"));
				EmployeeVector.add(employee);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return EmployeeVector;

	}

	/*
	 * Update Employee Duty
	 */
	public static String UpdateDuty(String _EmployeeID, String _Duty) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE Employee SET Duty=? WHERE EmployeeID=?");
			dbc.setString(1, _Duty);			
			dbc.setString(2, _EmployeeID);
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * Update Employee
	 */
	public static String UpdateBranch(String _EmployeeID, String _Branch) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE Employee SET Branch=? WHERE EmployeeID=?");
			dbc.setString(1, _Branch);			
			dbc.setString(2, _EmployeeID);
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}
	
	
}