Java毕业设计_基于activiti工作流引擎的办公系统

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

基于activiti工作流引擎的办公系统mysql数据库创建语句
基于activiti工作流引擎的办公系统oracle数据库创建语句
基于activiti工作流引擎的办公系统sqlserver数据库创建语句
基于activiti工作流引擎的办公系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于activiti工作流引擎的办公系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频：shangyepingtai.xin

基于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’);
SQLCopy
部门表创建语句如下：
create table t_bm(
id int primary key auto_increment comment ‘主键’,
bmName varchar(100) comment ‘部门’
) comment ‘部门’;
SQLCopy
部门通知表创建语句如下：
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 ‘部门通知’;
SQLCopy
人员表创建语句如下：
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 ‘人员’;
SQLCopy
邮件表创建语句如下：
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 ‘邮件’;
SQLCopy
工作审批表创建语句如下：
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 ‘工作审批’;
SQLCopy
签到表创建语句如下：
create table t_qiandao(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘人员’,
insertDate datetime comment ‘签到日期’
) comment ‘签到’;
SQLCopy
日程安排表创建语句如下：
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 ‘日程安排’;
SQLCopy
通知公告表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
content varchar(100) comment ‘内容’,
insertDate datetime comment ‘日期’
) comment ‘通知公告’;
SQLCopy
文档表创建语句如下：
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 ‘文档’;
SQLCopy
工作下发表创建语句如下：
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 ‘工作下发’;
SQLCopy
消息表创建语句如下：
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 ‘消息’;
SQLCopy

基于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 ‘超级管理员’;
SQLCopy
部门表创建语句如下：
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 ‘部门’;
SQLCopy
部门通知表创建语句如下：
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 ‘部门通知’;
SQLCopy
人员表创建语句如下：
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 ‘人员’;
SQLCopy
邮件表创建语句如下：
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 ‘邮件’;
SQLCopy
工作审批表创建语句如下：
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 ‘工作审批’;
SQLCopy
签到表创建语句如下：
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 ‘签到’;
SQLCopy
日程安排表创建语句如下：
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 ‘日程安排’;
SQLCopy
通知公告表创建语句如下：