添加maven依赖
<!--mysql驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!--阿里巴巴druid依赖-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.20</version>
</dependency>
application.yml文件的配置
spring:
datasource:
druid:
# 数据源基本配置
username: root
password: root
url: jdbc:mysql://127.0.0.1:3306/springboottest?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false
driver-class-name: com.mysql.cj.jdbc.Driver
# 连接池配置
# 初始化大小,最小,最大
initialSize: 5
minIdle: 5
maxActive: 20
# 配置获取连接等待超时的时间
maxWait: 60000
# 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位毫秒
timeBetweenEvictionRunsMillis: 60000
# 配置一个连接在池中最小生存时间
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
# 打开 PSCache,并且指定每个连接上 PSCache 的大小
poolPreparedStatements: true
maxPoolPreparedStatementPerConnectionSize: 20
# 合并多个DruidDataSource的监控数据
useGlobalDataSourceStat: true
# 配置监控统计拦截的 Filter,去掉后监控界面 SQL 无法统计,wall 用于防火墙
filters: stat,wall,log4j2
# 通过 connection-properties 属性打开 mergeSql 功能;慢 SQL 记录
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
Druid 的数据源监控
/**
* Druid 的数据源监控
*
* @author sxyuser
*/
@Configuration
public class DruidConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource.druid")
public DataSource druidDataSource() {
return new DruidDataSource();
}
/**
* 配置一个监控的filter
*
* @return
*/
@Bean
public FilterRegistrationBean<WebStatFilter> webStatFilter() {
FilterRegistrationBean<WebStatFilter> beanFilter = new FilterRegistrationBean<>();
beanFilter.setFilter(new WebStatFilter());
Map<String, String> initParams = new HashMap<>();
// 排除名单
initParams.put("exclusions", "*.js,*.css,/druid/*");
beanFilter.setInitParameters(initParams);
// 所有请求进行监控处理
beanFilter.setUrlPatterns(Collections.singletonList("/*"));
return beanFilter;
}
/**
* 配置一个管理后台的servlet
*
* @return
*/
@Bean
public ServletRegistrationBean<StatViewServlet> setStatViewServlet() {
ServletRegistrationBean<StatViewServlet> beanServlet = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
Map<String, String> initParams = new HashMap<>();
initParams.put("loginUsername", "root");
initParams.put("loginPassword", "root");
//默认允许任何访问但需提供账户和密码
initParams.put("allow", "");
beanServlet.setInitParameters(initParams);
return beanServlet;
}
}
配置完成后输入地址:http://localhost:端口号/项目名/druid/login.html输入用户名密码后即可查询后台监控界面;