- 人力资源管理系统mysql数据库创建语句
- 人力资源管理系统oracle数据库创建语句
- 人力资源管理系统sqlserver数据库创建语句
- 人力资源管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 人力资源管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
人力资源管理系统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_bm(
id int primary key auto_increment comment '主键',
bmName varchar(100) comment '部门'
) comment '部门';
员工表创建语句如下:
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
pic varchar(100) comment '图片',
sex varchar(100) comment '性别',
zw varchar(100) comment '职位',
xl varchar(100) comment '学历',
bmId int comment '部门',
zzmm varchar(100) comment '政治面貌',
hybj varchar(100) comment '行业背景',
jstc varchar(100) comment '技术特长',
status varchar(100) comment '状态'
) comment '员工';
公告表创建语句如下:
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
cotnent varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
奖励惩罚表创建语句如下:
create table t_jlcf(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
types varchar(100) comment '奖励惩罚',
fee int comment '金额',
content varchar(100) comment '记录内容',
showDate varchar(100) comment '月份'
) comment '奖励惩罚';
公司事务表创建语句如下:
create table t_order(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
types varchar(100) comment '业务类型',
title varchar(100) comment '标题',
content varchar(100) comment '详细说明',
insertDate datetime comment '申请日期',
status varchar(100) comment '状态',
back varchar(100) comment '回复内容'
) comment '公司事务';
签到表创建语句如下:
create table t_qd(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
insertDate datetime comment '日期'
) comment '签到';
私人消息表创建语句如下:
create table t_xiaoxi(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
cotnent varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '私人消息';
薪资表创建语句如下:
create table t_xz(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
jbgz int comment '基本工资',
jl int comment '奖励金额',
cf int comment '惩罚金额',
zg int comment '月份',
showDate varchar(100) comment '月份'
) comment '薪资';
职位变动表创建语句如下:
create table t_zcbd(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
zcmc varchar(100) comment '职位名称',
showDate datetime 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_bm(
id integer,
bmName varchar(100)
);
--部门字段加注释
comment on column t_bm.id is '主键';
comment on column t_bm.bmName is '部门';
--部门表加注释
comment on table t_bm is '部门';
员工表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
pic varchar(100),
sex varchar(100),
zw varchar(100),
xl varchar(100),
bmId int,
zzmm varchar(100),
hybj varchar(100),
jstc varchar(100),
status 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.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.pic is '图片';
comment on column t_customer.sex is '性别';
comment on column t_customer.zw is '职位';
comment on column t_customer.xl is '学历';
comment on column t_customer.bmId is '部门';
comment on column t_customer.zzmm is '政治面貌';
comment on column t_customer.hybj is '行业背景';
comment on column t_customer.jstc is '技术特长';
comment on column t_customer.status is '状态';
--员工表加注释
comment on table t_customer is '员工';
公告表创建语句如下:
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
--公告字段加注释
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.cotnent is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
奖励惩罚表创建语句如下:
create table t_jlcf(
id integer,
customerId int,
types varchar(100),
fee int,
content varchar(100),
showDate varchar(100)
);
--奖励惩罚字段加注释
comment on column t_jlcf.id is '主键';
comment on column t_jlcf.customerId is '员工';
comment on column t_jlcf.types is '奖励惩罚';
comment on column t_jlcf.fee is '金额';
comment on column t_jlcf.content is '记录内容';
comment on column t_jlcf.showDate is '月份';
--奖励惩罚表加注释
comment on table t_jlcf is '奖励惩罚';
公司事务表创建语句如下:
create table t_order(
id integer,
customerId int,
types varchar(100),
title varchar(100),
content varchar(100),
insertDate datetime,
status varchar(100),
back varchar(100)
);
--公司事务字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '员工';
comment on column t_order.types is '业务类型';
comment on column t_order.title is '标题';
comment on column t_order.content is '详细说明';
comment on column t_order.insertDate is '申请日期';
comment on column t_order.status is '状态';
comment on column t_order.back is '回复内容';
--公司事务表加注释
comment on table t_order is '公司事务';
签到表创建语句如下:
create table t_qd(
id integer,
customerId int,
insertDate datetime
);
--签到字段加注释
comment on column t_qd.id is '主键';
comment on column t_qd.customerId is '员工';
comment on column t_qd.insertDate is '日期';
--签到表加注释
comment on table t_qd is '签到';
私人消息表创建语句如下:
create table t_xiaoxi(
id integer,
customerId int,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
insertDate datetime
);
--私人消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.customerId is '员工';
comment on column t_xiaoxi.title is '标题';
comment on column t_xiaoxi.pic is '图片';
comment on column t_xiaoxi.cotnent is '内容';
comment on column t_xiaoxi.insertDate is '日期';
--私人消息表加注释
comment on table t_xiaoxi is '私人消息';
薪资表创建语句如下:
create table t_xz(
id integer,
customerId int,
jbgz int,
jl int,
cf int,
zg int,
showDate varchar(100)
);
--薪资字段加注释
comment on column t_xz.id is '主键';
comment on column t_xz.customerId is '用户';
comment on column t_xz.jbgz is '基本工资';
comment on column t_xz.jl is '奖励金额';
comment on column t_xz.cf is '惩罚金额';
comment on column t_xz.zg is '月份';
comment on column t_xz.showDate is '月份';
--薪资表加注释
comment on table t_xz is '薪资';
职位变动表创建语句如下:
create table t_zcbd(
id integer,
customerId int,
zcmc varchar(100),
showDate datetime,
content varchar(100)
);
--职位变动字段加注释
comment on column t_zcbd.id is '主键';
comment on column t_zcbd.customerId is '员工';
comment on column t_zcbd.zcmc is '职位名称';
comment on column t_zcbd.showDate is '日期';
comment on column t_zcbd.content is '调动说明';
--职位变动表加注释
comment on table t_zcbd is '职位变动';
oracle特有,对应序列如下:
create sequence s_t_bm;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_jlcf;
create sequence s_t_order;
create sequence s_t_qd;
create sequence s_t_xiaoxi;
create sequence s_t_xz;
create sequence s_t_zcbd;
人力资源管理系统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_bm(
id int identity(1,1) primary key not null,--主键
bmName varchar(100)--部门
);
员工表创建语句如下:
--员工表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
pic varchar(100),--图片
sex varchar(100),--性别
zw varchar(100),--职位
xl varchar(100),--学历
bmId int,--部门
zzmm varchar(100),--政治面貌
hybj varchar(100),--行业背景
jstc varchar(100),--技术特长
status varchar(100)--状态
);
公告表创建语句如下:
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
cotnent varchar(100),--内容
showDate datetime--日期
);
奖励惩罚表创建语句如下:
--奖励惩罚表注释
create table t_jlcf(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
types varchar(100),--奖励惩罚
fee int,--金额
content varchar(100),--记录内容
showDate varchar(100)--月份
);
公司事务表创建语句如下:
--公司事务表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
types varchar(100),--业务类型
title varchar(100),--标题
content varchar(100),--详细说明
insertDate datetime,--申请日期
status varchar(100),--状态
back varchar(100)--回复内容
);
签到表创建语句如下:
--签到表注释
create table t_qd(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
insertDate datetime--日期
);
私人消息表创建语句如下:
--私人消息表注释
create table t_xiaoxi(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
title varchar(100),--标题
pic varchar(100),--图片
cotnent varchar(100),--内容
insertDate datetime--日期
);
薪资表创建语句如下:
--薪资表注释
create table t_xz(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
jbgz int,--基本工资
jl int,--奖励金额
cf int,--惩罚金额
zg int,--月份
showDate varchar(100)--月份
);
职位变动表创建语句如下:
--职位变动表注释
create table t_zcbd(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
zcmc varchar(100),--职位名称
showDate datetime,--日期
content varchar(100)--调动说明
);
人力资源管理系统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_bm")
public class Bm {
//主键
@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 bmName;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}
员工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 phone;
//年龄
private String age;
//图片
private String pic;
//性别
private String sex;
//职位
private String zw;
//学历
private String xl;
//部门
private Integer bmId;
//政治面貌
private String zzmm;
//行业背景
private String hybj;
//技术特长
private String jstc;
//状态
private String status;
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 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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
public String getZzmm() {return zzmm;}
public void setZzmm(String zzmm) {this.zzmm = zzmm;}
public String getHybj() {return hybj;}
public void setHybj(String hybj) {this.hybj = hybj;}
public String getJstc() {return jstc;}
public void setJstc(String jstc) {this.jstc = jstc;}
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_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 String cotnent;
//日期
private Date showDate;
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 String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
奖励惩罚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_jlcf")
public class Jlcf {
//主键
@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 Integer fee;
//记录内容
private String content;
//月份
private String showDate;
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 Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}
公司事务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_order")
public class Order {
//主键
@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 title;
//详细说明
private String content;
//申请日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
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 getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}
签到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_qd")
public class Qd {
//主键
@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 insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}
私人消息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_xiaoxi")
public class Xiaoxi {
//主键
@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 title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}
薪资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_xz")
public class Xz {
//主键
@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 Integer jbgz;
//奖励金额
private Integer jl;
//惩罚金额
private Integer cf;
//月份
private Integer zg;
//月份
private String showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJbgz() {return jbgz;}
public void setJbgz(Integer jbgz) {this.jbgz = jbgz;}
public Integer getJl() {return jl;}
public void setJl(Integer jl) {this.jl = jl;}
public Integer getCf() {return cf;}
public void setCf(Integer cf) {this.cf = cf;}
public Integer getZg() {return zg;}
public void setZg(Integer zg) {this.zg = zg;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}
职位变动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_zcbd")
public class Zcbd {
//主键
@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 zcmc;
//日期
private Date showDate;
//调动说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getZcmc() {return zcmc;}
public void setZcmc(String zcmc) {this.zcmc = zcmc;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date 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 Bm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private String bmName;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}
员工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 phone;
//年龄
private String age;
//图片
private String pic;
//性别
private String sex;
//职位
private String zw;
//学历
private String xl;
//部门
private Integer bmId;
//政治面貌
private String zzmm;
//行业背景
private String hybj;
//技术特长
private String jstc;
//状态
private String status;
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 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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
public String getZzmm() {return zzmm;}
public void setZzmm(String zzmm) {this.zzmm = zzmm;}
public String getHybj() {return hybj;}
public void setHybj(String hybj) {this.hybj = hybj;}
public String getJstc() {return jstc;}
public void setJstc(String jstc) {this.jstc = jstc;}
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 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 String cotnent;
//日期
private Date showDate;
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 String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
奖励惩罚javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//奖励惩罚
public class Jlcf 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 Integer fee;
//记录内容
private String content;
//月份
private String showDate;
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 Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}
公司事务javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公司事务
public class Order 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 title;
//详细说明
private String content;
//申请日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
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 getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}
签到javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//签到
public class Qd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}
私人消息javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//私人消息
public class Xiaoxi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//标题
private String title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}
薪资javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//薪资
public class Xz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//基本工资
private Integer jbgz;
//奖励金额
private Integer jl;
//惩罚金额
private Integer cf;
//月份
private Integer zg;
//月份
private String showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getJbgz() {return jbgz;}
public void setJbgz(Integer jbgz) {this.jbgz = jbgz;}
public Integer getJl() {return jl;}
public void setJl(Integer jl) {this.jl = jl;}
public Integer getCf() {return cf;}
public void setCf(Integer cf) {this.cf = cf;}
public Integer getZg() {return zg;}
public void setZg(Integer zg) {this.zg = zg;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}
职位变动javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//职位变动
public class Zcbd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//职位名称
private String zcmc;
//日期
private Date showDate;
//调动说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getZcmc() {return zcmc;}
public void setZcmc(String zcmc) {this.zcmc = zcmc;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}