- 办公自动化系统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_bgzy(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '资源名称',
pic varchar(100) comment '图片',
sl int comment '数量',
v3 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 '工号',
zw varchar(100) comment '职位',
bm varchar(100) comment '部门',
js varchar(100) 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_grjh(
id int primary key auto_increment comment '主键',
customerId int comment '人员',
title varchar(100) comment '标题',
showDate datetime comment '计划时间',
content varchar(100) comment '内容'
) comment '个人计划';
会议流程通知表创建语句如下：
create table t_hytz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
showDate datetime comment '时间',
content varchar(100) comment '内容',
ry varchar(100) comment '人员',
address varchar(100) comment '地址'
) comment '会议流程通知';
考勤打卡表创建语句如下：
create table t_kq(
id int primary key auto_increment comment '主键',
customerId int comment '人员',
insertDate datetime comment '打卡时间'
) comment '考勤打卡';
办公资源申请表创建语句如下：
create table t_order(
id int primary key auto_increment comment '主键',
customerId int comment '借用人',
content varchar(100) comment '借用说明',
insertDate datetime comment '申请日期',
bgzyId int comment '办公资源',
back varchar(100) comment '回复',
status varchar(100) comment '状态'
) comment '办公资源申请';
请假申请表创建语句如下：
create table t_qj(
id int primary key auto_increment comment '主键',
customerId int comment '借用人',
content varchar(100) comment '请假说明',
showDate datetime comment '请假日期',
back varchar(100) 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 '通知';
办公自动化系统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_bgzy(
id integer,
v1 varchar(100),
pic varchar(100),
sl int,
v3 varchar(100)
);
--办公资源字段加注释
comment on column t_bgzy.id is '主键';
comment on column t_bgzy.v1 is '资源名称';
comment on column t_bgzy.pic is '图片';
comment on column t_bgzy.sl is '数量';
comment on column t_bgzy.v3 is '说明内容';
--办公资源表加注释
comment on table t_bgzy 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),
zw varchar(100),
bm varchar(100),
js 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.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.zw is '职位';
comment on column t_customer.bm is '部门';
comment on column t_customer.js 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_grjh(
id integer,
customerId int,
title varchar(100),
showDate datetime,
content varchar(100)
);
--个人计划字段加注释
comment on column t_grjh.id is '主键';
comment on column t_grjh.customerId is '人员';
comment on column t_grjh.title is '标题';
comment on column t_grjh.showDate is '计划时间';
comment on column t_grjh.content is '内容';
--个人计划表加注释
comment on table t_grjh is '个人计划';
会议流程通知表创建语句如下：
create table t_hytz(
id integer,
title varchar(100),
showDate datetime,
content varchar(100),
ry varchar(100),
address varchar(100)
);
--会议流程通知字段加注释
comment on column t_hytz.id is '主键';
comment on column t_hytz.title is '标题';
comment on column t_hytz.showDate is '时间';
comment on column t_hytz.content is '内容';
comment on column t_hytz.ry is '人员';
comment on column t_hytz.address is '地址';
--会议流程通知表加注释
comment on table t_hytz is '会议流程通知';
考勤打卡表创建语句如下：
create table t_kq(
id integer,
customerId int,
insertDate datetime
);
--考勤打卡字段加注释
comment on column t_kq.id is '主键';
comment on column t_kq.customerId is '人员';
comment on column t_kq.insertDate is '打卡时间';
--考勤打卡表加注释
comment on table t_kq is '考勤打卡';
办公资源申请表创建语句如下：
create table t_order(
id integer,
customerId int,
content varchar(100),
insertDate datetime,
bgzyId int,
back varchar(100),
status varchar(100)
);
--办公资源申请字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '借用人';
comment on column t_order.content is '借用说明';
comment on column t_order.insertDate is '申请日期';
comment on column t_order.bgzyId is '办公资源';
comment on column t_order.back is '回复';
comment on column t_order.status is '状态';
--办公资源申请表加注释
comment on table t_order is '办公资源申请';
请假申请表创建语句如下：
create table t_qj(
id integer,
customerId int,
content varchar(100),
showDate datetime,
back varchar(100),
status varchar(100)
);
--请假申请字段加注释
comment on column t_qj.id is '主键';
comment on column t_qj.customerId is '借用人';
comment on column t_qj.content is '请假说明';
comment on column t_qj.showDate is '请假日期';
comment on column t_qj.back 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 '通知';
oracle特有，对应序列如下：
create sequence s_t_bgzy;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_grjh;
create sequence s_t_hytz;
create sequence s_t_kq;
create sequence s_t_order;
create sequence s_t_qj;
create sequence s_t_tongzhi;
办公自动化系统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_bgzy(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--资源名称
pic varchar(100),--图片
sl int,--数量
v3 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),--工号
zw varchar(100),--职位
bm varchar(100),--部门
js varchar(100),--角色
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_grjh(
id int identity(1,1) primary key not null,--主键
customerId int,--人员
title varchar(100),--标题
showDate datetime,--计划时间
content varchar(100)--内容
);
会议流程通知表创建语句如下：
--会议流程通知表注释
create table t_hytz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
showDate datetime,--时间
content varchar(100),--内容
ry varchar(100),--人员
address varchar(100)--地址
);
考勤打卡表创建语句如下：
--考勤打卡表注释
create table t_kq(
id int identity(1,1) primary key not null,--主键
customerId int,--人员
insertDate datetime--打卡时间
);
办公资源申请表创建语句如下：
--办公资源申请表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
customerId int,--借用人
content varchar(100),--借用说明
insertDate datetime,--申请日期
bgzyId int,--办公资源
back varchar(100),--回复
status varchar(100)--状态
);
请假申请表创建语句如下：
--请假申请表注释
create table t_qj(
id int identity(1,1) primary key not null,--主键
customerId int,--借用人
content varchar(100),--请假说明
showDate datetime,--请假日期
back varchar(100),--回复
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--日期
);
登录后主页.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_bgzy")
public class Bgzy {
//主键
@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 Integer sl;
//说明内容
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 Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
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_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 String zw;
//部门
private String bm;
//角色
private String js;
//状态
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 String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
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_grjh")
public class Grjh {
//主键
@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 Date showDate;
//内容
private String content;
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 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;}
}会议流程通知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_hytz")
public class Hytz {
//主键
@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 Date showDate;
//内容
private String content;
//人员
private String ry;
//地址
private String address;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getRy() {return ry;}
public void setRy(String ry) {this.ry = ry;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}考勤打卡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 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_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 content;
//申请日期
private Date insertDate;
//办公资源
private Integer bgzyId;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 Integer getBgzyId() {return bgzyId;}
public void setBgzyId(Integer bgzyId) {this.bgzyId = bgzyId;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_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 content;
//请假日期
private Date showDate;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 getBack() {return back;}
public void setBack(String back) {this.back = back;}
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;}
}办公自动化系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
办公资源javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//办公资源
public class Bgzy 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 Integer sl;
//说明内容
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 Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
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 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 String zw;
//部门
private String bm;
//角色
private String js;
//状态
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 String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
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 Grjh 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 Date showDate;
//内容
private String content;
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 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;}
}会议流程通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//会议流程通知
public class Hytz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//时间
private Date showDate;
//内容
private String content;
//人员
private String ry;
//地址
private String address;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getRy() {return ry;}
public void setRy(String ry) {this.ry = ry;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}考勤打卡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 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 Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//借用人
private Integer customerId;
//借用说明
private String content;
//申请日期
private Date insertDate;
//办公资源
private Integer bgzyId;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 Integer getBgzyId() {return bgzyId;}
public void setBgzyId(Integer bgzyId) {this.bgzyId = bgzyId;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Qj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//借用人
private Integer customerId;
//请假说明
private String content;
//请假日期
private Date showDate;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
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 getBack() {return back;}
public void setBack(String back) {this.back = back;}
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;}
}