1、Activiti 创建表

public class ActivitiTest

{

@Test

public void createTable()

{

ProcessEngineConfiguration configuration = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();

configuration.setJdbcDriver("com.mysql.jdbc.Driver")

.setJdbcUrl("jdbc:mysql://localhost:3306/activiti?useUnicode=true&characterEncoding=utf8")

.setJdbcUsername("root")

.setJdbcPassword("654321a");

/**

* ProcessEngineConfiguration.DB_SCHEMA_UPDATE_CREATE_DROP 先删除表在创建

* ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE 不能自动创建表，需要表存在

* ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE 如果没有表自动创建，存在就直接使用

*/

configuration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE);

ProcessEngine processEngine = configuration.buildProcessEngine();

System.out.println("processEngine:" + processEngine);

}

@Test

public void createTableByXml()

{

ProcessEngine processEngine = ProcessEngineConfiguration.createProcessEngineConfigurationFromResource("activiti.cfg.xml").buildProcessEngine();

System.out.println("processEngine:" + processEngine);

}

@Test

public void createTableByDefault()

{

ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();

System.out.println("processEngine:" + processEngine);

}

}

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:jee="http://www.springframework.org/schema/jee" xmlns:aop="http://www.springframework.org/schema/aop"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd

http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">

<!-- <bean id="dbProperties" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

<property name="locations">

<list>

<value>classpath:db.properties</value>

<value>file:activiti-rest.properties</value>

</list>

</property>

<property name="ignoreUnresolvablePlaceholders" value="true" />

<property name="ignoreResourceNotFound" value="true" />

</bean>

<bean id="dataSource"

class="org.springframework.jdbc.datasource.SimpleDriverDataSource">

<property name="driverClass" value="${jdbc.driver}" />

<property name="url" value="${jdbc.url}" />

<property name="username" value="${jdbc.username}" />

<property name="password" value="${jdbc.password}" />

</bean>

<bean id="transactionManager"

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="dataSource" />

</bean>

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">

<property name="dataSource" ref="dataSource" />

<property name="transactionManager" ref="transactionManager" />

<property name="databaseSchemaUpdate" value="true" />

<property name="mailServerHost" value="localhost" />

<property name="mailServerPort" value="5025" />

<property name="jobExecutorActivate" value="false" />

<property name="customFormTypes">

<list>

<bean class="org.activiti.rest.form.UserFormType"/>

<bean class="org.activiti.rest.form.ProcessDefinitionFormType"/>

<bean class="org.activiti.rest.form.MonthFormType"/>

</list>

</property>

</bean>

<bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean">

<property name="processEngineConfiguration" ref="processEngineConfiguration" />

</bean>

<bean id="repositoryService" factory-bean="processEngine" factory-method="getRepositoryService" />

<bean id="runtimeService" factory-bean="processEngine" factory-method="getRuntimeService" />

<bean id="taskService" factory-bean="processEngine" factory-method="getTaskService" />

<bean id="formService" factory-bean="processEngine" factory-method="getFormService" />

<bean id="historyService" factory-bean="processEngine" factory-method="getHistoryService" />

<bean id="managementService" factory-bean="processEngine" factory-method="getManagementService" />

<bean id="identityService" factory-bean="processEngine" factory-method="getIdentityService" /> -->

<bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">

<property name="jdbcDriver" value="com.mysql.jdbc.Driver" />

<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/activiti?useUnicode=true&amp;characterEncodeing=utf8" />

<property name="jdbcUsername" value="root" />

<property name="jdbcPassword" value="654321a" />

<property name="databaseSchemaUpdate" value="true" />

</bean>

</beans>

建表情况

资源库流程规则表

act_re_deployment 部署信息表

act_re_model 流程设计模型部署表

act_re_procdef 流程定义数据表

运行时数据库表

act_ru_execution 运行时流程执行实例表

act_ru_identitylink 运行时流程人员表，主要存储任务节点与参与者的相关信息

act_ru_task 运行时任务节点表

act_ru_variable 运行时流程变量数据表

历史数据库表

act_hi_actinst 历史节点表

act_hi_attachment 历史附件表

act_hi_comment 历史意见表

act_hi_identitylink 历史流程人员表

act_hi_detail 历史详情表，提供历史变量的查询

act_hi_procinst 历史流程实例表

act_hi_taskinst 历史任务实例表

act_hi_varinst 历史变量表

组织机构表

act_id_group 用户组信息表

act_id_info 用户扩展信息表

act_id_membership 用户与用户组对应信息表

act_id_user 用户信息表

这四张表很常见，基本的组织机构管理，关于用户认证方面建议还是自己开发一套

通用数据表

act_ge_bytearray 二进制数据表

act_ge_property 属性数据表存储整个流程引擎级别的数据,初始化表结构时，会默认插入三条记录