SpringBoot+Mybatis-plus(多数据源配置)
1.添加依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>2.4.2</version>
</dependency>
<dependency>
<groupId>p6spy</groupId>
<artifactId>p6spy</artifactId>
<version>3.8.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>8.0.20</scope>
</dependency>
2.添加依赖
spring:
datasource:
p6spy: true
dynamic:
datasource:
master:
username: root
password: 12345678
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/数据库1(默认)?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
booking_car:
username: root
password: 12345678
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/数据库2?characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
3.serviceImpl实现
@Service
@RequiredArgsConstructor
@DS("booking_car")
public class OrderServiceImpl implements OrderService {
private final OrderDao orderDao;
@Override
public OrderEntity getUser(Long id) {
return orderDao.selectById(id);
}
}
4.测试同一项目连多个数据库效果
我也找了另一篇博文作为参考
Druid的情况下看另一篇