SpringBoot从入门到精通教程（十四）- Druid连接池集成

我就是我 2021-10-15 03:01 389阅读 0赞

# 需求背景 #

> Springboot集成Druid连接池集成，来自阿里的数据库连接池，Druid加入了日志监控，可以很好的监控DB池连接和SQL的执行情况等。

# 代码演示 #

此项目在教程：[SpringBoot从入门到精通教程（六）- Mysql和Mybatis+XML用法详解][SpringBoot_- Mysql_Mybatis_XML]的基础上改造的

**1. 引入Druid最新maven依赖**

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

**2. application.yml文件配置，配置Druid。多数据源项目时，用法同理**（[SpringBoot从入门到精通教程（七）- 多数据源用法][SpringBoot_-]）

spring:
       datasource:
          driverClassName: com.mysql.jdbc.Driver
          url: jdbc:mysql://localhost:3306/cfdb?useUnicode=true&autoReconnect=true&allowMultiQueries=true&useSSL=false
          username: root
          password: a123456
          # 使用alibaba的druid连接池、监控
          type: com.alibaba.druid.pool.DruidDataSource
          druid:
             max-active: 10
             max-wait: 5000
             min-idle: 5
             initial-size: 2
             validation-query: SELECT 1
             test-on-borrow: false
             test-while-idle: true
             time-between-eviction-runs-millis: 18800
             web-stat-filter:
                enabled: true
                exclusions: js,gif,jpg,png,css,ico,/druid/*
             stat-view-servlet:
                enabled: true
                login-username: druid
                login-password: druid@2019
    server:
       port: 9090
    mybatis:
       config-location: classpath:mybatis-config.xml

注意：这里是配置druid web访问界面的账号的密码

stat-view-servlet:
        enabled: true
        login-username: druid
        login-password: druid@2019

**3. 启动项目**

启动日志中，可以看到Druid已成功加载

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70][]

**4. 分别访问接口，Druid会监控到的**

[http://localhost:9090/hello][http_localhost_9090_hello]

[http://localhost:9090/listCities][http_localhost_9090_listCities]

[http://localhost:9090/getCityById?id=1][http_localhost_9090_getCityById_id_1]

**5. 登录Druid管理控制界面**

访问地址：[http://localhost:9090/druid/][http_localhost_9090_druid]，输入前面配置的账号名和密码，即可登录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 1][]

登录成功：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 2][]

# 案例说明 #

### **SQL监控界面** ###

可以看得到sql执行的相关数据，比如次数、执行时间等

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 3][]

### **URL监控界面** ###

可以看得到接口访问的相关数据，比如接口名、请求次数、请求时间等

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 4][]

其他相关功能，可以自行摸索了

# 完整源码下载 #

我的[Github源码地址：][Github]

[https://github.com/hemin1003/spring-boot-study/tree/master/spring-boot2-study/spring-boot2-parent/spring-boot2-mysql-druid][https_github.com_hemin1003_spring-boot-study_tree_master_spring-boot2-study_spring-boot2-parent_spring-boot2-mysql-druid]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 5][]

# 下一章教程 #

[SpringBoot从入门到精通教程（十五）- Logback日志框架集成][SpringBoot_- Logback]

# 该系列教程 #

[SpringBoot从入门到精通教程][SpringBoot]

至此，全部介绍就结束了

\------------------------------------------------------

[关于我][Link 1]（个人域名）

[我的开源项目集Github][Github 1]

期望和大家***一起学习，一起成长***，共勉，O(∩\_∩)O谢谢

欢迎交流问题，可加个人QQ 469580884，

或者，加我的群号 **751925591**，一起探讨交流问题

不讲虚的，只做实干家

Talk is cheap，show me the code

![20180411181545874][]

[SpringBoot_- Mysql_Mybatis_XML]: https://hemin.blog.csdn.net/article/details/93123524
[SpringBoot_-]: https://hemin.blog.csdn.net/article/details/94194400
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70]: /images/20211015/64aef026058740abb9f704768d845b2f.png
[http_localhost_9090_hello]: http://localhost:9090/hello
[http_localhost_9090_listCities]: http://localhost:9090/listCities
[http_localhost_9090_getCityById_id_1]: http://localhost:9090/getCityById?id=1
[http_localhost_9090_druid]: http://localhost:9090/druid/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 1]: /images/20211015/e239efe73e18483b8f3f972bc0865b91.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 2]: /images/20211015/3009f4406aff422094dcd5df35065d25.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 3]: /images/20211015/7ccb6e3100fc492093aecaeeff4793b4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 4]: /images/20211015/86bfef5eded24daa97807f7204e1e528.png
[Github]: https://github.com/hemin1003/spring-boot-study/tree/master/spring-boot2-study/spring-boot2-parent
[https_github.com_hemin1003_spring-boot-study_tree_master_spring-boot2-study_spring-boot2-parent_spring-boot2-mysql-druid]: https://github.com/hemin1003/spring-boot-study/tree/master/spring-boot2-study/spring-boot2-parent/spring-boot2-mysql-druid
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9oZW1pbi5ibG9nLmNzZG4ubmV0_size_16_color_FFFFFF_t_70 5]: /images/20211015/907d74396ee94bdbaf96521f0b2d1524.png
[SpringBoot_- Logback]: https://blog.csdn.net/hemin1003/article/details/99637532
[SpringBoot]: https://hemin.blog.csdn.net/column/info/40170
[Link 1]: http://heminit.com/about/
[Github 1]: https://github.com/hemin1003
[20180411181545874]: /images/20211015/2f1ffd6e5d934f2da2543b3eba17829d.png