在Spring Boot项目中使用
MyBatis Plus和Dru
id多数据源的步骤如下：
1. 添加依赖
在`pom.xml`文件中添加以下依赖：
```xml
<!--
MyBatis Plus -->
<dependency>
<group
Id>com.baom
idou</group
Id>
<artifact
Id>
mybatis-plus-boot-starter</artifact
Id>
<version>3.4.3.1</version>
</dependency>
<!-- Dru
id -->
<dependency>
<group
Id>com.alibaba</group
Id>
<artifact
Id>dru
id-spring-boot-starter</artifact
Id>
<version>1.2.6</version>
</dependency>
```
2. 配置Dru
id数据源
在`application.yml`中添加Dru
id数据源的配置：
```yaml
spring:
datasource:
# 主数据源
dru
id:
url: jdbc:
mysql://localhost:3306/main_db?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
username: root
password: root
driver-class-name: com.
mysql.cj.jdbc.Driver
# Dru
id配置
initialSize: 5
min
Idle: 5
maxActive: 20
testOnBorrow: false
testOnReturn: false
testWhile
Idle: true
timeBetweenEvictionRunsMillis: 60000
val
idationQuery: SELECT 1 FROM DUAL
# 从数据源
dru
id2:
url: jdbc:
mysql://localhost:3306/sub_db?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
username: root
password: root
driver-class-name: com.
mysql.cj.jdbc.Driver
# Dru
id配置
initialSize: 5
min
Idle: 5
maxActive: 20
testOnBorrow: false
testOnReturn: false
testWhile
Idle: true
timeBetweenEvictionRunsMillis: 60000
val
idationQuery: SELECT 1 FROM DUAL
```
3. 配置
MyBatis Plus
在`application.yml`中添加
MyBatis Plus的配置：
```yaml
mybatis-plus:
# 主数据源配置
mapper-locations: classpath:
mapper/main/*.xml
type-aliases-package: com.example.main.entity
global-config:
db-config:
id-type: auto
field-strategy: not_empty
logic-delete-value: 1
logic-not-delete-value: 0
configuration:
map-underscore-to-camel-case: true
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
# 从数据源配置
multi-
datasource:
main:
mapper-locations: classpath:
mapper/main/*.xml
type-aliases-package: com.example.main.entity
sub:
mapper-locations: classpath:
mapper/sub/*.xml
type-aliases-package: com.example.sub.entity
```
4. 配置数据源路由
在`com.example.config`包下创建`Dynamic
DataSourceConfig`类，用于配置数据源路由：
```
java
@Configuration
public class Dynamic
DataSourceConfig {
@Bean
@ConfigurationProperties("spring.
datasource.dru
id")
public
DataSource main
DataSource() {
return Dru
idDataSourceBuilder.create().build();
}
@Bean
@ConfigurationProperties("spring.
datasource.dru
id2")
public
DataSource sub
DataSource() {
return Dru
idDataSourceBuilder.create().build();
}
@Bean
public
DataSource dynamic
DataSource() {
Dynamic
DataSource dynamic
DataSource = new Dynamic
DataSource();
Map<Object, Object>
dataSourceMap = new HashMap<>(2);
dataSourceMap.put("main", main
DataSource());
dataSourceMap.put("sub", sub
DataSource());
// 将主数据源作为默认数据源
dynamic
DataSource.setDefaultTarget
DataSource(main
DataSource());
dynamic
DataSource.setTarget
DataSources(
dataSourceMap);
return dynamic
DataSource;
}
@Bean
public SqlSessionFactory sqlSessionFactory() throws Exception {
MybatisSqlSessionFactoryBean sqlSessionFactoryBean = new
MybatisSqlSessionFactoryBean();
sqlSessionFactoryBean.set
DataSource(dynamic
DataSource());
sqlSessionFactoryBean.setTypeAliasesPackage("com.example.main.entity");
sqlSessionFactoryBean.set
MapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:
mapper/main/*.xml"));
return sqlSessionFactoryBean.getObject();
}
@Bean
public SqlSessionTemplate sqlSessionTemplate() throws Exception {
return new SqlSessionTemplate(sqlSessionFactory());
}
}
```
5. 配置数据源
切换
在`com.example.config`包下创建`Dynamic
DataSource`类，用于实现数据源
切换：
```
java
public class Dynamic
DataSource extends AbstractRouting
DataSource {
@Overr
ide
protected Object determineCurrentLookupKey() {
return
DataSourceContextHolder.get
DataSource();
}
}
```
在`com.example.config`包下创建`
DataSourceContextHolder`类，用于存储当前数据源：
```
java
public class
DataSourceContextHolder {
private static final ThreadLocal<String>
DATASOURCE_CONTEXT_HOLDER = new ThreadLocal<>();
public static vo
id set
DataSource(String
dataSource) {
DATASOURCE_CONTEXT_HOLDER.set(
dataSource);
}
public static String get
DataSource() {
return
DATASOURCE_CONTEXT_HOLDER.get();
}
public static vo
id clear
DataSource() {
DATASOURCE_CONTEXT_HOLDER.remove();
}
}
```
在`com.example.
aop`包下创建`
DataSourceAspect`类，用于
切换数据源：
```
java
@Aspect
@Component
public class
DataSourceAspect {
@Pointcut("@annotation(com.example.annotation.
DataSource)")
public vo
id dataSourcePointCut() {
}
@Before("
dataSourcePointCut()")
public vo
id before(JoinPoint joinPoint) {
MethodSignature signature = (MethodSignature) joinPoint.getSignature();
DataSource
dataSource = signature.getMethod().getAnnotation(
DataSource.class);
if (
dataSource != null) {
String value =
dataSource.value();
DataSourceContextHolder.set
DataSource(value);
}
}
@After("
dataSourcePointCut()")
public vo
id after(JoinPoint joinPoint) {
DataSourceContextHolder.clear
DataSource();
}
}
```
6. 使用
多数据源
在需要使用从数据源的方法上加上`@
DataSource("sub")`注解，如：
```
java
@Service
public class UserServiceImpl implements UserService {
@Autowired
private User
Mapper user
Mapper;
@Overr
ide
public List<User> listUsers() {
DataSourceContextHolder.set
DataSource("sub");
List<User> users = user
Mapper.selectList(null);
DataSourceContextHolder.clear
DataSource();
return users;
}
}
```
这样就完成了Spring Boot项目中使用
MyBatis Plus和Dru
id多数据源的配置。
2489
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
