配置文件
spring:
datasource:
dynamic:
primary: master
datasource:
master:
druid:
initialSize: 5
minIdle: 5
maxWait: 60000
testWhileIdle: true
validationQuery: select 'x'
testOnBorrow: false
testOnReturn: false
filter:
config:
enabled: true
publicKey: MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAJCNXUpodxToEp+7dvGjFkTcwjBISeoNTvGEdicwo4bgExQLQhM/Tzn6phVd8GH1rHkXISaAZrtsXDQvvUoVpr8CAwEAAQ==
url: jdbc:mysql://127.0.0.1:3306/test01?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&useSSL=false
username: root
password: SZDXxc6bgUAAmqLPEruN6k16918gxAudxGK11nPNYbudbiLz/poXEnBt/ahnL+omg6/dLIAPfw8K/+Lyx9n0mg==
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
slave:
druid:
initialSize: 5
minIdle: 5
maxWait: 60000
testWhileIdle: true
validationQuery: select 'x'
testOnBorrow: false
testOnReturn: false
filter:
config:
enabled: true
publicKey: MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAJCNXUpodxToEp+7dvGjFkTcwjBISeoNTvGEdicwo4bgExQLQhM/Tzn6phVd8GH1rHkXISaAZrtsXDQvvUoVpr8CAwEAAQ==
url: 127.0.0.1:3306/test02?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&useSSL=false
username: root
password: SZDXxc6bgUAAmqLPEruN6k16918gxAudxGK11nPNYbudbiLz/poXEnBt/ahnL+omg6/dLIAPfw8K/+Lyx9n0mg==
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
@DS("slave") // 非默认的数据源需要特别指定
@Mapper
public interface UserMapper extends BaseMapper<UserVo> {
//
}
@Mapper
public interface SysUserMapper extends BaseMapper<SysUserMapperVo> {
//
}
@Autowired
private UserMapper userMapper;
@Autowired
private SysUserMapper sysUserMapper;
@Test
public void testMultipleDS(){
System.out.println(userMapper.selectById(1L));
System.out.println(sysUserMapper.selectById(1L));
}