springboot中使用druid和监控配置

# Mysql数据库连接 alibaba数据源
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=
# 数据源初始化大小,最小,最大
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
# 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效。
spring.datasource.testWhileIdle=true
# 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。
spring.datasource.testOnBorrow=false
# 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能
spring.datasource.testOnReturn=false
# 打开PSCache，并且指定每个连接上PSCache的大小
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，’wall’用于防火墙
spring.datasource.filters=stat,wall,log4j
# 通过connectProperties属性来打开mergeSql功能；慢SQL记录
spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
# 合并多个DruidDataSource的监控数据
spring.datasource.useGlobalDataSourceStat=true

import com.alibaba.druid.support.http.StatViewServlet;

import javax.servlet.annotation.WebInitParam;
import javax.servlet.annotation.WebServlet;

    /**
     * Create with Intellij idea
     * User: mingtian
     * Date:2018/7/10
     * Time:22:10
     * druid数据源状态监控.
     **/
    @WebServlet(urlPatterns = "/druid/",
            initParams = {
                    @WebInitParam(name = "allow", value = "127.0.0.1"), //ip白名单(没有配置为空,则允许所有访问)
                    @WebInitParam(name = "deny", value = ""),//ip黑名单(存在时,deny优先于allow)
                    @WebInitParam(name = "loginUsername", value = "admin1"), //用户名
                    @WebInitParam(name = "loginPassword", value = "123456"),//密码
                    @WebInitParam(name = "resetEnable", value = "false")//禁用HTML页面上的"resetAll"功能
            })
    public class DruidStatViewServlet extends StatViewServlet {
        private static final long serialVersionID = 1L;
    }

import com.alibaba.druid.support.http.WebStatFilter;

import javax.servlet.annotation.WebFilter;
import javax.servlet.annotation.WebInitParam;

    /**
     * Create with Intellij idea
     * User:lzm
     * Date:2018/7/10
     * Time:22:06
     * druid过滤器
     **/
    @WebFilter(filterName = "druidWebStatFilter", urlPatterns = "/",
            initParams = {
                    @WebInitParam(name = "exclusions", value = "*.js,*.gif,*.jpg,*.bmp,*.css,*.ico,/druid/*")
                    //忽略资源
            })
    public class DruidStatFilter extends WebStatFilter {
    }

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.apache.tomcat.jdbc.pool.DataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Value;
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 java.sql.SQLException;

    /**
     * Create with Intellij idea
     * User: mingtian
     * Date:2018/7/10
     * Time:17:43
     */
    @Configuration
    public class DruidConfig {
        private Logger logger = LoggerFactory.getLogger(DruidConfig.class);

        @Bean
        @ConfigurationProperties(“spring.datasource”)
        public DruidDataSource druidDataSource() {

            DruidDataSource druidDataSource = new DruidDataSource();
            return druidDataSource;
        }
    }

    /**
     * 注册一个StatViewServlet
     **/
    @Bean
    public ServletRegistrationBean druidStatViewServlet() {
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),” / druid /“)
        ;
        //添加初始化参数initParams
        //白名单
        servletRegistrationBean.addInitParameter(“allow”,” 127.0 .0 .1”);

        //ip黑名单(存在共同时，deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page.
        servletRegistrationBean.addInitParameter(“deny”,””);
        //登录查看信息的账号和密码
        servletRegistrationBean.addInitParameter(“loginUsername”,”admin”);
        servletRegistrationBean.addInitParameter(“loginPassword”,”123456”);
        //是否能够重置数据
        servletRegistrationBean.addInitParameter(“resetEnable”,” false”);
        return servletRegistrationBean;
    }

    /**
     * 注册一个：filterRegistrationBean
     *
     * @return
     **/
    @Bean
    public FilterRegistrationBean druidStatFilter() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        //添加过滤规则
        filterRegistrationBean.addUrlPatterns(“ /“);
        //filterRegistrationBean.addInitParameter(“urlPatterns”,”/“);
        //添加不需要忽略的格式信息
        filterRegistrationBean.addInitParameter(“exclusions”,”.js, gif,.jpg,.png,.css,.ico,/druid2 /“);
        return filterRegistrationBean;
    }