activiti工作流数据库表介绍

 
    <dependencies>
        <!--日志包，方便看sql语句-->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.6.4</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.6.1</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>
        <!--mysql驱动包-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.37</version>
        </dependency>
        <dependency>
            <groupId>org.activiti</groupId>
            <artifactId>activiti-engine</artifactId>
            <version>5.22.0</version>
        </dependency>
 
        <dependency>
            <groupId>org.activiti</groupId>
            <artifactId>activiti-spring</artifactId>
            <version>5.22.0</version>
        </dependency>
    </dependencies>

 /**
     * 使用代码生成Activity需要的表
     */
    @Test
    public void createTable() {
        ProcessEngineConfiguration processEngineConfiguration =
                ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();
        processEngineConfiguration.setJdbcDriver("com.mysql.jdbc.Driver");
        processEngineConfiguration.setJdbcUrl("jdbc:mysql://localhost:3306/db_stuleave?characterEncoding=utf-8");
        processEngineConfiguration.setJdbcUsername("root");
        processEngineConfiguration.setJdbcPassword("root");
        /*参数可选项：
        1.DB_SCHEMA_UPDATE_TRUE如果表不存在则自动创建表
        2.DB_SCHEMA_UPDATE_FALSE不能自动创建表  需要表存在
        3.删除表再创建表
         */
        processEngineConfiguration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);
        //流程引擎对象
        ProcessEngine processEngine = processEngineConfiguration.buildProcessEngine();
        System.out.println(processEngine);
    }

<beans xmlns="http://www.springframework.org/schema/beans"
 
       xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
 
       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
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">
 
 
    <bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">
 
        <!-- 连接数据的配置 -->
 
        <property name="jdbcDriver" value="com.mysql.jdbc.Driver"></property>
 
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/db_stuleave?useUnicode=true&characterEncoding=utf8"></property>
 
        <property name="jdbcUsername" value="root"></property>
 
        <property name="jdbcPassword" value="root"></property>
 
        <!-- 没有表创建表 -->
 
        <property name="databaseSchemaUpdate" value="true"></property>
 
    </bean>
 
</beans>

 @Test
 
    public void createTable2() {
 
        ProcessEngineConfiguration processEngineConfiguration = ProcessEngineConfiguration.createProcessEngineConfigurationFromResource("activiti.cfg.xml");
 
        ProcessEngine processEngine = processEngineConfiguration.buildProcessEngine();
 
        System.out.println(processEngine);
 
 
    }

<bean id="dbcpdataSource" class="org.apache.commons.dbcp.BasicDataSource">
 
        <!--配置连接池属性-->
 
        <property name="driverClassName" value="${jdbc.driver}"/>
 
        <property name="url" value="${jdbc.url}"/>
 
        <property name="username" value="${jdbc.username}"/>
 
        <property name="password" value="${jdbc.password}"/>
 
    </bean>
 
    <bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">
 
       <property name="dataSource"  ref="dataSource"></property>
 
        <property name="databaseSchemaUpdate" value="true"></property>
 
    </bean>