spring+ibatis多数据源(转载)

来源:百度文库 编辑:神马文学网 时间:2024/04/29 01:04:54
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">


WEB-INF/config/jdbc.properties



class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
value="${jdbc.driverClassName}" />





class="org.springframework.jdbc.datasource.DataSourceTransactionManager">


class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
value="/WEB-INF/config/sqlMap-config.xml" />


DAO层是:
public class DepartmentDaoImp extends SqlMapClientDaoSupport implements
DepartmentDao {
public int addDepartment(DepartmentInfo departmentInfo) {
return getSqlMapClientTemplate().update("Department.addDepartment", departmentInfo);
}
当然可以配置多个,sqlMapClient只是默认的,你可以自己配置多个呀






transactionManager也分成多个
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">


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