mybatis mysql merge_Spring Boot + Mybatis 整合Mysql ，SQLServer数据源以及整合druid，动态调整数据源切换。...

pom.xml依赖

org.springframework.boot

spring-boot-starter-web

org.mybatis.spring.boot

mybatis-spring-boot-starter

1.3.2

mysql

mysql-connector-java

runtime

org.springframework.boot

spring-boot-starter-test

test

com.microsoft.sqlserver

sqljdbc4

4.0

org.springframework.boot

spring-boot-starter-aop

配置文件application.yml

datasource:

mysql:

type: com.alibaba.druid.pool.DruidDataSource

driverClassName: com.mysql.jdbc.Driver

url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&useSSL=false&characterEncoding=utf8

username: root

password: root

initialSize: 1

minIdle: 3

maxActive: 20

maxWait: 60000

timeBetweenEvictionRunsMillis: 60000

minEvictableIdleTimeMillis: 30000

validationQuery: select 'x'

testWhileIdle: true

testOnBorrow: false

testOnReturn: false

poolPreparedStatements: true

maxPoolPreparedStatementPerConnectionSize: 20

# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙

filters: stat,wall,slf4j

# 通过connectProperties属性来打开mergeSql功能；慢SQL记录

connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

# 合并多个DruidDataSource的监控数据

#useGlobalDataSourceStat: true

sqlserver:

url: jdbc:sqlserver://127.0.0.1:1433;databasename=test

driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver

username: lc0019999

password: Xtgly2018

创建一个数据源类型枚举类

public enum DataSourceType {

Mysql("mysql"),

SQLServer("sqlserver");

private String name;

DataSourceType(String name) {

this.name = name;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name =