SpringBoot(2.X版本)配置Druid(亲测成功)

1.Pom文件中引入Druid依赖

我的Pom依赖如下：

<dependencies>
		<!--SpringBoot的starter-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        
        <!--Druid数据库连接池依赖-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.14</version>
        </dependency>
        
		<!--Mybatis依赖，这里也可以用原生的JDBC依赖，但是Mybatis中包含了JDBC所以比较方便-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.1</version>
        </dependency>
		
		<!--mysql数据库连接依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

		<!--测试包依赖-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

2.在application.properties中添加如下配置：

spring.datasource.druid.url= #这里为连接本机或远程数据库的URL地址
spring.datasource.druid.username= # 数据库登陆用户名
spring.datasource.druid.password= # 数据库登陆密码
spring.datasource.druid.driver-class-name=com.mysql.cj.jdbc.Driver #数据库连接驱动

#连接池配置
spring.datasource.druid.initial-size=5
spring.datasource.druid.max-active=100
spring.datasource.druid.min-idle=5
spring.datasource.druid.max-wait=60000
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
spring.datasource.druid.validation-query-timeout=60000
spring.datasource.druid.test-on-borrow=false
spring.datasource.druid.test-on-return=false
spring.datasource.druid.test-while-idle=true
spring.datasource.druid.time-between-eviction-runs-millis=60000
spring.datasource.druid.min-evictable-idle-time-millis=100000
spring.datasource.druid.max-evictable-idle-time-millis=100000000000

# WebStatFilter配置，说明请参考Druid Wiki，配置_配置WebStatFilter
spring.datasource.druid.web-stat-filter.enabled=true
spring.datasource.druid.web-stat-filter.url-pattern=/*
spring.datasource.druid.web-stat-filter.exclusions=*.js,*.css,*.gif,*.jpg,*.png,*.ico,/druid/*
# StatViewServlet配置，说明请参考Druid Wiki，配置_StatViewServlet配置
spring.datasource.druid.stat-view-servlet.enabled= true
spring.datasource.druid.stat-view-servlet.url-pattern= /druid/*
spring.datasource.druid.stat-view-servlet.reset-enable= false
#这里的username和password为登陆druid监控首页的登录名和密码
spring.datasource.druid.stat-view-servlet.login-username= admin 
spring.datasource.druid.stat-view-servlet.login-password= 1234
#配置允许白名单（既然有白名单，相应的就会有黑名单）
spring.datasource.druid.stat-view-servlet.allow= 127.0.0.1


# 配置StatFilter
spring.datasource.druid.filter.stat.enabled=true
spring.datasource.druid.filter.stat.db-type=mysql
spring.datasource.druid.filter.stat.log-slow-sql=true
spring.datasource.druid.filter.stat.slow-sql-millis=5000

# 配置WallFilter
spring.datasource.druid.filter.wall.enabled=true
spring.datasource.druid.filter.wall.db-type=mysql
spring.datasource.druid.filter.wall.config.delete-allow=false
spring.datasource.druid.filter.wall.config.drop-table-allow=false

3.配置完properties过后，启动主程序

在浏览器上访问URL http://127.0.0.1:8080/druid 进入登陆首页：

输入在properties中设置的账号和密码进入监控页面：

至此，配置完毕。详情可以去Github上看看。比我这个详细得多。还有这个阿里云的广告是阿里自己搞的，和我没有一点关系哦！！