Use Spring's javasactroutingdatasource to solve the problem of multiple data sources

Multiple data sources are common, such as read/write splitting database configuration.

A new requirement emerged in the original project. The local team asked the local team to add a server to provide a code, which involved multiple data sources.

The solution is as follows:

1. Configure multiple datasource

2,

 

DynamicDataSource}

 

 

String DATA_SOURCE_A = "dataSource" String DATA_SOURCE_ B = "cece2" ThreadLocal <String> contextHolder = ThreadLocal <String>}

 

 

 

 

 

5. Switch the data source in DAOImpl

CustomerContextHolder. setCustomerType (CustomerContextHolder. DATA_SOURCE_ B );