springBoot配置数据库连接

最新推荐文章于 2024-08-11 23:49:08 发布

Vision-Team

最新推荐文章于 2024-08-11 23:49:08 发布

阅读量7.1k

点赞数 1

分类专栏： SpringBoot

本文链接：https://blog.csdn.net/qq_16393511/article/details/79031585

版权

SpringBoot 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

spring:
    datasource:
        type: com.alibaba.druid.pool.DruidDataSource
        driverClassName: com.mysql.jdbc.Driver
        druid:
            default:  #默认数据源
              url: jdbc:mysql://localhost:3306/数据库?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8
              username: 账户
              password: 密码
            initial-size: 10
            max-active: 1000
            min-idle: 10
            max-wait: 60000
            pool-prepared-statements: true
            max-pool-prepared-statement-per-connection-size: 20
            time-between-eviction-runs-millis: 60000
            min-evictable-idle-time-millis: 300000
            validation-query: SELECT 1 FROM DUAL
            test-while-idle: true
            test-on-borrow: false
            test-on-return: false
            stat-view-servlet:
                enabled: true
                url-pattern: /druid/*
                #login-username: admin
                #login-password: 123456
            filter:
                stat:
                    log-slow-sql: true
                    slow-sql-millis: 1000
                    merge-sql: true
                wall:
                    config:
                        multi-statement-allow: true