Spring-SpringMvc-Mybatis整合配置

Spring-SpringMvc-Mybatis整合配置

（一）导jar包
- -Spring:context,core,beans,jdbc,aop,aspects,web,webmvc
- -Mybatis:core,mybatis
- -commons:logging,log4j,dbcp2
- -其他:jstl,standard,junit,jstl-api,mysql-connector,aspectweaver,aopalliance
（二）配置web.xml

1. 配置服务器启动后加载applicationContext.xml

<!--启动Spring的容器-->
<context-param>
	<param-name>contextConfigLocation</param-name>
	<param-value>classpath:beans.xml</param-value>
</context-param>
<listener>
	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

2. 配置SpringMVC的前端控制器。

<servlet>
	<servlet-name>dispatcherServlet</servlet-name>
	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
	<init-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:springmvc.xml</param-value>
	</init-param>
	<!---->
	<load-on-startup>1</load-on-startup>
</servlet>
<!--拦截所有请求-->
<servlet-mapping>
	<servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
</servlet-mapping>

3. 配置字符编码过滤器

<filter>
    <filter-name>characterEncodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
      <param-name>encoding</param-name>
      <param-value>UTF-8</param-value>
    </init-param>
    <init-param>
      <param-name>forceEncoding</param-name>
      <param-value>true</param-value>
    </init-param>
  </filter>
  
  <filter-mapping>
    <filter-name>characterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>

（三）编写mybatis配置文件SqlMapConfig.xml

1. log4j配置
2. 别名配置
3. 映射配置

<?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>
    <!--log4j-->
    <settings>
        <setting name="logImpl" value="LOG4J"/>
    </settings>
    <!--别名-->
    <typeAliases>
        <package name="com.li.bean"/>
    </typeAliases>
    <!--映射-->
    <mappers>
        <package name="com.li.dao"/>
    </mappers>
</configuration>

（四）编写Spring配置文件applicationContext.xml

1. 配置自动扫描（不包含Controller注解）
2. 配置dbcp2数据源
3. 利用数据源与mybatis配置文件创建SqlSessionFactoryBean类的bean
4. 利用dao包名和SqlSessionFactoryBean配置MapperScannerConfigurer（Mapper接口动态代理类）的bean。
5. 利用xml设置Spring管理事务。

<?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:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       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">
    <!--1.开启自动扫描，-->
    <context:component-scan base-package="com.li">
        <!--不包含Controller注解-->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    <!--2.配置数据源-->
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/(数据库名)"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
    </bean>
    <!--3.配置SQLSessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="configLocation" value="SqlMapConfig.xml"/>
    </bean>
    <!--4.配置MapperScannerConfigurer-->
    <bean id="config" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--为com.li.dao包下的接口创建代理对象存入bean中-->
        <property name="basePackage" value="com.li.dao"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>
    <!--5.Spring管理事务-->
    <bean id="tx" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <tx:advice id="txAdvice" transaction-manager="tx">
        <tx:attributes>
            <tx:method name="insert*" propagation="REQUIRED"/>
            <tx:method name="delete*" propagation="REQUIRED"/>
            <tx:method name="update*" propagation="REQUIRED"/>
            <tx:method name="select*" propagation="SUPPORTS"/>
            <tx:method name="query*" propagation="SUPPORTS"/>
            <tx:method name="find*" propagation="SUPPORTS"/>
        </tx:attributes>
    </tx:advice>
    <aop:config>
        <aop:pointcut id="aopPointcut" expression="execution(* com.li.dao.*.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="aopPointcut"/>
    </aop:config>
</beans>

（五）编写SpringMVC配置文件SpringMVC.xml

1. 启动自动扫描功能（只扫描Controller）
2. springmvc标准配置

    <!--1.开启自动扫描，-->
    <context:component-scan base-package="com.li.controller">
        <!--只包含Controller注解-->
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
   <!---->
    <mvc:default-servlet-handler/>
    <mvc:annotation-driven/>
</beans>

…