工作流 Activiti7-3.springboot与Activiti7的整合
image.png
image.png
image.png
下面附上配置信息:
server: port: 8081spring: application.name: activiti datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=UTF-8&useSSL=true&serverTimezone=UTC username: root password: 12345678 activiti: #activiti 历史表的创建 history-level: full db-history-used: true #activiti 关闭自动部署,就是在resource下的文件检查并部署 check-process-definitions: false
注意: 因为Activiti有一些bug,其中有一个bug就是流程表中,添加流程时候总是会多生成一条数据,例如:
image.png
在流程表发布的时候总是多一条SpringAutoDeployment的数据
但是在M4以下的版本就不会有问题,而M4的版本好像只有阿里云的maven仓库中下载的才行,所以这里需要把maven镜像加上阿里云,链接为:https://maven.aliyun.com/mvn/guide
maven配置:
<dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-security</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.activiti</groupId> <artifactId>activiti-spring-boot-starter</artifactId> <version>7.1.0.M4</version> </dependency> <dependency> <groupId>org.activiti.dependencies</groupId> <artifactId>activiti-dependencies</artifactId> <version>7.1.0.M4</version> <type>pom</type> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <optional>true</optional> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> </dependencies>
数据库配置和activiti都配置好之后,我们重启程序,然后再去数据库看,就会发现activiti已经自动生成了很多的表:
image.png
注意Activiti7的一个bug问题
如果ACT_RE_DEPLOYMENT表缺失字段则执行这个sql,如果已有字段,则证明该bug已经被修复:
alter table ACT_RE_DEPLOYMENT add column PROJECT_RELEASE_VERSION_ varchar(255) DEFAULT NULL;alter table ACT_RE_DEPLOYMENT add column VERSION_ varchar(255) DEFAULT NULL;
下面是创建我们练习用到的user表:
SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ 创建用户表-- ----------------------------DROP TABLE IF EXISTS `user`;CREATE TABLE `user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(32) DEFAULT NULL COMMENT '姓名', `address` varchar(64) DEFAULT NULL COMMENT '联系地址', `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '账号', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码', `roles` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '角色', PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;-- ------------------------------ 填充用户表-- ----------------------------INSERT INTO `user` VALUES ('1', 'admincn', 'beijing', 'admin', '$2a$10$gw46pmsOVYO.smHYQ2jH.OoXoe.lGP8OStDkHNs/E74GqZDL5K7ki', 'ROLE_ACTIVITI_ADMIN');INSERT INTO `user` VALUES ('2', 'bajiecn', 'shanghang', 'bajie', '$2a$10$gw46pmsOVYO.smHYQ2jH.OoXoe.lGP8OStDkHNs/E74GqZDL5K7ki', 'ROLE_ACTIVITI_USER,GROUP_activitiTeam,g_bajiewukong');INSERT INTO `user` VALUES ('3', 'wukongcn', 'beijing', 'wukong', '$2a$10$gw46pmsOVYO.smHYQ2jH.OoXoe.lGP8OStDkHNs/E74GqZDL5K7ki', 'ROLE_ACTIVITI_USER,GROUP_activitiTeam');INSERT INTO `user` VALUES ('4', 'salaboycn', 'beijing', 'salaboy', '$2a$10$gw46pmsOVYO.smHYQ2jH.OoXoe.lGP8OStDkHNs/E74GqZDL5K7ki', 'ROLE_ACTIVITI_USER,GROUP_activitiTeam');-- ------------------------------ 动态表单数据存储-- ----------------------------DROP TABLE IF EXISTS `formdata`;CREATE TABLE `formdata` ( `PROC_DEF_ID_` varchar(64) DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `FORM_KEY_` varchar(255) DEFAULT NULL, `Control_ID_` varchar(100) DEFAULT NULL, `Control_VALUE_` varchar(2000) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
作者:那钱有着落吗
链接:https://www.jianshu.com/p/a229849b2b0b