SpringMVC和mybatis的整合

SpringMVC+mybaits的系统架构

---

SpringMVC+mybaits整合步骤

第一步：整合dao层

在doDispatch()方法中调用了DispatcherServlet类的getHandler方法。映射器根据request当中的URL，找到了Handler，最终返回一个执行器的链(HandlerExecutionChain)。这个链里面有Handler。
配置mybatis的全局配置文件：sqlMapConfig.xml

sqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--mybatis的全局配置文件-->
<!-- 全局setting配置，根据需要添加 -->

<!-- 配置别名 -->
<typeAliases>
    <!-- 批量扫描别名 -->
    <package name="com.syshlang.smm.pojo"/>
</typeAliases>

<!-- 配置mapper
由于使用spring和mybatis的整合包进行mapper扫描，这里不需要配置了。
必须遵循：mapper.xml和mapper.java文件同名且在一个目录
 -->

<!--
<mappers>
     通过mapper元素的resource属性可以指定一个相对于类路径的Mapper.xml文件
    <mapper resource="com/syshlang/smm/mapping/ItemsMapper.xml"/>
    通过mapper元素的url属性可以指定一个通过URL请求道的Mapper.xml文件
    <mapper url="file:///E:\Workspaces\Intellij\SpringMM\src\main\resources\com\syshlang\smm\mapping\ItemsMapper.xml"/>
    通过mapper元素的class属性可以指定一个Mapper接口进行注册
    <mapper class="com.syshlang.smm.mapper.ItemsMapper"/>
    通过package元素将会把指定包下面的所有Mapper接口进行注册
    <package name="com.syshlang.smm.mapper"/>
</mappers>
-->
</configuration>

配置spring和mybatis整合的配置文件：applicationContext-dao.xml
主要包括数据源、SqlSessionFactory、mapper扫描器等

applicationContext-dao.xml

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.2.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">

    <!-- 加载db.properties文件中的内容，db.properties文件中key命名要有一定的特殊规则 -->
    <context:property-placeholder location="classpath:db.properties" />
    <!-- 配置数据源 ，dbcp -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
          destroy-method="close">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="maxActive" value="30" />
        <property name="maxIdle" value="5" />
    </bean>


    <!-- sqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 数据库连接池 -->
        <property name="dataSource" ref="dataSource" />
        <!-- 加载mybatis的全局配置文件 -->
        <property name="configLocation" value="classpath:config/mybatis/sqlMapConfig.xml" />
        <property name="mapperLocations" value="classpath:com/syshlang/smm/mapping/*Mapper.xml"/>
        <!--分页插件-->
        <property name="plugins">
            <array>
                <bean class="com.github.pagehelper.PageHelper">
                    <property name="properties">
                        <value>
                            dialect=mysql
                            reasonable=true
                        </value>
                    </property>
                </bean>
            </array>
        </property>
    </bean>

    <!-- mapper扫描器 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!-- 扫描包路径，如果需要扫描多个包，中间使用半角逗号隔开 -->
        <property name="basePackage" value="com.syshlang.smm.mapper"></property>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    </bean>
</beans>

第二步：整合service层

通过spring管理 service接口,使用配置方式将service接口配置在spring配置文件中,实现事务控制。
配置service：applicationContext-service.xml

applicationContext-service.xml

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.2.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
    <bean id="itemsserviceimpl"  class="com.syshlang.smm.service.impl.ItemsServiceImpl" />
</beans>

使用spring声明事务控制方法，配置事务控制：applicationContext-transaction.xml

applicationContext-transaction.xml

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.2.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
    <!-- 事务管理器
    对mybatis操作数据库事务控制，spring使用jdbc的事务控制类
    -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!-- 数据源
            dataSource在applicationContext-dao.xml中配置了
         -->
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- 通知 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <!-- 传播行为 -->
            <tx:method name="save*" propagation="REQUIRED"/>
            <tx:method name="delete*" propagation="REQUIRED"/>
            <tx:method name="insert*" propagation="REQUIRED"/>
            <tx:method name="update*" propagation="REQUIRED"/>
            <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
            <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
            <tx:method name="select*" propagation="SUPPORTS" read-only="true"/>
        </tx:attributes>
    </tx:advice>
    <!-- aop -->
    <aop:config>
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.syshlang.smm.service.impl.*.*(..))"/>
    </aop:config>

   <!-- <aop:config>
        <aop:pointcut id="transactionPointcut"
                      expression="execution(* com.syshlang.smm.service.impl.*.*Dao.*(..))" />
        <aop:advisor pointcut-ref="transactionPointcut"
                     advice-ref="txAdvice"  />
    </aop:config>-->
</beans>

第三步：整合SpringMVC

由于SpringMVC是spring的模块，不需要整合，只需配置spring-mvc.xml文件，包括处理器映射器、适配器、视图解析器等。
配置:spring-mvc.xml

spring-mvc.xml

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.2.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">

    <!-- 自动扫描包，实现支持注解的IOC -->
    <context:component-scan base-package="com.syshlang.smm" />

    <!-- Spring MVC不处理静态资源 -->
    <mvc:default-servlet-handler />

    <!--注解映射器 支持mvc注解驱动-->
    <mvc:annotation-driven />


    <!-- 扫描指定controller的包-->
    <!--<context:component-scan base-package="com.syshlang.smm.controller"></context:component-scan>-->

    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!--
        配置jsp路径的前缀
        <property name="prefix" value="/WEB-INF/jsp/" />
        配置jsp路径的后缀
        <property name="suffix" value=".jsp" />
        -->
    </bean>
</beans>