自定义Druid配置(/druid页面数据都显示)_自定义 druidconfig-优快云博客

该博客展示了如何在Spring Boot应用中配置Druid数据源，并实现监控功能。配置包括设置DruidDataSource、StatViewServlet、WebStatFilter、DruidStatInterceptor等，以实现数据源监控、Web请求统计和AOP拦截器等功能。同时，提供了YML文件中的相关配置示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

@Configuration
public class MyDataSourceConfig {

    // 默认自动配置判断容器中没有才会配 @ConditionalOnMissingBean(DataSource.class) HikariDataSource
    @ConfigurationProperties("spring.datasource")
    @Bean
    public DataSource dataSource() throws SQLException {
        DruidDataSource dataSource = new DruidDataSource();
//        dataSource.setUrl();
//        dataSource.setUsername();
//        dataSource.setPassword();
//        dataSource.setDriver();
        // 加入监控
        dataSource.setFilters("stat,wall");
        return dataSource;
    }

    /**
     * 配置durid的监控页面
     * @return
     */
    @Bean
    public ServletRegistrationBean statViewServlet(){

        StatViewServlet statViewServlet = new StatViewServlet();
        ServletRegistrationBean<StatViewServlet> registrationBean = new ServletRegistrationBean<>(statViewServlet, "/druid/*");

        registrationBean.addInitParameter("loginUsername","admin");
        registrationBean.addInitParameter("loginPassword","123456");
        return registrationBean;
    }

    // WebStatFilter用于采集web-jdbc关联监控的数据。
    @Bean
    public FilterRegistrationBean webStatFilter(){
        WebStatFilter webStatFilter = new WebStatFilter();
        FilterRegistrationBean<WebStatFilter> filterRegistrationBean = new FilterRegistrationBean<>(webStatFilter);
        filterRegistrationBean.setUrlPatterns(Arrays.asList("/*"));
        filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

        return filterRegistrationBean;
    }

    // spring监控
    @Bean
    public DruidStatInterceptor druidStatInterceptor() {
        DruidStatInterceptor dsInterceptor = new DruidStatInterceptor();
        return dsInterceptor;
    }

    // aop定义切点
    @Bean
    @Scope("prototype")
    public JdkRegexpMethodPointcut druidStatPointcut() {
        JdkRegexpMethodPointcut pointcut = new JdkRegexpMethodPointcut();
        pointcut.setPattern("com.ramelon.admin.controller.*");
        return pointcut;
    }

    // Springboot的切点可配置化
    @Bean
    public DefaultPointcutAdvisor druidStatAdvisor(DruidStatInterceptor druidStatInterceptor, JdkRegexpMethodPointcut druidStatPointcut) {
        DefaultPointcutAdvisor defaultPointAdvisor = new DefaultPointcutAdvisor();
        defaultPointAdvisor.setPointcut(druidStatPointcut);
        defaultPointAdvisor.setAdvice(druidStatInterceptor);
        return defaultPointAdvisor;
    }

}

# yml文件配置
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/demo?useSSL=false
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
    #    type: com.zaxxer.hikari.HikariDataSource
  jdbc:
    template:
      query-timeout: 3