mybatis多数据源配置

1：配置多个数据源

<!-- 数据源1 -->    <bean id="dwDataSource" parent="parentDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver" />        <property name="url" value="jdbc:mysql://***.mysql.rds.aliyuncs.com:3306/fmcm_data?useUnicode=true&characterEncoding=utf8" />        <property name="username" value="***" />        <property name="password" value="***" /></bean>    <bean id="dwSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">             <property name="configLocation" value="classpath:mybatis_configuration_dw.xml" />             <property name="dataSource" ref="dwDataSource" />         </bean>     <bean id="dwTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dwDataSource" />    </bean>        <!-- 数据源2 -->    <bean id="pgcDataSource" parent="parentDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver" />        <property name="url" value="jdbc:mysql://***.mysql.rds.aliyuncs.com:3306/fmcm_pgc?useUnicode=true&characterEncoding=utf8" />        <property name="username" value="***" />        <property name="password" value="***" /></bean>    <bean id="pgcSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">             <property name="configLocation" value="classpath:mybatis_configuration_pgc.xml" />             <property name="dataSource" ref="pgcDataSource" />         </bean>     <bean id="pgcTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="pgcDataSource" />    </bean>

2：给不同的dao配置不同的sessionFactory，Dao继承SqlSessionDaoSupport

<bean id="newsDao" class="cn.cover.worker.dao.server.impl.NewsDaoImpl"><property name="sqlSessionFactory" ref="sqlSessionFactory" /></bean><bean id="dwNewsDao" class="cn.cover.worker.dao.server.impl.DwNewsDaoImpl">    <property name="sqlSessionFactory" ref="dwSqlSessionFactory"/>    </bean>        <bean id="dwNewsCmsDao" class="cn.cover.worker.dao.server.impl.DwNewsCmsDaoImpl">    <property name="sqlSessionFactory" ref="sqlSessionFactory"/>    </bean>