企业事务管理系统的设计与实现

企业事务管理系统的设计与实现登录注册界面

企业事务管理系统的设计与实现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_bumen(
	id int primary key auto_increment comment '主键',
	bumenName varchar(100) comment '部门'
) comment '部门';

备忘录表创建语句如下:


create table t_bwl(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	title varchar(100) comment '标题',
	pic varchar(100) comment '附件',
	content varchar(100) comment '内容',
	insertDate datetime 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 '年龄',
	sex varchar(100) comment '性别',
	js varchar(100) comment '角色',
	gangweiId int comment '岗位',
	bumenId int comment '部门'
) comment '员工';

岗位表创建语句如下:


create table t_gangwei(
	id int primary key auto_increment comment '主键',
	gangweiName varchar(100) comment '岗位'
) comment '岗位';

通告表创建语句如下:


create table t_gonggao(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate varchar(100) comment '日期'
) comment '通告';

会议通知表创建语句如下:


create table t_huiyi(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate varchar(100) comment '日期',
	hysId int comment '会议室'
) comment '会议通知';

会议室申请表创建语句如下:


create table t_huiyishisq(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	hysId int comment '会议室',
	showDate datetime comment '申请日期',
	content varchar(100) comment '申请内容',
	status varchar(100) comment '申请状态'
) comment '会议室申请';

会议室表创建语句如下:


create table t_hys(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '会议室',
	content varchar(100) comment '会议室说明',
	status varchar(100) comment '状态'
) comment '会议室';

考勤表创建语句如下:


create table t_kaoqin(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	insertDate datetime comment '日期'
) comment '考勤';

文档表创建语句如下:


create table t_wendang(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	title varchar(100) comment '标题',
	pic varchar(100) comment '附件',
	content varchar(100) comment '文档说明',
	status varchar(100) comment '状态'
) comment '文档';

消息表创建语句如下:


create table t_xiaoxi(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	toId int comment '接收方',
	title varchar(100) comment '消息',
	insertDate datetime comment '日期',
	pic varchar(100) comment '文档'
) comment '消息';

表创建语句如下:


create table t_xiaoxibm(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	toId int comment '接收方',
	title varchar(100) comment '消息',
	insertDate datetime comment '日期',
	pic 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_bumen(
	id integer,
	bumenName varchar(100)
);
--部门字段加注释
comment on column t_bumen.id is '主键';
comment on column t_bumen.bumenName is '部门';
--部门表加注释
comment on table t_bumen is '部门';

备忘录表创建语句如下:


create table t_bwl(
	id integer,
	customerId int,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	insertDate datetime
);
--备忘录字段加注释
comment on column t_bwl.id is '主键';
comment on column t_bwl.customerId is '员工';
comment on column t_bwl.title is '标题';
comment on column t_bwl.pic is '附件';
comment on column t_bwl.content is '内容';
comment on column t_bwl.insertDate is '日期';
--备忘录表加注释
comment on table t_bwl is '备忘录';

员工表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	js varchar(100),
	gangweiId int,
	bumenId int
);
--员工字段加注释
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.sex is '性别';
comment on column t_customer.js is '角色';
comment on column t_customer.gangweiId is '岗位';
comment on column t_customer.bumenId is '部门';
--员工表加注释
comment on table t_customer is '员工';

岗位表创建语句如下:


create table t_gangwei(
	id integer,
	gangweiName varchar(100)
);
--岗位字段加注释
comment on column t_gangwei.id is '主键';
comment on column t_gangwei.gangweiName is '岗位';
--岗位表加注释
comment on table t_gangwei is '岗位';

通告表创建语句如下:


create table t_gonggao(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate varchar(100)
);
--通告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.pic is '图片';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.showDate is '日期';
--通告表加注释
comment on table t_gonggao is '通告';

会议通知表创建语句如下:


create table t_huiyi(
	id integer,
	customerId int,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate varchar(100),
	hysId int
);
--会议通知字段加注释
comment on column t_huiyi.id is '主键';
comment on column t_huiyi.customerId is '员工';
comment on column t_huiyi.title is '标题';
comment on column t_huiyi.pic is '图片';
comment on column t_huiyi.content is '内容';
comment on column t_huiyi.showDate is '日期';
comment on column t_huiyi.hysId is '会议室';
--会议通知表加注释
comment on table t_huiyi is '会议通知';

会议室申请表创建语句如下:


create table t_huiyishisq(
	id integer,
	customerId int,
	hysId int,
	showDate datetime,
	content varchar(100),
	status varchar(100)
);
--会议室申请字段加注释
comment on column t_huiyishisq.id is '主键';
comment on column t_huiyishisq.customerId is '用户';
comment on column t_huiyishisq.hysId is '会议室';
comment on column t_huiyishisq.showDate is '申请日期';
comment on column t_huiyishisq.content is '申请内容';
comment on column t_huiyishisq.status is '申请状态';
--会议室申请表加注释
comment on table t_huiyishisq is '会议室申请';

会议室表创建语句如下:


create table t_hys(
	id integer,
	title varchar(100),
	content varchar(100),
	status varchar(100)
);
--会议室字段加注释
comment on column t_hys.id is '主键';
comment on column t_hys.title is '会议室';
comment on column t_hys.content is '会议室说明';
comment on column t_hys.status is '状态';
--会议室表加注释
comment on table t_hys is '会议室';

考勤表创建语句如下:


create table t_kaoqin(
	id integer,
	customerId int,
	insertDate datetime
);
--考勤字段加注释
comment on column t_kaoqin.id is '主键';
comment on column t_kaoqin.customerId is '员工';
comment on column t_kaoqin.insertDate is '日期';
--考勤表加注释
comment on table t_kaoqin is '考勤';

文档表创建语句如下:


create table t_wendang(
	id integer,
	customerId int,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	status varchar(100)
);
--文档字段加注释
comment on column t_wendang.id is '主键';
comment on column t_wendang.customerId is '员工';
comment on column t_wendang.title is '标题';
comment on column t_wendang.pic is '附件';
comment on column t_wendang.content is '文档说明';
comment on column t_wendang.status is '状态';
--文档表加注释
comment on table t_wendang is '文档';

消息表创建语句如下:


create table t_xiaoxi(
	id integer,
	customerId int,
	toId int,
	title varchar(100),
	insertDate datetime,
	pic varchar(100)
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.customerId is '用户';
comment on column t_xiaoxi.toId is '接收方';
comment on column t_xiaoxi.title is '消息';
comment on column t_xiaoxi.insertDate is '日期';
comment on column t_xiaoxi.pic is '文档';
--消息表加注释
comment on table t_xiaoxi is '消息';

表创建语句如下:


create table t_xiaoxibm(
	id integer,
	customerId int,
	toId int,
	title varchar(100),
	insertDate datetime,
	pic varchar(100)
);
--字段加注释
comment on column t_xiaoxibm.id is '主键';
comment on column t_xiaoxibm.customerId is '用户';
comment on column t_xiaoxibm.toId is '接收方';
comment on column t_xiaoxibm.title is '消息';
comment on column t_xiaoxibm.insertDate is '日期';
comment on column t_xiaoxibm.pic is '文档';
--表加注释
comment on table t_xiaoxibm is '';

oracle特有,对应序列如下:


create sequence s_t_bumen;
create sequence s_t_bwl;
create sequence s_t_customer;
create sequence s_t_gangwei;
create sequence s_t_gonggao;
create sequence s_t_huiyi;
create sequence s_t_huiyishisq;
create sequence s_t_hys;
create sequence s_t_kaoqin;
create sequence s_t_wendang;
create sequence s_t_xiaoxi;
create sequence s_t_xiaoxibm;

企业事务管理系统的设计与实现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_bumen(
	id int identity(1,1) primary key not null,--主键
	bumenName varchar(100)--部门
);

备忘录表创建语句如下:


--备忘录表注释
create table t_bwl(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	title varchar(100),--标题
	pic varchar(100),--附件
	content varchar(100),--内容
	insertDate datetime--日期
);

员工表创建语句如下:


--员工表注释
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),--年龄
	sex varchar(100),--性别
	js varchar(100),--角色
	gangweiId int,--岗位
	bumenId int--部门
);

岗位表创建语句如下:


--岗位表注释
create table t_gangwei(
	id int identity(1,1) primary key not null,--主键
	gangweiName varchar(100)--岗位
);

通告表创建语句如下:


--通告表注释
create table t_gonggao(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate varchar(100)--日期
);

会议通知表创建语句如下:


--会议通知表注释
create table t_huiyi(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate varchar(100),--日期
	hysId int--会议室
);

会议室申请表创建语句如下:


--会议室申请表注释
create table t_huiyishisq(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	hysId int,--会议室
	showDate datetime,--申请日期
	content varchar(100),--申请内容
	status varchar(100)--申请状态
);

会议室表创建语句如下:


--会议室表注释
create table t_hys(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--会议室
	content varchar(100),--会议室说明
	status varchar(100)--状态
);

考勤表创建语句如下:


--考勤表注释
create table t_kaoqin(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	insertDate datetime--日期
);

文档表创建语句如下:


--文档表注释
create table t_wendang(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	title varchar(100),--标题
	pic varchar(100),--附件
	content varchar(100),--文档说明
	status varchar(100)--状态
);

消息表创建语句如下:


--消息表注释
create table t_xiaoxi(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	toId int,--接收方
	title varchar(100),--消息
	insertDate datetime,--日期
	pic varchar(100)--文档
);

表创建语句如下:


--表注释
create table t_xiaoxibm(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	toId int,--接收方
	title varchar(100),--消息
	insertDate datetime,--日期
	pic 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_bumen")
public class Bumen {
//主键
@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 bumenName;
public String getBumenName() {return bumenName;}
public void setBumenName(String bumenName) {this.bumenName = bumenName;}
}

备忘录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_bwl")
public class Bwl {
//主键
@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 content;
//日期
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 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_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 sex;
//角色
private String js;
//岗位
private Integer gangweiId;
//部门
private Integer bumenId;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public Integer getGangweiId() {return gangweiId;}
public void setGangweiId(Integer gangweiId) {this.gangweiId = gangweiId;}
public Integer getBumenId() {return bumenId;}
public void setBumenId(Integer bumenId) {this.bumenId = bumenId;}
}

岗位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_gangwei")
public class Gangwei {
//主键
@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 gangweiName;
public String getGangweiName() {return gangweiName;}
public void setGangweiName(String gangweiName) {this.gangweiName = gangweiName;}
}

通告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_gonggao")
public class Gonggao {
//主键
@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 String 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 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_huiyi")
public class Huiyi {
//主键
@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 content;
//日期
private String showDate;
//会议室
private Integer hysId;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public Integer getHysId() {return hysId;}
public void setHysId(Integer hysId) {this.hysId = hysId;}
}

会议室申请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_huiyishisq")
public class Huiyishisq {
//主键
@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 hysId;
//申请日期
private Date showDate;
//申请内容
private String content;
//申请状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHysId() {return hysId;}
public void setHysId(Integer hysId) {this.hysId = hysId;}
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 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_hys")
public class Hys {
//主键
@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 content;
//状态
private String status;
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 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_kaoqin")
public class Kaoqin {
//主键
@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_wendang")
public class Wendang {
//主键
@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 content;
//状态
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 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 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_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 Integer toId;
//消息
private String title;
//日期
private Date insertDate;
//文档
private String pic;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

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_xiaoxibm")
public class Xiaoxibm {
//主键
@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 toId;
//消息
private String title;
//日期
private Date insertDate;
//文档
private String pic;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

企业事务管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

部门javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//部门
public class Bumen  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private String bumenName;
public String getBumenName() {return bumenName;}
public void setBumenName(String bumenName) {this.bumenName = bumenName;}
}

备忘录javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//备忘录
public class Bwl  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 content;
//日期
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 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 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 sex;
//角色
private String js;
//岗位
private Integer gangweiId;
//部门
private Integer bumenId;
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 getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public Integer getGangweiId() {return gangweiId;}
public void setGangweiId(Integer gangweiId) {this.gangweiId = gangweiId;}
public Integer getBumenId() {return bumenId;}
public void setBumenId(Integer bumenId) {this.bumenId = bumenId;}
}

岗位javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//岗位
public class Gangwei  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//岗位
private String gangweiName;
public String getGangweiName() {return gangweiName;}
public void setGangweiName(String gangweiName) {this.gangweiName = gangweiName;}
}

通告javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//通告
public class Gonggao  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 String 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 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 Huiyi  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 content;
//日期
private String showDate;
//会议室
private Integer hysId;
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public Integer getHysId() {return hysId;}
public void setHysId(Integer hysId) {this.hysId = hysId;}
}

会议室申请javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//会议室申请
public class Huiyishisq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//会议室
private Integer hysId;
//申请日期
private Date showDate;
//申请内容
private String content;
//申请状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHysId() {return hysId;}
public void setHysId(Integer hysId) {this.hysId = hysId;}
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 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 Hys  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//会议室
private String title;
//会议室说明
private String content;
//状态
private String status;
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 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 Kaoqin  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 Wendang  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 content;
//状态
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 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 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 Xiaoxi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//接收方
private Integer toId;
//消息
private String title;
//日期
private Date insertDate;
//文档
private String pic;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//
public class Xiaoxibm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//接收方
private Integer toId;
//消息
private String title;
//日期
private Date insertDate;
//文档
private String pic;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}

评论