<!-- druid數(shù)據(jù)源 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.23</version>
</dependency>

<!-- mysql驅(qū)動-->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.30</version>
</dependency>


<!--mybatis，引入了 SpringBoot的 JDBC 模塊，所以，默認是使用 hikari 作為數(shù)據(jù)源-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.0</version>
    <exclusions>
        <!-- 排除默認的 HikariCP 數(shù)據(jù)源 -->
        <exclusion>
            <groupId>com.zaxxer</groupId>
            <artifactId>HikariCP</artifactId>
        </exclusion>
    </exclusions>
</dependency>

# 數(shù)據(jù)庫連接配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mysql?relaxAutoCommit=true&zeroDateTimeBehavior=convertToNull&characterEncoding=utf-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=root

# 配置初始化大小、最小、最大
spring.datasource.druid.initial-size=5
spring.datasource.druid.min-idle=1
spring.datasource.druid.max-active=10

# 配置獲取連接等待超時的時間(單位：毫秒)
spring.datasource.druid.max-wait=60000

# 配置StatViewServlet（監(jiān)控頁面），用于展示Druid的統(tǒng)計信息
spring.datasource.druid.stat-view-servlet.enabled=true

# 訪問內(nèi)置監(jiān)控頁面的路徑，內(nèi)置監(jiān)控頁面的首頁是/druid/index.html
spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*

# 監(jiān)控頁面賬戶與密碼
spring.datasource.druid.stat-view-servlet.login-username=admin
spring.datasource.druid.stat-view-servlet.login-password=admin

# 配置WebStatFilter，用于采集web關(guān)聯(lián)監(jiān)控的數(shù)據(jù)
spring.datasource.druid.web-stat-filter.enabled=true
spring.datasource.druid.web-stat-filter.url-pattern=/*
spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*

# 開啟druiddatasource的狀態(tài)監(jiān)控
spring.datasource.druid.filter.stat.enabled=true
spring.datasource.druid.filter.stat.db-type=mysql

# 開啟慢sql監(jiān)控
spring.datasource.druid.filter.stat.log-slow-sql=true

# 超過500ms 就認為是慢sql，記錄到日志中,為了測試我這邊設(shè)置的小一點
spring.datasource.druid.filter.stat.slow-sql-millis=2

# 也可以這樣子，不過這個使用的都是默認配置了
spring.datasource.druid.filters=stat,wall

@Configuration
@ConditionalOnWebApplication
@AutoConfigureAfter(DruidDataSourceAutoConfigure.class)
@ConditionalOnProperty(name = "spring.datasource.druid.stat-view-servlet.enabled", havingValue = "true", matchIfMissing = true)
public class DruidAdConfig {

    @Bean
    public FilterRegistrationBean removeDruidAdFilterRegistrationBean(DruidStatProperties properties) {

        // 獲取web監(jiān)控頁面的參數(shù)
        DruidStatProperties.StatViewServlet config = properties.getStatViewServlet();
        // 提取common.js的配置路徑
        String pattern = config.getUrlPattern() != null ? config.getUrlPattern() : "/druid/*";
        String commonJsPattern = pattern.replaceAll("\\*", "js/common.js");

        final String filePath = "support/http/resources/js/common.js";

        //創(chuàng)建filter進行過濾
        Filter filter = new Filter() {
            @Override
            public void init(FilterConfig filterConfig) throws ServletException {}

            @Override
            public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
                chain.doFilter(request, response);
                // 重置緩沖區(qū)，響應(yīng)頭不會被重置
                response.resetBuffer();
                // 獲取common.js
                String text = Utils.readFromResource(filePath);
                // 正則替換banner, 除去底部的廣告信息
                text = text.replaceAll("<a.*?banner\"></a><br/>", "");
                text = text.replaceAll("powered.*?shrek.wang</a>", "");
                response.getWriter().write(text);
            }

            @Override
            public void destroy() {}
        };

        FilterRegistrationBean registrationBean = new FilterRegistrationBean();
        registrationBean.setFilter(filter);
        registrationBean.addUrlPatterns(commonJsPattern);
        return registrationBean;
    }
}

@RestController
@RequestMapping(value = "/druid")
public class DruidStatController {

    @GetMapping("/stat")
    public Object druidStat(){
        // 獲取數(shù)據(jù)源的監(jiān)控數(shù)據(jù)
        return DruidStatManagerFacade.getInstance().getDataSourceStatDataList();
    }
}