mybaits+spring连接多个数据库源码

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:jdbc="http://www.springframework.org/schema/jdbc"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">


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

<!-- datasource -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/gzgs?useUnicode=true&amp;characterEncoding=utf-8" />
<property name="username" value="scw2" />
<property name="password" value="scw2" />
</bean>


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


<!-- SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- <property name="configLocation">
<value>WEB-INF/mybatis-config.xml</value>
</property> -->
<property name="dataSource" ref="dataSource" />
<property name="typeAliasesPackage" value="com.vfj.gzgs.base;com.vfj.gzgs.account.domain;com.vfj.gzgs.agency.domain;com.vfj.gzgs.agencybranch.domain;com.vfj.gzgs.cpucard2issue.domain;com.vfj.gzgs.encryptor.domain;com.vfj.gzgs.terminal.domain;com.vfj.gzgs.centerdevice.domain;com.vfj.gzgs.devicetypeman.domain;com.vfj.gzgs.devicecenter.domain;com.vfj.gzgs.system.domain;com.vfj.gzgs.cardtype.domain;com.vfj.gzgs.personcard.domain;com.vfj.gzgs.card.domain" />
</bean>


<bean name="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.vfj.gzgs.account.service;com.vfj.gzgs.agency.service;com.vfj.gzgs.cpucard2issue.service;com.vfj.gzgs.encryptor.service;com.vfj.gzgs.agencybranch.service;com.vfj.gzgs.terminal.service;com.vfj.gzgs.devicecenter.service;com.vfj.gzgs.centerdevice.service;com.vfj.gzgs.devicetypeman.service;com.vfj.gzgs.system.service;com.vfj.gzgs.cardtype.service;com.vfj.gzgs.personcard.service;com.vfj.gzgs.card.service" />
<property name="sqlSessionFactory" ref="sqlSessionFactory"> </property>
</bean>


<!-- enable component scanning and autowire (beware that this does not enable mapper scanning!) -->
<!-- <context:component-scan base-package="com.vfj.gzgs.account.service" />
<context:component-scan base-package="com.vfj.gzgs.agency.service" />
<context:component-scan base-package="com.vfj.gzgs.cpucard2issue.service" />
<context:component-scan base-package="com.vfj.gzgs.encryptor.service" />
<context:component-scan base-package="com.vfj.gzgs.agencybranch.service" />
<context:component-scan base-package="com.vfj.gzgs.terminal.service" />


<context:component-scan base-package="com.vfj.gzgs.devicecenter.service" />


<context:component-scan base-package="com.vfj.gzgs.centerdevice.service" />
<context:component-scan base-package="com.vfj.gzgs.devicetypeman.service" />
<context:component-scan base-package="com.vfj.gzgs.system.service" />
<context:component-scan base-package="com.vfj.gzgs.cardtype.service" />
<context:component-scan base-package="com.vfj.gzgs.personcard.service" />
<context:component-scan base-package="com.vfj.gzgs.card.service" />
<context:component-scan base-package="com.vfj.gzgs.test.service" />
-->

<!-- scan for mappers and let them be autowired -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.vfj.gzgs.account.dao;com.vfj.gzgs.agency.dao;com.vfj.gzgs.agencybranch.dao;com.vfj.gzgs.cpucard2issue.dao;com.vfj.gzgs.encryptor.dao;com.vfj.gzgs.terminal.dao;com.vfj.gzgs.centerdevice.dao;com.vfj.gzgs.devicetypeman.dao;com.vfj.gzgs.devicecenter.dao;com.vfj.gzgs.system.dao;com.vfj.gzgs.cardtype.dao;com.vfj.gzgs.personcard.dao;com.vfj.gzgs.card.dao" />
<property name="sqlSessionFactory" ref="sqlSessionFactory"> </property>
</bean>
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="maxUploadSize" value="1073741824" />
</bean>

<!-- Service -->
<bean id="cpucard2issueService" class="com.vfj.gzgs.cpucard2issue.service.Cpucard2issueServiceImpl"/>
<bean id="accountService" class="com.vfj.gzgs.account.service.AccountServiceImpl"/>
<bean id="agencyService" class="com.vfj.gzgs.agency.service.AgencyServiceImpl"/>
<bean id="agencyBranchService" class="com.vfj.gzgs.agencybranch.service.AgencyBranchServiceImpl"/>
<bean id="encryptorService" class="com.vfj.gzgs.encryptor.service.EncryptorServiceImpl"/>
<bean id="terminalService" class="com.vfj.gzgs.terminal.service.TerminalServiceImpl"/>

<!-- <bean id="devicecenterService" class="com.vfj.gzgs.devicecenter.service.DeviceCenterServiceImpl"/> -->
<bean id="centerDeviceService" class="com.vfj.gzgs.centerdevice.service.CenterDeviceServiceImpl"/>
<bean id="deviceTypeManService" class="com.vfj.gzgs.devicetypeman.service.DeviceTypeManServiceImpl"/>
<bean id="systemService" class="com.vfj.gzgs.system.service.SystemServiceImpl"/>
<bean id="cardFormatService" class="com.vfj.gzgs.cardtype.service.CardFormatServiceImpl"/>
<bean id="personCardService" class="com.vfj.gzgs.personcard.service.PersonCardServiceImpl"/>
<bean id="businessService" class="com.vfj.gzgs.system.service.BusinessServiceImpl"/>
<bean id="card_contractService" class="com.vfj.gzgs.card.service.Card_contractServiceImpl"/>
<bean id="testService" class="com.vfj.gzgs.test.service.TestServiceImpl"/>



<bean id="dataSource_1" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:8080/trdb?useUnicode=true&amp;characterEncoding=utf-8" />
<property name="username" value="scw2" />
<property name="password" value="scw2" />
</bean>


<bean id="sqlSessionFactory_1" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource_1" />
<property name="typeAliasesPackage" value="com.vfj.gzgs.test.domain"/>
</bean>

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


<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.vfj.gzgs.test.dao" />
<property name="sqlSessionFactory" ref="sqlSessionFactory_1"> </property>
</bean>


<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactory" ref="sqlSessionFactory_1"> </property>
<property name="basePackage" value="com.vfj.gzgs.test.service" />

</bean>



</beans>