springboot和druid实现监控功能

1.依赖导入 <parent>     <groupId>org.springframework.boot</groupId>     <artifactId>spring-boot-starter-parent</artifactId>     <version>1.5.7.RELEASE</version>     <relativePath/> <!-- lookup parent from repository --> </parent> <dependency>     <groupId>org.springframework.boot</groupId>     <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <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>org.springframework.boot</groupId>     <artifactId>spring-boot-devtools</artifactId>     <scope>runtime</scope> </dependency> <dependency>     <groupId>mysql</groupId>     <artifactId>mysql-connector-java</artifactId>     <scope>runtime</scope> </dependency> <dependency>     <groupId>org.springframework.boot</groupId>     <artifactId>spring-boot-starter-test</artifactId>     <scope>test</scope> </dependency> <dependency>     <groupId>com.alibaba</groupId>     <artifactId>druid</artifactId>     <version>1.1.8</version> </dependency> 2.application.properties配置 # 数据库访问配置 spring.datasource.type=com.alibaba.druid.pool.DruidDataSource #wumanxinTest spring.datasource.url=jdbc:mysql://192.168.227.2:3306/picturelabel spring.datasource.username=root spring.datasource.password=123456 spring.datasource.driverClassName=com.mysql.jdbc.Driver # 下面为连接池的补充设置，应用到上面所有数据源中 spring.datasource.initialSize=5 spring.datasource.minIdle=5 spring.datasource.maxActive=20 # 配置获取连接等待超时的时间 spring.datasource.maxWait=60000 # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 spring.datasource.timeBetweenEvictionRunsMillis=60000 # 配置一个连接在池中最小生存的时间，单位是毫秒 spring.datasource.minEvictableIdleTimeMillis=300000 spring.datasource.validationQuery=SELECT 1 FROM DUAL spring.datasource.testWhileIdle=true spring.datasource.testOnBorrow=false spring.datasource.testOnReturn=false # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙 spring.datasource.filters=stat,wall,log4j spring.datasource.logSlowSql=true spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 #添加了下面的配置才可以进行自动生成表 spring.jpa.hibernate.ddl-auto=update spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl spring.jpa.show-sql=true 3.配置类 package com.irisian.picturelabel.configuration; import com.alibaba.druid.pool.DruidDataSource; import com.alibaba.druid.support.http.StatViewServlet; import com.alibaba.druid.support.http.WebStatFilter; import org.slf4j.Logger; import org.slf4j.LoggerFactory; 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.sql.SQLException; /**  * Author:吴满心  * Date:2018/5/11  * Function:用来配置druid数据源  */ @Configuration public class DruidConfig {     private Logger logger = LoggerFactory.getLogger(DruidConfig.class);     @Value("${spring.datasource.url}")     private String dbUrl;     @Value("${spring.datasource.username}")     private String username;     @Value("${spring.datasource.password}")     private String password;     @Value("${spring.datasource.driverClassName}")     private String driverClassName;     @Value("${spring.datasource.initialSize}")     private int initialSize;     @Value("${spring.datasource.minIdle}")     private int minIdle;     @Value("${spring.datasource.maxActive}")     private int maxActive;     @Value("${spring.datasource.maxWait}")     private int maxWait;     @Value("${spring.datasource.timeBetweenEvictionRunsMillis}")     private int timeBetweenEvictionRunsMillis;     @Value("${spring.datasource.minEvictableIdleTimeMillis}")     private int minEvictableIdleTimeMillis;     @Value("${spring.datasource.validationQuery}")     private String validationQuery;     @Value("${spring.datasource.testWhileIdle}")     private boolean testWhileIdle;     @Value("${spring.datasource.testOnBorrow}")     private boolean testOnBorrow;     @Value("${spring.datasource.testOnReturn}")     private boolean testOnReturn;     @Value("${spring.datasource.filters}")     private String filters;     @Value("${spring.datasource.logSlowSql}")     private String logSlowSql;     @Bean     public ServletRegistrationBean druidServlet() {         ServletRegistrationBean reg = new ServletRegistrationBean();         reg.setServlet(new StatViewServlet());         reg.addUrlMappings("/druid/*");         reg.addInitParameter("loginUsername", username);         reg.addInitParameter("loginPassword", password);         reg.addInitParameter("logSlowSql", logSlowSql);         return reg;     }     @Bean     public FilterRegistrationBean filterRegistrationBean() {         FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();         filterRegistrationBean.setFilter(new WebStatFilter());         filterRegistrationBean.addUrlPatterns("/*");         filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");         filterRegistrationBean.addInitParameter("profileEnable", "true");         return filterRegistrationBean;     }     @Bean     public DruidDataSource druidDataSource() {         DruidDataSource datasource = new DruidDataSource();         datasource.setUrl(dbUrl);         datasource.setUsername(username);         datasource.setPassword(password);         datasource.setDriverClassName(driverClassName);         datasource.setInitialSize(initialSize);         datasource.setMinIdle(minIdle);         datasource.setMaxActive(maxActive);         datasource.setMaxWait(maxWait);         datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);         datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);         datasource.setValidationQuery(validationQuery);         datasource.setTestWhileIdle(testWhileIdle);         datasource.setTestOnBorrow(testOnBorrow);         datasource.setTestOnReturn(testOnReturn);         try {             datasource.setFilters(filters);         } catch (SQLException e) {             logger.error("druid configuration initialization filter", e);         }         return datasource;     } } 1. 访问 http://localhost:8080/druid/login.html 5.此外 也可以使用servlet配置方式来配置servlet和filter,此种方式在@SpringBootApplication添加@ServletComponentScan注解之后和@Configuration方式等价 Filter类 package com.irisian.picturelabel.Filter; import com.alibaba.druid.support.http.WebStatFilter; import javax.servlet.annotation.WebFilter; import javax.servlet.annotation.WebInitParam; /**  * Author:吴满心  * Date:2018/5/12  * Function:  */ @WebFilter(filterName="druidWebStatFilter",urlPatterns="/*",         initParams={                 @WebInitParam(name="exclusions",value="*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")//忽略资源         } ) public class DruidStatFilter extends WebStatFilter { }   Servlet package com.irisian.picturelabel.Filter; import com.alibaba.druid.support.http.StatViewServlet; import javax.servlet.annotation.WebInitParam; import javax.servlet.annotation.WebServlet; /**  * Author:吴满心  * Date:2018/5/12  * Function:  */ @WebServlet(urlPatterns="/druid/*",         initParams={                 @WebInitParam(name="allow",value="127.0.0.1,192.168.163.1"),// IP白名单(没有配置或者为空，则允许所有访问)                 @WebInitParam(name="deny",value="192.168.1.73"),// IP黑名单 (存在共同时，deny优先于allow)                 @WebInitParam(name="loginUsername",value="admin"),// 用户名                 @WebInitParam(name="loginPassword",value="123456"),// 密码                 @WebInitParam(name="resetEnable",value="false")// 禁用HTML页面上的“Reset All”功能         }) public class DruidStatViewServlet extends StatViewServlet { }