- 基于Java的企业人力资源管理系统mysql数据库创建语句
- 基于Java的企业人力资源管理系统oracle数据库创建语句
- 基于Java的企业人力资源管理系统sqlserver数据库创建语句
- 基于Java的企业人力资源管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于Java的企业人力资源管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于Java的企业人力资源管理系统mysql数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '超级管理员账号',
password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');
惩罚奖励表创建语句如下：
create table t_cfjl(
id int primary key auto_increment comment '主键',
employeeId int comment '员工',
types varchar(100) comment '类型',
title varchar(100) comment '说明',
showDate datetime comment '操作日期',
remark varchar(100) comment '详细内容'
) comment '惩罚奖励';
员工表创建语句如下：
create table t_employee(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
employeeName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '员工';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
nowDate datetime comment '时间',
content varchar(100) comment '内容'
) comment '公告';
离职表创建语句如下：
create table t_lz(
id int primary key auto_increment comment '主键',
employeeId int comment '员工',
v1 varchar(100) comment '之前岗位',
showDate datetime comment '操作日期',
remark varchar(100) comment '离职原因'
) comment '离职';
普通管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ptadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '普通管理员';
培训人员表创建语句如下：
create table t_pxry(
id int primary key auto_increment comment '主键',
pxryName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
pic varchar(100) comment '头像',
pxmb varchar(100) comment '培训目标',
pxtitle varchar(100) comment '培训标题',
pxcontent varchar(100) comment '培训内容',
pxDate datetime comment '培训日期',
status varchar(100) comment '培训结果'
) comment '培训人员';
调职表创建语句如下：
create table t_tz(
id int primary key auto_increment comment '主键',
employeeId int comment '员工',
v1 varchar(100) comment '之前岗位',
v2 varchar(100) comment '调后岗位',
showDate datetime comment '操作日期',
remark varchar(100) comment '备注'
) comment '调职';
薪资福利表创建语句如下：
create table t_xzfl(
id int primary key auto_increment comment '主键',
employeeId int comment '员工',
jbxz int comment '基本工资',
fl int comment '福利',
zzgz int comment '最终工资',
beginDate datetime comment '开始时间',
status varchar(100) comment '状态'
) comment '薪资福利';
再教育表创建语句如下：
create table t_zjy(
id int primary key auto_increment comment '主键',
employeeId int comment '员工',
title varchar(100) comment '再教育名称',
beginDate datetime comment '操作日期',
endDate datetime comment '结束日期',
remark varchar(100) comment '内容'
) comment '再教育';
招聘人员表创建语句如下：
create table t_zpry(
id int primary key auto_increment comment '主键',
zpryName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
pic varchar(100) comment '头像',
xzyq varchar(100) comment '薪资要求',
mbgw varchar(100) comment '目标岗位',
fileUrl varchar(100) comment '详细简历附件',
status varchar(100) comment '状态'
) comment '招聘人员';
基于Java的企业人力资源管理系统oracle数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';
惩罚奖励表创建语句如下：
create table t_cfjl(
id integer,
employeeId int,
types varchar(100),
title varchar(100),
showDate datetime,
remark varchar(100)
);
--惩罚奖励字段加注释
comment on column t_cfjl.id is '主键';
comment on column t_cfjl.employeeId is '员工';
comment on column t_cfjl.types is '类型';
comment on column t_cfjl.title is '说明';
comment on column t_cfjl.showDate is '操作日期';
comment on column t_cfjl.remark is '详细内容';
--惩罚奖励表加注释
comment on table t_cfjl is '惩罚奖励';
员工表创建语句如下：
create table t_employee(
id integer,
username varchar(100),
password varchar(100),
employeeName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--员工字段加注释
comment on column t_employee.id is '主键';
comment on column t_employee.username is '账号';
comment on column t_employee.password is '密码';
comment on column t_employee.employeeName is '姓名';
comment on column t_employee.phone is '电话';
comment on column t_employee.age is '年龄';
comment on column t_employee.sex is '性别';
--员工表加注释
comment on table t_employee is '员工';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
nowDate datetime,
content varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.nowDate is '时间';
comment on column t_gg.content is '内容';
--公告表加注释
comment on table t_gg is '公告';
离职表创建语句如下：
create table t_lz(
id integer,
employeeId int,
v1 varchar(100),
showDate datetime,
remark varchar(100)
);
--离职字段加注释
comment on column t_lz.id is '主键';
comment on column t_lz.employeeId is '员工';
comment on column t_lz.v1 is '之前岗位';
comment on column t_lz.showDate is '操作日期';
comment on column t_lz.remark is '离职原因';
--离职表加注释
comment on table t_lz is '离职';
普通管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
培训人员表创建语句如下：
create table t_pxry(
id integer,
pxryName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
pic varchar(100),
pxmb varchar(100),
pxtitle varchar(100),
pxcontent varchar(100),
pxDate datetime,
status varchar(100)
);
--培训人员字段加注释
comment on column t_pxry.id is '主键';
comment on column t_pxry.pxryName is '姓名';
comment on column t_pxry.phone is '电话';
comment on column t_pxry.age is '年龄';
comment on column t_pxry.sex is '性别';
comment on column t_pxry.pic is '头像';
comment on column t_pxry.pxmb is '培训目标';
comment on column t_pxry.pxtitle is '培训标题';
comment on column t_pxry.pxcontent is '培训内容';
comment on column t_pxry.pxDate is '培训日期';
comment on column t_pxry.status is '培训结果';
--培训人员表加注释
comment on table t_pxry is '培训人员';
调职表创建语句如下：
create table t_tz(
id integer,
employeeId int,
v1 varchar(100),
v2 varchar(100),
showDate datetime,
remark varchar(100)
);
--调职字段加注释
comment on column t_tz.id is '主键';
comment on column t_tz.employeeId is '员工';
comment on column t_tz.v1 is '之前岗位';
comment on column t_tz.v2 is '调后岗位';
comment on column t_tz.showDate is '操作日期';
comment on column t_tz.remark is '备注';
--调职表加注释
comment on table t_tz is '调职';
薪资福利表创建语句如下：
create table t_xzfl(
id integer,
employeeId int,
jbxz int,
fl int,
zzgz int,
beginDate datetime,
status varchar(100)
);
--薪资福利字段加注释
comment on column t_xzfl.id is '主键';
comment on column t_xzfl.employeeId is '员工';
comment on column t_xzfl.jbxz is '基本工资';
comment on column t_xzfl.fl is '福利';
comment on column t_xzfl.zzgz is '最终工资';
comment on column t_xzfl.beginDate is '开始时间';
comment on column t_xzfl.status is '状态';
--薪资福利表加注释
comment on table t_xzfl is '薪资福利';
再教育表创建语句如下：
create table t_zjy(
id integer,
employeeId int,
title varchar(100),
beginDate datetime,
endDate datetime,
remark varchar(100)
);
--再教育字段加注释
comment on column t_zjy.id is '主键';
comment on column t_zjy.employeeId is '员工';
comment on column t_zjy.title is '再教育名称';
comment on column t_zjy.beginDate is '操作日期';
comment on column t_zjy.endDate is '结束日期';
comment on column t_zjy.remark is '内容';
--再教育表加注释
comment on table t_zjy is '再教育';
招聘人员表创建语句如下：
create table t_zpry(
id integer,
zpryName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
pic varchar(100),
xzyq varchar(100),
mbgw varchar(100),
fileUrl varchar(100),
status varchar(100)
);
--招聘人员字段加注释
comment on column t_zpry.id is '主键';
comment on column t_zpry.zpryName is '姓名';
comment on column t_zpry.phone is '电话';
comment on column t_zpry.age is '年龄';
comment on column t_zpry.sex is '性别';
comment on column t_zpry.pic is '头像';
comment on column t_zpry.xzyq is '薪资要求';
comment on column t_zpry.mbgw is '目标岗位';
comment on column t_zpry.fileUrl is '详细简历附件';
comment on column t_zpry.status is '状态';
--招聘人员表加注释
comment on table t_zpry is '招聘人员';
oracle特有，对应序列如下：
create sequence s_t_cfjl;
create sequence s_t_employee;
create sequence s_t_gg;
create sequence s_t_lz;
create sequence s_t_ptadmin;
create sequence s_t_pxry;
create sequence s_t_tz;
create sequence s_t_xzfl;
create sequence s_t_zjy;
create sequence s_t_zpry;
基于Java的企业人力资源管理系统sqlserver数据库版本源码：
超级管理员表创建语句如下：
--超级管理员
create table t_admin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--超级管理员账号
password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');
惩罚奖励表创建语句如下：
--惩罚奖励表注释
create table t_cfjl(
id int identity(1,1) primary key not null,--主键
employeeId int,--员工
types varchar(100),--类型
title varchar(100),--说明
showDate datetime,--操作日期
remark varchar(100)--详细内容
);
员工表创建语句如下：
--员工表注释
create table t_employee(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
employeeName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
nowDate datetime,--时间
content varchar(100)--内容
);
离职表创建语句如下：
--离职表注释
create table t_lz(
id int identity(1,1) primary key not null,--主键
employeeId int,--员工
v1 varchar(100),--之前岗位
showDate datetime,--操作日期
remark varchar(100)--离职原因
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
培训人员表创建语句如下：
--培训人员表注释
create table t_pxry(
id int identity(1,1) primary key not null,--主键
pxryName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
pic varchar(100),--头像
pxmb varchar(100),--培训目标
pxtitle varchar(100),--培训标题
pxcontent varchar(100),--培训内容
pxDate datetime,--培训日期
status varchar(100)--培训结果
);
调职表创建语句如下：
--调职表注释
create table t_tz(
id int identity(1,1) primary key not null,--主键
employeeId int,--员工
v1 varchar(100),--之前岗位
v2 varchar(100),--调后岗位
showDate datetime,--操作日期
remark varchar(100)--备注
);
薪资福利表创建语句如下：
--薪资福利表注释
create table t_xzfl(
id int identity(1,1) primary key not null,--主键
employeeId int,--员工
jbxz int,--基本工资
fl int,--福利
zzgz int,--最终工资
beginDate datetime,--开始时间
status varchar(100)--状态
);
再教育表创建语句如下：
--再教育表注释
create table t_zjy(
id int identity(1,1) primary key not null,--主键
employeeId int,--员工
title varchar(100),--再教育名称
beginDate datetime,--操作日期
endDate datetime,--结束日期
remark varchar(100)--内容
);
招聘人员表创建语句如下：
--招聘人员表注释
create table t_zpry(
id int identity(1,1) primary key not null,--主键
zpryName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
pic varchar(100),--头像
xzyq varchar(100),--薪资要求
mbgw varchar(100),--目标岗位
fileUrl varchar(100),--详细简历附件
status varchar(100)--状态
);
登录后主页.jpg?x-oss-process=style/00001)
基于Java的企业人力资源管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：
惩罚奖励javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//惩罚奖励
@Table(name = "t_cfjl")
public class Cfjl {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//类型
private String types;
//说明
private String title;
//操作日期
private Date showDate;
//详细内容
private String remark;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}员工javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//员工
@Table(name = "t_employee")
public class Employee {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String employeeName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}公告javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//公告
@Table(name = "t_gg")
public class Gg {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//时间
private Date nowDate;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getNowDate() {return nowDate;}
public void setNowDate(Date nowDate) {this.nowDate = nowDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}离职javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//离职
@Table(name = "t_lz")
public class Lz {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//之前岗位
private String v1;
//操作日期
private Date showDate;
//离职原因
private String remark;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}普通管理员javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//普通管理员
@Table(name = "t_ptadmin")
public class Ptadmin {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String ptadminName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}培训人员javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//培训人员
@Table(name = "t_pxry")
public class Pxry {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String pxryName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String pic;
//培训目标
private String pxmb;
//培训标题
private String pxtitle;
//培训内容
private String pxcontent;
//培训日期
private Date pxDate;
//培训结果
private String status;
public String getPxryName() {return pxryName;}
public void setPxryName(String pxryName) {this.pxryName = pxryName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPxmb() {return pxmb;}
public void setPxmb(String pxmb) {this.pxmb = pxmb;}
public String getPxtitle() {return pxtitle;}
public void setPxtitle(String pxtitle) {this.pxtitle = pxtitle;}
public String getPxcontent() {return pxcontent;}
public void setPxcontent(String pxcontent) {this.pxcontent = pxcontent;}
public Date getPxDate() {return pxDate;}
public void setPxDate(Date pxDate) {this.pxDate = pxDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}调职javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//调职
@Table(name = "t_tz")
public class Tz {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//之前岗位
private String v1;
//调后岗位
private String v2;
//操作日期
private Date showDate;
//备注
private String remark;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}薪资福利javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//薪资福利
@Table(name = "t_xzfl")
public class Xzfl {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//基本工资
private Integer jbxz;
//福利
private Integer fl;
//最终工资
private Integer zzgz;
//开始时间
private Date beginDate;
//状态
private String status;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public Integer getJbxz() {return jbxz;}
public void setJbxz(Integer jbxz) {this.jbxz = jbxz;}
public Integer getFl() {return fl;}
public void setFl(Integer fl) {this.fl = fl;}
public Integer getZzgz() {return zzgz;}
public void setZzgz(Integer zzgz) {this.zzgz = zzgz;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}再教育javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//再教育
@Table(name = "t_zjy")
public class Zjy {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//再教育名称
private String title;
//操作日期
private Date beginDate;
//结束日期
private Date endDate;
//内容
private String remark;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}招聘人员javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//招聘人员
@Table(name = "t_zpry")
public class Zpry {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String zpryName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String pic;
//薪资要求
private String xzyq;
//目标岗位
private String mbgw;
//详细简历附件
private String fileUrl;
//状态
private String status;
public String getZpryName() {return zpryName;}
public void setZpryName(String zpryName) {this.zpryName = zpryName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getXzyq() {return xzyq;}
public void setXzyq(String xzyq) {this.xzyq = xzyq;}
public String getMbgw() {return mbgw;}
public void setMbgw(String mbgw) {this.mbgw = mbgw;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}基于Java的企业人力资源管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
惩罚奖励javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//惩罚奖励
public class Cfjl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//类型
private String types;
//说明
private String title;
//操作日期
private Date showDate;
//详细内容
private String remark;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}员工javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//员工
public class Employee extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String employeeName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//时间
private Date nowDate;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getNowDate() {return nowDate;}
public void setNowDate(Date nowDate) {this.nowDate = nowDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}离职javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//离职
public class Lz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//之前岗位
private String v1;
//操作日期
private Date showDate;
//离职原因
private String remark;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}普通管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//普通管理员
public class Ptadmin extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String ptadminName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}培训人员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//培训人员
public class Pxry extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String pxryName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String pic;
//培训目标
private String pxmb;
//培训标题
private String pxtitle;
//培训内容
private String pxcontent;
//培训日期
private Date pxDate;
//培训结果
private String status;
public String getPxryName() {return pxryName;}
public void setPxryName(String pxryName) {this.pxryName = pxryName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getPxmb() {return pxmb;}
public void setPxmb(String pxmb) {this.pxmb = pxmb;}
public String getPxtitle() {return pxtitle;}
public void setPxtitle(String pxtitle) {this.pxtitle = pxtitle;}
public String getPxcontent() {return pxcontent;}
public void setPxcontent(String pxcontent) {this.pxcontent = pxcontent;}
public Date getPxDate() {return pxDate;}
public void setPxDate(Date pxDate) {this.pxDate = pxDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}调职javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//调职
public class Tz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//之前岗位
private String v1;
//调后岗位
private String v2;
//操作日期
private Date showDate;
//备注
private String remark;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}薪资福利javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//薪资福利
public class Xzfl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//基本工资
private Integer jbxz;
//福利
private Integer fl;
//最终工资
private Integer zzgz;
//开始时间
private Date beginDate;
//状态
private String status;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public Integer getJbxz() {return jbxz;}
public void setJbxz(Integer jbxz) {this.jbxz = jbxz;}
public Integer getFl() {return fl;}
public void setFl(Integer fl) {this.fl = fl;}
public Integer getZzgz() {return zzgz;}
public void setZzgz(Integer zzgz) {this.zzgz = zzgz;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}再教育javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//再教育
public class Zjy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer employeeId;
//再教育名称
private String title;
//操作日期
private Date beginDate;
//结束日期
private Date endDate;
//内容
private String remark;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}招聘人员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//招聘人员
public class Zpry extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String zpryName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String pic;
//薪资要求
private String xzyq;
//目标岗位
private String mbgw;
//详细简历附件
private String fileUrl;
//状态
private String status;
public String getZpryName() {return zpryName;}
public void setZpryName(String zpryName) {this.zpryName = zpryName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getXzyq() {return xzyq;}
public void setXzyq(String xzyq) {this.xzyq = xzyq;}
public String getMbgw() {return mbgw;}
public void setMbgw(String mbgw) {this.mbgw = mbgw;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}