1.什么是Druid？
Druid是阿里的開源庫咒精，是Java語言中最好的數(shù)據(jù)庫連接池。Druid能夠提供強大的監(jiān)控和擴展功能。
還有其實Druidf翻譯過來就是大名鼎鼎的德魯伊樟凄！看樣子大神們都是很調(diào)皮的阿。
大德魯伊（Arch-Druid）：瑪法里奧·怒風(fēng)
2. 配置Druid
其實大多數(shù)在GitHub上已經(jīng)寫的比較明白了兄渺。Maven參考文檔缝龄。
參考https://github.com/alibaba/druid即可，但是還是有配置上的小坑挂谍，這里就列下配置文件叔壤。
applicaition.yml:
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://192.168.15.128:3306/jdbc
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
#dataSource Pool configuration
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
#配置監(jiān)控統(tǒng)計攔截的filters，去掉后監(jiān)控界面sql無法統(tǒng)計口叙，'wall'用于防火墻
filters: {stat,wall,log4j}
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
DruidConfig:
package com.example.jdbc.config;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.springframework.boot.context.properties.ConfigurationProperties;
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 org.springframework.context.annotation.Primary;
import javax.sql.DataSource;
import java.util.Arrays;
import java.util.HashMap;
import java.util.Map;
/**
* @author BaoZhou
* @date 2018/5/25
*/
@Configuration
public class DruidConfig {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DataSource druid(){
return DruidDataSourceBuilder.create().build();
}
@Bean
public ServletRegistrationBean startViewServlet()
{
//參數(shù)可以在StatViewServlet和ResourceServlet中查看
ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
Map<String,String> params = new HashMap<>();
//用戶名
params.put("loginUsername","admin");
//密碼
params.put("loginPassword","123456");
//IP白名單 (不填寫代表允許所有IP)
params.put("allow","");
//IP黑名單 (存在共同時炼绘，deny優(yōu)先于allow)
//initParameters.put("deny", "192.168.20.38");
bean.setInitParameters(params);
return bean;
}
@Bean
public FilterRegistrationBean webStatFilter(){
FilterRegistrationBean bean = new FilterRegistrationBean();
bean.setFilter(new WebStatFilter());
Map<String,String> initParams = new HashMap<>();
//排除攔截
initParams.put("exclusions","*.js,*.css,/druid/*");
bean.setInitParameters(initParams);
bean.setUrlPatterns(Arrays.asList("/*"));
return bean;
}
}
運行后即可登錄http://localhost:8080/druid/login.html查看監(jiān)控訊息。
監(jiān)控訊息
監(jiān)控訊息
總的來說就是十分簡單好用的數(shù)據(jù)庫連接池妄田，當(dāng)然更多高級用法還是要參考GitHub文檔俺亮。
