详解SpringBoot配置连接池

spring.datasource.url=jdbc:mysql://localhost/testspring.datasource.username=dbuserspring.datasource.password=dbpassspring.datasource.driver-class-name=com.mysql.jdbc.Driver

    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <scope>runtime</scope>    </dependency>

    <dependency>      <groupId>com.alibaba</groupId>      <artifactId>druid</artifactId>      <version>1.0.25</version>    </dependency>

# 驱动配置信息spring.datasource.type=com.alibaba.druid.pool.DruidDataSourcespring.datasource.url = jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8 spring.datasource.username = rootspring.datasource.password = adminterspring.datasource.driverClassName = com.mysql.jdbc.Driver#连接池的配置信息## 初始化大小，最小，最大spring.druid.initialSize=5spring.druid.minIdle=5spring.druid.maxActive=20## 配置获取连接等待超时的时间spring.druid.maxWait=60000# 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒spring.druid.timeBetweenEvictionRunsMillis=60000# 配置一个连接在池中最小生存的时间，单位是毫秒spring.druid.minEvictableIdleTimeMillis=300000spring.druid.validationQuery=SELECT 1 FROM DUALspring.druid.testWhileIdle=truespring.druid.testOnBorrow=falsespring.druid.testOnReturn=falsespring.druid.poolPreparedStatements=truespring.druid.maxPoolPreparedStatementPerConnectionSize=20# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙spring.druid.filters=stat,wall,log4j# 通过connectProperties属性来打开mergeSql功能；慢SQL记录spring.druid.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

package com.lf.datasource;import com.alibaba.druid.pool.DruidDataSource;import org.springframework.boot.context.properties.ConfigurationProperties;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Primary;import javax.sql.DataSource;import java.sql.SQLException;/** * Created by LF on 2017/4/18. */@ConfigurationProperties(prefix = "spring.druid")public class DruidSource {  private String dbUrl;  private String username;  private String password;  private String driverClassName;  private int initialSize;  private int minIdle;  private int maxActive;  private int maxWait;  private int timeBetweenEvictionRunsMillis;  private int minEvictableIdleTimeMillis;  private String validationQuery;  private boolean testWhileIdle;  private boolean testOnBorrow;  private boolean testOnReturn;  private boolean poolPreparedStatements;  private int maxPoolPreparedStatementPerConnectionSize;  private String filters;  private String connectionProperties;  public String getDbUrl() {    return dbUrl;  }  public void setDbUrl(String dbUrl) {    this.dbUrl = dbUrl;  }  public String getUsername() {    return username;  }  public void setUsername(String username) {    this.username = username;  }  public String getPassword() {    return password;  }  public void setPassword(String password) {    this.password = password;  }  public String getDriverClassName() {    return driverClassName;  }  public void setDriverClassName(String driverClassName) {    this.driverClassName = driverClassName;  }  public int getInitialSize() {    return initialSize;  }  public void setInitialSize(int initialSize) {    this.initialSize = initialSize;  }  public int getMinIdle() {    return minIdle;  }  public void setMinIdle(int minIdle) {    this.minIdle = minIdle;  }  public int getMaxActive() {    return maxActive;  }  public void setMaxActive(int maxActive) {    this.maxActive = maxActive;  }  public int getMaxWait() {    return maxWait;  }  public void setMaxWait(int maxWait) {    this.maxWait = maxWait;  }  public int getTimeBetweenEvictionRunsMillis() {    return timeBetweenEvictionRunsMillis;  }  public void setTimeBetweenEvictionRunsMillis(int timeBetweenEvictionRunsMillis) {    this.timeBetweenEvictionRunsMillis = timeBetweenEvictionRunsMillis;  }  public int getMinEvictableIdleTimeMillis() {    return minEvictableIdleTimeMillis;  }  public void setMinEvictableIdleTimeMillis(int minEvictableIdleTimeMillis) {    this.minEvictableIdleTimeMillis = minEvictableIdleTimeMillis;  }  public String getValidationQuery() {    return validationQuery;  }  public void setValidationQuery(String validationQuery) {    this.validationQuery = validationQuery;  }  public boolean isTestWhileIdle() {    return testWhileIdle;  }  public void setTestWhileIdle(boolean testWhileIdle) {    this.testWhileIdle = testWhileIdle;  }  public boolean isTestOnBorrow() {    return testOnBorrow;  }  public void setTestOnBorrow(boolean testOnBorrow) {    this.testOnBorrow = testOnBorrow;  }  public boolean isTestOnReturn() {    return testOnReturn;  }  public void setTestOnReturn(boolean testOnReturn) {    this.testOnReturn = testOnReturn;  }  public boolean isPoolPreparedStatements() {    return poolPreparedStatements;  }  public void setPoolPreparedStatements(boolean poolPreparedStatements) {    this.poolPreparedStatements = poolPreparedStatements;  }  public int getMaxPoolPreparedStatementPerConnectionSize() {    return maxPoolPreparedStatementPerConnectionSize;  }  public void setMaxPoolPreparedStatementPerConnectionSize(int maxPoolPreparedStatementPerConnectionSize) {    this.maxPoolPreparedStatementPerConnectionSize = maxPoolPreparedStatementPerConnectionSize;  }  public String getFilters() {    return filters;  }  public void setFilters(String filters) {    this.filters = filters;  }  public String getConnectionProperties() {    return connectionProperties;  }  public void setConnectionProperties(String connectionProperties) {    this.connectionProperties = connectionProperties;  }  @Bean   //声明其为Bean实例  @Primary //在同样的DataSource中，首先使用被标注的DataSource  public DataSource dataSource() throws SQLException {    DruidDataSource datasource = new DruidDataSource();    datasource.setUrl(this.dbUrl);    datasource.setUsername(username);    datasource.setPassword(password);    datasource.setDriverClassName(driverClassName);    //configuration    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);    datasource.setPoolPreparedStatements(poolPreparedStatements);    datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);    datasource.setFilters(filters);    return datasource;  }}

package com.lf.config;import com.alibaba.druid.support.http.WebStatFilter;import javax.servlet.annotation.WebFilter;import javax.servlet.annotation.WebInitParam;/** * Created by LF on 2017/4/18. */@WebFilter(filterName = "druidWebStatFilter", urlPatterns = "/*",    initParams = {        @WebInitParam(name = "exclusions", value = "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")//忽略资源    })public class DruidStatFilter extends WebStatFilter {}

package com.lf.config;import com.alibaba.druid.support.http.StatViewServlet;import javax.servlet.annotation.WebInitParam;import javax.servlet.annotation.WebServlet;/** * Created by LF on 2017/4/18. */@WebServlet(urlPatterns = "/druid/*",    initParams = {        @WebInitParam(name = "allow", value = "127.0.0.1,192.168.163.1"),// IP白名单(没有配置或者为空，则允许所有访问)        @WebInitParam(name = "deny", value = "192.168.1.73"),// IP黑名单 (存在共同时，deny优先于allow)        @WebInitParam(name = "loginUsername", value = "admin"),// 用户名        @WebInitParam(name = "loginPassword", value = "123456"),// 密码        @WebInitParam(name = "resetEnable", value = "false")// 禁用HTML页面上的“Reset All”功能    })public class DruidStatViewServlet extends StatViewServlet {  private static final long serialVersionUID = -2688872071445249539L;}

package com.lf.config;import com.alibaba.druid.support.http.StatViewServlet;import com.alibaba.druid.support.http.WebStatFilter;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;/** * Created by LF on 2017/4/18. */@Configurationpublic class DruidConfig {  @Bean  public ServletRegistrationBean registrationBean() {    ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet());    //添加初始化参数：initParams    servletRegistrationBean.addUrlMappings("/druid/*");    //白名单：    servletRegistrationBean.addInitParameter("allow", "127.0.0.1");    //IP黑名单 (存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page.    servletRegistrationBean.addInitParameter("deny", "192.168.1.73");    //登录查看信息的账号密码.    servletRegistrationBean.addInitParameter("loginUsername", "admin");    servletRegistrationBean.addInitParameter("loginPassword", "123456");    //是否能够重置数据.    servletRegistrationBean.addInitParameter("resetEnable", "false");    return servletRegistrationBean;  }  @Bean  public FilterRegistrationBean filterRegistrationBean() {    FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());    //添加过滤规则.    filterRegistrationBean.addUrlPatterns("/*");    //添加不需要忽略的格式信息.    filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");    return filterRegistrationBean;  }}