feat: 新增数采数据源、储丝三方视图数据源；配置测试三数据源；区分开发、生产环境

zhuguifei

2026-04-03 a2077e70da78d28089c40ad65291885aad58b857

feat: 新增数采数据源、储丝三方视图数据源；配置测试三数据源；区分开发、生产环境

 RuoYi-Vue-Plus/ruoyi-admin/src/main/resources/application-dev.yml

@@ -45,7 +45,7 @@
        master:
          type: ${spring.datasource.type}
          driverClassName: org.postgresql.Driver
          url: jdbc:postgresql://192.168.2.26:5432/postgres?currentSchema=public&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true
          url: jdbc:postgresql://127.0.0.1:5433/postgres?currentSchema=public&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true
          username: postgres
          password: 123456
      #        master:
@@ -64,10 +64,17 @@
#          url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true
#          username:
#          password:
        oracle:
        oracle_zs:
          lazy: true
          type: ${spring.datasource.type}
          driverClassName: oracle.jdbc.OracleDriver
          url: jdbc:oracle:thin:@192.168.2.26:1521:orcl
          url: jdbc:oracle:thin:@127.0.0.1:1521:xe
          username: appusr
          password: lanbaoit
        oracle_sc:
          type: ${spring.datasource.type}
          driverClassName: oracle.jdbc.OracleDriver
          url: jdbc:oracle:thin:@127.0.0.1:1521:xe
          username: gfsc
          password: lbit
#        postgres:

 RuoYi-Vue-Plus/ruoyi-admin/src/main/resources/application-prod.yml

@@ -4,7 +4,7 @@
--- # 监控中心配置
spring.boot.admin.client:
  # 增加客户端开关
  enabled: true
  enabled: false
  url: http://localhost:9090/admin
  instance:
    service-host-type: IP
@@ -16,7 +16,7 @@

--- # snail-job 配置
snail-job:
  enabled: true
  enabled: false
  # 需要在 SnailJob 后台组管理创建对应名称的组,然后创建任务的时候选择对应的组,才能正确分派任务
  group: "ruoyi_group"
  # SnailJob 接入验证令牌 详见 script/sql/ry_job.sql `sj_group_config`表
@@ -47,12 +47,10 @@
        # 主库数据源
        master:
          type: ${spring.datasource.type}
          driverClassName: com.mysql.cj.jdbc.Driver
          # jdbc 所有参数配置参考 https://lionli.blog.csdn.net/article/details/122018562
          # rewriteBatchedStatements=true 批处理优化 大幅提升批量插入更新删除性能(对数据库有性能损耗 使用批量操作应考虑性能问题)
          url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true
          username: root
          password: root
          driverClassName: org.postgresql.Driver
          url: jdbc:postgresql://10.39.186.6:5432/postgres?currentSchema=public&serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=true&autoReconnect=true&reWriteBatchedInserts=true
          username: postgres
          password: 123456
#        # 从库数据源
#        slave:
#          lazy: true
@@ -61,12 +59,19 @@
#          url: jdbc:mysql://localhost:3306/ry-vue?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&autoReconnect=true&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true
#          username:
#          password:
#        oracle:
#          type: ${spring.datasource.type}
#          driverClassName: oracle.jdbc.OracleDriver
#          url: jdbc:oracle:thin:@//localhost:1521/XE
#          username: ROOT
#          password: root
        oracle_zs:
          type: ${spring.datasource.type}
          driverClassName: oracle.jdbc.OracleDriver
          url: jdbc:oracle:thin:@10.39.185.2:1521:orcl
          username: aerotop
          password: aerotop
        oracle_sc:
          lazy: true
          type: ${spring.datasource.type}
          driverClassName: oracle.jdbc.OracleDriver
          url: jdbc:oracle:thin:@10.39.186.5:1521:orcl
          username: gfsc
          password: lbit
#        postgres:
#          type: ${spring.datasource.type}
#          driverClassName: org.postgresql.Driver
@@ -99,13 +104,13 @@
spring.data:
  redis:
    # 地址
    host: localhost
    # 端口，默认为6379
    port: 6379
    host: 10.39.186.3
    # 端口，默认为6677
    port: 6677
    # 数据库索引
    database: 0
    # redis 密码必须配置
    password: ruoyi123
    # password: ruoyi123
    # 连接超时时间
    timeout: 10s
    # 是否开启ssl