1、Spring数据源配置如下:
- <?xml version="1.0" encoding="UTF-8"?>
- <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN" "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
- <beans>
- <!-- 配置数据源 -->
- <!-- 主数据库服务器 -->
- <bean id="ds1"
- class="org.springframework.jdbc.datasource.DriverManagerDataSource">
- <property name="driverClassName" value="org.logicalcobwebs.proxool.ProxoolDriver" />
- <property name="url" value="proxool.db1" />
- </bean>
- <!-- 从数据库服务器 -->
- <bean id="ds2"
- class="org.springframework.jdbc.datasource.DriverManagerDataSource">
- <property name="driverClassName" value="org.logicalcobwebs.proxool.ProxoolDriver" />
- <property name="url" value="proxool.db2" />
- </bean>
- <!-- 统一数据源-->
- <bean id="ds" class="com.a8.web.core.dynads.DynamicDataSource">
- <property name="targetDataSources">
- <map key-type="java.lang.String">
- <entry key="ds1" value-ref="ds1" />
- <entry key="ds2" value-ref="ds2" />
- </map>
- </property>
- <property name="defaultTargetDataSource" ref="ds1" />
- </bean>
- </beans>
2、代码继承AbstractRoutingDataSource
- import java.sql.Connection;
- import java.sql.SQLException;
- import org.springframework.jdbc.datasource.DriverManagerDataSource;
- import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
- import org.springframework.web.context.WebApplicationContext;
- import org.springframework.web.context.support.WebApplicationContextUtils;
- import com.a8.web.util.ApplicationConstantUtil;
- public class DynamicDataSource extends AbstractRoutingDataSource {
- // 主数据库bean名
- private static String MASTER = "ds1";
- // 从数据库bean名
- private static String SLAVEDS = "ds2";
- @Override
- protected Object determineCurrentLookupKey() {
- String dskey = "";
- try {
- // 获取上下文
- WebApplicationContext wac = WebApplicationContextUtils
- .getRequiredWebApplicationContext(ApplicationConstantUtil
- .getServletContext());
- // 获取从数据库连接
- DriverManagerDataSource curr_ds = (DriverManagerDataSource) wac
- .getBean(SLAVEDS);
- Connection conn = curr_ds.getConnection();
- if (conn.isClosed()) {
- // 主数据库
- dskey = MASTER;
- } else {
- // 从数据库
- dskey = SLAVEDS;
- }
- } catch (SQLException e1) {
- dskey = MASTER;
- }
- return dskey;
- }
- }