SpringBoot25：使用druid集成sql监控

超、凢脫俗 2022-01-23 23:21 317阅读 0赞

# 第一步:引入依赖 #

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.6</version>
            </dependency>
    
            
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>

# 第二步：在yml中添加配置 #

type: com.alibaba.druid.pool.DruidDataSource #Druid连接池
        initialSize: 5
        minIdle: 5
        maxActive: 20
        maxWait: 60000
        timeBetweenEvictionRunsMillis: 60000
        minEvictableIdleTimeMillis: 300000
        validationQuery: SELECT 1 FROM DUAL
        testWhileIdle: true
        testOnBorrow: false
        testOnReturn: false
        poolPreparedStatements: true
        #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
        filters: stat,wall,log4j
        maxPoolPreparedStatementPerConnectionSize: 20
        useGlobalDataSourceStat: true
        connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

# 第三步：编写配置类 #

@Configuration
    public class DruidConfig {
        @ConfigurationProperties(prefix = "spring.datasource")
        @Bean
        public DataSource druid(){
            return new DruidDataSource();
        }
    
    
        /**
         * 配置servlet
         */
        @Bean
        public ServletRegistrationBean statViewServlet(){
            ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
            HashMap<Object, Object> hashMap = new HashMap<>();
            hashMap.put("loginUsername","admin");
            hashMap.put("loginPassword","1234");
            hashMap.put("allow","");//允许访问所有
            return bean;
        }
    
        /**
         * 配置filter
         */
        @Bean
        public FilterRegistrationBean webStatFilter(){
            FilterRegistrationBean bean = new FilterRegistrationBean(new WebStatFilter());
            HashMap<Object, Object> HashMap = new HashMap<>();
            HashMap.put("exclusions","*.js,*.css,/durid/*");
            bean.setInitParameters(HashMap);
            bean.setUrlPatterns(Arrays.asList("/*"));
            return bean;
        }
    }

# 第四步：启动服务器并访问指定地址 #

http://localhost:8080/druid

# 结果： #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTk4NDY3_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4MTk4NDY3_size_16_color_FFFFFF_t_70]: /images/20220124/d05eaec68b6b49b18a82fec7b74795de.png