后端项目开发：集成Druid数据源

深藏阁楼爱情的钟 2024-03-24 21:02 45阅读 0赞

Druid作为连接池中间件可以监控数据库访问性能，对数据库密码加密，查看SQL执行日志，扩展JDBC。  
添加依赖

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

参考官方文档：[https://github.com/alibaba/druid/wiki][https_github.com_alibaba_druid_wiki]

spring:
      #数据库配置,连接mybatis持久层
      datasource:
        type: com.alibaba.druid.pool.DruidDataSource
        url: jdbc:mysql://localhost:3306/generic?useSSL=true&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=GMT
        # 数据库账号
        username: root
        # 数据库密码
        password: 123456
        driver-class-name: com.mysql.cj.jdbc.Driver
        druid:
          # 最大连接数
          max-active: 100
          # 初始化大小
          initial-size: 1
          # 最小连接数
          min-idle: 1
          # 等待超时事件
          max-wait: 60000
          # 检测需要关闭的空闲连接的时间间隔
          time-between-eviction-runs-millis: 60000
          # 一个连接在池中最小生存时间
          min-evictable-idle-time-millis: 300000
          # 配置监控统计拦截的filters，去掉后监控界面无法进行统计
          filters: stat,wall,config,log4j
          stat-view-servlet:
            # 开启Druid连接池监控
            enabled: true
            # 网页登陆账号
            login-username: admin
            # 网页登陆密码
            login-password: admin

更多配置参考：[https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter][https_github.com_alibaba_druid_tree_master_druid-spring-boot-starter]  
启动应用：访问[http://localhost:8001/druid/login.html][http_localhost_8001_druid_login.html]查看监控后台

[https_github.com_alibaba_druid_wiki]: https://github.com/alibaba/druid/wiki
[https_github.com_alibaba_druid_tree_master_druid-spring-boot-starter]: https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter
[http_localhost_8001_druid_login.html]: http://localhost:8001/druid/login.html