- 企业人事管理系统mysql数据库创建语句
- 企业人事管理系统oracle数据库创建语句
- 企业人事管理系统sqlserver数据库创建语句
- 企业人事管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 企业人事管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
企业人事管理系统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_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
bh varchar(100) comment '编号',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
cs varchar(100) comment '出生',
xl varchar(100) comment '学历',
sfhy varchar(100) comment '是否婚姻',
phone varchar(100) comment '电话',
address varchar(100) comment '住址',
jtlxr varchar(100) comment '家庭联系人信息',
rzsj varchar(100) comment '入职时间',
deptId int comment '部门',
isfzr varchar(100) comment '是否部门负责人'
) comment '员工';
部门表创建语句如下：
create table t_dept(
id int primary key auto_increment comment '主键',
deptName varchar(100) comment '部门名称',
v1 varchar(100) comment '部门编号',
v2 varchar(100) comment '部门级别',
v3 varchar(100) comment '部门职能',
pDeptId int comment '父级部门'
) comment '部门';
工资表创建语句如下：
create table t_gz(
id int primary key auto_increment comment '主键',
customerId int comment '人员',
v1 varchar(100) comment '基本工资',
v2 varchar(100) comment '浮动工资',
v3 varchar(100) comment '加班工资',
v4 varchar(100) comment '工资合计',
v5 varchar(100) comment '备注'
) comment '工资';
员工考核表创建语句如下：
create table t_gzkh(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
v1 varchar(100) comment '考核说明',
khyf varchar(100) comment '考核月份',
content varchar(100) comment '考核说明',
remark varchar(100) comment '考核评价'
) comment '员工考核';
工资日志表创建语句如下：
create table t_gzrz(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
showDate datetime comment '日期',
v1 varchar(100) comment '标题',
fee int comment '金额'
) comment '工资日志';
打卡表创建语句如下：
create table t_kq(
id int primary key auto_increment comment '主键',
customerId int comment '人员',
v1 varchar(100) comment '打卡属性',
inseretDate datetime comment '部门编号',
v2 varchar(100) comment '备注'
) comment '打卡';
劳动合同表创建语句如下：
create table t_ldht(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
qdrq datetime comment '签订日期',
htqx varchar(100) comment '合同期限',
endDate datetime comment '到期日期',
v2 varchar(100) comment '合同备注',
v3 varchar(100) comment '合同附件',
v4 varchar(100) comment '合同编号'
) comment '劳动合同';
离职入职表创建语句如下：
create table t_lzrz(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
types varchar(100) comment '类型',
showDate varchar(100) comment '日期',
content varchar(100) comment '说明'
) comment '离职入职';
员工报销表创建语句如下：
create table t_ygbx(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
v1 varchar(100) comment '报销标题',
fee int comment '报销金额',
fp varchar(100) comment '发票图片',
insertDate datetime comment '发起日期',
content varchar(100) comment '报销说明',
status varchar(100) comment '状态'
) comment '员工报销';
员工调动表创建语句如下：
create table t_ygdd(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
showDate varchar(100) comment '调动日期',
v1 varchar(100) comment '原来职位',
v2 varchar(100) comment '原来部门',
v3 varchar(100) comment '现在职位',
v4 varchar(100) comment '现在部门',
content varchar(100) comment '调动说明'
) comment '员工调动';
员工转正表创建语句如下：
create table t_ygzz(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
showDate varchar(100) comment '日期',
content varchar(100) comment '转正说明'
) comment '员工转正';
企业人事管理系统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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
bh varchar(100),
age varchar(100),
sex varchar(100),
cs varchar(100),
xl varchar(100),
sfhy varchar(100),
phone varchar(100),
address varchar(100),
jtlxr varchar(100),
rzsj varchar(100),
deptId int,
isfzr varchar(100)
);
--员工字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.bh is '编号';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.cs is '出生';
comment on column t_customer.xl is '学历';
comment on column t_customer.sfhy is '是否婚姻';
comment on column t_customer.phone is '电话';
comment on column t_customer.address is '住址';
comment on column t_customer.jtlxr is '家庭联系人信息';
comment on column t_customer.rzsj is '入职时间';
comment on column t_customer.deptId is '部门';
comment on column t_customer.isfzr is '是否部门负责人';
--员工表加注释
comment on table t_customer is '员工';
部门表创建语句如下：
create table t_dept(
id integer,
deptName varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
pDeptId int
);
--部门字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '部门名称';
comment on column t_dept.v1 is '部门编号';
comment on column t_dept.v2 is '部门级别';
comment on column t_dept.v3 is '部门职能';
comment on column t_dept.pDeptId is '父级部门';
--部门表加注释
comment on table t_dept is '部门';
工资表创建语句如下：
create table t_gz(
id integer,
customerId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--工资字段加注释
comment on column t_gz.id is '主键';
comment on column t_gz.customerId is '人员';
comment on column t_gz.v1 is '基本工资';
comment on column t_gz.v2 is '浮动工资';
comment on column t_gz.v3 is '加班工资';
comment on column t_gz.v4 is '工资合计';
comment on column t_gz.v5 is '备注';
--工资表加注释
comment on table t_gz is '工资';
员工考核表创建语句如下：
create table t_gzkh(
id integer,
customerId int,
v1 varchar(100),
khyf varchar(100),
content varchar(100),
remark varchar(100)
);
--员工考核字段加注释
comment on column t_gzkh.id is '主键';
comment on column t_gzkh.customerId is '员工';
comment on column t_gzkh.v1 is '考核说明';
comment on column t_gzkh.khyf is '考核月份';
comment on column t_gzkh.content is '考核说明';
comment on column t_gzkh.remark is '考核评价';
--员工考核表加注释
comment on table t_gzkh is '员工考核';
工资日志表创建语句如下：
create table t_gzrz(
id integer,
customerId int,
showDate datetime,
v1 varchar(100),
fee int
);
--工资日志字段加注释
comment on column t_gzrz.id is '主键';
comment on column t_gzrz.customerId is '员工';
comment on column t_gzrz.showDate is '日期';
comment on column t_gzrz.v1 is '标题';
comment on column t_gzrz.fee is '金额';
--工资日志表加注释
comment on table t_gzrz is '工资日志';
打卡表创建语句如下：
create table t_kq(
id integer,
customerId int,
v1 varchar(100),
inseretDate datetime,
v2 varchar(100)
);
--打卡字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.customerId is '人员';
comment on column t_kq.v1 is '打卡属性';
comment on column t_kq.inseretDate is '部门编号';
comment on column t_kq.v2 is '备注';
--打卡表加注释
comment on table t_kq is '打卡';
劳动合同表创建语句如下：
create table t_ldht(
id integer,
customerId int,
qdrq datetime,
htqx varchar(100),
endDate datetime,
v2 varchar(100),
v3 varchar(100),
v4 varchar(100)
);
--劳动合同字段加注释
comment on column t_ldht.id is '主键';
comment on column t_ldht.customerId is '员工';
comment on column t_ldht.qdrq is '签订日期';
comment on column t_ldht.htqx is '合同期限';
comment on column t_ldht.endDate is '到期日期';
comment on column t_ldht.v2 is '合同备注';
comment on column t_ldht.v3 is '合同附件';
comment on column t_ldht.v4 is '合同编号';
--劳动合同表加注释
comment on table t_ldht is '劳动合同';
离职入职表创建语句如下：
create table t_lzrz(
id integer,
customerId int,
types varchar(100),
showDate varchar(100),
content varchar(100)
);
--离职入职字段加注释
comment on column t_lzrz.id is '主键';
comment on column t_lzrz.customerId is '员工';
comment on column t_lzrz.types is '类型';
comment on column t_lzrz.showDate is '日期';
comment on column t_lzrz.content is '说明';
--离职入职表加注释
comment on table t_lzrz is '离职入职';
员工报销表创建语句如下：
create table t_ygbx(
id integer,
customerId int,
v1 varchar(100),
fee int,
fp varchar(100),
insertDate datetime,
content varchar(100),
status varchar(100)
);
--员工报销字段加注释
comment on column t_ygbx.id is '主键';
comment on column t_ygbx.customerId is '员工';
comment on column t_ygbx.v1 is '报销标题';
comment on column t_ygbx.fee is '报销金额';
comment on column t_ygbx.fp is '发票图片';
comment on column t_ygbx.insertDate is '发起日期';
comment on column t_ygbx.content is '报销说明';
comment on column t_ygbx.status is '状态';
--员工报销表加注释
comment on table t_ygbx is '员工报销';
员工调动表创建语句如下：
create table t_ygdd(
id integer,
customerId int,
showDate varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
content varchar(100)
);
--员工调动字段加注释
comment on column t_ygdd.id is '主键';
comment on column t_ygdd.customerId is '员工';
comment on column t_ygdd.showDate is '调动日期';
comment on column t_ygdd.v1 is '原来职位';
comment on column t_ygdd.v2 is '原来部门';
comment on column t_ygdd.v3 is '现在职位';
comment on column t_ygdd.v4 is '现在部门';
comment on column t_ygdd.content is '调动说明';
--员工调动表加注释
comment on table t_ygdd is '员工调动';
员工转正表创建语句如下：
create table t_ygzz(
id integer,
customerId int,
showDate varchar(100),
content varchar(100)
);
--员工转正字段加注释
comment on column t_ygzz.id is '主键';
comment on column t_ygzz.customerId is '员工';
comment on column t_ygzz.showDate is '日期';
comment on column t_ygzz.content is '转正说明';
--员工转正表加注释
comment on table t_ygzz is '员工转正';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_dept;
create sequence s_t_gz;
create sequence s_t_gzkh;
create sequence s_t_gzrz;
create sequence s_t_kq;
create sequence s_t_ldht;
create sequence s_t_lzrz;
create sequence s_t_ygbx;
create sequence s_t_ygdd;
create sequence s_t_ygzz;
企业人事管理系统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_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
bh varchar(100),--编号
age varchar(100),--年龄
sex varchar(100),--性别
cs varchar(100),--出生
xl varchar(100),--学历
sfhy varchar(100),--是否婚姻
phone varchar(100),--电话
address varchar(100),--住址
jtlxr varchar(100),--家庭联系人信息
rzsj varchar(100),--入职时间
deptId int,--部门
isfzr varchar(100)--是否部门负责人
);
部门表创建语句如下：
--部门表注释
create table t_dept(
id int identity(1,1) primary key not null,--主键
deptName varchar(100),--部门名称
v1 varchar(100),--部门编号
v2 varchar(100),--部门级别
v3 varchar(100),--部门职能
pDeptId int--父级部门
);
工资表创建语句如下：
--工资表注释
create table t_gz(
id int identity(1,1) primary key not null,--主键
customerId int,--人员
v1 varchar(100),--基本工资
v2 varchar(100),--浮动工资
v3 varchar(100),--加班工资
v4 varchar(100),--工资合计
v5 varchar(100)--备注
);
员工考核表创建语句如下：
--员工考核表注释
create table t_gzkh(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
v1 varchar(100),--考核说明
khyf varchar(100),--考核月份
content varchar(100),--考核说明
remark varchar(100)--考核评价
);
工资日志表创建语句如下：
--工资日志表注释
create table t_gzrz(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
showDate datetime,--日期
v1 varchar(100),--标题
fee int--金额
);
打卡表创建语句如下：
--打卡表注释
create table t_kq(
id int identity(1,1) primary key not null,--主键
customerId int,--人员
v1 varchar(100),--打卡属性
inseretDate datetime,--部门编号
v2 varchar(100)--备注
);
劳动合同表创建语句如下：
--劳动合同表注释
create table t_ldht(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
qdrq datetime,--签订日期
htqx varchar(100),--合同期限
endDate datetime,--到期日期
v2 varchar(100),--合同备注
v3 varchar(100),--合同附件
v4 varchar(100)--合同编号
);
离职入职表创建语句如下：
--离职入职表注释
create table t_lzrz(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
types varchar(100),--类型
showDate varchar(100),--日期
content varchar(100)--说明
);
员工报销表创建语句如下：
--员工报销表注释
create table t_ygbx(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
v1 varchar(100),--报销标题
fee int,--报销金额
fp varchar(100),--发票图片
insertDate datetime,--发起日期
content varchar(100),--报销说明
status varchar(100)--状态
);
员工调动表创建语句如下：
--员工调动表注释
create table t_ygdd(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
showDate varchar(100),--调动日期
v1 varchar(100),--原来职位
v2 varchar(100),--原来部门
v3 varchar(100),--现在职位
v4 varchar(100),--现在部门
content varchar(100)--调动说明
);
员工转正表创建语句如下：
--员工转正表注释
create table t_ygzz(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
showDate varchar(100),--日期
content varchar(100)--转正说明
);
登录后主页.jpg?x-oss-process=style/00001)
企业人事管理系统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_customer")
public class Customer {
//主键
@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 customerName;
//编号
private String bh;
//年龄
private String age;
//性别
private String sex;
//出生
private String cs;
//学历
private String xl;
//是否婚姻
private String sfhy;
//电话
private String phone;
//住址
private String address;
//家庭联系人信息
private String jtlxr;
//入职时间
private String rzsj;
//部门
private Integer deptId;
//是否部门负责人
private String isfzr;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
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 getCs() {return cs;}
public void setCs(String cs) {this.cs = cs;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getSfhy() {return sfhy;}
public void setSfhy(String sfhy) {this.sfhy = sfhy;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJtlxr() {return jtlxr;}
public void setJtlxr(String jtlxr) {this.jtlxr = jtlxr;}
public String getRzsj() {return rzsj;}
public void setRzsj(String rzsj) {this.rzsj = rzsj;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getIsfzr() {return isfzr;}
public void setIsfzr(String isfzr) {this.isfzr = isfzr;}
}部门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_dept")
public class Dept {
//主键
@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 deptName;
//部门编号
private String v1;
//部门级别
private String v2;
//部门职能
private String v3;
//父级部门
private Integer pDeptId;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getPDeptId() {return pDeptId;}
public void setPDeptId(Integer pDeptId) {this.pDeptId = pDeptId;}
}工资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_gz")
public class Gz {
//主键
@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 customerId;
//基本工资
private String v1;
//浮动工资
private String v2;
//加班工资
private String v3;
//工资合计
private String v4;
//备注
private String v5;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}员工考核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_gzkh")
public class Gzkh {
//主键
@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 customerId;
//考核说明
private String v1;
//考核月份
private String khyf;
//考核说明
private String content;
//考核评价
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getKhyf() {return khyf;}
public void setKhyf(String khyf) {this.khyf = khyf;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_gzrz")
public class Gzrz {
//主键
@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 customerId;
//日期
private Date showDate;
//标题
private String v1;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}打卡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_kq")
public class Kq {
//主键
@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 customerId;
//打卡属性
private String v1;
//部门编号
private Date inseretDate;
//备注
private String v2;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getInseretDate() {return inseretDate;}
public void setInseretDate(Date inseretDate) {this.inseretDate = inseretDate;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}劳动合同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_ldht")
public class Ldht {
//主键
@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 customerId;
//签订日期
private Date qdrq;
//合同期限
private String htqx;
//到期日期
private Date endDate;
//合同备注
private String v2;
//合同附件
private String v3;
//合同编号
private String v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getQdrq() {return qdrq;}
public void setQdrq(Date qdrq) {this.qdrq = qdrq;}
public String getHtqx() {return htqx;}
public void setHtqx(String htqx) {this.htqx = htqx;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
}离职入职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_lzrz")
public class Lzrz {
//主键
@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 customerId;
//类型
private String types;
//日期
private String showDate;
//说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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_ygbx")
public class Ygbx {
//主键
@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 customerId;
//报销标题
private String v1;
//报销金额
private Integer fee;
//发票图片
private String fp;
//发起日期
private Date insertDate;
//报销说明
private String content;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getFp() {return fp;}
public void setFp(String fp) {this.fp = fp;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_ygdd")
public class Ygdd {
//主键
@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 customerId;
//调动日期
private String showDate;
//原来职位
private String v1;
//原来部门
private String v2;
//现在职位
private String v3;
//现在部门
private String v4;
//调动说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
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_ygzz")
public class Ygzz {
//主键
@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 customerId;
//日期
private String showDate;
//转正说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}企业人事管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
员工javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//员工
public class Customer 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 customerName;
//编号
private String bh;
//年龄
private String age;
//性别
private String sex;
//出生
private String cs;
//学历
private String xl;
//是否婚姻
private String sfhy;
//电话
private String phone;
//住址
private String address;
//家庭联系人信息
private String jtlxr;
//入职时间
private String rzsj;
//部门
private Integer deptId;
//是否部门负责人
private String isfzr;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
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 getCs() {return cs;}
public void setCs(String cs) {this.cs = cs;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getSfhy() {return sfhy;}
public void setSfhy(String sfhy) {this.sfhy = sfhy;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJtlxr() {return jtlxr;}
public void setJtlxr(String jtlxr) {this.jtlxr = jtlxr;}
public String getRzsj() {return rzsj;}
public void setRzsj(String rzsj) {this.rzsj = rzsj;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getIsfzr() {return isfzr;}
public void setIsfzr(String isfzr) {this.isfzr = isfzr;}
}部门javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//部门
public class Dept extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门名称
private String deptName;
//部门编号
private String v1;
//部门级别
private String v2;
//部门职能
private String v3;
//父级部门
private Integer pDeptId;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getPDeptId() {return pDeptId;}
public void setPDeptId(Integer pDeptId) {this.pDeptId = pDeptId;}
}工资javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//工资
public class Gz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员
private Integer customerId;
//基本工资
private String v1;
//浮动工资
private String v2;
//加班工资
private String v3;
//工资合计
private String v4;
//备注
private String v5;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
}员工考核javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//员工考核
public class Gzkh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//考核说明
private String v1;
//考核月份
private String khyf;
//考核说明
private String content;
//考核评价
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getKhyf() {return khyf;}
public void setKhyf(String khyf) {this.khyf = khyf;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Gzrz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//日期
private Date showDate;
//标题
private String v1;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}打卡javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//打卡
public class Kq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员
private Integer customerId;
//打卡属性
private String v1;
//部门编号
private Date inseretDate;
//备注
private String v2;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getInseretDate() {return inseretDate;}
public void setInseretDate(Date inseretDate) {this.inseretDate = inseretDate;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}劳动合同javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//劳动合同
public class Ldht extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//签订日期
private Date qdrq;
//合同期限
private String htqx;
//到期日期
private Date endDate;
//合同备注
private String v2;
//合同附件
private String v3;
//合同编号
private String v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getQdrq() {return qdrq;}
public void setQdrq(Date qdrq) {this.qdrq = qdrq;}
public String getHtqx() {return htqx;}
public void setHtqx(String htqx) {this.htqx = htqx;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
}离职入职javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//离职入职
public class Lzrz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//类型
private String types;
//日期
private String showDate;
//说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 Ygbx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//报销标题
private String v1;
//报销金额
private Integer fee;
//发票图片
private String fp;
//发起日期
private Date insertDate;
//报销说明
private String content;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getFp() {return fp;}
public void setFp(String fp) {this.fp = fp;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Ygdd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//调动日期
private String showDate;
//原来职位
private String v1;
//原来部门
private String v2;
//现在职位
private String v3;
//现在部门
private String v4;
//调动说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
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 String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
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 Ygzz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//日期
private String showDate;
//转正说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}