更多成品,定做java毕业设计,请咨询管理员qq:2812491287

基于activiti工作流引擎的办公系统

基于activiti工作流引擎的办公系统登录注册界面

基于activiti工作流引擎的办公系统mysql数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '超级管理员账号',
	password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');

部门表创建语句如下:


create table t_bm(
	id int primary key auto_increment comment '主键',
	bmName varchar(100) comment '部门'
) comment '部门';

部门通知表创建语句如下:


create table t_bumentongzhi(
	id int primary key auto_increment comment '主键',
	bmId int comment '部门',
	title 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 '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	bmId int comment '部门',
	js varchar(100) comment '角色'
) comment '人员';

邮件表创建语句如下:


create table t_email(
	id int primary key auto_increment comment '主键',
	customerId int comment '人员',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	fj varchar(100) comment '附件',
	toId int comment '接收人',
	showDate datetime comment '发送日期'
) comment '邮件';

工作审批表创建语句如下:


create table t_order(
	id int primary key auto_increment comment '主键',
	customerId int comment '发起人',
	types varchar(100) comment '审批类型',
	title varchar(100) comment '说明',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '附件',
	insertDate datetime comment '发起日期',
	name1 varchar(100) comment '部门审批人',
	date1 datetime comment '部门审批日期',
	content1 varchar(100) comment '审批内容',
	name2 varchar(100) comment '总经理',
	date2 datetime comment '总经理审批日期',
	content2 varchar(100) comment '审批内容',
	status varchar(100) comment '状态'
) comment '工作审批';

签到表创建语句如下:


create table t_qiandao(
	id int primary key auto_increment comment '主键',
	customerId int comment '人员',
	insertDate datetime comment '签到日期'
) comment '签到';

日程安排表创建语句如下:


create table t_rcap(
	id int primary key auto_increment comment '主键',
	customerId int comment '人员',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	showDate datetime comment '安排日期'
) comment '日程安排';

通知公告表创建语句如下:


create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	insertDate datetime comment '日期'
) comment '通知公告';

文档表创建语句如下:


create table t_wendang(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	pic varchar(100) comment '图片',
	fj varchar(100) comment '附件',
	insertDate datetime comment '发布日期'
) comment '文档';

工作下发表创建语句如下:


create table t_work(
	id int primary key auto_increment comment '主键',
	customerId int comment '发起人',
	toId int comment '执行人',
	title varchar(100) comment '说明',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '附件',
	insertDate datetime comment '发起日期',
	gjcontent varchar(100) comment '跟进内容',
	gjDate datetime comment '跟进日期',
	status varchar(100) comment '状态'
) comment '工作下发';

消息表创建语句如下:


create table t_xiaoxi(
	id int primary key auto_increment comment '主键',
	customerId int comment '人员',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	insertDate datetime comment '日期'
) comment '消息';

基于activiti工作流引擎的办公系统oracle数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

部门表创建语句如下:


create table t_bm(
	id integer,
	bmName varchar(100)
);
--部门字段加注释
comment on column t_bm.id is '主键';
comment on column t_bm.bmName is '部门';
--部门表加注释
comment on table t_bm is '部门';

部门通知表创建语句如下:


create table t_bumentongzhi(
	id integer,
	bmId int,
	title varchar(100),
	content varchar(100),
	insertDate datetime
);
--部门通知字段加注释
comment on column t_bumentongzhi.id is '主键';
comment on column t_bumentongzhi.bmId is '部门';
comment on column t_bumentongzhi.title is '标题';
comment on column t_bumentongzhi.content is '内容';
comment on column t_bumentongzhi.insertDate is '日期';
--部门通知表加注释
comment on table t_bumentongzhi 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),
	bmId int,
	js 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.bmId is '部门';
comment on column t_customer.js is '角色';
--人员表加注释
comment on table t_customer is '人员';

邮件表创建语句如下:


create table t_email(
	id integer,
	customerId int,
	title varchar(100),
	content varchar(100),
	fj varchar(100),
	toId int,
	showDate datetime
);
--邮件字段加注释
comment on column t_email.id is '主键';
comment on column t_email.customerId is '人员';
comment on column t_email.title is '标题';
comment on column t_email.content is '内容';
comment on column t_email.fj is '附件';
comment on column t_email.toId is '接收人';
comment on column t_email.showDate is '发送日期';
--邮件表加注释
comment on table t_email is '邮件';

工作审批表创建语句如下:


create table t_order(
	id integer,
	customerId int,
	types varchar(100),
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	name1 varchar(100),
	date1 datetime,
	content1 varchar(100),
	name2 varchar(100),
	date2 datetime,
	content2 varchar(100),
	status varchar(100)
);
--工作审批字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '发起人';
comment on column t_order.types is '审批类型';
comment on column t_order.title is '说明';
comment on column t_order.content is '内容';
comment on column t_order.fileUrl is '附件';
comment on column t_order.insertDate is '发起日期';
comment on column t_order.name1 is '部门审批人';
comment on column t_order.date1 is '部门审批日期';
comment on column t_order.content1 is '审批内容';
comment on column t_order.name2 is '总经理';
comment on column t_order.date2 is '总经理审批日期';
comment on column t_order.content2 is '审批内容';
comment on column t_order.status is '状态';
--工作审批表加注释
comment on table t_order is '工作审批';

签到表创建语句如下:


create table t_qiandao(
	id integer,
	customerId int,
	insertDate datetime
);
--签到字段加注释
comment on column t_qiandao.id is '主键';
comment on column t_qiandao.customerId is '人员';
comment on column t_qiandao.insertDate is '签到日期';
--签到表加注释
comment on table t_qiandao is '签到';

日程安排表创建语句如下:


create table t_rcap(
	id integer,
	customerId int,
	title varchar(100),
	content varchar(100),
	showDate datetime
);
--日程安排字段加注释
comment on column t_rcap.id is '主键';
comment on column t_rcap.customerId is '人员';
comment on column t_rcap.title is '标题';
comment on column t_rcap.content is '内容';
comment on column t_rcap.showDate is '安排日期';
--日程安排表加注释
comment on table t_rcap is '日程安排';

通知公告表创建语句如下:


create table t_tongzhi(
	id integer,
	title varchar(100),
	content varchar(100),
	insertDate datetime
);
--通知公告字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知公告表加注释
comment on table t_tongzhi is '通知公告';

文档表创建语句如下:


create table t_wendang(
	id integer,
	title varchar(100),
	content varchar(100),
	pic varchar(100),
	fj varchar(100),
	insertDate datetime
);
--文档字段加注释
comment on column t_wendang.id is '主键';
comment on column t_wendang.title is '标题';
comment on column t_wendang.content is '内容';
comment on column t_wendang.pic is '图片';
comment on column t_wendang.fj is '附件';
comment on column t_wendang.insertDate is '发布日期';
--文档表加注释
comment on table t_wendang is '文档';

工作下发表创建语句如下:


create table t_work(
	id integer,
	customerId int,
	toId int,
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	gjcontent varchar(100),
	gjDate datetime,
	status varchar(100)
);
--工作下发字段加注释
comment on column t_work.id is '主键';
comment on column t_work.customerId is '发起人';
comment on column t_work.toId is '执行人';
comment on column t_work.title is '说明';
comment on column t_work.content is '内容';
comment on column t_work.fileUrl is '附件';
comment on column t_work.insertDate is '发起日期';
comment on column t_work.gjcontent is '跟进内容';
comment on column t_work.gjDate is '跟进日期';
comment on column t_work.status is '状态';
--工作下发表加注释
comment on table t_work is '工作下发';

消息表创建语句如下:


create table t_xiaoxi(
	id integer,
	customerId int,
	title varchar(100),
	content varchar(100),
	insertDate datetime
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.customerId is '人员';
comment on column t_xiaoxi.title is '标题';
comment on column t_xiaoxi.content is '内容';
comment on column t_xiaoxi.insertDate is '日期';
--消息表加注释
comment on table t_xiaoxi is '消息';

oracle特有,对应序列如下:


create sequence s_t_bm;
create sequence s_t_bumentongzhi;
create sequence s_t_customer;
create sequence s_t_email;
create sequence s_t_order;
create sequence s_t_qiandao;
create sequence s_t_rcap;
create sequence s_t_tongzhi;
create sequence s_t_wendang;
create sequence s_t_work;
create sequence s_t_xiaoxi;

基于activiti工作流引擎的办公系统sqlserver数据库版本源码:

超级管理员表创建语句如下:


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

部门表创建语句如下:


--部门表注释
create table t_bm(
	id int identity(1,1) primary key not null,--主键
	bmName varchar(100)--部门
);

部门通知表创建语句如下:


--部门通知表注释
create table t_bumentongzhi(
	id int identity(1,1) primary key not null,--主键
	bmId int,--部门
	title 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),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--性别
	bmId int,--部门
	js varchar(100)--角色
);

邮件表创建语句如下:


--邮件表注释
create table t_email(
	id int identity(1,1) primary key not null,--主键
	customerId int,--人员
	title varchar(100),--标题
	content varchar(100),--内容
	fj varchar(100),--附件
	toId int,--接收人
	showDate datetime--发送日期
);

工作审批表创建语句如下:


--工作审批表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	customerId int,--发起人
	types varchar(100),--审批类型
	title varchar(100),--说明
	content varchar(100),--内容
	fileUrl varchar(100),--附件
	insertDate datetime,--发起日期
	name1 varchar(100),--部门审批人
	date1 datetime,--部门审批日期
	content1 varchar(100),--审批内容
	name2 varchar(100),--总经理
	date2 datetime,--总经理审批日期
	content2 varchar(100),--审批内容
	status varchar(100)--状态
);

签到表创建语句如下:


--签到表注释
create table t_qiandao(
	id int identity(1,1) primary key not null,--主键
	customerId int,--人员
	insertDate datetime--签到日期
);

日程安排表创建语句如下:


--日程安排表注释
create table t_rcap(
	id int identity(1,1) primary key not null,--主键
	customerId int,--人员
	title varchar(100),--标题
	content varchar(100),--内容
	showDate datetime--安排日期
);

通知公告表创建语句如下:


--通知公告表注释
create table t_tongzhi(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	insertDate datetime--日期
);

文档表创建语句如下:


--文档表注释
create table t_wendang(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	pic varchar(100),--图片
	fj varchar(100),--附件
	insertDate datetime--发布日期
);

工作下发表创建语句如下:


--工作下发表注释
create table t_work(
	id int identity(1,1) primary key not null,--主键
	customerId int,--发起人
	toId int,--执行人
	title varchar(100),--说明
	content varchar(100),--内容
	fileUrl varchar(100),--附件
	insertDate datetime,--发起日期
	gjcontent varchar(100),--跟进内容
	gjDate datetime,--跟进日期
	status varchar(100)--状态
);

消息表创建语句如下:


--消息表注释
create table t_xiaoxi(
	id int identity(1,1) primary key not null,--主键
	customerId int,--人员
	title varchar(100),--标题
	content varchar(100),--内容
	insertDate datetime--日期
);

基于activiti工作流引擎的办公系统登录后主页

基于activiti工作流引擎的办公系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

部门javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//部门
@Table(name = "t_bm")
public class Bm {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private String bmName;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}

部门通知javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//部门通知
@Table(name = "t_bumentongzhi")
public class Bumentongzhi {
//主键
@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 bmId;
//标题
private String title;
//内容
private String content;
//日期
private Date insertDate;
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

人员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 Integer bmId;
//角色
private String js;
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 Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}

邮件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_email")
public class Email {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员
private Integer customerId;
//标题
private String title;
//内容
private String content;
//附件
private String fj;
//接收人
private Integer toId;
//发送日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
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_order")
public class Order {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发起人
private Integer customerId;
//审批类型
private String types;
//说明
private String title;
//内容
private String content;
//附件
private String fileUrl;
//发起日期
private Date insertDate;
//部门审批人
private String name1;
//部门审批日期
private Date date1;
//审批内容
private String content1;
//总经理
private String name2;
//总经理审批日期
private Date date2;
//审批内容
private String content2;
//状态
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getName1() {return name1;}
public void setName1(String name1) {this.name1 = name1;}
public Date getDate1() {return date1;}
public void setDate1(Date date1) {this.date1 = date1;}
public String getContent1() {return content1;}
public void setContent1(String content1) {this.content1 = content1;}
public String getName2() {return name2;}
public void setName2(String name2) {this.name2 = name2;}
public Date getDate2() {return date2;}
public void setDate2(Date date2) {this.date2 = date2;}
public String getContent2() {return content2;}
public void setContent2(String content2) {this.content2 = content2;}
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_qiandao")
public class Qiandao {
//主键
@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_rcap")
public class Rcap {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员
private Integer customerId;
//标题
private String title;
//内容
private String content;
//安排日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

通知公告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 String title;
//内容
private String content;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

文档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 String title;
//内容
private String content;
//图片
private String pic;
//附件
private String fj;
//发布日期
private Date insertDate;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
}

工作下发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_work")
public class Work {
//主键
@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 String content;
//附件
private String fileUrl;
//发起日期
private Date insertDate;
//跟进内容
private String gjcontent;
//跟进日期
private Date gjDate;
//状态
private String status;
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 String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getGjcontent() {return gjcontent;}
public void setGjcontent(String gjcontent) {this.gjcontent = gjcontent;}
public Date getGjDate() {return gjDate;}
public void setGjDate(Date gjDate) {this.gjDate = gjDate;}
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 String title;
//内容
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

基于activiti工作流引擎的办公系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

部门javaBean创建语句如下:


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

//部门
public class Bm  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private String bmName;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}

部门通知javaBean创建语句如下:


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

//部门通知
public class Bumentongzhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private Integer bmId;
//标题
private String title;
//内容
private String content;
//日期
private Date insertDate;
public Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

人员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 Integer bmId;
//角色
private String js;
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 Integer getBmId() {return bmId;}
public void setBmId(Integer bmId) {this.bmId = bmId;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}

邮件javaBean创建语句如下:


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

//邮件
public class Email  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员
private Integer customerId;
//标题
private String title;
//内容
private String content;
//附件
private String fj;
//接收人
private Integer toId;
//发送日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
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 Order  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//发起人
private Integer customerId;
//审批类型
private String types;
//说明
private String title;
//内容
private String content;
//附件
private String fileUrl;
//发起日期
private Date insertDate;
//部门审批人
private String name1;
//部门审批日期
private Date date1;
//审批内容
private String content1;
//总经理
private String name2;
//总经理审批日期
private Date date2;
//审批内容
private String content2;
//状态
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getName1() {return name1;}
public void setName1(String name1) {this.name1 = name1;}
public Date getDate1() {return date1;}
public void setDate1(Date date1) {this.date1 = date1;}
public String getContent1() {return content1;}
public void setContent1(String content1) {this.content1 = content1;}
public String getName2() {return name2;}
public void setName2(String name2) {this.name2 = name2;}
public Date getDate2() {return date2;}
public void setDate2(Date date2) {this.date2 = date2;}
public String getContent2() {return content2;}
public void setContent2(String content2) {this.content2 = content2;}
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 Qiandao  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 Rcap  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员
private Integer customerId;
//标题
private String title;
//内容
private String content;
//安排日期
private Date showDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

通知公告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 String title;
//内容
private String content;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

文档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 String title;
//内容
private String content;
//图片
private String pic;
//附件
private String fj;
//发布日期
private Date insertDate;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
}

工作下发javaBean创建语句如下:


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

//工作下发
public class Work  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 String content;
//附件
private String fileUrl;
//发起日期
private Date insertDate;
//跟进内容
private String gjcontent;
//跟进日期
private Date gjDate;
//状态
private String status;
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 String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getGjcontent() {return gjcontent;}
public void setGjcontent(String gjcontent) {this.gjcontent = gjcontent;}
public Date getGjDate() {return gjDate;}
public void setGjDate(Date gjDate) {this.gjDate = gjDate;}
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 String title;
//内容
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

评论