springboot项目中实现访问druid内置监控页面

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.9</version>
</dependency>

# 数据库访问配置
# 主数据源，默认的
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
spring.datasource.username=root
spring.datasource.passWord=123456
 
# 下面为连接池的补充设置，应用到上面所有数据源中
# 初始化大小，最小，最大
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
# 打开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  

@Bean
public ServletReGIStrationBean<StatViewServlet> druidStatViewServlet() {
	ServletRegistrationBean<StatViewServlet> registrationBean = new ServletRegistrationBean<>(new StatViewServlet(),  "/druid                                                                                                            
  @Bean                                                                                                          
  public ServletRegistrationBean druidStatViewServlet() { 
     //先配置管理后台的servLet，访问的入口为/druid/                                                       
      ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(                             
             new StatViewServlet(), "/druid                                                                                                                      
 @Bean                                                                                                                    
 public FilterRegistrationBean druidStatFilter(){                                                                         
     FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(                                          
             new WEBStatFilter());                                                                                        
     // 添加过滤规则.                                                                                                           
     filterRegistrationBean.addUrlPatterns("                          
  @Bean(name = "statFilter")                                                 
  public StatFilter statFilter(){                                            
      StatFilter statFilter = new StatFilter();                              
      //慢sql时间设置,即执行时间大于200毫秒的都是慢sql                                         
      statFilter.setSlowSqlMillis(30);                                       
      statFilter.setLogSlowSql(true);
      statFilter.setMergeSql(true);                                        
      return statFilter;                                                     
  }                                                                          
                                                                            
  @Bean(name = "logFilter")                                                  
  public Slf4jLogFilter logFilter(){                                         
      Slf4jLogFilter slf4jLogFilter = new Slf4jLogFilter();                  
      slf4jLogFilter.setDataSourceLogEnabled(true);                          
      slf4jLogFilter.setStatementExecutableSqlLogEnable(true);               
      return slf4jLogFilter;                                                 
  }    

  logging:
   pattern: #配置日志格式 %d：日期 , %msg：日志信息 ，%n换行
    console: "%d - %msg%n" #设置控制台打印格式
   file: "%d{yyyy/MM/dd-HH:mm} %-5level %logger- %msg%n"
 level:
  root: INFO
     org:
       springframework:
       security: ERROR
       web: ERROR
       hhu.yu: INFO
 file:
  name: YU.log
     max-history: 30

@Bean                                                                    
 @Primary                      
 @Qualifier("mainDataSource")                                             
 @ConfigurationProperties(prefix = "spring.datasource.main")              
 DataSource mainConfig() throws SQLException{                             
     DruidDataSource build = DruidDataSourceBuilder.create().build();     
     List<Filter> filters = new ArrayList<>();                            
     filters.add(statFilter());                                           
     filters.add(logFilter());                                            
     build.setProxyFilters(filters);                                      
     return build;   

@Configuration
@EnableAspectJAutoProxy(proxyTargetClass = true)
public class DruidAspectConfig {
    @Bean
    public DruidStatInterceptor druidStatInterceptor() {
        DruidStatInterceptor dsInterceptor = new DruidStatInterceptor();
        return dsInterceptor;
    }
    @Bean
    @Scope("prototype")
    public jdkRegexpMethodPointcut druidStatPointcut() {
        JdkRegexpMethodPointcut pointcut = new JdkRegexpMethodPointcut();
        pointcut.setPatterns("com.qa.cloud.mapper.*","com.qa.cloud.service.*");
        return pointcut;
    }
    @Bean
    public DefaultPointcutAdvisor druidStatAdvisor(DruidStatInterceptor druidStatInterceptor, JdkRegexpMethodPointcut druidStatPointcut) {
        DefaultPointcutAdvisor defaultPointAdvisor = new DefaultPointcutAdvisor();
        defaultPointAdvisor.setPointcut(druidStatPointcut);
        defaultPointAdvisor.setAdvice(druidStatInterceptor);
        return defaultPointAdvisor;
    }