springboot配置druid -尊龙游戏旗舰厅官网

druid是java语言中最好的数据库连接池。druid能够提供强大的监控和扩展功能。关于详细介绍可查看http://www.iteye.com/magazines/90

springboot中集成druid非常简单

一：yml中添加配置链接

spring:#mysql数据库datasource:url: jdbc:mysql://182.254.221.58:3306/test?usessl=false&&characterencoding=utf8 username: rootpassword: zoulu19900206@driver-class-name: com.mysql.jdbc.driver#配置监控统计拦截的filters，去掉后监控界面sql将无法统计，wall用于防火墙filters: stat,wall,log4j#最大活跃数maxactive: 20#初始化数量initialsize: 1#最大连接等待超时时间maxwait: 60000#打开pscache，并且指定每个连接pscache的大小poolpreparedstatements: truemaxpoolpreparedstatementperconnectionsize: 20#通过connectionproperties属性打开mergesql功能；慢sql记录connectionproperties: druid.stat.mergesql=true;druif.stat.slowsqlmillis=5000minldle: 1timebetweenevictionrunsmillis: 60000minevictabletimemillis: 300000validationquery: select 1 from dualtestwhileldle: truetestonborrow: falsetestonreturn: false#jpajpa:properties:hibernate:hbm2ddl.auto: truedialect: org.hibernate.dialect.mysql5innodbdialectshow-sql: true

二：添加druidconfiguration配置类

@configuration public class druidconfiguration {@beanpublic servletregistrationbean statviewservlet(){//创建servlet注册实体servletregistrationbean servletregistrationbean = new servletregistrationbean(new statviewservlet(),"/druid/*");//设置ip白名单servletregistrationbean.addinitparameter("allow","127.0.0.1");//设置ip黑名单，如果allow与deny共同存在时,deny优先于allowservletregistrationbean.addinitparameter("deny","192.168.0.19");//设置控制台管理用户servletregistrationbean.addinitparameter("loginusername","xiaopotian");servletregistrationbean.addinitparameter("loginpassword","123456");//是否可以重置数据servletregistrationbean.addinitparameter("resetenable","false");return servletregistrationbean;}@beanpublic filterregistrationbean statfilter(){//创建过滤器filterregistrationbean filterregistrationbean = new filterregistrationbean(new webstatfilter());//设置过滤器过滤路径filterregistrationbean.addurlpatterns("/*");//忽略过滤的形式filterregistrationbean.addinitparameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");return filterregistrationbean;}@bean@configurationproperties(prefix = "spring.datasource")public datasource druiddatasource(){return new druiddatasource();} }

三：运行http://localhost:8080/druid进入登陆界面，用上面配置的用户名密码登录即可

非常的简单

 

最后附上demo地址 https://github.com/xiaopotian1990/springbootdemo

 

转载于:https://www.cnblogs.com/xiaopotian/p/8279664.html

总结

以上是尊龙游戏旗舰厅官网为你收集整理的springboot配置druid的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得尊龙游戏旗舰厅官网网站内容还不错，欢迎将尊龙游戏旗舰厅官网推荐给好友。