Spring与Mybatis的集成

需要在pom文件中导入的依赖有如下：

<!--集成mybatis框架-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.30</version>
    </dependency>
    <dependency>
      <groupId>com.oracle</groupId>
      <artifactId>ojdbc8</artifactId>
      <version>12.2.0.1</version>
    </dependency>
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId> <!--阿里巴巴开源平台上一个数据库连接池实现，可以监控DB连接池和SQL的执行情况-->
      <version>${druid.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>${mybatis.spring.version}</version>
    </dependency>

配置文件为：

<context:component-scan base-package="com.wpq.cn"/>

     <!--配置数据库相关参数-->
     <context:property-placeholder location="classpath:jdbc.properties" ignore-unresolvable="true"/>

     <!--数据源-->
     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
           init-method="init" destroy-method="close">
          <property name="driverClassName" value="${jdbc.oracle.driver}"/>
          <property name="url" value="${jdbc.oracle.url}"/>
          <property name="username" value="${jdbc.oracle.username}"/>
          <property name="password" value="${jdbc.oracle.password}"/>
     </bean>
     <!--配置sqlsessionfactory-->
     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
          <!--注入数据库连接池-->
          <property name="dataSource" ref="dataSource"/>
          <!--扫描SQL的配置文件，mapping需要的xml的文件-->
          <property name="mapperLocations" value="classpath:mapper/*.xml"/>
     </bean>
     <!--<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">-->
          <!--<constructor-arg index="0" ref="sqlSessionFactory"/>-->
     <!--</bean>-->

     <!--扫描basepackage下一@MyBatis注解的接口-->
     <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
          <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
          <property name="basePackage" value="com.wpq.cn.dao"/>
     </bean>
     <!--s事物管理-->
     <!-- 声明式事务 -->
     <tx:annotation-driven transaction-manager="transactionManager"
                           proxy-target-class="true" />
     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
     <property name="dataSource" ref="dataSource"/>
     </bean>