Durid实战

Druid简介

Druid 可以很好的监控 DB 池连接和 SQL 的执行情况,天生就是针对监控而生的 DB 连接池。

com.alibaba.druid.pool.DruidDataSource 基本配置参数如下:

一、配置单数据源

1.添加依赖

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

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>

2.yaml配置

spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/erp_ydh?useUnicode=true&characterEncoding=utf-8&useSSL=false
username: root
password: xxxxx
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource # 自定义数据源

二、配置多数据源

Author: iMine
Link: https://imine141.github.io/2020/06/03/%E5%AE%9E%E6%88%98/Druid/
Copyright Notice: All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.