<?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"
? ? ? xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
? ? ? 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
http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd"
? ? ? default-lazy-init="true">
<description>mybatis配置</description>
? <bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!-- 指定 domain 路徑,為Java類型命名一個短的別名,例如:com.mochasoft 的別名是Category -->
? ? <property name="typeAliasesPackage" value="cmcc.unify.backlog.collection"/>
<!--? 指定單個類-->
? ? <!-- 指定mapper.xml路徑 -->
? ? <property name="mapperLocations" value="classpath:cmcc/unify/backlog/collection/**/mapper/*.xml"></property>
<!-- 1.配置mybatis屬性第一種方式:指定 mybatis的配置文件 -->
? ? <!-- 2.配置mybatis屬性第二種方式:直接配置mybatis屬性萝喘。-->
? ? <property name="configuration">
<bean class="org.apache.ibatis.session.Configuration">
<property name="cacheEnabled" value="${mybatis.cacheEnabled}"/>
<property name="useGeneratedKeys" value="${mybatis.useGeneratedKeys}"/>
<property name="defaultExecutorType" value="${mybatis.defaultExecutorType}"/>
<property name="mapUnderscoreToCamelCase" value="${mybatis.mapUnderscoreToCamelCase}"/>
<property name="lazyLoadingEnabled" value="${mybatis.lazyLoadingEnabled}"/>
<property name="multipleResultSetsEnabled" value="${mybatis.multipleResultSetsEnabled}"/>
<property name="useColumnLabel" value="${mybatis.useColumnLabel}"/>
<property name="defaultStatementTimeout" value="${mybatis.defaultStatementTimeout}"/>
<property name="jdbcTypeForNull" value="NULL"></property>
</bean>
</property>
</bean>
<!-- scan for mappers and let them be autowired,類和xml在同一目錄中,名稱相同,則自動綁定? -->
? <!-- mybatis 事物托管給spring-->
? <bean name="transcationManagerMybatis" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:annotation-driven transaction-manager="transcationManagerMybatis"/>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cmcc.unify.backlog.collection.**.mapper" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<bean name="dataSource_2" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="url" value="${sgs.db.url}" />
<property name="username" value="${sgs.db.username}" />
<property name="password" value="${sgs.db.password}" />
<!-- 初始化連接大小 -->
? ? <property name="initialSize" value="0" />
<!-- 連接池最大使用連接數(shù)量 -->
? ? <property name="maxActive" value="20" />
<!-- 連接池最大空閑 -->
? ? <property name="maxIdle" value="20" />
<!-- 連接池最小空閑 -->
? ? <property name="minIdle" value="0" />
<!-- 獲取連接最大等待時間 -->
? ? <property name="maxWait" value="60000" />
</bean>
? <bean name="sqlSessionFactory2" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource_2"/>
<!-- 指定 domain 路徑,為Java類型命名一個短的別名,例如:com.mochasoft 的別名是Category -->
? ? <property name="typeAliasesPackage" value="cmcc.unify.backlog.transform"/>
<!--? 指定單個類-->
? ? <!-- 指定mapper.xml路徑 -->
? ? <property name="mapperLocations" value="classpath:cmcc/unify/backlog/transform/**/mapper/*.xml"></property>
<!-- 1.配置mybatis屬性第一種方式:指定 mybatis的配置文件 -->
? ? <!-- 2.配置mybatis屬性第二種方式:直接配置mybatis屬性。-->
? ? <property name="configuration">
<bean class="org.apache.ibatis.session.Configuration">
<property name="cacheEnabled" value="${mybatis.cacheEnabled}"/>
<property name="useGeneratedKeys" value="${mybatis.useGeneratedKeys}"/>
<property name="defaultExecutorType" value="${mybatis.defaultExecutorType}"/>
<property name="mapUnderscoreToCamelCase" value="${mybatis.mapUnderscoreToCamelCase}"/>
<property name="lazyLoadingEnabled" value="${mybatis.lazyLoadingEnabled}"/>
<property name="multipleResultSetsEnabled" value="${mybatis.multipleResultSetsEnabled}"/>
<property name="useColumnLabel" value="${mybatis.useColumnLabel}"/>
<property name="defaultStatementTimeout" value="${mybatis.defaultStatementTimeout}"/>
<property name="jdbcTypeForNull" value="NULL"></property>
</bean>
</property>
</bean>
<!-- scan for mappers and let them be autowired,類和xml在同一目錄中,名稱相同,則自動綁定? -->
? <!-- mybatis 事物托管給spring-->
? <bean name="transcationManagerMybatis2" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource_2"/>
</bean>
<tx:annotation-driven transaction-manager="transcationManagerMybatis2"/>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="cmcc.unify.backlog.transform.**.mapper" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory2"/>
</bean>
</beans>
注意强窖，兩個數(shù)據(jù)源引用包需要分開削祈，不可混用
