SpringBoot实现多数据源配置详解

<dependencies>
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter</artifactId>
  </dependency>
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
  </dependency>
  <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
  </dependency>
  <dependency>
    <groupId>com.github.noraui</groupId>
    <artifactId>ojdbc7</artifactId>
    <version>12.1.0.2</version>
  </dependency>
  <dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-lang3</artifactId>
  </dependency>
  <dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.1.1</version>
  </dependency>
</dependencies>
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.

server:
  port: 50000 
---
spring:
  jpa: 
    hibernate:  
      ddlAuto: update
    openInView: true
    showSql: false
    databasePlatform: org.hibernate.dialect.Oracle10gDialect
---
# 第一个数据源      
master: 
  datasource:
    driverClassName: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@localhost:1521/orcl
    username: t0
    password: t0
    type: com.zaxxer.hikari.HikariDataSource
    hikari:
      minimumIdle: 10
      maximumPoolSize: 200
      autoCommit: true
      idleTimeout: 30000
      poolName: MasterDatabookHikariCP
      maxLifetime: 1800000
      connectionTimeout: 30000
      connectionTestQuery: SELECT 1 FROM DUAL
# 第二个数据源      
slave:
  datasource:
    driverClassName: oracle.jdbc.driver.OracleDriver
    url: jdbc:oracle:thin:@localhost:1521/orcl
    username: t1
    password: t1
    type: com.zaxxer.hikari.HikariDataSource
    hikari:
      minimumIdle: 10
      maximumPoolSize: 200
      autoCommit: true
      idleTimeout: 30000
      poolName: SlaveDatabookHikariCP
      maxLifetime: 1800000
      connectionTimeout: 30000
      connectionTestQuery: SELECT 1 FROM DUAL      
---
# mybatis 配置，分表对应到不同的包中        
master:
  mybatis:
    config-location: classpath:/MyBatis-conf.xml
    type-aliases-package: com.pack.domain #master数据源对应的包
    mapper-locations:
    - classpath:/com/pack/mapper/oracle/*.xml #master数据源对应mapper文件
slave:
  mybatis:
    config-location: classpath:/MyBatis-conf.xml
    type-aliases-package: com.pack.slave.domain #slave数据源对应的包
    mapper-locations:
    - classpath:/com/pack/slave/mapper/oracle/*.xml    #slave数据源对应mapper文件
---
# jpa相关的配置
master:
  jpa:
    repos: com.pack.base.repository #master数据源对应的包配置
    domain: com.pack.domain #master对应的实体包
slave:
  jpa:
    repos: com.pack.slave.repository #salve数据源对应的包配置
    domain: com.pack.slave.domain  #slave对应的实体包
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.

public class BaseDataSourceProperties implements BeanClassLoaderAware, InitializingBean {


  private ClassLoader classLoader;
  private String name;
  private boolean generateUniqueName;
  private Class<? extends DataSource> type;
  private String driverClassName;
  private String url;
  private String username;
  private String password;
  private String jndiName;
  private DataSourceInitializationMode initializationMode = DataSourceInitializationMode.EMBEDDED;
  private String platform = "all";
  private List<String> schema;
  private String schemaUsername;
  private String schemaPassword;
  private List<String> data;
  private String dataUsername;
  private String dataPassword;
  private boolean continueOnError = false;
  private String separator = ";";
  private Charset sqlScriptEncoding;


  private EmbeddedDatabaseConnection embeddedDatabaseConnection = EmbeddedDatabaseConnection.NONE;


  private Xa xa = new Xa();


  private String uniqueName;


  @Override
  public void setBeanClassLoader(ClassLoader classLoader) {
    this.classLoader = classLoader;
  }


  @Override
  public void afterPropertiesSet() throws Exception {
    this.embeddedDatabaseConnection = EmbeddedDatabaseConnection
        .get(this.classLoader);
  }
  public DataSourceBuilder<?> initializeDataSourceBuilder() {
    return DataSourceBuilder.create(getClassLoader()).type(getType())
        .driverClassName(determineDriverClassName()).url(determineUrl())
        .username(determineUsername()).password(determinePassword());
  }


  public String getName() {
    return this.name;
  }


  public void setName(String name) {
    this.name = name;
  }


  public boolean isGenerateUniqueName() {
    return this.generateUniqueName;
  }


  public void setGenerateUniqueName(boolean generateUniqueName) {
    this.generateUniqueName = generateUniqueName;
  }


  public Class<? extends DataSource> getType() {
    return this.type;
  }


  public void setType(Class<? extends DataSource> type) {
    this.type = type;
  }
  public String getDriverClassName() {
    return this.driverClassName;
  }


  public void setDriverClassName(String driverClassName) {
    this.driverClassName = driverClassName;
  }
  public String determineDriverClassName() {
    if (StringUtils.hasText(this.driverClassName)) {
      Assert.state(driverClassIsLoadable(),
          () -> "Cannot load driver class: " + this.driverClassName);
      return this.driverClassName;
    }
    String driverClassName = null;
    if (StringUtils.hasText(this.url)) {
      driverClassName = DatabaseDriver.fromJdbcUrl(this.url).getDriverClassName();
    }
    if (!StringUtils.hasText(driverClassName)) {
      driverClassName = this.embeddedDatabaseConnection.getDriverClassName();
    }
    if (!StringUtils.hasText(driverClassName)) {
      throw new DataSourceBeanCreationException(
          "Failed to determine a suitable driver class", this,
          this.embeddedDatabaseConnection);
    }
    return driverClassName;
  }


  private boolean driverClassIsLoadable() {
    try {
      ClassUtils.forName(this.driverClassName, null);
      return true;
    }
    catch (UnsupportedClassVersionError ex) {
      // Driver library has been compiled with a later JDK, propagate error
      throw ex;
    }
    catch (Throwable ex) {
      return false;
    }
  }
  public String getUrl() {
    return this.url;
  }


  public void setUrl(String url) {
    this.url = url;
  }
  public String determineUrl() {
    if (StringUtils.hasText(this.url)) {
      return this.url;
    }
    String databaseName = determineDatabaseName();
    String url = (databaseName != null)
        ? this.embeddedDatabaseConnection.getUrl(databaseName) : null;
    if (!StringUtils.hasText(url)) {
      throw new DataSourceBeanCreationException(
          "Failed to determine suitable jdbc url", this,
          this.embeddedDatabaseConnection);
    }
    return url;
  }
  public String determineDatabaseName() {
    if (this.generateUniqueName) {
      if (this.uniqueName == null) {
        this.uniqueName = UUID.randomUUID().toString();
      }
      return this.uniqueName;
    }
    if (StringUtils.hasLength(this.name)) {
      return this.name;
    }
    if (this.embeddedDatabaseConnection != EmbeddedDatabaseConnection.NONE) {
      return "testdb";
    }
    return null;
  }
  public String getUsername() {
    return this.username;
  }


  public void setUsername(String username) {
    this.username = username;
  }
  public String determineUsername() {
    if (StringUtils.hasText(this.username)) {
      return this.username;
    }
    if (EmbeddedDatabaseConnection.isEmbedded(determineDriverClassName())) {
      return "sa";
    }
    return null;
  }
  public String getPassword() {
    return this.password;
  }


  public void setPassword(String password) {
    this.password = password;
  }
  public String determinePassword() {
    if (StringUtils.hasText(this.password)) {
      return this.password;
    }
    if (EmbeddedDatabaseConnection.isEmbedded(determineDriverClassName())) {
      return "";
    }
    return null;
  }


  public String getJndiName() {
    return this.jndiName;
  }
  public void setJndiName(String jndiName) {
    this.jndiName = jndiName;
  }


  public DataSourceInitializationMode getInitializationMode() {
    return this.initializationMode;
  }


  public void setInitializationMode(DataSourceInitializationMode initializationMode) {
    this.initializationMode = initializationMode;
  }


  public String getPlatform() {
    return this.platform;
  }


  public void setPlatform(String platform) {
    this.platform = platform;
  }


  public List<String> getSchema() {
    return this.schema;
  }


  public void setSchema(List<String> schema) {
    this.schema = schema;
  }


  public String getSchemaUsername() {
    return this.schemaUsername;
  }


  public void setSchemaUsername(String schemaUsername) {
    this.schemaUsername = schemaUsername;
  }


  public String getSchemaPassword() {
    return this.schemaPassword;
  }


  public void setSchemaPassword(String schemaPassword) {
    this.schemaPassword = schemaPassword;
  }


  public List<String> getData() {
    return this.data;
  }


  public void setData(List<String> data) {
    this.data = data;
  }


  public String getDataUsername() {
    return this.dataUsername;
  }


  public void setDataUsername(String dataUsername) {
    this.dataUsername = dataUsername;
  }


  public String getDataPassword() {
    return this.dataPassword;
  }


  public void setDataPassword(String dataPassword) {
    this.dataPassword = dataPassword;
  }


  public boolean isContinueOnError() {
    return this.continueOnError;
  }


  public void setContinueOnError(boolean continueOnError) {
    this.continueOnError = continueOnError;
  }


  public String getSeparator() {
    return this.separator;
  }


  public void setSeparator(String separator) {
    this.separator = separator;
  }


  public Charset getSqlScriptEncoding() {
    return this.sqlScriptEncoding;
  }


  public void setSqlScriptEncoding(Charset sqlScriptEncoding) {
    this.sqlScriptEncoding = sqlScriptEncoding;
  }


  public ClassLoader getClassLoader() {
    return this.classLoader;
  }


  public Xa getXa() {
    return this.xa;
  }


  public void setXa(Xa xa) {
    this.xa = xa;
  }
  public static class Xa {
    private String dataSourceClassName;
    private Map<String, String> properties = new LinkedHashMap<>();


    public String getDataSourceClassName() {
      return this.dataSourceClassName;
    }


    public void setDataSourceClassName(String dataSourceClassName) {
      this.dataSourceClassName = dataSourceClassName;
    }


    public Map<String, String> getProperties() {
      return this.properties;
    }


    public void setProperties(Map<String, String> properties) {
      this.properties = properties;
    }


  }


  static class DataSourceBeanCreationException extends BeanCreationException {
    private static final long serialVersionUID = 1L;


    private final BaseDataSourceProperties properties;


    private final EmbeddedDatabaseConnection connection;


    DataSourceBeanCreationException(String message, BaseDataSourceProperties properties,
        EmbeddedDatabaseConnection connection) {
      super(message);
      this.properties = properties;
      this.connection = connection;
    }


    public BaseDataSourceProperties getProperties() {
      return this.properties;
    }


    public EmbeddedDatabaseConnection getConnection() {
      return this.connection;
    }


  }


}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.

public class BaseMybatisProperties {
  private String configLocation;
  private String[] mapperLocations;
  private String typeAliasesPackage;
  private String typeHandlersPackage;
  private boolean checkConfigLocation = false;
  private ExecutorType executorType;
  private Configuration configuration;
  public String getConfigLocation() {
    return this.configLocation;
  }
  public void setConfigLocation(String configLocation) {
    this.configLocation = configLocation;
  }
  @Deprecated
  public String getConfig() {
    return this.configLocation;
  }
  @Deprecated
  public void setConfig(String config) {
    this.configLocation = config;
  }
  public String[] getMapperLocations() {
    return this.mapperLocations;
  }
  public void setMapperLocations(String[] mapperLocations) {
    this.mapperLocations = mapperLocations;
  }
  public String getTypeHandlersPackage() {
    return this.typeHandlersPackage;
  }
  public void setTypeHandlersPackage(String typeHandlersPackage) {
    this.typeHandlersPackage = typeHandlersPackage;
  }
  public String getTypeAliasesPackage() {
    return this.typeAliasesPackage;
  }
  public void setTypeAliasesPackage(String typeAliasesPackage) {
    this.typeAliasesPackage = typeAliasesPackage;
  }
  public boolean isCheckConfigLocation() {
    return this.checkConfigLocation;
  }
  public void setCheckConfigLocation(boolean checkConfigLocation) {
    this.checkConfigLocation = checkConfigLocation;
  }
  public ExecutorType getExecutorType() {
    return this.executorType;
  }
  public void setExecutorType(ExecutorType executorType) {
    this.executorType = executorType;
  }
  public Configuration getConfiguration() {
    return configuration;
  }
  public void setConfiguration(Configuration configuration) {
    this.configuration = configuration;
  }
  public Resource[] resolveMapperLocations() {
    List<Resource> resources = new ArrayList<Resource>();
    if (this.mapperLocations != null) {
      for (String mapperLocation : this.mapperLocations) {
        Resource[] mappers;
        try {
          mappers = new PathMatchingResourcePatternResolver().getResources(mapperLocation);
          resources.addAll(Arrays.asList(mappers));
        } catch (IOException e) {


        }
      }
    }


    Resource[] mapperLocations = new Resource[resources.size()];
    mapperLocations = resources.toArray(mapperLocations);
    return mapperLocations;
  }
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.

@Component
@ConfigurationProperties(prefix = "master.datasource")
public class MasterDataSourceProperties extends BaseDataSourceProperties {
}
1.
2.
3.
4.

@Component
@ConfigurationProperties(prefix = "slave.datasource")
public class SlaveDataSourceProperties extends BaseDataSourceProperties {
}
1.
2.
3.
4.

@Component
@ConfigurationProperties(prefix = "master.mybatis")
public class MasterMybatisProperties extends BaseMybatisProperties {
}
1.
2.
3.
4.

@Component
@ConfigurationProperties(prefix = "slave.mybatis")
public class SlaveMybatisProperties extends BaseMybatisProperties {
}
1.
2.
3.
4.

@Configuration
public class HikariDataSourceConfig {
  
  @Bean
  @Primary
  public HikariDataSource masterDataSource(MasterDataSourceProperties properties) {
    HikariDataSource dataSource = createDataSource(properties,
        HikariDataSource.class);
    if (StringUtils.hasText(properties.getName())) {
      dataSource.setPoolName(properties.getName());
    }
    return dataSource;
  }
  @Bean
  public HikariDataSource slaveDataSource(SlaveDataSourceProperties properties) {
    HikariDataSource dataSource = createDataSource(properties,
        HikariDataSource.class);
    if (StringUtils.hasText(properties.getName())) {
      dataSource.setPoolName(properties.getName());
    }
    return dataSource;
  }
  
  @SuppressWarnings("unchecked")
  protected static <T> T createDataSource(BaseDataSourceProperties properties,
      Class<? extends DataSource> type) {
    return (T) properties.initializeDataSourceBuilder().type(type).build();
  }
  
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.

public class EntityManagerFactoryConfig {


  @Configuration
  @EnableJpaRepositories(basePackages = {
      "${master.jpa.repos}" }, entityManagerFactoryRef = "masterEntityManagerFactory", transactionManagerRef = "masterJPATransactionManager")
  static class MasterEntityManagerFactory {
    @Resource(name = "masterDataSource")
    private DataSource masterDataSource;
    @Value("${master.jpa.domain}")
    private String masterDomainPkg;


    @Bean
    @Primary
    public LocalContainerEntityManagerFactoryBean masterEntityManagerFactory(EntityManagerFactoryBuilder builder) {
      Map<String, Object> properties = new HashMap<>();
      properties.put("hibernate.hbm2ddl.auto", "update");
      properties.put("hibernate.id.new_generator_mappings", true);
      properties.put("hibernate.physical_naming_strategy", SpringPhysicalNamingStrategy.class.getName()) ;
      return builder.dataSource(masterDataSource).packages(masterDomainPkg).persistenceUnit("master")
          .properties(properties).build();
    }


    @Bean
    @Primary
    public PlatformTransactionManager masterJPATransactionManager(EntityManagerFactoryBuilder builder) {
      JpaTransactionManager tm = new JpaTransactionManager(masterEntityManagerFactory(builder).getObject());
      return tm;
    }
  }


  @Configuration
  @EnableJpaRepositories(basePackages = {
      "${slave.jpa.repos}" }, entityManagerFactoryRef = "slaveEntityManagerFactory", transactionManagerRef = "slaveJPATransactionManager")
  @ConditionalOnProperty(name = "multiple.ds.enabled", havingValue = "true")
  static class SlaveEntityManagerFactory {
    @Resource(name = "slaveDataSource")
    private DataSource slaveDataSource;
    @Value("${slave.jpa.domain}")
    private String slaveDomainPkg;


    @Bean
    public LocalContainerEntityManagerFactoryBean slaveEntityManagerFactory(EntityManagerFactoryBuilder builder) {
      Map<String, Object> properties = new HashMap<>();
      properties.put("hibernate.hbm2ddl.auto", "update");
      properties.put("hibernate.id.new_generator_mappings", true);
      properties.put("hibernate.physical_naming_strategy", SpringPhysicalNamingStrategy.class.getName()) ;
      return builder.dataSource(slaveDataSource).packages(slaveDomainPkg).persistenceUnit("slave")
          .properties(properties).build();
    }


    @Bean
    public PlatformTransactionManager slaveJPATransactionManager(EntityManagerFactoryBuilder builder) {
      JpaTransactionManager tm = new JpaTransactionManager(slaveEntityManagerFactory(builder).getObject());
      return tm;
    }
  }


}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.

public class SqlSessionFactoryConfig {


  @Configuration
  static class MasterSqlSessionFactory {
    @Resource
    private MasterMybatisProperties properties;
    @Autowired(required = false)
    private Interceptor[] interceptors;
    @Autowired
    private ResourceLoader resourceLoader = new DefaultResourceLoader();
    @Autowired(required = false)
    private DatabaseIdProvider databaseIdProvider;


    @Bean
    public SqlSessionFactory masterSqlSessionFactory(@Qualifier("masterDataSource") DataSource dataSource)
        throws Exception {
      SqlSessionFactoryBean factory = new SqlSessionFactoryBean();
      factory.setDataSource(dataSource);
      factory.setVfs(SpringBootVFS.class);
      if (StringUtils.hasText(this.properties.getConfigLocation())) {
        factory.setConfigLocation(this.resourceLoader.getResource(this.properties.getConfigLocation()));
      }
      factory.setConfiguration(properties.getConfiguration());
      if (!ObjectUtils.isEmpty(this.interceptors)) {
        factory.setPlugins(this.interceptors);
      }
      if (this.databaseIdProvider != null) {
        factory.setDatabaseIdProvider(this.databaseIdProvider);
      }
      if (StringUtils.hasLength(this.properties.getTypeAliasesPackage())) {
        factory.setTypeAliasesPackage(this.properties.getTypeAliasesPackage());
      }
      if (StringUtils.hasLength(this.properties.getTypeHandlersPackage())) {
        factory.setTypeHandlersPackage(this.properties.getTypeHandlersPackage());
      }
      if (!ObjectUtils.isEmpty(this.properties.resolveMapperLocations())) {
        factory.setMapperLocations(this.properties.resolveMapperLocations());
      }


      return factory.getObject();
    }
    @Bean
      public DataSourceTransactionManager masterTransactionManager(@Qualifier("masterDataSource") DataSource dataSource) {
          return new DataSourceTransactionManager(dataSource);
      }
    @Bean
    public SqlSessionTemplate masterSqlSessionTemplate(@Qualifier("masterSqlSessionFactory")SqlSessionFactory sqlSessionFactory) {
      ExecutorType executorType = this.properties.getExecutorType();
      if (executorType != null) {
        return new SqlSessionTemplate(sqlSessionFactory, executorType);
      } else {
        return new SqlSessionTemplate(sqlSessionFactory);
      }
    }
  }
  
  @Configuration
  @ConditionalOnProperty(name = "multiple.ds.enabled", havingValue = "true")
  static class SlaveSqlSessionFactory {
    @Resource
    private SlaveMybatisProperties properties;
    @Autowired(required = false)
    private Interceptor[] interceptors;
    @Autowired
    private ResourceLoader resourceLoader = new DefaultResourceLoader();
    @Autowired(required = false)
    private DatabaseIdProvider databaseIdProvider;


    @Bean
    public SqlSessionFactory slaveSqlSessionFactory(@Qualifier("slaveDataSource") DataSource dataSource) throws Exception {
      SqlSessionFactoryBean factory = new SqlSessionFactoryBean();
      factory.setDataSource(dataSource);
      factory.setVfs(SpringBootVFS.class);
      if (StringUtils.hasText(this.properties.getConfigLocation())) {      factory.setConfigLocation(this.resourceLoader.getResource(this.properties.getConfigLocation()));
      }
      factory.setConfiguration(properties.getConfiguration());
      if (!ObjectUtils.isEmpty(this.interceptors)) {
        factory.setPlugins(this.interceptors);
      }
      if (this.databaseIdProvider != null) {
        factory.setDatabaseIdProvider(this.databaseIdProvider);
      }
      if (StringUtils.hasLength(this.properties.getTypeAliasesPackage())) {
        factory.setTypeAliasesPackage(this.properties.getTypeAliasesPackage());
      }
      if (StringUtils.hasLength(this.properties.getTypeHandlersPackage())) {     factory.setTypeHandlersPackage(this.properties.getTypeHandlersPackage());
      }
      if (!ObjectUtils.isEmpty(this.properties.resolveMapperLocations())) {
        factory.setMapperLocations(this.properties.resolveMapperLocations());
      }
      return factory.getObject();
    }
    
    @Bean
    public DataSourceTransactionManager slaveTransactionManager(@Qualifier("slaveDataSource") DataSource dataSource) {
      return new DataSourceTransactionManager(dataSource);
  }
    @Bean
    public SqlSessionTemplate slaveSqlSessionTemplate(@Qualifier("slaveSqlSessionFactory")SqlSessionFactory sqlSessionFactory) {
      ExecutorType executorType = this.properties.getExecutorType();
      if (executorType != null) {
        return new SqlSessionTemplate(sqlSessionFactory, executorType);
      } else {
        return new SqlSessionTemplate(sqlSessionFactory);
      }
    }
  }
  
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.

public class MapperScanConfig {
  
  @Configuration
  @MapperScan(basePackages = {"com.pack.base.mapper"}, sqlSessionTemplateRef  = "masterSqlSessionTemplate")
  static class MasterMapper {
  }
  
  @Configuration
  @MapperScan(basePackages = {"com.pack.slave.mapper"}, sqlSessionTemplateRef  = "slaveSqlSessionTemplate")
  @ConditionalOnProperty(name = "multiple.ds.enabled", havingValue = "true")
  static class SlaveMapper {
  }
  
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.

@Entity
@Table(name = "T_USERS")
@Data
public class Users {
  @Id
  private Long id;
  private String username ;
  private String password ;
  private String realName ;
  private String phone ;
  private String idNo ;
  @Column(length=4000)
  private String authority ;
  @Column(columnDefinitinotallow="int default 0")
  private Integer status = 0 ;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.

@Entity
@Table(name = "T_PERSON")
@Data
public class Person{
  @Id
  private Long id;
  private String name ;
  private String email ;
}
1.
2.
3.
4.
5.
6.
7.
8.
9.