druid依赖,mysql连接器

金丝雀与百灵鸟

于 2023-03-27 11:26:57 发布

阅读量171

点赞数

文章标签： java spring spring boot

本文链接：https://blog.csdn.net/mml12464/article/details/129791340

版权

pom配置

<!--mysql连接器-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.31</version>
    <scope>runtime</scope>
</dependency>


<!--对druid数据源的装配-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
    <version>2.6.12</version>
</dependency>

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

yml配置

spring:
  profiles:
    active: dev

  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://111.111.111.111:0000/springboot-demo?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
      username: 
      password: 
      initial-size: 10
      min-idle: 10
      max-active: 50
      max-wait: 60000

      #SQL监控
      stat-view-servlet:
        enabled: true
        login-username: admin
        login-password: 123456
        allow:
        deny:
        reset-enable: false
        url-pattern: /druid/*