配置多个数据源

1、config.properties中配置多个数据源，以不同的名称区别

#运维库配置
managedb.driver=com.mysql.jdbc.Driver
managedb.url=
managedb.username=
managedb.password=

#檢索mysql庫配置
searchdb.driver=com.mysql.jdbc.Driver
searchdb.url=
searchdb.username=
searchdb.password=

2、applicationContext.xml中如下配置

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${managedb.driver}" />
        。。。
    </bean>

<bean id="dataSourceSearch" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${searchdb.driver}" />
</bean>

<bean id="dynamicDataSource" class="cn.gwssi.di.processing.manage.dao.DynamicDataSource" >  
        <!-- 通过key-value的形式来关联数据源 -->  
        <property name="targetDataSources">  
            <map>  
                <entry value-ref="dataSource" key="dataSource"></entry>  
                <entry value-ref="dataSourceSearch" key="dataSourceSearch"></entry>  
            </map>  
        </property>  
        <property name="defaultTargetDataSource" ref="dataSource" />  
    </bean>

    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">  
        <property name="dataSource">  
            <ref bean="dynamicDataSource" />  
        </property>  
    </bean>