springboot 两步搭建druid配置

网上druid的配置很多，druid可以说是非常好的数据库系统监控插件，可以有效的知道sql的执行次数和效率，页面的访问程度，从而可以针对性的优化。之前都是web.xml中直接配置，现在发现springboot不生效，所以重新弄了下，采用注解的方式。

1、创建一个DruidConfig的配置类：

import com.alibaba.druid.pool.DruidDataSource;

import com.alibaba.druid.support.http.StatViewServlet

;import com.alibaba.druid.support.http.WebStatFilter;

import org.slf4j.Logger;import org.slf4j.LoggerFactory;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.boot.web.servlet.FilterRegistrationBean;

import org.springframework.boot.web.servlet.ServletRegistrationBean;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;import javax.sql.DataSource;

import java.sql.SQLException;

@Configuration

public class DruidConfig {

    privateLogger logger = LoggerFactory.getLogger(DruidConfig.class);

    @Value("${spring.datasource.url}")

    private String dbUrl;

    @Value("${spring.datasource.username}")

    private String username;

    @Value("${spring.datasource.password}")

    private String password;

    @Value("${spring.datasource.driver-class-name}")

    private String driverClassName;

    @Value("${spring.datasource.initialSize}")

    privateint initialSize;

    @Value("${spring.datasource.minIdle}")

    privateint minIdle;

    @Value("${spring.datasource.maxActive}")

    privateint maxActive;

    @Value("${spring.datasource.maxWait}")

    privateint maxWait;

    @Value("${spring.datasource.timeBetweenEvictionRunsMillis}")

    privateint timeBetweenEvictionRunsMillis;

    @Value("${spring.datasource.minEvictableIdleTimeMillis}")

    privateint minEvictableIdleTimeMillis;

    @Value("${spring.datasource.validationQuery}")

    private String validationQuery;

    @Value("${spring.datasource.testWhileIdle}")

    privateboolean testWhileIdle;

    @Value("${spring.datasource.testOnBorrow}")

    privateboolean testOnBorrow;

    @Value("${spring.datasource.testOnReturn}")

    privateboolean testOnReturn;

    @Value("${spring.datasource.filters}")

    private String filters;

    @Value("${spring.datasource.logSlowSql}")

    private String logSlowSql;

    @Bean

    public ServletRegistrationBean druidServlet() {

        ServletRegistrationBean reg =new ServletRegistrationBean();

        reg.setServlet(new StatViewServlet());

        reg.addUrlMappings("/druid/*");

        reg.addInitParameter("loginUsername", username);

        reg.addInitParameter("loginPassword", password);

        reg.addInitParameter("logSlowSql", logSlowSql);

        return reg;

    }

    @Bean

    public FilterRegistrationBean filterRegistrationBean() {

        FilterRegistrationBean filterRegistrationBean =new FilterRegistrationBean();

        filterRegistrationBean.setFilter(new WebStatFilter());

        filterRegistrationBean.addUrlPatterns("/*");

        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

        filterRegistrationBean.addInitParameter("profileEnable", "true");

        return filterRegistrationBean;

    }

    @Bean

    public DataSource druidDataSource() {

        DruidDataSource datasource =new DruidDataSource();

        datasource.setUrl(dbUrl);

        datasource.setUsername(username);

        datasource.setPassword(password);

        datasource.setDriverClassName(driverClassName);

        datasource.setInitialSize(initialSize);

        datasource.setMinIdle(minIdle);

        datasource.setMaxActive(maxActive);

        datasource.setMaxWait(maxWait);

        datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);

        datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);

        datasource.setValidationQuery(validationQuery);

        datasource.setTestWhileIdle(testWhileIdle);

        datasource.setTestOnBorrow(testOnBorrow);

        datasource.setTestOnReturn(testOnReturn);

        try {

            datasource.setFilters(filters);

        } catch (SQLException e) {

            logger.error("druid configuration initialization filter", e);

        }

        return datasource;

    }

}

2、application.properties中配置数据源：

# 数据库访问配置

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

#mysql配置

#spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#spring.datasource.url=jdbc:mysql://localhost:3306/spring-boot?#useUnicode=true&characterEncoding=gbk&zeroDateTimeBehavior=convertToNull&useSSL=false

#spring.datasource.username=root

#spring.datasource.password=admin

#oracle配置

spring.jpa.database=oracle

spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver

spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl

spring.datasource.username=root

spring.datasource.password=admin

# 下面为连接池的补充设置，应用到上面所有数据源中

spring.datasource.initialSize=5

spring.datasource.minIdle=5

spring.datasource.maxActive=20

# 配置获取连接等待超时的时间

spring.datasource.maxWait=60000

# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒

spring.datasource.timeBetweenEvictionRunsMillis=60000

# 配置一个连接在池中最小生存的时间，单位是毫秒

spring.datasource.minEvictableIdleTimeMillis=300000

spring.datasource.validationQuery=SELECT 1 FROM DUAL

spring.datasource.testWhileIdle=true

spring.datasource.testOnBorrow=false

spring.datasource.testOnReturn=false

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

spring.datasource.filters=stat,wall,log4j

spring.datasource.logSlowSql=true

最后访问：http://localhost:port/domain/druid/login.html 进行登录访问。

可以看出，是使用了连接池的。