spring boot 多数据源配置（mysql mongodb）

最新推荐文章于 2024-07-13 13:55:40 发布

fengzhigu2017

最新推荐文章于 2024-07-13 13:55:40 发布

阅读量514

点赞数

本文链接：https://blog.csdn.net/fengzhigu2017/article/details/116714867

版权

spring boot多个数据源配置

mysql-mybatis
- mongo配置
- - 三级目录

mysql-mybatis

引入依赖不在陈述

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>${
   mysql-connector}</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>${
   mybatis-spring-boot}</version>
		</dependency>
		<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.9</version>
        </dependency>

配置文件配置
spring:

spring:
  data:
    mongodb:
      anamongodb:
       uri: mongodb://xxx:27017/dataAnalysis
      videodb:
       uri: mongodb://xxx:27017/video
  datasource:
    databasename1:
     name: report
     url: jdbc:mysql://xxx:xxx/databasename1??useUnicode=true&amp;characterEncoding=UTF-8
     username: root
     password: xxxx
    #url: jdbc:mysql://127.0.0.1:3306/databasename1??useUnicode=true&amp;characterEncoding=UTF-8
    #username: root
    #password: root
    # 使用druid数据源
     type: com.alibaba.druid.pool.DruidDataSource
     driver-class-name: com.mysql.jdbc.Driver
    databasename2:
      name: databasename2
      url: jdbc:mysql://xxxx:3306/databasename2??useUnicode=true&amp;characterEncoding=UTF-8
      username: root
      password: xxx
      # 使用druid数据源
      type: com.alibaba.druid.pool.DruidDataSource
      driver-class-name: com.mysql.jdbc.Driver
    druid:
      filters:
        - stat
        - wall
        - log4j
      maxActive: 20
      initialSize: 1
      maxWait: 60000
      minIdle: 1
      timeBetweenEvictionRunsMillis: 60000
      minEvictableIdleTimeMillis: 300000
      validationQuery: select 'x'
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      poolPreparedStatements: true
      maxOpenPreparedStatements: 20
      druidusername: admin
      druidpassword: admin
      weballowip: 127.0.0.1
      webdenyip:
mybatis:
    databasename1:
      mapper-locations: classpath:mapper/databasename1/Mapper.xml
      configuration:
       log-impl: org.apache.ibatis.logging