记录判断springboot druid配置生效（代码方式）

spring.datasource.druid.primary.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=yes&characterEncoding=UTF-8&useSSL=false
spring.datasource.druid.primary.username=root
spring.datasource.druid.primary.password=root123

spring.datasource.druid.primary.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.primary.data-source-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.primary.initial-size=5
spring.datasource.druid.primary.min-idle=5
spring.datasource.druid.primary.max-active=100
#spring.datasource.druid.primary.max-idle=100
spring.datasource.druid.primary.max-wait=10000
spring.datasource.druid.primary.numTestsPerEvictionRun=3
spring.datasource.druid.primary.pool-prepared-statements=false
spring.datasource.druid.primary.validation-query=SELECT 1
spring.datasource.druid.primary.validation-query-timeout=3
spring.datasource.druid.primary.test-on-borrow=true
spring.datasource.druid.primary.test-on-return=false
spring.datasource.druid.primary.test-while-idle=true
spring.datasource.druid.primary.time-between-eviction-runs-millis=5000
spring.datasource.druid.primary.min-evictable-idle-time-millis=540000
spring.datasource.druid.primary.filters=stat,wall,slf4j

在配置文件配置好后，创建DruidDataSource对象，交给Bean管理

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

@Configuration
public class DruidConfig {
    @Bean
    @ConfigurationProperties("spring.datasource.druid")
    public DataSource druidDataSource(){
        return new DruidDataSource();
    }
}

创建连接，查看相关的配置信息

    @Autowired
    private DataSource dataSource;
    @SneakyThrows
    public String testDemo() {
        //String jSonString = JsonUtil.toJSonString(req);
        //获得连接
        Connection connection =   dataSource.getConnection();
        System.out.println(connection);
        DruidDataSource druidDataSource = (DruidDataSource) dataSource;
        System.out.println("druidDataSource 数据源最大连接数：" + druidDataSource.getMaxActive());
        System.out.println("druidDataSource 数据源初始化连接数：" + druidDataSource.getInitialSize());
        long timeBetweenEvictionRunsMillis = druidDataSource.getTimeBetweenEvictionRunsMillis();
        //关闭连接
        connection.close();

        return null;

    }

可以查看参数有值。