mybatis plus + druid多数据源(使用dynamic实现)
参考开源项目dynamic: https://github.com/baomidou/dynamic-datasource-spring-boot-starter
引入pom:
<!-- 动态数据源 --> <dependency> <groupId>com.baomidou</groupId> <artifactId>dynamic-datasource-spring-boot-starter</artifactId> <version>2.5.4</version> </dependency>
配置文件yml中:
spring: autoconfigure: #自动化配置 例外处理 exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure datasource: type: com.alibaba.druid.pool.DruidDataSource #多数据源配置 dynamic: primary: db1 datasource: # 数据库1 db1: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://xxxx:3306/xxx?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false&serverTimezone=Asia/Shanghai username: xxx password: xxxx # 数据库2 db2: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://xxxx:3306/xxx?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&useSSL=false&serverTimezone=Asia/Shanghai username: xxx password: xxxx #dynamic - 公共配置 druid: initialSize: 5 minIdle: 5 maxActive: 30 maxWait: 60000 timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 validationQuery: SELECT ‘x‘ testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true maxPoolPreparedStatementPerConnectionSize: 20 filters: stat,wall,slf4j,config useGlobalDataSourceStat: true stat: log-slow-sql: true merge-sql: true slow-sql-millis: 10000
用法:在相应service类或方法上添加DS注解,如:
package com.tuijie.loanapi.service.impl; import com.baomidou.dynamic.datasource.annotation.DS; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.tuijie.loanapi.mapper.TestUserMapper; import com.tuijie.loanapi.model.mysql.TestUser; import com.tuijie.loanapi.service.TestUserService; import org.springframework.stereotype.Service; /** * TestUserServiceImpl * 测试ServiceImpl * @version : */ @Service @DS("db2") public class TestUserServiceImpl extends ServiceImpl<TestUserMapper, TestUser> implements TestUserService { }
相关推荐
杜鲁门 2020-11-05
Rain 2020-06-25
咻pur慢 2020-06-18
thunderstorm 2020-06-06
仰起嘴角 2020-05-27
吾日五省我身 2020-05-12
baobaozai 2020-04-30
GechangLiu 2020-04-26
heywakeup 2020-04-23
jaylong 2020-03-23
shisongsong 2020-03-11
chognzhihongseu 2020-03-06
bluetears 2020-03-03
84593973 2020-03-03
Kele0 2020-02-23
nan00zzu 2020-02-11
suixinsuoyu 2019-12-28
末点 2019-12-30
齐天大圣数据候 2019-12-30