基于工作流的企业批文审批系统设计与实现

基于工作流的企业批文审批系统设计与实现登录注册界面

基于工作流的企业批文审批系统设计与实现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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	yhbh varchar(100) comment '用户编号',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	deptId int comment '部门',
	isSp varchar(100) comment '是否有审批权限'
) comment '用户';

部门表创建语句如下:


create table t_dept(
	id int primary key auto_increment comment '主键',
	deptName varchar(100) comment '部门编号名称',
	v1 varchar(100) comment '部门类别',
	v2 varchar(100) comment '经理ID',
	v3 varchar(100) comment '电话'
) comment '部门';

批文类型表创建语句如下:


create table t_lx(
	id int primary key auto_increment comment '主键',
	lxName varchar(100) comment '批文类型'
) comment '批文类型';

批文表创建语句如下:


create table t_pw(
	id int primary key auto_increment comment '主键',
	customerId int comment '发起人',
	toId int comment '接收人',
	lxId varchar(100) comment '批文类型',
	pwName varchar(100) comment '文件标题',
	v1 varchar(100) comment '批文紧急程度',
	v7 varchar(100) comment '内容',
	v2 varchar(100) comment '附件一',
	v3 varchar(100) comment '附件二',
	v4 varchar(100) comment '附件三',
	v5 varchar(100) comment '状态',
	shnr1 varchar(100) comment '备注',
	shrId1 int comment '审核人',
	shDate1 datetime comment '审核时间',
	shnr2 varchar(100) comment '',
	shrId2 int comment '',
	shDate2 datetime comment '',
	shnr3 varchar(100) comment '',
	shrId3 int comment '',
	shDate3 datetime comment ''
) comment '批文';

基于工作流的企业批文审批系统设计与实现oracle数据库版本源码:

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


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

用户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	yhbh varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	deptId int,
	isSp 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.yhbh 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.deptId is '部门';
comment on column t_customer.isSp is '是否有审批权限';
--用户表加注释
comment on table t_customer is '用户';

部门表创建语句如下:


create table t_dept(
	id integer,
	deptName varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--部门字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '部门编号名称';
comment on column t_dept.v1 is '部门类别';
comment on column t_dept.v2 is '经理ID';
comment on column t_dept.v3 is '电话';
--部门表加注释
comment on table t_dept is '部门';

批文类型表创建语句如下:


create table t_lx(
	id integer,
	lxName varchar(100)
);
--批文类型字段加注释
comment on column t_lx.id is '主键';
comment on column t_lx.lxName is '批文类型';
--批文类型表加注释
comment on table t_lx is '批文类型';

批文表创建语句如下:


create table t_pw(
	id integer,
	customerId int,
	toId int,
	lxId varchar(100),
	pwName varchar(100),
	v1 varchar(100),
	v7 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	shnr1 varchar(100),
	shrId1 int,
	shDate1 datetime,
	shnr2 varchar(100),
	shrId2 int,
	shDate2 datetime,
	shnr3 varchar(100),
	shrId3 int,
	shDate3 datetime
);
--批文字段加注释
comment on column t_pw.id is '主键';
comment on column t_pw.customerId is '发起人';
comment on column t_pw.toId is '接收人';
comment on column t_pw.lxId is '批文类型';
comment on column t_pw.pwName is '文件标题';
comment on column t_pw.v1 is '批文紧急程度';
comment on column t_pw.v7 is '内容';
comment on column t_pw.v2 is '附件一';
comment on column t_pw.v3 is '附件二';
comment on column t_pw.v4 is '附件三';
comment on column t_pw.v5 is '状态';
comment on column t_pw.shnr1 is '备注';
comment on column t_pw.shrId1 is '审核人';
comment on column t_pw.shDate1 is '审核时间';
comment on column t_pw.shnr2 is '';
comment on column t_pw.shrId2 is '';
comment on column t_pw.shDate2 is '';
comment on column t_pw.shnr3 is '';
comment on column t_pw.shrId3 is '';
comment on column t_pw.shDate3 is '';
--批文表加注释
comment on table t_pw is '批文';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_dept;
create sequence s_t_lx;
create sequence s_t_pw;

基于工作流的企业批文审批系统设计与实现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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	yhbh varchar(100),--用户编号
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	deptId int,--部门
	isSp varchar(100)--是否有审批权限
);

部门表创建语句如下:


--部门表注释
create table t_dept(
	id int identity(1,1) primary key not null,--主键
	deptName varchar(100),--部门编号名称
	v1 varchar(100),--部门类别
	v2 varchar(100),--经理ID
	v3 varchar(100)--电话
);

批文类型表创建语句如下:


--批文类型表注释
create table t_lx(
	id int identity(1,1) primary key not null,--主键
	lxName varchar(100)--批文类型
);

批文表创建语句如下:


--批文表注释
create table t_pw(
	id int identity(1,1) primary key not null,--主键
	customerId int,--发起人
	toId int,--接收人
	lxId varchar(100),--批文类型
	pwName varchar(100),--文件标题
	v1 varchar(100),--批文紧急程度
	v7 varchar(100),--内容
	v2 varchar(100),--附件一
	v3 varchar(100),--附件二
	v4 varchar(100),--附件三
	v5 varchar(100),--状态
	shnr1 varchar(100),--备注
	shrId1 int,--审核人
	shDate1 datetime,--审核时间
	shnr2 varchar(100),--
	shrId2 int,--
	shDate2 datetime,--
	shnr3 varchar(100),--
	shrId3 int,--
	shDate3 datetime--
);

基于工作流的企业批文审批系统设计与实现登录后主页

基于工作流的企业批文审批系统设计与实现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_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 yhbh;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//部门
private Integer deptId;
//是否有审批权限
private String isSp;
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 getYhbh() {return yhbh;}
public void setYhbh(String yhbh) {this.yhbh = yhbh;}
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 Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getIsSp() {return isSp;}
public void setIsSp(String isSp) {this.isSp = isSp;}
}

部门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_dept")
public class Dept {
//主键
@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 deptName;
//部门类别
private String v1;
//经理ID
private String v2;
//电话
private String v3;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

批文类型javaBean创建语句如下:


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

//批文类型
@Table(name = "t_lx")
public class Lx {
//主键
@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 lxName;
public String getLxName() {return lxName;}
public void setLxName(String lxName) {this.lxName = lxName;}
}

批文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_pw")
public class Pw {
//主键
@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 lxId;
//文件标题
private String pwName;
//批文紧急程度
private String v1;
//内容
private String v7;
//附件一
private String v2;
//附件二
private String v3;
//附件三
private String v4;
//状态
private String v5;
//备注
private String shnr1;
//审核人
private Integer shrId1;
//审核时间
private Date shDate1;
//
private String shnr2;
//
private Integer shrId2;
//
private Date shDate2;
//
private String shnr3;
//
private Integer shrId3;
//
private Date shDate3;
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 getLxId() {return lxId;}
public void setLxId(String lxId) {this.lxId = lxId;}
public String getPwName() {return pwName;}
public void setPwName(String pwName) {this.pwName = pwName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getShnr1() {return shnr1;}
public void setShnr1(String shnr1) {this.shnr1 = shnr1;}
public Integer getShrId1() {return shrId1;}
public void setShrId1(Integer shrId1) {this.shrId1 = shrId1;}
public Date getShDate1() {return shDate1;}
public void setShDate1(Date shDate1) {this.shDate1 = shDate1;}
public String getShnr2() {return shnr2;}
public void setShnr2(String shnr2) {this.shnr2 = shnr2;}
public Integer getShrId2() {return shrId2;}
public void setShrId2(Integer shrId2) {this.shrId2 = shrId2;}
public Date getShDate2() {return shDate2;}
public void setShDate2(Date shDate2) {this.shDate2 = shDate2;}
public String getShnr3() {return shnr3;}
public void setShnr3(String shnr3) {this.shnr3 = shnr3;}
public Integer getShrId3() {return shrId3;}
public void setShrId3(Integer shrId3) {this.shrId3 = shrId3;}
public Date getShDate3() {return shDate3;}
public void setShDate3(Date shDate3) {this.shDate3 = shDate3;}
}

基于工作流的企业批文审批系统设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

用户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 yhbh;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//部门
private Integer deptId;
//是否有审批权限
private String isSp;
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 getYhbh() {return yhbh;}
public void setYhbh(String yhbh) {this.yhbh = yhbh;}
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 Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
public String getIsSp() {return isSp;}
public void setIsSp(String isSp) {this.isSp = isSp;}
}

部门javaBean创建语句如下:


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

//部门
public class Dept  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门编号名称
private String deptName;
//部门类别
private String v1;
//经理ID
private String v2;
//电话
private String v3;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

批文类型javaBean创建语句如下:


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

//批文类型
public class Lx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//批文类型
private String lxName;
public String getLxName() {return lxName;}
public void setLxName(String lxName) {this.lxName = lxName;}
}

批文javaBean创建语句如下:


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

//批文
public class Pw  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 lxId;
//文件标题
private String pwName;
//批文紧急程度
private String v1;
//内容
private String v7;
//附件一
private String v2;
//附件二
private String v3;
//附件三
private String v4;
//状态
private String v5;
//备注
private String shnr1;
//审核人
private Integer shrId1;
//审核时间
private Date shDate1;
//
private String shnr2;
//
private Integer shrId2;
//
private Date shDate2;
//
private String shnr3;
//
private Integer shrId3;
//
private Date shDate3;
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 getLxId() {return lxId;}
public void setLxId(String lxId) {this.lxId = lxId;}
public String getPwName() {return pwName;}
public void setPwName(String pwName) {this.pwName = pwName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getShnr1() {return shnr1;}
public void setShnr1(String shnr1) {this.shnr1 = shnr1;}
public Integer getShrId1() {return shrId1;}
public void setShrId1(Integer shrId1) {this.shrId1 = shrId1;}
public Date getShDate1() {return shDate1;}
public void setShDate1(Date shDate1) {this.shDate1 = shDate1;}
public String getShnr2() {return shnr2;}
public void setShnr2(String shnr2) {this.shnr2 = shnr2;}
public Integer getShrId2() {return shrId2;}
public void setShrId2(Integer shrId2) {this.shrId2 = shrId2;}
public Date getShDate2() {return shDate2;}
public void setShDate2(Date shDate2) {this.shDate2 = shDate2;}
public String getShnr3() {return shnr3;}
public void setShnr3(String shnr3) {this.shnr3 = shnr3;}
public Integer getShrId3() {return shrId3;}
public void setShrId3(Integer shrId3) {this.shrId3 = shrId3;}
public Date getShDate3() {return shDate3;}
public void setShDate3(Date shDate3) {this.shDate3 = shDate3;}
}

评论