Druid是Java語(yǔ)言中最好的數(shù)據(jù)庫(kù)連接池。Druid能夠提供強(qiáng)大的監(jiān)控和擴(kuò)展功能。關(guān)于詳細(xì)介紹可查看http://www.iteye.com/magazines/90

SpringBoot中集成Druid非常簡(jiǎn)單

一：yml中添加配置鏈接

spring:#MySQL數(shù)據(jù)庫(kù)datasource:url: jdbc:mysql://182.254.221.58:3306/test?useSSL=false&&characterEncoding=utf8 username: rootpassword: Zoulu19900206@driver-class-name: com.mysql.jdbc.Driver#配置監(jiān)控統(tǒng)計(jì)攔截的filters，去掉后監(jiān)控界面sql將無(wú)法統(tǒng)計(jì)，wall用于防火墻filters: stat,wall,log4j#最大活躍數(shù)maxActive: 20#初始化數(shù)量initialSize: 1#最大連接等待超時(shí)時(shí)間maxWait: 60000#打開(kāi)PSCache，并且指定每個(gè)連接PSCache的大小poolPreparedStatements: truemaxPoolPreparedStatementPerConnectionSize: 20#通過(guò)connectionProperties屬性打開(kāi)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(){//創(chuàng)建servlet注冊(cè)實(shí)體ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");//設(shè)置ip白名單servletRegistrationBean.addInitParameter("allow","127.0.0.1");//設(shè)置ip黑名單，如果allow與deny共同存在時(shí),deny優(yōu)先于allowservletRegistrationBean.addInitParameter("deny","192.168.0.19");//設(shè)置控制臺(tái)管理用戶servletRegistrationBean.addInitParameter("loginUsername","xiaopotian");servletRegistrationBean.addInitParameter("loginPassword","123456");//是否可以重置數(shù)據(jù)servletRegistrationBean.addInitParameter("resetEnable","false");return servletRegistrationBean;}@Beanpublic FilterRegistrationBean statFilter(){//創(chuàng)建過(guò)濾器FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());//設(shè)置過(guò)濾器過(guò)濾路徑filterRegistrationBean.addUrlPatterns("/*");//忽略過(guò)濾的形式filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");return filterRegistrationBean;}@Bean@ConfigurationProperties(prefix = "spring.datasource")public DataSource druidDataSource(){return new DruidDataSource();} }

三：運(yùn)行http://localhost:8080/druid進(jìn)入登陸界面，用上面配置的用戶名密碼登錄即可

非常的簡(jiǎn)單

?

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

?

轉(zhuǎn)載于:https://www.cnblogs.com/xiaopotian/p/8279664.html

總結(jié)

以上是生活随笔為你收集整理的SpringBoot配置Druid的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。