springboot整合druid(多数据源配置)

Druid 是阿里巴巴一个开源项目，之前(hikari 出现之前)一直被认为是Java语言中各方面最好的数据库连接池，并且Druid还能够提供强大的监控和扩展功能，备受软件开发人员推崇。本文主要介绍springboot整合druid流程，及多数据配置。

一、pom引入druid依赖

<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid-spring-boot-starter</artifactId>
	<version>1.1.10</version>
</dependency>
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid</artifactId>
	<version>1.1.10</version>
</dependency>

二、properties或yml文件配置数据源信息(SQLServer、mySQL多数据源)

## SQLServer数据源信息
spring.datasource.druid.sqlserver.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.sqlserver.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.druid.sqlserver.url=jdbc:sqlserver://192.168.1.8:1433;DatabaseName=myDB;useUnicode=true;characterEncoding=utf8;characterSetResults=utf8;allowMultiQueries=true;multiStatementAllow=true    
spring.datasource.druid.sqlserver.username=sa
spring.datasource.druid.sqlserver.password=DBadmin
spring.datasource.druid.sqlserver.initial-size=5
spring.datasource.druid.sqlserver.min-idle=5
spring.datasource.druid.sqlserver.max-active=300
spring.datasource.druid.sqlserver.max-wait=30000
spring.datasource.druid.sqlserver.time-between-eviction-runs-millis=60000
spring.datasource.druid.sqlserver.min-evictable-idle-time-millis=30000
spring.datasource.druid.sqlserver.validation-query=SELECT 1
spring.datasource.druid.sqlserver.test-while-idle=true
spring.datasource.druid.sqlserver.test-on-borrow=false
spring.datasource.druid.sqlserver.test-on-return=false
spring.datasource.druid.sqlserver.pool-prepared-statements=true
spring.datasource.druid.sqlserver.max-pool-prepared-statement-per-connection-size=20
spring.datasource.druid.sqlserver.filters=stat
spring.datasource.druid.sqlserver.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
spring.datasource.druid.sqlserver.use-global-data-source-stat=true

## mySql数据源信息
spring.datasource.druid.mysql.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.mysql.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.mysql.url=jdbc:sqlserver://192.168.1.8:3306;DatabaseName=myDB;useUnicode=true;characterEncoding=utf8;characterSetResults=utf8;allowMultiQueries=true;multiStatementAllow=true    
spring.datasource.druid.mysql.username=sa
spring.datasource.druid.mysql.password=DBadmin
spring.datasource.druid.mysql.initial-size=5
spring.datasource.druid.mysql.min-idle=5
spring.datasource.druid.mysql.max-active=300
spring.datasource.druid.mysql.max-wait=30000
spring.datasource.druid.mysql.time-between-eviction-runs-millis=60000
spring.datasource.druid.mysql.min-evictable-idle-time-millis=30000
spring.datasource.druid.mysql.validation-query=SELECT 1
spring.datasource.druid.mysql.test-while-idle=true
spring.datasource.druid.mysql.test-on-borrow=false
spring.datasource.druid.mysql.test-on-return=false
spring.datasource.druid.mysql.pool-prepared-statements=true
spring.datasource.druid.mysql.max-pool-prepared-statement-per-connection-size=20
spring.datasource.druid.mysql.filters=stat
spring.datasource.druid.mysql.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
spring.datasource.druid.mysql.use-global-data-source-stat=true

常用属性参数信息：