初始化數(shù)據(jù)庫

方法一：執(zhí)行sql腳本文件

sql位置：activiti-6\database\create\activiti.mysql.create.*.sql文件

方法二：JAVA代碼創(chuàng)建

import org.activiti.engine.ProcessEngine; import org.activiti.engine.ProcessEngineConfiguration; import org.junit.Test;/*** Activity 初始化** @author Yang*/ public class ActivitiInitTableTest {@Testpublic void init() {//創(chuàng)建引擎配置對(duì)象ProcessEngineConfiguration configration = ProcessEngineConfiguration.createStandaloneInMemProcessEngineConfiguration();//創(chuàng)建流程引擎對(duì)象//目標(biāo)生成數(shù)據(jù)庫表configration.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/activiti?nullCatalogMeansCurrent=true");configration.setJdbcDriver("com.mysql.cj.jdbc.Driver");configration.setJdbcUsername("root");configration.setJdbcPassword("root");//設(shè)置表的生成策略configration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);ProcessEngine processEngine = configration.buildProcessEngine();System.out.println(processEngine.getName());}}

增加mysql表注釋字段注釋

數(shù)據(jù)庫字段說明：
地址1、 地址2、 地址3
把原文地址整理為了sql文件 。
例：

ALTER TABLE `act_hi_actinst` MODIFY COLUMN `ID_` VARCHAR ( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '主鍵ID' FIRST,MODIFY COLUMN `PROC_DEF_ID_` VARCHAR ( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '流程定義ID' AFTER `ID_`,MODIFY COLUMN `PROC_INST_ID_` VARCHAR ( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '流程實(shí)例ID' AFTER `PROC_DEF_ID_`,MODIFY COLUMN `EXECUTION_ID_` VARCHAR ( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '執(zhí)行實(shí)例ID' AFTER `PROC_INST_ID_`,MODIFY COLUMN `ACT_ID_` VARCHAR ( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '節(jié)點(diǎn)ID' AFTER `EXECUTION_ID_`,MODIFY COLUMN `TASK_ID_` VARCHAR ( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '任務(wù)實(shí)例ID' AFTER `ACT_ID_`,MODIFY COLUMN `CALL_PROC_INST_ID_` VARCHAR ( 64 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '調(diào)用外部的流程實(shí)例ID' AFTER `TASK_ID_`,MODIFY COLUMN `ACT_NAME_` VARCHAR ( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '節(jié)點(diǎn)名稱' AFTER `CALL_PROC_INST_ID_`,MODIFY COLUMN `ACT_TYPE_` VARCHAR ( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '節(jié)點(diǎn)類型' AFTER `ACT_NAME_`,MODIFY COLUMN `ASSIGNEE_` VARCHAR ( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '簽收人' AFTER `ACT_TYPE_`,MODIFY COLUMN `START_TIME_` datetime ( 3 ) NOT NULL COMMENT '開始時(shí)間' AFTER `ASSIGNEE_`,MODIFY COLUMN `END_TIME_` datetime ( 3 ) NULL DEFAULT NULL COMMENT '結(jié)束時(shí)間' AFTER `START_TIME_`,MODIFY COLUMN `DURATION_` BIGINT ( 20 ) NULL DEFAULT NULL COMMENT '耗時(shí)，毫秒值' AFTER `END_TIME_`,MODIFY COLUMN `DELETE_REASON_` VARCHAR ( 4000 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '刪除原因' AFTER `DURATION_`,MODIFY COLUMN `TENANT_ID_` VARCHAR ( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '租戶ID' AFTER `DELETE_REASON_`, COMMENT = '歷史行為表';

PS：其他表注釋請(qǐng)見資源文件

activiti學(xué)習(xí)文檔

1、版本6官方API
2、Activiti6.0教程
3、Activiti6.0工作流使用說明文檔v1.0.pdf
4、視頻講解 提取密碼： r6pc

總結(jié)

以上是生活随笔為你收集整理的Activiti学习记录 Activiti初始化数据库、Activiti6增加表注释字段注释的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。