springBoot里整合activity，启动后生成表

最新推荐文章于 2024-10-07 15:22:57 发布

原创最新推荐文章于 2024-10-07 15:22:57 发布 · 8.4k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#springBoot和activity

工作流专栏收录该内容

7 篇文章

订阅专栏

本文详细介绍了在Spring框架下如何配置Activiti流程引擎，包括数据源、事务管理器的设置，以及如何自定义字体和数据库类型。同时，提供了创建用户、组和成员关系视图的SQL语句，以便于在Activiti中进行用户和组织信息的同步。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.dh.zhdj_v2.config;

import org.activiti.spring.SpringProcessEngineConfiguration;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.ApplicationContext;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.PlatformTransactionManager;

import javax.sql.DataSource;

/**
 * Created by Administrator on 2018/5/4.
 */
@Configuration
public class ActivitiConfig {

    @Autowired
    PlatformTransactionManager transactionManager;

    @Autowired
    ApplicationContext applicationContext;

    @Bean
    public SpringProcessEngineConfiguration getProcessEngineConfiguration() {
        DataSource dataSource = applicationContext.getBean(DataSource.class);
        SpringProcessEngineConfiguration config =
                new SpringProcessEngineConfiguration();
        config.setDataSource(dataSource);
          //config.setDbHistoryUsed(false);
        config.setDbIdentityUsed(false);
        config.setTransactionManager(transactionManager);
        //添加字体
        config.setActivityFontName("宋体");
        config.setLabelFontName("宋体");
        config.setAnnotationFontName("宋体");
        config.setDatabaseType("oracle");
        // config.getJobExecutor();
        //第一生成表要启动下面配置，以后重新生成create改为drop-create
        //如果有表不存在就更新添加
         //  config.setDatabaseSchemaUpdate("create");
        //设置Schema为ACT，他会字段添加表
        // config.setDatabaseSchema("ACT");
        return config;
    }

}

//下面一定要写不扫描这个类

@SpringBootApplication(exclude = {org.activiti.spring.boot.SecurityAutoConfiguration.class})
@Transactional(rollbackFor = Exception.class)
@MapperScan("com.dh.zhdj.modules.*.mapper")
@EnableRabbit
public class ZhdjApplication {
    public static void main(String[] args) {
        SpringApplication.run(ZhdjApplication.class, args);
    }

    @Primary
    @Bean
    public TaskExecutor primaryTaskExecutor() {
        ThreadPoolTaskExecutor executor = new ThreadPoolTaskExecutor();
        return executor;
    }
}

-- 方案1：根据业务需求，删除工作量的三张表，对应你用户表，创建视图，

--方案2：用户和角色更新时，更新工作流里面的用户和组织信息
CREATE OR REPLACE VIEW ACT_ID_GROUP AS
SELECT r.role_name AS ID_,NULL AS REV_,r.full_name AS NAME_,NULL AS TYPE_ FROM sys_role r;
comment on table ACT_ID_GROUP is '用户组信息表';
comment on column ACT_ID_GROUP.REV_ is '乐观锁';
comment on column ACT_ID_GROUP.NAME_ is '节点名称';
comment on column ACT_ID_GROUP.TYPE_ is '节点类型';

CREATE OR REPLACE VIEW ACT_ID_MEMBERSHIP AS
SELECT u.user_name AS USER_ID_,r.role_name AS GROUP_ID_ FROM sys_user u join sys_user_role ur ON ur.user_id = u.id JOIN sys_role r ON r.id = ur.role_id;
comment on table ACT_ID_MEMBERSHIP is '用户与分组对应信息表';
comment on column ACT_ID_MEMBERSHIP.USER_ID_ is '用户ID';
comment on column ACT_ID_MEMBERSHIP.GROUP_ID_ is '用户组ID';

CREATE OR REPLACE VIEW ACT_ID_USER AS
SELECT
au.user_name AS ID_,
NULL AS REV_,
concat('first_',au.full_name) AS FIRST_,
concat('last_',au.full_name) AS LAST_,
au.email AS EMAIL_,
au.user_pwd AS PWD_,
NULL AS PICTURE_ID_
FROM sys_user au;
comment on table ACT_ID_USER is '用户信息表';
comment on column ACT_ID_USER.REV_ is '乐观锁';
comment on column ACT_ID_USER.FIRST_ is '姓';
comment on column ACT_ID_USER.LAST_ is '名';
comment on column ACT_ID_USER.EMAIL_ is 'EMAIL_';
comment on column ACT_ID_USER.PWD_ is '密码';
comment on column ACT_ID_USER.PICTURE_ID_ is '图片ID';