SpringBoot配置Druid数据监控代码实例
druid,一个为监控而生的数据库连接池,提供可视化界面来查看sql执行情况。
1、pom文件引入druid数据源
com.alibaba druid 1.1.8
2、新建一个DrruidConfig配置文件
packagecom.example.mybatisplus.config; importcom.alibaba.druid.pool.DruidDataSource; importcom.alibaba.druid.support.http.StatViewServlet; importcom.alibaba.druid.support.http.WebStatFilter; importorg.springframework.boot.context.properties.ConfigurationProperties; importorg.springframework.boot.web.servlet.FilterRegistrationBean; importorg.springframework.boot.web.servlet.ServletRegistrationBean; importorg.springframework.context.annotation.Bean; importorg.springframework.context.annotation.Configuration; importjavax.sql.DataSource; importjava.util.Arrays; importjava.util.HashMap; importjava.util.Map; /** *druid数据池配置 */ @Configuration publicclassDruidConfig{ @ConfigurationProperties(prefix="spring.datasource") @Bean publicDataSourcedruid(){ returnnewDruidDataSource(); } //配置Druid的监控 //1、配置一个管理后台的Servlet @Bean publicServletRegistrationBeanstatViewServlet(){ ServletRegistrationBeanbean=newServletRegistrationBean(newStatViewServlet(),"/druid/*"); MapinitParams=newHashMap<>(); //配置登录的账号密码 initParams.put("loginUsername","admin"); initParams.put("loginPassword","123456"); //initParams.put("deny","localhost");//拒绝谁登录 //是否能够重置数据. //bean.addInitParameter("resetEnable","false"); bean.setInitParameters(initParams); returnbean; } //2、配置一个web监控的filter @Bean publicFilterRegistrationBeanwebStatFilter(){ FilterRegistrationBeanbean=newFilterRegistrationBean(); bean.setFilter(newWebStatFilter()); Map initParams=newHashMap<>(); initParams.put("exclusions","*.html,*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); bean.setInitParameters(initParams); bean.setUrlPatterns(Arrays.asList("/*")); returnbean; } }
3、yml文件配置
spring: datasource: schema: -classpath:schema.sql initialization-mode:ALWAYS username:root password:root url:jdbc:mysql://localhost:3306/jdbc?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false driver-class-name:com.mysql.cj.jdbc.Driver #type:com.alibaba.druid.pool.DruidDataSource initialSize:5 minIdle:5 maxActive:20 maxWait:60000 timeBetweenEvictionRunsMillis:60000 minEvictableIdleTimeMillis:300000 validationQuery:SELECT1FROMDUAL testWhileIdle:true testOnBorrow:false testOnReturn:false poolPreparedStatements:true #配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙 filters:stat,wall maxPoolPreparedStatementPerConnectionSize:20 useGlobalDataSourceStat:true connectionProperties:druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。
声明:本文内容来源于网络,版权归原作者所有,内容由互联网用户自发贡献自行上传,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任。如果您发现有涉嫌版权的内容,欢迎发送邮件至:czq8825#qq.com(发邮件时,请将#更换为@)进行举报,并提供相关证据,一经查实,本站将立刻删除涉嫌侵权内容。