pom.xml

       
     
      com.alibaba
        
     
      druid
        
     
      1.0.27
     
    

配置filter

@WebFilter(filterName = "druidWebStatFilter", urlPatterns = "/*",        initParams = {@WebInitParam(name = "exclusions", value = "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")// 忽略资源        })public class DruidFilter extends WebStatFilter {}

自定义的servlet

@WebServlet(urlPatterns = "/druid/*",        initParams = {@WebInitParam(name = "allow", value = "127.0.0.1"),//访问白名单                @WebInitParam(name = "deny", value = "192.168.0.121"),//访问黑名单                @WebInitParam(name = "loginUsername", value = "admin"),//登录名                @WebInitParam(name = "loginPassword", value = "123456"),//登录密码                @WebInitParam(name = "resetEnable", value = "false")})//禁止页面reset allpublic class DruidServlet extends StatViewServlet{}

然后访问 http://localhost:8080/druid/index.html

但是会发现sql监控一直是空的，发现是springboot的版本问题，回退到1.3+是没有问题的。1.4+就是空的，所以要手动配置下DataSource，手动引入配置文件的的属性

@Configurationpublic class DruidDBConfig {    private Logger logger = LoggerFactory.getLogger(DruidDBConfig.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.poolPreparedStatements}")    private boolean poolPreparedStatements;    @Value("${spring.datasource.maxPoolPreparedStatementPerConnectionSize}")    private int maxPoolPreparedStatementPerConnectionSize;    @Value("${spring.datasource.filters}")    private String filters;    @Value("{spring.datasource.connectionProperties}")    private String connectionProperties;    @Bean     //声明其为Bean实例    @Primary  //在同样的DataSource中，首先使用被标注的DataSource    public DataSource dataSource() {        DruidDataSource datasource = new DruidDataSource();        datasource.setUrl(this.dbUrl);        datasource.setUsername(username);        datasource.setPassword(password);        datasource.setDriverClassName(driverClassName);        //configuration          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);        datasource.setPoolPreparedStatements(poolPreparedStatements);        datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);        try {            datasource.setFilters(filters);        } catch (SQLException e) {            logger.error("druid configuration initialization filter", e);        }        datasource.setConnectionProperties(connectionProperties);        return datasource;    }}

再次就会发现sql监控就有统计数据了