SpringBoot+Druid

关注

原创最新推荐文章于 2026-03-28 02:46:49 发布 612 阅读 AI 写同款· GEO 优化 ›

Spring Boot项目配置Druid数据源(druid-spring-boot-starter) Druid是阿里巴巴的一个开源项目，号称为监控而生的数据库连接池，在功能、性能、扩展性方面都超过其他例如DBCP、C3P0、BoneCP、Proxool、JBoss DataSource等连接池,而且Druid已经在阿里巴巴部署了超过600个应用，通过了极为严格的考验，这才收获了大家的青睐！Apache Druid（Incubating） - 面向列的分布式数据存储，非常适合为交互式应用程序提供动力,开发中使用的更多。以往我们都是直接引入Druid的依赖： apache中已经出了一套完美支持阅读详情

SpringBoot+Druid

依赖引入

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

Druid 多数据源配置

配置文件配置

spring:
  datasource:
    url: jdbc://mysql:192.168.137.127:3306/test
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
    druid:
      one:
        initial-size: 1
        max-active: 20
        min-idle: 1
        max-wait: 6000
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        #max-open-prepared-statements: 和上方属性一样
        validation-query: "select 1 from dual"
        validation-query-timeout: 10000
        test-on-borrow: false
        test-on-return: false
        test-while-idle: true
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        max-evictable-idle-time-millis: 600000
        filters: "stat,wall"
        async-init: true
      two:
        url: jdbc://mysql:192.168.137.126:3306/test
        username: root
        password: root
        driver-class-name: com.mysql.cj.jdbc.Driver
        initial-size: 1
        max-active: 20
        min-idle: 1
        max-wait: 6000
        pool-prepared-statements: true
        max-pool-prepared-statement-per-connection-size: 20
        #max-open-prepared-statements: 和上方属性一样
        validation-query: "select 1 from dual"
        validation-query-timeout: 10000
        test-on-borrow: false
        test-on-return: false
        test-while-idle: true
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        max-evictable-idle-time-millis: 600000
        filters: "stat,wall"
        async-init: true

配置类

@Configuration
public class DataSourceConfig {
	//当不指定数据源时使用该数据源
    @Bean
    @Primary
    @ConfigurationProperties("spring.datasource.druid.one")
    public DataSource dataSource(){
        return DruidDataSourceBuilder.create().build();
    }
    @Bean
    @ConfigurationProperties("spring.datasource.druid.two")
    public DataSource dataSourceTwo(){
        return DruidDataSourceBuilder.create().build();
    }
}

数据源注入

@RestController
public class HelloWordController {
    //注入指定数据源
    @Resource(name = "dataSourceTwo")
    private DataSource dataSource;
    @Resource
    private SayService sayService;
    @RequestMapping("/hello/{name}")
    public String sayHello(@PathVariable("name") String name) {
        return sayService.say("hello "+name);
    }
}