applicationContext.xml
<!-- 引入数据源信息的properties文件 -->
<context:property-placeholder location="classpath:db.properties" />
<!-- ORACLE数据源 -->
<bean id="oracleDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${oracle.driver}" />
<property name="url" value="${oracle.url}" />
<property name="username" value="${oracle.username}" />
<property name="password" value="${oracle.password}" />
</bean>
<!-- MYSQL数据源 -->
<bean id="mysqlDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${mysql.driver}" />
<property name="url" value="${mysql.url}" />
<property name="username" value="${mysql.username}" />
<property name="password" value="${mysql.password}" />
</bean>
<!-- 多个数据源的配置 -->
<bean id="multipleDataSource" class="com.springmybatis.system.db.MyDataSource">
<property name="defaultTargetDataSource" ref="oracleDataSource"></property>
<property name="targetDataSources">
<map key-type="java.lang.String">
<entry key="oracleDataSource" value-ref="oracleDataSource" />
<entry key="mysqlDataSource" value-ref="mysqlDataSource" />
</map>
</property>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="multipleDataSource" />
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>
com.springmybatis.system.db.MyDataSource.java
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
public class MyDataSource extends AbstractRoutingDataSource {
/**
* 获取当前使用的那个数据源。
*/
@Override
protected Object determineCurrentLookupKey() {
return MyDbContextHolder.getDbType();
}
}
com.springmybatis.system.db.MyDbContextHolder.java
public class MyDbContextHolder {
private static final ThreadLocal<String> contextHolder = new ThreadLocal<String>();
/**
* 设置当前数据库。
* @param dbType
*/
public static void setDbType(String dbType) {
contextHolder.set(dbType);
}
/**
* 取得当前数据源。
* @return
*/
public static String getDbType() {
String str = (String) contextHolder.get();
return str;
}
/**
* 清除上下文数据
*/
public static void clearDbType() {
contextHolder.remove();
}
}
调用实例,亲测OK!
@Transactional
public int addAndDelUser(TestUser user) throws Exception {
int addCount=0;int delCount=0;
// 切换到MYSQL数据源
MyDbContextHolder.setDbType("mysqlDataSource");
// 添加新会员信息
addCount = testUserDao.addUser(user);
String[] arr = new String[]{"1"};
for (String str : arr) {
// 设定旧会员ID
user = new TestUser();user.setUserId(str);
// 删除旧会员信息
delCount = testUserDao.delUser(user);
}
// 恢复到原先数据源
MyDbContextHolder.clearDbType();
return addCount + delCount;
}
切换数据库的时候,切记不要再Mapper层进行切换。在Mapper切换的话,数据库还是默认数据库。