java SpringBoot（十一）数据库访问-Druid

太过爱你忘了你带给我的痛 2022-10-15 14:54 87阅读 0赞

什么是Druid:

Druid是java语言中最好的数据库连接池。Druid能够提供强大的监控和扩展功能。

### druid官方github地址 ###

[https://github.com/alibaba/druid][https_github.com_alibaba_druid]

SpringBoot配置示例

[https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter][https_github.com_alibaba_druid_tree_master_druid-spring-boot-starter]

配置项列表[https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8][https_github.com_alibaba_druid_wiki_DruidDataSource_E9_85_8D_E7_BD_AE_E5_B1_9E_E6_80_A7_E5_88_97_E8_A1_A8]

**1、引入依赖**

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

**2、配置文件配置Druid部分功能**

![20210527095524451.png][]

druid:
      aop-patterns: com.atguigu.admin.*  #springbean监控
      filters: stat,wall,slf4j  #所有开启的功能
    
      stat-view-servlet:  #监控页配置
        enabled: true
        login-username: admin
        login-password: admin
        resetEnable: false
    
      web-stat-filter:  #web监控
        enabled: true
        urlPattern: /* #对所有页面进行监控
        exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*' #排除这些页面的监控
    
    
      filter: #开启的功能进行配置
        stat: #sql监控
          slow-sql-millis: 1000 #超过1000ms为慢sql查询
          logSlowSql: true
          enabled: true
        wall: #防火墙
          enabled: true
          config:
            drop-table-allow: false #不允许删除表

**3、访问Druid UI页面**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNzcxNTY3_size_16_color_FFFFFF_t_70][]

[https_github.com_alibaba_druid]: https://github.com/alibaba/druid
[https_github.com_alibaba_druid_tree_master_druid-spring-boot-starter]: https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter
[https_github.com_alibaba_druid_wiki_DruidDataSource_E9_85_8D_E7_BD_AE_E5_B1_9E_E6_80_A7_E5_88_97_E8_A1_A8]: https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE%E5%B1%9E%E6%80%A7%E5%88%97%E8%A1%A8
[20210527095524451.png]: /images/20221014/a8e830fefdbb45c9a6cf9e6af4bc694b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNzcxNTY3_size_16_color_FFFFFF_t_70]: /images/20221014/e6011fdaaa624b84a6df6f7e233e36a7.png