springboot druid 数据源监控

最新推荐文章于 2025-10-10 13:59:50 发布

原创最新推荐文章于 2025-10-10 13:59:50 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

springboot相关学习专栏收录该内容

13 篇文章

订阅专栏

本文介绍如何使用Druid监控数据库连接池的运行状态，包括配置监控过滤器、设置访问权限及界面定制，确保数据库操作的高效与安全。

首现要在配置数据源的地方开启要监控

# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
filters: stat,wall,log4j

package com.lenovo.esim.cloud.order.config.datasourcemonitor;

import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import java.util.HashMap;
import java.util.Map;

/**
 * datasource 数据源监控中心
 */
@Slf4j
@Configuration
public class DruidMonitorConfig {

    @Value("${security.user.name}")
    private String userName;
    @Value("${security.user.password}")
    private String password;

    @Bean
    public ServletRegistrationBean druidServlet() {
        log.info("init Druid Servlet Configuration ");
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean();
        servletRegistrationBean.setServlet(new StatViewServlet());
        servletRegistrationBean.addUrlMappings("/druid/*");
        Map<String, String> initParameters = new HashMap<String, String>();
        initParameters.put("loginUsername",userName);// 用户名
        initParameters.put("loginPassword", password);// 密码
        initParameters.put("resetEnable", "false");// 禁用HTML页面上的“Reset All”功能
        initParameters.put("allow", ""); // IP白名单 (没有配置或者为空，则允许所有访问)
        // initParameters.put("deny", "192.168.20.38");// IP黑名单
        // (存在共同时，deny优先于allow)
        servletRegistrationBean.setInitParameters(initParameters);
        return servletRegistrationBean;
    }

    @Bean
    public FilterRegistrationBean filterRegistrationBean() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();
        filterRegistrationBean.setFilter(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();
   }