spring+ibatis多数据源

<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>WEB-INF/config/jdbc.properties </value>
</list>
</property>
</bean>

<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName"
value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<!-- 数据源的加载 -->

<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>

<bean id="sqlMapClient"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation"
value="/WEB-INF/config/sqlMap-config.xml" />
<property name="dataSource" ref="dataSource" />
</bean>

DAO层是：
public class DepartmentDaoImp extends SqlMapClientDaoSupport implements
DepartmentDao {

public int addDepartment(DepartmentInfo departmentInfo) {

return getSqlMapClientTemplate().update("Department.addDepartment", departmentInfo);
}

 

 

当然可以配置多个，sqlMapClient只是默认的，你可以自己配置多个呀
<bean id="userDaoImp" class="gov.ynfda.dao.UserDaoImp">
<property name="sqlMapClient" ref="sqlMapClient" />
<property name="sqlMapClient1" ref="sqlMapClient" />
<property name="sqlMapClient2" ref="sqlMapClient2" />
<property name="sqlMapClient3" ref="sqlMapClient3" />
</bean>

transactionManager也分成多个
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="transactionManager1"......
<bean id="transactionManager2"......

然后再你的dao类里面声明(sqlMapClient是默认的无需声明)
private SqlMapClient sqlMapClient1;
private SqlMapClient sqlMapClient2;
private SqlMapClient sqlMapClient3;

get/set ......