分库管理

配置两个数据源 + 一个 数据路由器

  <!-- 数据源(主库) -->                             
     <bean id="dataSource_main" class="com.mchange.v2.c3p0.ComboPooledDataSource">
         <property name="jdbcUrl" value="${jdbc.url}"></property>
         <property name="user" value="${jdbc.username}"></property>
         <property name="password" value="${jdbc.password}"></property>
         <property name="driverClass" value="${jdbc.driverClass}"></property>
         
         <property name="maxPoolSize" value="${c3p0.pool.size.maxsize}"></property>
         <property name="minPoolSize" value="${c3p0.pool.size.minsize}"></property>
         <property name="initialPoolSize" value="${c3p0.pool.size.init}"></property>
         <property name="acquireIncrement" value="${c3p0.pool.size.increment}"></property>
     </bean>
     
     <!-- 数据源(从库  继承主库) -->
     <bean id="dataSource_1" parent="dataSource_main">
         <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/surveypark_1"></property>
     </bean>
     
     <!-- 数据路由器 -->
     <bean id="datasource_router" class="kite.datasource.SurveyparkDataSourceRouter">
         <property name="targetDataSources">
             <map>
                 <entry key="odd" value-ref="dataSource_main" />
                 <entry key="even" value-ref="dataSource_1"></entry>
             </map>
         </property>
        <property name="defaultTargetDataSource" ref="dataSource_main"></property>
     </bean>
     
     <!-- 
         本地会话工厂bean,spring整合hibernate的核心入口
      -->
     <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
         <!-- 注入数据源 -->
         <property name="dataSource" ref="datasource_router"></property>
         <!-- 指定hibernate配置文件的位置 -->
         <property name="configLocation" value="classpath:hibernate.cfg.xml"/>
         <!-- 指定映射文件的位置 -->
         <property name="mappingDirectoryLocations">
             <list>
                 <value>classpath:kite/domain</value>
             </list>
         </property>
     </bean>    

创建一个令牌类 

package kite.datasource;

import kite.domain.Survey;

/**
 * 调查令牌,绑定到当前的线程,传播到数据源路由器.进行分库判断
 */
public class SurveyToken
{
    private Survey survey;

    private static ThreadLocal<SurveyToken> t = new ThreadLocal<SurveyToken>();
    
    /**
     * 将令牌对象绑定到当前线程
     */
    public static void bindingToken(SurveyToken surveyToken)
    {
        t.set(surveyToken);
    }
    
    /**
     * 从当前线程获得绑定的令牌对象
     * @return
     */
    public static SurveyToken getCurrentToken()
    {
        return t.get();
    }
    
    /**
     * 解除令牌的绑定
     * @return
     */
    public static void unbinToken()
    {
        t.remove();
    }
    
    
    
    
    public Survey getSurvey()
    {
        return survey;
    }

    public void setSurvey(Survey survey)
    {
        this.survey = survey;
    }
    
}

自定义数据源

package kite.datasource;

import java.sql.SQLFeatureNotSupportedException;
import java.util.logging.Logger;

import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;

/**
 *   自定义数据源
 */
public class SurveyparkDataSourceRouter extends AbstractRoutingDataSource 
{

    protected Object determineCurrentLookupKey()
    {
        SurveyToken token = SurveyToken.getCurrentToken();
            
        if(token != null)
        {
            int id = token.getSurvey().getSurveyid();
            //解除绑定
            SurveyToken.unbinToken();
            return (id % 2) == 0 ? "even":"odd";
        }
        return null;
    }
    
    public Logger getParentLogger() throws SQLFeatureNotSupportedException
    {
        return null;
    }

    public <T> T unwrap()
    {
        return null;
    }

    public boolean isWrapperFor()
    {
        return false;
    }
}

在action中进行绑定

//绑定到当前线程中
SurveyToken token = new SurveyToken();
token.setSurvey(getCurrentSurvey());
SurveyToken.bindingToken(token);