第四章 SpringBoot集成Druid

一、引入jdbc启动器和mysql驱动以及durid的依赖

<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>8.0.25</version>
</dependency>
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid-spring-boot-starter</artifactId>
  <version>1.2.6</version>
</dependency>

二 基于druid starter的自动配置

spring.profiles.active=uat
spring.datasource.username=root
spring.datasource.password=12345678
#mysql8的驱动包
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/nacos?serverTimeZone=UTC&useUnicode=true&characterEncoding=utf8
#指定datasource的类型为druid
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
#配置druid连接池 注意 如果你导入的不是druid的starter的话 则下面的配置无法直接生效 你需要自己通过@Bean注解 配置一个duridConfig 手动注入连接池的配置
spring.datasource.druid.initial-size=5
spring.datasource.druid.min-idle=5
spring.datasource.druid.max-active=20
spring.datasource.druid.max-wait=60000
spring.datasource.druid.time-between-eviction-runs-millis=60000
spring.datasource.druid.max-evictable-idle-time-millis=3000000
spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
spring.datasource.druid.test-while-idle=true
spring.datasource.druid.test-on-borrow=false
spring.datasource.druid.test-on-return=false
spring.datasource.druid.pool-prepared-statements=true

三 基于druid的手动配置

<!--手动配置不需要导入starter 导入下面的依赖-->
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.2.6</version>
</dependency>

配置

spring.profiles.active=uat
spring.datasource.username=root
spring.datasource.password=12345678
#mysql8的驱动包
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/nacos?serverTimeZone=UTC&useUnicode=true&characterEncoding=utf8
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
#连接池配置
spring.datasource.initial-size=5                      
spring.datasource.min-idle=5                          
spring.datasource.max-active=20                       
spring.datasource.max-wait=60000                      
spring.datasource.time-between-eviction-runs-millis=60
spring.datasource.max-evictable-idle-time-millis=30000
spring.datasource.validation-query=SELECT 1 FROM DUAL 
spring.datasource.test-while-idle=true                
spring.datasource.test-on-borrow=false                
spring.datasource.test-on-return=false                
spring.datasource.pool-prepared-statements=true  

配置类

@Configuration
public class DruidDataSourceConfig {

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource druidDataSource() {
        return new DruidDataSource();
    }
}

通过这种方式也可以将druid数据源集成到springboot框架