Activiti7 创建表【二】

灰太狼 2024-03-22 21:36 46阅读 0赞

### Activiti 7系列文章目录 ###

[文章代码下载][Link 1]

[Activiti7 工作流设计器【一】][Activiti7]  
[Activiti7 创建表【二】][Activiti7 1]  
[Activiti7 表结构介绍 【三】][Activiti7 _]  
[Activiti7 设计器创建流程 【四】][Activiti7 _ 1]  
[Activiti7 部署流程【五】][Activiti7 2]  
[Activiti7 查询流程【六】][Activiti7 3]  
[Activiti7 删除流程【七】][Activiti7 4]  
[Activiti7 生成SVG图片【八】][Activiti7 _SVG]  
[Activiti7 发起任务【九】][Activiti7 5]  
[Activiti7 查询任务执行流程图【十】][Activiti7 6]  
[Activiti7 完成任务【十一】][Activiti7 7]  
[Activiti7 历史数据【十二】][Activiti7 8]  
[Activiti7 任务办理人、委派、转办、持有人、候选人、候选人组、审批意见【十三】][Activiti7 9]  
[Activiti7 监听器【十四】][Activiti7 10]  
[Activiti7 流程变量【十五】][Activiti7 11]  
[Activiti7 网关Gateway【十六】][Activiti7 _Gateway]  
[Activiti7 整合SpringBoot【十七】][Activiti7 _SpringBoot]  
[Activiti7 多种任务类型【十八】][Activiti7 12]  
[Activiti7 子流程【十九】][Activiti7 13]  
[Activiti7 流程回退、流程拒绝【二十】][Activiti7 14]

04、Activiti7 三种方式初始化数据库

### 导入依赖包 ###

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.7</version>
    </parent>
    
    <dependency>
        <groupId>org.activiti</groupId>
        <artifactId>activiti-spring-boot-starter</artifactId>
        <version>7.0.0.GA</version>
    </dependency>
    
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>
    
    <dependency>
         <groupId>org.springframework.boot</groupId>
         <artifactId>spring-boot-starter-test</artifactId>
     </dependency>
    
     <dependency>
         <groupId>org.junit.jupiter</groupId>
         <artifactId>junit-jupiter</artifactId>
         <scope>test</scope>
     </dependency>

### 代码方式 ###

启动即可自动创建表：但是数据库需要自己创建，数据库名称：activiti

@Test
    public void testInit(){
        
        ProcessEngineConfiguration config = ProcessEngineConfiguration
                .createStandaloneInMemProcessEngineConfiguration();
    
        // 连接数据库的配置
        config.setJdbcDriver("com.mysql.cj.jdbc.Driver");
        config.setJdbcUrl("jdbc:mysql://localhost:3306/activiti?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false&nullCatalogMeansCurrent=true");
        config.setJdbcUsername("root");
        config.setJdbcPassword("root");
    
        config.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);
        //工作流的核心对象，ProcessEnginee对象
        ProcessEngine processEngine = config.buildProcessEngine();
        System.out.println("processEngine:"+processEngine);
    
    }

### 配置文件方式 ###

首先在resources文件夹下创建：activiti.cfg.xml  
数据库名称：activiti，需要自己手动创建数据库

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans.xsd">
    
        
        
        <bean id="processEngineConfiguration"
              class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">
            <property name="jdbcDriver" value="com.mysql.cj.jdbc.Driver"/>
            <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/activiti?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false&nullCatalogMeansCurrent=true"/>
            <property name="jdbcUsername" value="root"/>
            <property name="jdbcPassword" value="root"/>
            
            <property name="databaseSchemaUpdate" value="true"/>
        </bean>
    
    </beans>

执行下面代码即可自动创建表：getDefaultProcessEngine方法中会默认加载上面的配置文件：activiti.cfg.xml，有兴趣的同学可以点进去看看源码，会看到有个默认名字的。。。。

@Test
    public void testInitByCfg(){
        
        //默认会加载resources/activiti.cfg.xml
        ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();
        System.out.println(processEngine);
    }

### 手动导入 ###

找到项目自动下载的依赖包位置，按照如下图位置找到即可，我这里是使用的mysql  
另外需要注意的是：导入的时候engine和history两个都需要的！！！  
![在这里插入图片描述][c9ea3f96f1de41c1b2a123aa90d56c56.png]

### 数据库表 ###

![在这里插入图片描述][9a656e238abd42f18884130068bbf6f1.png]

[Link 1]: https://item.taobao.com/item.htm?ft=t&id=731521858952
[Activiti7]: https://blog.csdn.net/imjcoder/article/details/131960788
[Activiti7 1]: https://blog.csdn.net/imjcoder/article/details/131961178
[Activiti7 _]: https://blog.csdn.net/imjcoder/article/details/131961740
[Activiti7 _ 1]: https://blog.csdn.net/imjcoder/article/details/131961870
[Activiti7 2]: https://blog.csdn.net/imjcoder/article/details/131962201
[Activiti7 3]: https://blog.csdn.net/imjcoder/article/details/131962676
[Activiti7 4]: https://blog.csdn.net/imjcoder/article/details/131962897
[Activiti7 _SVG]: https://blog.csdn.net/imjcoder/article/details/131963020
[Activiti7 5]: https://blog.csdn.net/imjcoder/article/details/131963117
[Activiti7 6]: https://blog.csdn.net/imjcoder/article/details/131963429
[Activiti7 7]: https://blog.csdn.net/imjcoder/article/details/131973436
[Activiti7 8]: https://blog.csdn.net/imjcoder/article/details/131974783
[Activiti7 9]: https://blog.csdn.net/imjcoder/article/details/131980252
[Activiti7 10]: https://blog.csdn.net/imjcoder/article/details/131980411
[Activiti7 11]: https://blog.csdn.net/imjcoder/article/details/131980452
[Activiti7 _Gateway]: https://blog.csdn.net/imjcoder/article/details/131980479
[Activiti7 _SpringBoot]: https://blog.csdn.net/imjcoder/article/details/131980531
[Activiti7 12]: https://blog.csdn.net/imjcoder/article/details/131980636
[Activiti7 13]: https://blog.csdn.net/imjcoder/article/details/131980676
[Activiti7 14]: https://blog.csdn.net/imjcoder/article/details/131980731
[c9ea3f96f1de41c1b2a123aa90d56c56.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/3a502a5a3e7d48238840dec681f5ef21.png
[9a656e238abd42f18884130068bbf6f1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/1ac6860545f343d5acb4f1f03f1fd738.png