查看版本并获取pom内容
https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter
添加进pom.xml文件中
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency>
<dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.9</version> </dependency>
application.yml添加配置
server:
context-path: /wxapp
port: 8080
debug: false
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false
username: root
password: 123456
#监控配置
druid:
initial-size: 1
max-active: 20
min-idle: 10
max-wait: 60000
max-open-prepared-statements: 20
validation-query: SELECT 'x'
validation-query-timeout: 2000
test-on-borrow: false
test-on-return: false
test-while-idle: true
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 300000
max-evictable-idle-time-millis: 600000
配置监控拦截器
package com.demo.webfilter; import javax.servlet.annotation.WebFilter; import javax.servlet.annotation.WebInitParam; import com.alibaba.druid.support.http.WebStatFilter; /** * druid监控拦截器 * Created by zzf * * 2018-04-10 11:54 */ @WebFilter(filterName="druidWebStatFilter", urlPatterns="/*", initParams={ @WebInitParam(name="exclusions",value="*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")// 忽略资源 }) public class DruidStatFilter extends WebStatFilter { }
配置监控
package com.demo.webservlet; import javax.servlet.annotation.WebInitParam; import javax.servlet.annotation.WebServlet; import com.alibaba.druid.support.http.StatViewServlet; /** * druid监控Servlet * Created by zzf * 2018-04-10 11:57 */ @WebServlet(urlPatterns = "/druid/*", initParams={ @WebInitParam(name="allow",value="127.0.0.1"),// IP白名单 (没有配置或者为空,则允许所有访问) @WebInitParam(name="deny",value="127.0.0.2"),// IP黑名单 (存在共同时,deny优先于allow) @WebInitParam(name="loginUsername",value="zzf"),// 用户名 @WebInitParam(name="loginPassword",value="QQ:648895145"),// 密码 @WebInitParam(name="resetEnable",value="false")// 禁用HTML页面上的“Reset All”功能 }) public class DruidStatViewServlet extends StatViewServlet { }
配置完成。启动后即可访问