千家信息网

SpringBoot中druid如何使用

发表于:2025-02-04 作者:千家信息网编辑
千家信息网最后更新 2025年02月04日,今天就跟大家聊聊有关SpringBoot中druid如何使用,可能很多人都不太了解,为了让大家更加了解,小编给大家总结了以下内容,希望大家根据这篇文章可以有所收获。配置application.yml文
千家信息网最后更新 2025年02月04日SpringBoot中druid如何使用

今天就跟大家聊聊有关SpringBoot中druid如何使用,可能很多人都不太了解,为了让大家更加了解,小编给大家总结了以下内容,希望大家根据这篇文章可以有所收获。

配置application.yml文件

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#   配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙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();   }//配置Druid监控[@Bean](https://my.oschina.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;}

}

看完上述内容,你们对SpringBoot中druid如何使用有进一步的了解吗?如果还想了解更多知识或者相关内容,请关注行业资讯频道,感谢大家的支持。

0