SpringBoot整合Druid--开启后台性能监控

╰半夏微凉° 2022-03-30 15:42 329阅读 0赞

>   **如果我的博客能够帮到大家能够点个赞，关注一下，以后还会更新更过JavaWeb的高级技术，大家的支持就是我继续更新的动力。谢谢。**

>         今天，来做一个SpringBoot整和Druid数据源的Demo，我们知道Druid是阿里巴巴的数据源，也就是第三方数据源，需要在pom.xml文件中加入依赖，然后配置Druid的属性，开启后台性能监控功能。话不多说，开撸！

## 一、环境搭建  ##

### 步骤： ###

*  创建Spring Boot工程
 *  导入依赖
 *  编写配置文件
 *  配置application.yml
 *  测试

### 1.创建SpringBoot工程工程，大家都会，略 ###

### 2.导入依赖：pom.xml ###

>     <?xml version="1.0" encoding="UTF-8"?>
>     <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
>         <modelVersion>4.0.0</modelVersion>
>         <parent>
>             <groupId>org.springframework.boot</groupId>
>             <artifactId>spring-boot-starter-parent</artifactId>
>             <version>2.1.1.RELEASE</version>
>             <relativePath/> 
>         </parent>
>         <groupId>com.nyist</groupId>
>         <artifactId>spring-boot-06-data-jdbc</artifactId>
>         <version>0.0.1-SNAPSHOT</version>
>         <name>spring-boot-06-data-jdbc</name>
>         <description>Demo project for Spring Boot</description>
>     
>         <properties>
>             <java.version>1.8</java.version>
>         </properties>
>     
>         <dependencies>
>     
>             
>             <dependency>
>                 <groupId>org.springframework.boot</groupId>
>                 <artifactId>spring-boot-starter-jdbc</artifactId>
>             </dependency>
>             <dependency>
>                 <groupId>org.springframework.boot</groupId>
>                 <artifactId>spring-boot-starter-web</artifactId>
>             </dependency>
>     
>             
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <scope>runtime</scope>
>             </dependency>
>     
>             
>             <dependency>
>                 <groupId>com.alibaba</groupId>
>                 <artifactId>druid</artifactId>
>                 <version>1.1.8</version>
>             </dependency>
>     
>             <dependency>
>                 <groupId>org.springframework.boot</groupId>
>                 <artifactId>spring-boot-starter-test</artifactId>
>                 <scope>test</scope>
>             </dependency>
>         </dependencies>
>     
>         <build>
>             <plugins>
>                 <plugin>
>                     <groupId>org.springframework.boot</groupId>
>                     <artifactId>spring-boot-maven-plugin</artifactId>
>                 </plugin>
>             </plugins>
>         </build>
>     
>     </project>

###  3.编写配置文件 ###

>     package com.nyist.springboot06datajdbc.config;
>     
>     import com.alibaba.druid.pool.DruidDataSource;
>     import com.alibaba.druid.support.http.StatViewServlet;
>     import com.alibaba.druid.support.http.WebStatFilter;
>     import org.springframework.boot.context.properties.ConfigurationProperties;
>     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 javax.sql.DataSource;
>     import java.util.HashMap;
>     import java.util.Map;
>     
>     @Configuration
>     public class DruidConfig {
>     
>         //@ConfigurationProperties 是将 阿里巴巴druid 的数据源 配置的属性和 属性文件绑定在一起
>         @ConfigurationProperties(prefix = "spring.datasource")
>         @Bean
>         public DataSource druid(){
>             return new DruidDataSource();
>         }
>     
>         //配置 Druid 的监控
>         //1.配置一个管理后台的Servlet
>         @Bean
>         public ServletRegistrationBean statViewServlet(){
>             ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
>             Map<String,String> map = new HashMap<>();
>             map.put("loginUsername","admin");
>             map.put("loginPassword","123456");
>             map.put("allow","localhost");       //不写 或者为null 默认允许所有
>             map.put("deny","192.168.1.122");
>             bean.setInitParameters(map);
>             return  bean;
>         }
>     
>         //2.配置一个监控的Filter
>         @Bean
>         public FilterRegistrationBean webStatFilter(){
>             FilterRegistrationBean initParam = new FilterRegistrationBean();
>             initParam.setFilter(new WebStatFilter());
>             Map<String,String> map = new HashMap<>();
>             //初始化不拦截请求的参数
>             map.put("exclusions","*.css,*.png,*.jpg,*.js,/druid/*");
>             initParam.setInitParameters(map);
>             return initParam;
>         }
>     
>     }

### 4.配置application.yml ###

>     spring:
>         datasource:
>           username: root
>           password: root
>           url: jdbc:mysql://localhost:3306/springdata_jdbc?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
>           type: com.alibaba.druid.pool.DruidDataSource
>     
>           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,logback
>           maxPoolPreparedStatementPerConnectionSize: 20
>           useGlobalDataSourceStat: true
>           connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
>     
>     #      建表
>     #      schema:
>     #        - classpath:jpa_department.sql
>     #        - classpath:jpa_manager.sql

### 5.测试，代码如下： ###

>     package com.nyist.springboot06datajdbc;
>     
>     import org.junit.Test;
>     import org.junit.runner.RunWith;
>     import org.springframework.beans.factory.annotation.Autowired;
>     import org.springframework.boot.test.context.SpringBootTest;
>     import org.springframework.test.context.junit4.SpringRunner;
>     
>     import javax.sql.DataSource;
>     import java.sql.Connection;
>     import java.sql.SQLException;
>     
>     @RunWith(SpringRunner.class)
>     @SpringBootTest
>     public class SpringBoot06DataJdbcApplicationTests {
>     
>         @Autowired  //开启自动注入
>         private DataSource dataSource;
>         @Test
>         public void contextLoads() throws SQLException {
>             //DataSource:class com.zaxxer.hikari.HikariDataSource
>             System.out.println("\nDataSource:" + dataSource.getClass());
>             Connection connection = dataSource.getConnection();
>             //HikariProxyConnection@749362556 wrapping com.mysql.cj.jdbc.ConnectionImpl@5e671e20
>             System.out.println("****************************:" + connection);
>             connection.close();
>         }
>     }

### 6.运行结果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70 1][]

### 7.源码下载： [下载][Link 1] ###

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70]: /images/20220330/7dd2d719fc8c45e384d5203d0b3dcefa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70 1]: /images/20220330/27b1956acd4843b7b59b50f7217a2e39.png
[Link 1]: https://download.csdn.net/download/lvhaoguang0/10899807