初始化activiti数据库

首先要把activiti相关的环境加进来

<dependency>
    <groupId>org.activiti</groupId>
    <artifactId>activiti-engine</artifactId>
    <version>5.19.0</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.26</version>
</dependency>
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.10</version>
    <scope>test</scope>
</dependency>

创建activiti数据库activiti，并使用ProcessEngineConfiguration.setDatabaseSchemaUpdate来创建表
setDatabaseSchemaUpdate的参数有以下几种：

ProcessEngineConfiguration的jdbc默认是h2
protected String jdbcDriver = "org.h2.Driver";
protected String jdbcUrl = "jdbc:h2:tcp://localhost/activiti";
protected String jdbcUsername = "sa";
protected String jdbcPassword = "";

示例:

/** 初始化activiti工作流的23张表 */
@Test
public void createTable() {
    ProcessEngineConfiguration processEngineConfiguration = ProcessEngineConfiguration
            .createStandaloneProcessEngineConfiguration();
    // 连接数据库的配置
    processEngineConfiguration.setJdbcDriver("com.mysql.jdbc.Driver");
    processEngineConfiguration
            .setJdbcUrl("jdbc:mysql://localhost:3306/activiti?useUnicode=true&characterEncoding=utf8");
    processEngineConfiguration.setJdbcUsername("root");
    processEngineConfiguration.setJdbcPassword("123456");
 
    /**
     * DB_SCHEMA_UPDATE_FALSE = "false";不能自动创建表，需要表存在
     * DB_SCHEMA_UPDATE_CREATE_DROP = "create-drop";先删除表再创建表
     * DB_SCHEMA_UPDATE_TRUE = "true";如果表不存在，自动创建表
     */
    processEngineConfiguration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);
    // 工作流的核心对象，ProcessEnginee对象
    ProcessEngine processEngine = processEngineConfiguration.buildProcessEngine();
    System.out.println("processEngine:" + processEngine);
}

本文参考网络