<?xml version="1.0" encoding="UTF-8"?> 
<beans xmlns="http://www.springframework.org/schema/beans" 
    xmlns:context="http://www.springframework.org/schema/context" 
    xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:cache="http://www.springframework.org/schema/cache" 
    xsi:schemaLocation="http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans.xsd 
            http://www.springframework.org/schema/context  http://www.springframework.org/schema/context/spring-context.xsd 
            http://www.springframework.org/schema/tx   http://www.springframework.org/schema/tx/spring-tx.xsd 
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd 
            http://www.springframework.org/schema/cache http://www.springframework.org/schema/cache/spring-cache.xsd"> 
  <context:component-scan base-package="com.zto.subscribecore"></context:component-scan> 
 
 
 
  <!-- 数据源 --> 
  <bean id="mysqlDataSource" class="com.alibaba.druid.pool.DruidDataSource" 
     init-method="init" destroy-method="close"> 
    <!-- 驱动名称 --> 
    <property name="DriverClassName" value="${mysql.DriverClassName}"/> 
    <!-- JDBC连接串 --> 
    <property name="url" value="${mysql.url}"/> 
    <!-- 数据库用户名称 --> 
    <property name="username" value="${mysql.username}"/> 
    <!-- 数据库密码 --> 
    <property name="password" value="${mysql.password}"/> 
    <!-- 连接池最大使用连接数量 --> 
    <property name="maxActive" value="${mysql.maxActive}"/> 
    <!-- 初始化大小 --> 
    <property name="initialSize" value="${mysql.initialSize}"/> 
    <!-- 获取连接最大等待时间 --> 
    <property name="maxWait" value="${mysql.maxWait}"/> 
    <!-- 连接池最小空闲 --> 
    <property name="minIdle" value="${mysql.minIdle}"/> 
    <!-- 逐出连接的检测时间间隔 --> 
    <property name="timeBetweenEvictionRunsMillis" value="${mysql.timeBetweenEvictionRunsMillis}"/> 
    <!-- 最小逐出时间 --> 
    <property name="minEvictableIdleTimeMillis" value="${mysql.minEvictableIdleTimeMillis}"/> 
    <!-- 测试有效用的SQL Query --> 
    <property name="validationQuery" value="${mysql.validationQuery}"/> 
    <!-- 连接空闲时测试是否有效 --> 
    <property name="testWhileIdle" value="${mysql.testWhileIdle}"/> 
    <!-- 获取连接时测试是否有效 --> 
    <property name="testOnBorrow" value="${mysql.testOnBorrow}"/> 
    <!-- 归还连接时是否测试有效 --> 
    <property name="testOnReturn" value="${mysql.testOnReturn}"/> 
  </bean> 
 
  <bean id="mysqlTransactionManager" 
     class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> 
    <property name="dataSource" ref="mysqlDataSource"/> 
  </bean> 
 
  <tx:annotation-driven transaction-manager="mysqlTransactionManager"/> 
 
  <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> 
    <property name="basePackage" value="com.zto.subscribecore.dal.mapper.mysql"/> 
    <property name="sqlSessionFactoryBeanName" value="mysqlSqlSessionFactory"/> 
  </bean> 
 
  <bean id="mysqlSqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 
    <property name="dataSource" ref="mysqlDataSource"/> 
    <property name="mapperLocations" value="classpath*:com/zto/subscribecore/dal/mapper/mysql/*.xml"></property> 
    <property name="typeAliasesPackage" value="com.zto.subscribecore.dal.domain"/> 
  </bean> 
 
</beans> 

@Configuration 
public class DruidConfiguration { 
  @Bean(name = "vip", initMethod = "init", destroyMethod = "close") 
  public DataSource compare1DataSource( 
      @Value("${spring.datasource.vip.driver-class-name}") String driver, 
      @Value("${spring.datasource.vip.url}") String url, 
      @Value("${spring.datasource.vip.username}") String username, 
      @Value("${spring.datasource.vip.password}") String password, 
      @Value("${spring.datasource.vip.minIdle}") int minIdle, 
      @Value("${spring.datasource.vip.maxActive}") int maxActive, 
      @Value("${spring.datasource.vip.initialSize}") int initialSize, 
      @Value("${spring.datasource.vip.timeBetweenEvictionRunsMillis}") long timeBetweenEvictionRunsMillis, 
      @Value("${spring.datasource.vip.minEvictableIdleTimeMillis}") long minEvictableIdleTimeMillis, 
      @Value("${spring.datasource.vip.validationQuery}") String validationQuery, 
      @Value("${spring.datasource.vip.testWhileIdle}") boolean testWhileIdle, 
      @Value("${spring.datasource.vip.testOnBorrow}") boolean testOnBorrow, 
      @Value("${spring.datasource.vip.testOnReturn}") boolean testOnReturn) { 
    DruidDataSource druidDataSource = new DruidDataSource(); 
    druidDataSource.setDriverClassName(driver); 
    druidDataSource.setUrl(url); 
    druidDataSource.setUsername(username); 
    druidDataSource.setPassword(password); 
    druidDataSource.setMinIdle(minIdle); 
    druidDataSource.setMaxActive(maxActive); 
    druidDataSource.setInitialSize(initialSize); 
    druidDataSource 
        .setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis); 
    druidDataSource 
        .setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis); 
    druidDataSource.setValidationQuery(validationQuery); 
    druidDataSource.setTestWhileIdle(testWhileIdle); 
    druidDataSource.setTestOnBorrow(testOnBorrow); 
    druidDataSource.setTestOnReturn(testOnReturn); 
    return druidDataSource; 
  } 
 
} 

@Configuration 
@MapperScan(basePackages = { "com.zto.merchantPlatform.mapper.vip" }, sqlSessionFactoryRef = "vipSqlSessionFactory") 
public class VipMybatisConfiguration { 
 
  @Autowired 
  @Qualifier("vip") 
  private DataSource dataSource; 
   
  @Bean(name = "vipSqlSessionFactory") 
  public SqlSessionFactoryBean sqlSessionFactory(@Value("${mybatis.vip.mapperLocations}") String mapperLocations,  
      @Value("${mybatis.vip.typeAliasesPackage}")String typeAliasesPackage) throws Exception { 
    SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean(); 
    sessionFactoryBean.setDataSource(dataSource); 
    sessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations)); 
    sessionFactoryBean.setTypeAliasesPackage(typeAliasesPackage); 
    return sessionFactoryBean; 
  } 
 
  @Bean(name = "vipTransactionManager") 
  public DataSourceTransactionManager transactionManager() { 
    return new DataSourceTransactionManager(dataSource); 
  } 
}