jdbc.properties
#mid数据源
mid.database.connecturl=jdbc:mysql://IP:3306/DB1?serverTimezone=Hongkong&useUnicode=true&characterEncoding=utf8&useSSL=false&allowMultiQueries=true
mid.database.username=expertuser
mid.database.password=123456
#oa数据源
oa.database.connecturl=jdbc:mysql://IP:3306/DB2?serverTimezone=Hongkong&useUnicode=true&characterEncoding=utf8&useSSL=false&allowMultiQueries=true
oa.database.username=root
oa.database.password=root123
ApplicationContext.xml
<!-- JDBC数据源 -->
<bean id="OPDataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="maxActive" value="15" />
<property name="maxIdle" value="0" />
<property name="minIdle" value="0" />
<property name="maxWait" value="30000" />
<property name="validationQuery" value="SELECT 1" />
<property name="minEvictableIdleTimeMillis" value="300000" />
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="${mid.database.connecturl}" />
<property name="username" value="${mid.database.username}" />
<property name="password" value="${mid.database.password}" />
</bean>
<bean id="OADataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="maxActive" value="15" />
<property name="maxIdle" value="0" />
<property name="minIdle" value="0" />
<property name="maxWait" value="30000" />
<property name="validationQuery" value="SELECT 1" />
<property name="minEvictableIdleTimeMillis" value="300000" />
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="${oa.database.connecturl}" />
<property name="username" value="${oa.database.username}" />
<property name="password" value="${oa.database.password}" />
</bean>
<bean id="dataSource" class="com.meritco.xsystem.expert.db.DynamicDataSource">
<property name="targetDataSources">
<map>
<entry key="OPDataSource" value-ref="OPDataSource"></entry>
<entry key="OADataSource" value-ref="OADataSource"></entry>
</map>
</property>
<property name="defaultTargetDataSource" ref="OPDataSource"></property>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage"
value="com.meritco.xsystem.*.*.dao" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
</bean>
<!-- 事务管理对象 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 使用annotation声明式事务 -->
<tx:annotation-driven transaction-manager="transactionManager" />
<!-- 使用annotation定义DAO和Service -->
<ctx:component-scan base-package="com.meritco.xsystem" />
DynamicDataSource
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
public class DynamicDataSource extends AbstractRoutingDataSource{
@Override
protected Object determineCurrentLookupKey() {
// TODO Auto-generated method stub
return DynamicDataSourceHolder.getDataSourceType();
}
}
DynamicDataSourceHolder
public class DynamicDataSourceHolder {
private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();
public static void setDataSourceType(String dataSourceType) {
contextHolder.set(dataSourceType);
}
public static String getDataSourceType() {
return contextHolder.get();
}
public static void clearDataSourceType() {
contextHolder.remove();
}
}
在Controller可以自由切换数据源
DynamicDataSourceHolder.setDataSourceType("OADataSource");