springboot -Druid 数据连接池学习

pom引入：

		com.alibabadruid1.1.10

applicati.yml配置：

spring:application:name: dev-managerdatasource:# 配置数据源类型type:com.alibaba.druid.pool.DruidDataSourcedriver-class-name: com.mysql.jdbc.Driverurl: jdbc:mysql://localhost:3306/dev_manage?useUnicode=true&characterEncoding=UTF-8username: rootpassword: abc12345# 初始化，最小，最大连接数initialSize: 3minidle: 3maxActive: 18# 获取数据库连接等待的超时时间maxWait: 60000# 配置多久进行一次检测，检测需要关闭的空闲连接 单位毫秒timeBetweenEvictionRunsMillis: 60000validationQuery: SELECT 1 FROM dual# 配置监控统计拦截的filters,去掉后，监控界面的sql无法统计filters: stat,wall,log4j

配置统计监控

@Configuration
public class DruidConfiguration {/*** 注册一个StatViewServlet* @return*/@Beanpublic ServletRegistrationBean DruidStatViewServle(){//org.springframework.boot.context.embedded.ServletRegistrationBean提供类的进行注册.ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");//添加初始化参数：initParams//白名单：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.0.114");//登录查看信息的账号密码.servletRegistrationBean.addInitParameter("loginUsername","admin");servletRegistrationBean.addInitParameter("loginPassword","123456");//是否能够重置数据.servletRegistrationBean.addInitParameter("resetEnable","false");return servletRegistrationBean;}/*** 注册一个：filterRegistrationBean* @return*/@Beanpublic FilterRegistrationBean druidStatFilter(){FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());//添加过滤规则.filterRegistrationBean.addUrlPatterns("/*");//添加不需要忽略的格式信息.filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");return filterRegistrationBean;}
}

访问监控页面

        访问监控页面http://ip:port/druid/index.html

参考：

Springboot+druid数据库连接池使用_时光钟摆-CSDN博客_springboot数据库连接池

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！