Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about how to use druid in SpringBoot. Many people may not know much about it. In order to let everyone know more, Xiaobian summarized the following contents for everyone. I hope you can gain something according to this article.

Configure the application.yml file

spring:

datasource:

username: rootpassword: 123456driver-class-name: com.mysql.jdbc.Driverurl: jdbc:mysql://127.0.0.1:3306/test1? useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=truetype: com.alibaba.druid.pool.DruidDataSourceinitialSize: 5minIdle: 5maxActive: 20maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 1 FROM DUALtestWhileIdle: truetestOnBorrow: falsetestOnReturn: falsepoolPreparedStatements: true# Configure monitoring statistics to intercept filters, Remove the monitoring interface sql cannot count,'wall' for firewall filters: stat,wall,log4jmaxPoolPreparedStatementPerConnectionSize: 20useGlobalDataSourceStat: trueconnectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500initialization-mode: always@Configuration

public class myDruid {

@ConfigurationProperties(prefix = "spring.datasource")[@Bean](https://my.oschina.net/bean)public DataSource dataSource(){ return new DruidDataSource(); }//Configure Druid Monitor [@Bean](https://my.ochina.net/bean)public ServletRegistrationBean statViewServlet(){ ServletRegistrationBean servletRegistrationBean= new ServletRegistrationBean(new StatViewServlet(),"/druid/*"); Map map =new HashMap(); map.put("loginUsername","admin"); map.put("loginPassword","admin"); servletRegistrationBean.setInitParameters(map); return servletRegistrationBean; }[@Bean](https://my.oschina.net/bean)public FilterRegistrationBean webStatFilter(){ FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(); filterRegistrationBean.setFilter(new WebStatFilter()); Map map = new HashMap(); map.put("exclusions","*.js,*.css,/druid/*"); filterRegistrationBean.setInitParameters(map); filterRegistrationBean.setUrlPatterns(Arrays.asList("/*")); return filterRegistrationBean;}

}

After reading the above, do you have any further understanding of how druid is used in SpringBoot? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.