package com.DAO;
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import com.DAO.DBConnect;
import com.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;
}
/*
* 查找员工
*/
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;
}
/*
* 增加员工
*/
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);
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.setStri
实现人事管理体系的基本功能和算法，如人员变迁，请假，调动，和工资结算等 ，myec Jsp/Servlet 126万源代码下载
3星 · 超过75%的资源 需积分: 10 76 浏览量
2011-03-03
11:48:37
上传
评论
收藏 80KB RAR 举报 
personnelManagement.rar （59个子文件） 
personnelManagement src com control 
rewardServlet.java 6KB userServlet.java 6KB emplyeeServlet.java 9KB TranslateServlet.java 6KB util DataConvert.java 1KB DAO Reward.java 9KB user.java 2KB DBConnect.java 3KB employee.java 18KB Translate.java 7KB .project 1KB WebRoot css style.css 624B reward ViewReward.jsp 5KB ManageReward.jsp 3KB Reward.jsp 884B AddReward.jsp 6KB ModifyReward.jsp 10KB RewardLeft.jsp 2KB Check.jsp 171B CheckIndex.jsp 168B META-INF MANIFEST.MF 39B Header.jsp 2KB WEB-INF web.xml 3KB classes com control userServlet.class 4KB rewardServlet.class 4KB emplyeeServlet.class 5KB TranslateServlet.class 4KB util DataConvert.class 2KB DAO DBConnect.class 4KB Reward.class 8KB employee.class 16KB Translate.class 7KB user.class 3KB lib ModifyPassword.jsp 3KB Left.jsp 2KB login.jsp 4KB index.jsp 798B Logout.jsp 329B employee SearchEmployeeStep2.jsp 4KB EmployeeLeft.jsp 2KB ManageEmployeeStep2.jsp 4KB ModifyEmployee.jsp 25KB ManageEmployeeStep2.jsp.bak 5KB ManageEmployee.jsp 8KB Employee.jsp 823B SearchEmployee.jsp 8KB AddEmployee.jsp 11KB ViewEmployee.jsp 11KB incoming Header.jsp 2KB Common.jsp 776B CheckRights.jsp 112B translate TranslateLeft.jsp 2KB AddTranslate.jsp 6KB Translate.jsp 828B ViewTranslate.jsp 3KB ModifyTranslate.jsp 12KB ManageTranslate.jsp 3KB .mymetadata 330B .classpath 362B .myeclipse 资源评论
Ridge192014-03-02做广告，没用。
COOLhst2015-08-25不错，对着源码开发挺好。还有好多不懂的地方。需要自己查资料
