- 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_bgsyp(
id int primary key auto_increment comment '主键',
title varchar(100) comment '用品名称',
pic varchar(100) comment '图片',
nums int comment '数量',
types varchar(100) comment '出库、入库',
showDate datetime comment '日期',
lyr varchar(100) comment '领用人'
) comment '办公室用品';
车辆管理表创建语句如下：
create table t_clgl(
id int primary key auto_increment comment '主键',
title varchar(100) comment '车辆牌照',
clName varchar(100) comment '车辆型号',
pic varchar(100) comment '图片',
showDate datetime comment '申请日期',
lyr varchar(100) comment '申请人',
sqly varchar(100) comment '申请理由',
mdd 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 '姓名',
gh varchar(100) comment '工号',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
email varchar(100) comment '邮箱',
isYx varchar(100) comment '是否优秀员工'
) comment '员工';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
会议记录表创建语句如下：
create table t_hyjl(
id int primary key auto_increment comment '主键',
title varchar(100) comment '会议名称',
showDate datetime comment '日期',
fileUrl varchar(100) comment '记录文档',
content varchar(100) comment '会议内容'
) comment '会议记录';
内部邮件表创建语句如下：
create table t_nbyj(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
title varchar(100) comment '标题',
cotnent varchar(100) comment '内容',
fj varchar(100) comment '附件',
insertDate datetime comment '日期',
status varchar(100) comment '状态'
) comment '内部邮件';
请假表创建语句如下：
create table t_qj(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
types varchar(100) comment '类型',
title varchar(100) comment '标题',
cotnent varchar(100) comment '请假理由',
showDate varchar(100) comment '请假日期',
status varchar(100) comment '状态'
) comment '请假';
文档表创建语句如下：
create table t_wd(
id int primary key auto_increment comment '主键',
title varchar(100) comment '文档名称',
fileUrl varchar(100) comment '文档',
bz varchar(100) comment '备注'
) comment '文档';
意见箱表创建语句如下：
create table t_yjx(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
yj varchar(100) comment '意见',
insertDate datetime 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_bgsyp(
id integer,
title varchar(100),
pic varchar(100),
nums int,
types varchar(100),
showDate datetime,
lyr varchar(100)
);
--办公室用品字段加注释
comment on column t_bgsyp.id is '主键';
comment on column t_bgsyp.title is '用品名称';
comment on column t_bgsyp.pic is '图片';
comment on column t_bgsyp.nums is '数量';
comment on column t_bgsyp.types is '出库、入库';
comment on column t_bgsyp.showDate is '日期';
comment on column t_bgsyp.lyr is '领用人';
--办公室用品表加注释
comment on table t_bgsyp is '办公室用品';
车辆管理表创建语句如下：
create table t_clgl(
id integer,
title varchar(100),
clName varchar(100),
pic varchar(100),
showDate datetime,
lyr varchar(100),
sqly varchar(100),
mdd varchar(100)
);
--车辆管理字段加注释
comment on column t_clgl.id is '主键';
comment on column t_clgl.title is '车辆牌照';
comment on column t_clgl.clName is '车辆型号';
comment on column t_clgl.pic is '图片';
comment on column t_clgl.showDate is '申请日期';
comment on column t_clgl.lyr is '申请人';
comment on column t_clgl.sqly is '申请理由';
comment on column t_clgl.mdd is '目的地';
--车辆管理表加注释
comment on table t_clgl is '车辆管理';
员工表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
gh varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
email varchar(100),
isYx 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.gh is '工号';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.email is '邮箱';
comment on column t_customer.isYx is '是否优秀员工';
--员工表加注释
comment on table t_customer is '员工';
公告表创建语句如下：
create table t_gg(
id integer,
title varchar(100),
pic varchar(100),
content 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.content is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
会议记录表创建语句如下：
create table t_hyjl(
id integer,
title varchar(100),
showDate datetime,
fileUrl varchar(100),
content varchar(100)
);
--会议记录字段加注释
comment on column t_hyjl.id is '主键';
comment on column t_hyjl.title is '会议名称';
comment on column t_hyjl.showDate is '日期';
comment on column t_hyjl.fileUrl is '记录文档';
comment on column t_hyjl.content is '会议内容';
--会议记录表加注释
comment on table t_hyjl is '会议记录';
内部邮件表创建语句如下：
create table t_nbyj(
id integer,
customerId int,
title varchar(100),
cotnent varchar(100),
fj varchar(100),
insertDate datetime,
status varchar(100)
);
--内部邮件字段加注释
comment on column t_nbyj.id is '主键';
comment on column t_nbyj.customerId is '员工';
comment on column t_nbyj.title is '标题';
comment on column t_nbyj.cotnent is '内容';
comment on column t_nbyj.fj is '附件';
comment on column t_nbyj.insertDate is '日期';
comment on column t_nbyj.status is '状态';
--内部邮件表加注释
comment on table t_nbyj is '内部邮件';
请假表创建语句如下：
create table t_qj(
id integer,
customerId int,
types varchar(100),
title varchar(100),
cotnent varchar(100),
showDate varchar(100),
status varchar(100)
);
--请假字段加注释
comment on column t_qj.id is '主键';
comment on column t_qj.customerId is '员工';
comment on column t_qj.types is '类型';
comment on column t_qj.title is '标题';
comment on column t_qj.cotnent is '请假理由';
comment on column t_qj.showDate is '请假日期';
comment on column t_qj.status is '状态';
--请假表加注释
comment on table t_qj is '请假';
文档表创建语句如下：
create table t_wd(
id integer,
title varchar(100),
fileUrl varchar(100),
bz varchar(100)
);
--文档字段加注释
comment on column t_wd.id is '主键';
comment on column t_wd.title is '文档名称';
comment on column t_wd.fileUrl is '文档';
comment on column t_wd.bz is '备注';
--文档表加注释
comment on table t_wd is '文档';
意见箱表创建语句如下：
create table t_yjx(
id integer,
customerId int,
yj varchar(100),
insertDate datetime
);
--意见箱字段加注释
comment on column t_yjx.id is '主键';
comment on column t_yjx.customerId is '员工';
comment on column t_yjx.yj is '意见';
comment on column t_yjx.insertDate is '日期';
--意见箱表加注释
comment on table t_yjx is '意见箱';
oracle特有，对应序列如下：
create sequence s_t_bgsyp;
create sequence s_t_clgl;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_hyjl;
create sequence s_t_nbyj;
create sequence s_t_qj;
create sequence s_t_wd;
create sequence s_t_yjx;
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_bgsyp(
id int identity(1,1) primary key not null,--主键
title varchar(100),--用品名称
pic varchar(100),--图片
nums int,--数量
types varchar(100),--出库、入库
showDate datetime,--日期
lyr varchar(100)--领用人
);
车辆管理表创建语句如下：
--车辆管理表注释
create table t_clgl(
id int identity(1,1) primary key not null,--主键
title varchar(100),--车辆牌照
clName varchar(100),--车辆型号
pic varchar(100),--图片
showDate datetime,--申请日期
lyr varchar(100),--申请人
sqly varchar(100),--申请理由
mdd varchar(100)--目的地
);
员工表创建语句如下：
--员工表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
gh varchar(100),--工号
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
email varchar(100),--邮箱
isYx varchar(100)--是否优秀员工
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
showDate datetime--日期
);
会议记录表创建语句如下：
--会议记录表注释
create table t_hyjl(
id int identity(1,1) primary key not null,--主键
title varchar(100),--会议名称
showDate datetime,--日期
fileUrl varchar(100),--记录文档
content varchar(100)--会议内容
);
内部邮件表创建语句如下：
--内部邮件表注释
create table t_nbyj(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
title varchar(100),--标题
cotnent varchar(100),--内容
fj varchar(100),--附件
insertDate datetime,--日期
status varchar(100)--状态
);
请假表创建语句如下：
--请假表注释
create table t_qj(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
types varchar(100),--类型
title varchar(100),--标题
cotnent varchar(100),--请假理由
showDate varchar(100),--请假日期
status varchar(100)--状态
);
文档表创建语句如下：
--文档表注释
create table t_wd(
id int identity(1,1) primary key not null,--主键
title varchar(100),--文档名称
fileUrl varchar(100),--文档
bz varchar(100)--备注
);
意见箱表创建语句如下：
--意见箱表注释
create table t_yjx(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
yj varchar(100),--意见
insertDate datetime--日期
);
登录后主页.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_bgsyp")
public class Bgsyp {
//主键
@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 Integer nums;
//出库、入库
private String types;
//日期
private Date showDate;
//领用人
private String lyr;
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 Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getLyr() {return lyr;}
public void setLyr(String lyr) {this.lyr = lyr;}
}车辆管理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_clgl")
public class Clgl {
//主键
@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 clName;
//图片
private String pic;
//申请日期
private Date showDate;
//申请人
private String lyr;
//申请理由
private String sqly;
//目的地
private String mdd;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getClName() {return clName;}
public void setClName(String clName) {this.clName = clName;}
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 getLyr() {return lyr;}
public void setLyr(String lyr) {this.lyr = lyr;}
public String getSqly() {return sqly;}
public void setSqly(String sqly) {this.sqly = sqly;}
public String getMdd() {return mdd;}
public void setMdd(String mdd) {this.mdd = mdd;}
}员工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 gh;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//邮箱
private String email;
//是否优秀员工
private String isYx;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getIsYx() {return isYx;}
public void setIsYx(String isYx) {this.isYx = isYx;}
}公告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 content;
//日期
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_hyjl")
public class Hyjl {
//主键
@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 fileUrl;
//会议内容
private String content;
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_nbyj")
public class Nbyj {
//主键
@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 cotnent;
//附件
private String fj;
//日期
private Date insertDate;
//状态
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
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;}
}请假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 types;
//标题
private String title;
//请假理由
private String cotnent;
//请假日期
private String showDate;
//状态
private String status;
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public String getShowDate() {return showDate;}
public void setShowDate(String 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_wd")
public class Wd {
//主键
@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 fileUrl;
//备注
private String bz;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
}意见箱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_yjx")
public class Yjx {
//主键
@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 yj;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYj() {return yj;}
public void setYj(String yj) {this.yj = yj;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}SSM网上办公自动系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
办公室用品javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//办公室用品
public class Bgsyp 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 Integer nums;
//出库、入库
private String types;
//日期
private Date showDate;
//领用人
private String lyr;
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 Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getLyr() {return lyr;}
public void setLyr(String lyr) {this.lyr = lyr;}
}车辆管理javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//车辆管理
public class Clgl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车辆牌照
private String title;
//车辆型号
private String clName;
//图片
private String pic;
//申请日期
private Date showDate;
//申请人
private String lyr;
//申请理由
private String sqly;
//目的地
private String mdd;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getClName() {return clName;}
public void setClName(String clName) {this.clName = clName;}
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 getLyr() {return lyr;}
public void setLyr(String lyr) {this.lyr = lyr;}
public String getSqly() {return sqly;}
public void setSqly(String sqly) {this.sqly = sqly;}
public String getMdd() {return mdd;}
public void setMdd(String mdd) {this.mdd = mdd;}
}员工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 gh;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//邮箱
private String email;
//是否优秀员工
private String isYx;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getIsYx() {return isYx;}
public void setIsYx(String isYx) {this.isYx = isYx;}
}公告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 content;
//日期
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Hyjl 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 fileUrl;
//会议内容
private String content;
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 getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Nbyj 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 cotnent;
//附件
private String fj;
//日期
private Date insertDate;
//状态
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
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;}
}请假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 types;
//标题
private String title;
//请假理由
private String cotnent;
//请假日期
private String showDate;
//状态
private String status;
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 getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public String getShowDate() {return showDate;}
public void setShowDate(String 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 Wd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//文档名称
private String title;
//文档
private String fileUrl;
//备注
private String bz;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
}意见箱javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//意见箱
public class Yjx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//意见
private String yj;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getYj() {return yj;}
public void setYj(String yj) {this.yj = yj;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}