spring mvc mybatis 注解实现多数据源

sanhutrees

<?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:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:context="http://www.springframework.org/schema/context" xmlns:task="http://www.springframework.org/schema/task"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans  http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/tx  http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/jee  http://www.springframework.org/schema/jee/spring-jee-3.0.xsd
http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd"
default-lazy-init="true">
<description>Spring公共配置</description>
<!-- 导入属性配置文件 -->
<context:property-placeholder location="classpath:property/db.properties" />

<!--################################### 平台数据源配置############################### -->
<!-- C3P0数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<property name="driverClass" value="${mysql.driverclass}"></property>
<property name="jdbcUrl" value="${mysql.jdbcurl}"></property>
<property name="user" value="${mysql.user}"></property>
<property name="password" value="${mysql.password}"></property>
<property name="acquireIncrement" value="5"></property><!-- 当连接池中的连接用完时，C3P0一次性创建新连接的数目2 -->
<property name="initialPoolSize" value="10"></property><!-- 初始化时创建的连接数，必须在minPoolSize和maxPoolSize之间 -->
<property name="minPoolSize" value="5"></property>
<property name="maxPoolSize" value="20"></property>
<!--
最大空闲时间，超过空闲时间的连接将被丢弃 [需要注意：mysql默认的连接时长为8小时(28800）【可在my.ini中添加 wait_timeout=30(单位秒)设置连接超时】,这里设置c3p0的超时必须<28800]
-->
<property name="maxIdleTime" value="300"></property>
<property name="idleConnectionTestPeriod" value="60"></property><!-- 每60秒检查连接池中的空闲连接 -->
<property name="maxStatements" value="20"></property>
<!--
jdbc的标准参数 用以控制数据源内加载的PreparedStatement数量，但由于预缓存的Statement属
于单个Connection而不是整个连接
-->
</bean>
<!-- 使用annotation 自动注册bean,并保证@Required,@Autowired的属性被注入 -->
<context:component-scan base-package="com.wxws" />
<!--开启注解 有了context:component-scan，@Required,@Autowired自动注入了
<context:annotation-config />-->

<!-- 使用annotation定义事务 -->
<!--
<tx:annotation-driven transaction-manager="transactionManager"
proxy-target-class="true" />
-->
<!-- Spring xml统一管理事务开始 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="get*" read-only="true" />
<tx:method name="query*" read-only="true" />
<tx:method name="find*" read-only="true" />
<tx:method name="list*" read-only="true" />
<tx:method name="*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
<aop:config>
<!-- 多个包可以加  or execution(* cn.tempus.demo.service.*.*(..)) -->
<aop:pointcut id="allManagerMethod" expression="execution(* com.wxws.admin.*.service.*.*(..))" />
<aop:advisor pointcut-ref="allManagerMethod" advice-ref="txAdvice" />
</aop:config>
<!-- Spring xml统一管理事务结束 -->

<!-- MyBatis 配置开始 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 实体的包名 -->
<property name="configLocation" value="classpath:spring/platform-mybatis-config.xml" />
</bean>
<!-- 定义所要扫描的Mapper配置文件包路径，多个包用逗号或者分号隔开-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.wxws.*.*.dao" />
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property></bean>
<!-- MyBatis 配置结束 -->


<!--################################### erp配置############################### -->
<!-- erp数据源 -->
<bean id="erpDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<property name="driverClass" value="${mysqlerp.driverclass}"></property>
<property name="jdbcUrl" value="${mysqlerp.jdbcurl}"></property>
<property name="user" value="${mysqlerp.user}"></property>
<property name="password" value="${mysqlerp.password}"></property>
<property name="acquireIncrement" value="${acquireIncrement}"></property> <!--当连接池中的连接用完时，C3P0一次性创建新连接的数目2 -->
<property name="initialPoolSize" value="${initialPoolSize}"></property> <!--初始化时创建的连接数，必须在minPoolSize和maxPoolSize之间 -->
<property name="minPoolSize" value="${minPoolSize}"></property>
<property name="maxPoolSize" value="${maxPoolSize}"></property>
<property name="maxIdleTime" value="${maxIdleTime}"></property>
<property name="idleConnectionTestPeriod" value="${idleConnectionTestPeriod}"></property> <!--每60秒检查连接池中的空闲连接  -->
<property name="maxStatements" value="${maxStatements}"></property>
</bean>
<!-- 使用annotation 自动注册bean,并保证@Required,@Autowired的属性被注入 -->
<!--<context:component-scan base-package="com.wxws.admin" />-->
<!--开启注解 有了context:component-scan，@Required,@Autowired自动注入了
<context:annotation-config />-->
<!-- Spring xml统一管理事务开始 -->
<bean id="erpTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="erpDataSource" />
</bean>
<tx:advice id="erpTxAdvice" transaction-manager="erpTransactionManager">
<tx:attributes>
<tx:method name="get*" read-only="true" />
<tx:method name="query*" read-only="true" />
<tx:method name="find*" read-only="true" />
<tx:method name="list*" read-only="true" />
<tx:method name="*" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
<aop:config>
<!-- 多个包可以加  or execution(* cn.tempus.demo.service.*.*(..)) -->
<aop:pointcut id="allManagerMethodErp" expression="execution(* com.wxws.*.service.*.*(..))" />
<aop:advisor pointcut-ref="allManagerMethodErp" advice-ref="erpTxAdvice" />
</aop:config>
<!-- MyBatis 配置开始 -->
<bean id="sqlSessionFactoryErp" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="erpDataSource" />
<!-- 实体的包名 -->
<property name="configLocation" value="classpath:spring/erp-mybatis-config.xml" />
</bean>

<!-- 定义所要扫描的Mapper配置文件包路径，多个包用逗号或者分号隔开-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.wxws.*.dao" />
<property name="sqlSessionFactory" ref="sqlSessionFactoryErp"></property></bean>
<!-- MyBatis 配置结束 -->
</beans>


当初我配置的时候<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>没有配置这个属性，所以多数据源始终不起作用