Spring 数据源-数据库链接自动检测

1、Spring数据源配置如下：
配置主从数据源ds1,ds2，分别提供给统一的数据源ds来调度；

<?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;
	}

}