spring boot+mybatisPlus配置mysql双数据源

1.yml配置

spring:
  datasource:
    primary:
      type: com.zaxxer.hikari.HikariDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: 数据库链接
      username: 用户名
      password: 密码
    secondary: # 次数据源
      type: com.zaxxer.hikari.HikariDataSource
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: 
      username: 
      password: 

2.主数据源配置

@Configuration
@MapperScan(basePackages = "com.example.demo.mysql.dao.pri", sqlSessionTemplateRef = "db1SqlSessionTemplate")
public class DataSource1Config {

  @Bean
  @ConfigurationProperties(prefix = "spring.datasource.primary")
  @Primary
  public DataSource db1DataSource() {
    return DataSourceBuilder.create().build();
  }

  @Bean
  @Primary
  public SqlSessionFactory db1SqlSessionFactory(@Qualifier("db1DataSource") DataSource dataSource) throws Exception {
    SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    bean.setDataSource(dataSource);
    bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/pri/*.xml"));
    return bean.getObject();
  }

  @Bean
  @Primary
  public DataSourceTransactionManager db1TransactionManager(@Qualifier("db1DataSource") DataSource dataSource) {
    return new DataSourceTransactionManager(dataSource);
  }

  @Bean
  @Primary
  public SqlSessionTemplate db1SqlSessionTemplate(@Qualifier("db1SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
    return new SqlSessionTemplate(sqlSessionFactory);
  }

}

3.次数据源配置

@Configuration
@MapperScan(basePackages = "com.example.demo.mysql.dao.sec", sqlSessionTemplateRef = "db2SqlSessionTemplate")
public class DataSource2Config {

  @Bean
  @ConfigurationProperties(prefix = "spring.datasource.secondary")
  public DataSource db2DataSource() {
    return DataSourceBuilder.create().build();
  }

  @Bean
  public SqlSessionFactory db2SqlSessionFactory(@Qualifier("db2DataSource") DataSource dataSource) throws Exception {
    SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
    bean.setDataSource(dataSource);
    bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/sec/*.xml"));
    return bean.getObject();
  }

  @Bean
  public DataSourceTransactionManager db2TransactionManager(@Qualifier("db2DataSource") DataSource dataSource) {
    return new DataSourceTransactionManager(dataSource);
  }

  @Bean
  public SqlSessionTemplate db2SqlSessionTemplate(@Qualifier("db2SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
    return new SqlSessionTemplate(sqlSessionFactory);
  }

}

4.数据结构