- 基于SSM框架的人事管理系统mysql数据库创建语句
- 基于SSM框架的人事管理系统oracle数据库创建语句
- 基于SSM框架的人事管理系统sqlserver数据库创建语句
- 基于SSM框架的人事管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于SSM框架的人事管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于SSM框架的人事管理系统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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
gh varchar(100) comment '工号',
bmId int comment '部门',
status varchar(100) comment '状态'
) comment '员工';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
pic varchar(100) comment '图片',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
普通管理员表创建语句如下：
create table t_glyadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
glyadminName varchar(100) comment '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄'
) comment '普通管理员';
讨论平台表创建语句如下：
create table t_jiaoliu(
id int primary key auto_increment comment '主键',
fbr varchar(100) comment '发布人',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容'
) comment '讨论平台';
讨论平台记录表创建语句如下：
create table t_jiaoliulist(
id int primary key auto_increment comment '主键',
jiaoliuId int comment '交流平台',
hdrName varchar(100) comment '回答人',
insertDate datetime comment '日期',
content varchar(100) comment '内容'
) comment '讨论平台记录';
请假表创建语句如下：
create table t_qj(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '请假标题',
content varchar(100) comment '请假说明',
showDate datetime comment '请假日期',
status varchar(100) comment '状态'
) comment '请假';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
txName varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '通知';
薪资表创建语句如下：
create table t_xz(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
jbgz int comment '基本工资',
qjkc int comment '请假扣除',
jggz int comment '加班工资',
zj int comment '最终工资',
yf varchar(100) comment '月份'
) comment '薪资';
基于SSM框架的人事管理系统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),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
gh varchar(100),
bmId int,
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.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.gh is '工号';
comment on column t_customer.bmId is '部门';
comment on column t_customer.status is '状态';
--员工表加注释
comment on table t_customer is '员工';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
pic varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
普通管理员表创建语句如下：
create table t_glyadmin(
id integer,
username varchar(100),
password varchar(100),
glyadminName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100)
);
--普通管理员字段加注释
comment on column t_glyadmin.id is '主键';
comment on column t_glyadmin.username is '账号';
comment on column t_glyadmin.password is '密码';
comment on column t_glyadmin.glyadminName is '姓名';
comment on column t_glyadmin.headPic is '头像';
comment on column t_glyadmin.phone is '电话';
comment on column t_glyadmin.age is '年龄';
--普通管理员表加注释
comment on table t_glyadmin is '普通管理员';
讨论平台表创建语句如下：
create table t_jiaoliu(
id integer,
fbr varchar(100),
title varchar(100),
pic varchar(100),
content varchar(100)
);
--讨论平台字段加注释
comment on column t_jiaoliu.id is '主键';
comment on column t_jiaoliu.fbr is '发布人';
comment on column t_jiaoliu.title is '标题';
comment on column t_jiaoliu.pic is '图片';
comment on column t_jiaoliu.content is '内容';
--讨论平台表加注释
comment on table t_jiaoliu is '讨论平台';
讨论平台记录表创建语句如下：
create table t_jiaoliulist(
id integer,
jiaoliuId int,
hdrName varchar(100),
insertDate datetime,
content varchar(100)
);
--讨论平台记录字段加注释
comment on column t_jiaoliulist.id is '主键';
comment on column t_jiaoliulist.jiaoliuId is '交流平台';
comment on column t_jiaoliulist.hdrName is '回答人';
comment on column t_jiaoliulist.insertDate is '日期';
comment on column t_jiaoliulist.content is '内容';
--讨论平台记录表加注释
comment on table t_jiaoliulist is '讨论平台记录';
请假表创建语句如下：
create table t_qj(
id integer,
customerId int,
title varchar(100),
content varchar(100),
showDate datetime,
status varchar(100)
);
--请假字段加注释
comment on column t_qj.id is '主键';
comment on column t_qj.customerId is '用户';
comment on column t_qj.title is '请假标题';
comment on column t_qj.content is '请假说明';
comment on column t_qj.showDate is '请假日期';
comment on column t_qj.status is '状态';
--请假表加注释
comment on table t_qj is '请假';
通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
txName varchar(100),
content varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.txName is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi is '通知';
薪资表创建语句如下：
create table t_xz(
id integer,
customerId int,
jbgz int,
qjkc int,
jggz int,
zj int,
yf 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.qjkc is '请假扣除';
comment on column t_xz.jggz is '加班工资';
comment on column t_xz.zj is '最终工资';
comment on column t_xz.yf is '月份';
--薪资表加注释
comment on table t_xz is '薪资';
oracle特有，对应序列如下：
create sequence s_t_bm;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_glyadmin;
create sequence s_t_jiaoliu;
create sequence s_t_jiaoliulist;
create sequence s_t_qj;
create sequence s_t_tongzhi;
create sequence s_t_xz;
基于SSM框架的人事管理系统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),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
gh varchar(100),--工号
bmId int,--部门
status varchar(100)--状态
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
pic varchar(100),--图片
showDate datetime,--日期
v3 varchar(100)--内容
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_glyadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
glyadminName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100)--年龄
);
讨论平台表创建语句如下：
--讨论平台表注释
create table t_jiaoliu(
id int identity(1,1) primary key not null,--主键
fbr varchar(100),--发布人
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100)--内容
);
讨论平台记录表创建语句如下：
--讨论平台记录表注释
create table t_jiaoliulist(
id int identity(1,1) primary key not null,--主键
jiaoliuId int,--交流平台
hdrName varchar(100),--回答人
insertDate datetime,--日期
content varchar(100)--内容
);
请假表创建语句如下：
--请假表注释
create table t_qj(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--请假标题
content varchar(100),--请假说明
showDate datetime,--请假日期
status varchar(100)--状态
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
txName varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
薪资表创建语句如下：
--薪资表注释
create table t_xz(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
jbgz int,--基本工资
qjkc int,--请假扣除
jggz int,--加班工资
zj int,--最终工资
yf varchar(100)--月份
);
登录后主页.jpg?x-oss-process=style/00001)
基于SSM框架的人事管理系统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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//工号
private String gh;
//部门
private Integer bmId;
//状态
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
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 v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}普通管理员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_glyadmin")
public class Glyadmin {
//主键
@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 glyadminName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
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 getGlyadminName() {return glyadminName;}
public void setGlyadminName(String glyadminName) {this.glyadminName = glyadminName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
}讨论平台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_jiaoliu")
public class Jiaoliu {
//主键
@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 fbr;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public String getFbr() {return fbr;}
public void setFbr(String fbr) {this.fbr = fbr;}
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 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_jiaoliulist")
public class Jiaoliulist {
//主键
@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 jiaoliuId;
//回答人
private String hdrName;
//日期
private Date insertDate;
//内容
private String content;
public Integer getJiaoliuId() {return jiaoliuId;}
public void setJiaoliuId(Integer jiaoliuId) {this.jiaoliuId = jiaoliuId;}
public String getHdrName() {return hdrName;}
public void setHdrName(String hdrName) {this.hdrName = hdrName;}
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;}
}请假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_qj")
public class Qj {
//主键
@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 content;
//请假日期
private Date showDate;
//状态
private String status;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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_tongzhi")
public class Tongzhi {
//主键
@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 txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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;}
}薪资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 qjkc;
//加班工资
private Integer jggz;
//最终工资
private Integer zj;
//月份
private String yf;
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 getQjkc() {return qjkc;}
public void setQjkc(Integer qjkc) {this.qjkc = qjkc;}
public Integer getJggz() {return jggz;}
public void setJggz(Integer jggz) {this.jggz = jggz;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
}基于SSM框架的人事管理系统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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//工号
private String gh;
//部门
private Integer bmId;
//状态
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
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 v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}普通管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//普通管理员
public class Glyadmin 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 glyadminName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
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 getGlyadminName() {return glyadminName;}
public void setGlyadminName(String glyadminName) {this.glyadminName = glyadminName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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;}
}讨论平台javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//讨论平台
public class Jiaoliu extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发布人
private String fbr;
//标题
private String title;
//图片
private String pic;
//内容
private String content;
public String getFbr() {return fbr;}
public void setFbr(String fbr) {this.fbr = fbr;}
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 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 Jiaoliulist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//交流平台
private Integer jiaoliuId;
//回答人
private String hdrName;
//日期
private Date insertDate;
//内容
private String content;
public Integer getJiaoliuId() {return jiaoliuId;}
public void setJiaoliuId(Integer jiaoliuId) {this.jiaoliuId = jiaoliuId;}
public String getHdrName() {return hdrName;}
public void setHdrName(String hdrName) {this.hdrName = hdrName;}
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;}
}请假javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//请假
public class Qj 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 content;
//请假日期
private Date showDate;
//状态
private String status;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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;}
}薪资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 qjkc;
//加班工资
private Integer jggz;
//最终工资
private Integer zj;
//月份
private String yf;
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 getQjkc() {return qjkc;}
public void setQjkc(Integer qjkc) {this.qjkc = qjkc;}
public Integer getJggz() {return jggz;}
public void setJggz(Integer jggz) {this.jggz = jggz;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
}