SpringBoot多数据源配置

最新推荐文章于 2024-03-26 19:41:59 发布

张~~~

最新推荐文章于 2024-03-26 19:41:59 发布

阅读量1.3k

点赞数 1

文章标签： java

本文链接：https://blog.csdn.net/zhang1587423114/article/details/131677618

版权

配置文件

spring:
  datasource:
    dynamic:
      primary: master #设置默认的数据源或者数据源组,默认值即为master
      strict: false #设置严格模式,默认false不启动. 启动后在未匹配到指定数据源时候会抛出异常,不启动则使用默认数据源.
      datasource:
        master:
          driver-class-name:  com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://10.164.15.38/mpaas_app?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=CTT&allowPublicKeyRetrieval=true&allowMultiQueries=true
          username: root
          password: Haier123!
        crm:
          driver-class-name:  com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://10.164.15.36:3306/hummingbird_crm?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=CTT&allowPublicKeyRetrieval=true
          username: fengniao
          password: Fn20200721$
        fn:
          driver-class-name:  com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://10.164.15.36:3306/finance?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=CTT&allowPublicKeyRetrieval=true
          username: fengniao
          password: Fn20200721$
        hd:
          driver-class-name:  oracle.jdbc.driver.OracleDriver
          username: crmp_query
          password: CrMp_19402#
          url: jdbc:oracle:thin:@10.164.9.6:1521/newbutterfly
        bpm:
          driver-class-name:  com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://10.164.15.36:3306/agilebpm?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=CTT&allowPublicKeyRetrieval=true
          username: fengniao
          password: Fn20200721$
  redis:
    database: 1
    host: 172.19.219.61
    port: 6379
    password: Haier123!

redisCore:
  database: 1
  host: 10.164.15.36
  port: 6379
  password: Humm!nG13i&D

redisCoreForUniHome:
  database: 1
  host: 10.164.15.36
  port: 6379
  password: Humm!nG13i&D

#==============================================xxl相关=================================================
xxl:
  job:
    admin:
      addresses: http://10.164.15.36:9721/xxl-job-admin
    executor:
      appname: mpaas-app
      address: 10.164.15.36:9721
      ip: 10.164.15.36
      port: 8133
      logpath: logs/mpaas-app-job/task-log
      logretentiondays: 3
    accessToken:

#==============================================Feign相关=================================================
#feign配置
feign:
  crm: http://10.164.15.36:8000
  upms: http://10.164.15.36:8000
  sms: http://127.0.0.1:8310
  zq: http://10.164.15.36:8000
  fftask: http://127.0.0.1:8112

# app内部用户修改密码时 显示的系统名称
company:
  system:
#      '蜂鸟,蝴蝶,蜜蜂'

appId: 270
roleId: 10135

rocktmq:
  nameserver: 10.164.15.36:9876
  topicName: fftask_calendar
  groupName: fftask_calendar_group
  scheduleTopicName: schedule_home_count
  schedulegroupName: schedule_home_count_group

app-info:
  business-card:
    appletName: 我的名片
    appId: 2020113000003333
    appletIcon: https://appuat.mirrorftech.com/icon/vfill3.png
    appletUrl: pages/index/index
  archives:
    applet-name: 我的档案
    app-id: 2020113000005555
    applet-icon: https://appuat.mirrorftech.com/icon/vfill3.png
    applet-url: pages/index/index

#==============================================日历调用rc相关=================================================

save_calender_url: http://10.166.8.14:8080/restcloud/rest/calendar/server/add
del_calender_url: http://10.166.8.14:8080/restcloud/rest/calendar/server/del
update_calender_url: http://10.166.8.14:8080/restcloud/rest/calendar_server/update
query_calender_the_day_detail_url: http://10.166.8.14:8080/restcloud/rest/calendar/server/query/details?creator_number={creator_number}&intraday_date={intraday_date}
query_calender_the_day_meet_url: http://10.166.8.14:8080/restcloud/rest/calendar/server/query?start_time={start_time}&end_time={end_time}&user_number_list={user_number_list}
query_calender_server_time_url: http://10.166.8.14:8080/restcloud/rest/calendar/server/query/time?start_time={start_time}&end_time={end_time}
save_two_calender_url: http://10.166.8.14:8080/restcloud/rest/calendar/server/secondary/confirmation
query_calender_holiday: http://10.166.8.14:8080/restcloud/rest/calendar/server/query/holiday?start_time={start_time}&end_time={end_time}
query_calender_year: http://10.166.8.14:8080/restcloud/rest/calendar/server/query/year?year={year}
query_calender_start_time: http://10.166.8.14:8080/restcloud/rest/calendar/server/query/startTime?cycle_start_time={cycle_start_time}
app_key: 60482fc458b0864089cd370f

#==============================================企业查询调用rc相关=================================================

report_app_key: 5fc62d7312cf1a3f1a220f22
report_search_key: http://10.164.9.15:8080/restcloud/bgreport/ECIV4/Search

#==============================================数据指标相关=================================================

indicators_appkey: 5fc62d7312cf1a3f1a220f22
indicators_url: http://10.164.9.15:8080/restcloud/hryf/toufang/query

#==============================================蝴蝶数据库配置相关=================================================

hd:
  database:
    config: test

#==============================================每天可发送的短信验证码数量=================================================

phone:
  code:
    num: 5
  request:
    num: 5

#==============================================oss=================================================

oss:
  valid:
    time: 10
  access:
    time: 1800
  va:
    time: 1500
  environment:
    test/mediaconvert/


#==============================================云屋千里眼=================================================

cloud:
  house:
    compId: 255586
    compSecret: 45fb2ca7b0bc449aace8f8326984f905
    appId: 9jsefkes9v
  create:
    url: https://www.cloudroom.com/CLOUDROOM-API/room/create
  delete:
    url: https://www.cloudroom.com/CLOUDROOM-API/room/delete
  online_users_num:
    url: https://www.cloudroom.com/CLOUDROOM-API/room/onlineUsersNum/query
  online_members:
    url: https://www.cloudroom.com/CLOUDROOM-API/room/onlineMembers/query
  net_disk:
    url: https://www.cloudroom.com/CLOUDROOM-API/netDisk/query
  net_disk_del:
    url: https://www.cloudroom.com/CLOUDROOM-API/netDisk/delete


#==============================================钉钉=================================================

dingTalk:
  appkey: dingfhcnhe8fysmv3j57
  appsecret: NsAxZZmo_7pEEKlHg4uT2FA77y7Br3_EozCoUq65mLY6BU3QH91Dz9d6caWNFLlH
  corpid: ding9f71dd70c3adb557
  maxTripNum: 3

#== 保理 ==#
# factoring:
#   appkey: dingvwnnizr8atgka7vh
#   appsecret: _6E4FtMQrpgsWk-jdoNi0D8vLd76YezjqJ744v6GG7Mk3LYYYRwTwgB_LSEHFZaL
#   corpid: ding16df2fd7d750b321ee0f45d8e4f7c288

#==============================================集团=================================================

thirdparty:
  jksFilePath: /home/appuat/cert/haierfinancial.jks
  alias: mykey
  jksPassword: 123123
  aliasPassword: 123123

#===============================================商旅===================================================

hfmpaas:
  hoDoMeter: 2020113000141414

#===============================================MQTT===================================================

mqtt:
  clientId: GID_NORMAL_TOPIC_GRP@@@mpaas_server_uat_cq
  group: GID_UT1
  time: 5
  type: Uat

thread:
  sleep: 3000


#===============================================agilebpm===================================================

bpm:
  rest:
    ip: http://10.164.15.36:8022/bpm
    instance:
      #发起工作流
      start: ${bpm.rest.ip}/instance/doAction
      getInstanceIdTaskId: ${bpm.rest.ip}/task/getInstanceIdTaskId?bizKey=%s
      getUrl: http://10.164.15.36:8022/agilebpm-ui/bpm/instance/instanceImageDialog.html?instanceId=%s
      getIdsByBizKey: ${bpm.rest.ip}/instance/getIdsByBizKey?bizKey=%s
      getById: ${bpm.rest.ip}/instance/getById?id=%s
      delInstanceById: ${bpm.rest.ip}/instance/delete?id=%s
      #根据bizkey查询实例数量
      bpmTaskGetInstanceListByBizIds: ${bpm.rest.ip}/instance/getInstanceListByBizIds?bizKey=%s
    task:
      #审核
      doAction: ${bpm.rest.ip}/task/doAction
      getTaskNode: ${bpm.rest.ip}/task/getTaskNode?bizKey=%s
      getFlowIsStart: ${bpm.rest.ip}/task/getFlowIsStart?bizKey=%s
      getCanBackHistoryNodes: ${bpm.rest.ip}/task/getCanBackHistoryNodes?bizKey=%s
      assignTask: ${bpm.rest.ip}/task/assignTask?taskId=%s&userName=%s&userId=%s
      # 根据taskId查询当前是否可审批
      getTaskId: ${bpm.rest.ip}/task/getByTaskId?taskId=%s 
    my:
      #审核历史
      getOpinion: ${bpm.rest.ip}/instance/getOpinion/override
      addOpinion: ${bpm.rest.ip}/instance/addOpinion?bpmTaskOpinion=%s

#商旅出差申请一级事业部领导
#1. 审批人为张磊的 -->>> 抄送王冰然
#2. 审批人为陈宝泉的 -->>> 抄送张磊、王冰然
#3. 其余人员发起无需抄送
dingtalkEvectionApply:
  makeCopy: "{'166':'60','167':'166,60'}"


system:
  homeSlideShowList:
    - slideShowName: 轮播图1
 #https://hftemp.oss-cn-shanghai.aliyuncs.com/appBackstage/pic1.png
      mobileIcon: https://appuat.mirrorftech.com/icon/banner1.jpg
      mobileXIcon: https://appuat.mirrorftech.com/icon/banner1_X.jpg
      iPadIcon: https://appuat.mirrorftech.com/icon/banner1_iPad.jpg
      jumpUrl: 
    - slideShowName: 轮播图2
# https://hftemp.oss-cn-shanghai.aliyuncs.com/appBackstage/pic2.png    
      mobileIcon: https://appuat.mirrorftech.com/icon/banner2.jpg
      mobileXIcon: https://appuat.mirrorftech.com/icon/banner2_X.jpg
      iPadIcon: https://appuat.mirrorftech.com/icon/banner2_iPad.jpg
      jumpUrl: 
    - slideShowName: 轮播图3
#https://hftemp.oss-cn-shanghai.aliyuncs.com/appBackstage/pic3.png
      mobileIcon: https://appuat.mirrorftech.com/icon/banner3.jpg
      mobileXIcon: https://appuat.mirrorftech.com/icon/banner3_X.jpg
      iPadIcon: https://appuat.mirrorftech.com/icon/banner3_iPad.jpg
      jumpUrl: 

agilebpm:
  sendToDoUrl: https://appuat.mirrorftech.com/sendToDo/save
  updateToDoUrl: https://appuat.mirrorftech.com/sendToDo/update
  sendMsgUrl: https://appuat.mirrorftech.com/sendToDo/sendMsg

jpush:
  masterSecret: 84f51ee1f161c8432fc5e7de
  appKey: 95d1295fd5a5860a83b7079b

调用

package mpaasapp.services.service.crm.impl;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import mpaasapp.services.mapper.crm.UnifyUserInfoMapper;
import mpaasapp.services.model.crm.UnifyUserInfo;
import mpaasapp.services.service.crm.UnifyUserInfoService;
import mpaasapp.utils.Assert;
import org.springframework.stereotype.Service;

/**
 * <p>
 * 统一用户信息表 服务实现类
 * </p>
 *
 * @author haier
 * @since 2020-11-24
 */
@Service
@DS("crm")
public class UnifyUserInfoServiceImpl extends ServiceImpl<UnifyUserInfoMapper, UnifyUserInfo> implements UnifyUserInfoService {

    @Override
    public Long getCrmIdByUserId(Long userId) {
        UnifyUserInfo userInfo = this.getOne(Wrappers.<UnifyUserInfo>query().eq("id", userId).eq("status", 1));
        Assert.fail(userInfo == null || userInfo.getCrmUserId() == null, "用户不存在或未启用");
        return userInfo.getCrmUserId();
    }

    @Override
    public IPage<UnifyUserInfo> listAppUserInfo(Page page, String userName, String mobile, Integer status) {
        return this.baseMapper.listAppUserInfo(page,userName, mobile, status);
    }

    /**
     *  根据UPMS_ID 加载APP会员信息
     * @param upmsUserId
     * @return
     */
    @Override
    public UnifyUserInfo qryByUpmsId(Long upmsUserId) {
        return baseMapper.qryByUpmsId(upmsUserId);
    }

    @Override
    public UnifyUserInfo getUnifyUserInfo(Integer appUserId) {
        UnifyUserInfo userInfo = baseMapper.getUnifyUserInfo(appUserId.longValue());
        Assert.fail(userInfo == null, "获取用户信息失败！");

        if (userInfo.getUpmsUserId() == null || userInfo.getLastLoginCompany() == null) {
            Assert.fail(true, "用户信息缺少公司主体信息！");
        }
        return userInfo;
    }
}