[关闭]
@MrXiao 2018-03-05T16:48:53.000000Z 字数 11350 阅读 765

Spring MVC(2)——整合spring-mybatis

SpringMVC

1、整合思路

dao层：

mybatis+spring
目标：
使用spring对sqlSessionFactory进行管理
使用spring和mybatis整合包中的mapper扫描器对mapper接口进行扫描生成代理对象。

service层：

spring
目标：
让spring管理service类，将mapper代理对象注入到service对象中。
spring要对service方法执行进行事务控制

controller层：

springmvc+spring
目标：
使用注解处理器映射器和适配器进行开发Handler
Handler使用组件扫描方式在spring容器中进行注册

2、工程搭建

2.1 创建maven web工程

2.2 设置jar包依赖(pom设置)

  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  3.     <modelVersion>4.0.0</modelVersion>
  4.     <groupId>com.topvision.maven</groupId>
  5.     <artifactId>ssm</artifactId>
  6.     <packaging>war</packaging>
  7.     <version>0.0.1-SNAPSHOT</version>
  8.     <name>ssm Maven Webapp</name>
  9.     <url>http://maven.apache.org</url>
  11.     <!-- 属性 -->
  12.     <properties>
  13.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  14.         <spring.version>4.3.12.RELEASE</spring.version>
  15.         <mybatis.version>3.4.5</mybatis.version>
  16.     </properties>
  18.     <!-- 锁定版本 -->
  19.     <dependencyManagement>
  20.         <dependencies>
  21.             <dependency>
  22.                 <groupId>org.springframework</groupId>
  23.                 <artifactId>spring-context</artifactId>
  24.                 <version>${spring.version}</version>
  25.             </dependency>
  26.             <dependency>
  27.             	<groupId>org.springframework</groupId>
  28.             	<artifactId>spring-aspects</artifactId>
  29.             	<version>${spring.version}</version>
  30.             </dependency>
  31.             <dependency>
  32.                 <groupId>org.springframework</groupId>
  33.                 <artifactId>spring-orm</artifactId>
  34.                 <version>${spring.version}</version>
  35.             </dependency>
  36.             <dependency>
  37.             	<groupId>org.springframework</groupId>
  38.             	<artifactId>spring-test</artifactId>
  39.             	<version>${spring.version}</version>
  40.             </dependency>
  41.             <dependency>
  42.                 <groupId>org.springframework</groupId>
  43.                 <artifactId>spring-web</artifactId>
  44.                 <version>${spring.version}</version>
  45.             </dependency>
  46.             <dependency>
  47.             	<groupId>org.springframework</groupId>
  48.             	<artifactId>spring-webmvc</artifactId>
  49.             	<version>${spring.version}</version>
  50.             </dependency>
  51.             <dependency>
  52.                 <groupId>org.mybatis</groupId>
  53.                 <artifactId>mybatis</artifactId>
  54.                 <version>${mybatis.version}</version>
  55.             </dependency>
  56.         </dependencies>
  57.     </dependencyManagement>
  59.     <dependencies>
  60.         <!-- Spring -->
  61.         <dependency>
  62.             <groupId>org.springframework</groupId>
  63.             <artifactId>spring-test</artifactId>
  64.         </dependency>
  65.         <dependency>
  66.             <groupId>org.springframework</groupId>
  67.             <artifactId>spring-context</artifactId>
  68.         </dependency>
  69.         <dependency>
  70.             <groupId>org.springframework</groupId>
  71.             <artifactId>spring-aspects</artifactId>
  72.         </dependency>
  73.         <dependency>
  74.             <groupId>org.springframework</groupId>
  75.             <artifactId>spring-orm</artifactId>
  76.         </dependency>
  77.         <dependency>
  78.             <groupId>org.springframework</groupId>
  79.             <artifactId>spring-web</artifactId>
  80.         </dependency>
  81.         <dependency>
  82.             <groupId>org.springframework</groupId>
  83.             <artifactId>spring-webmvc</artifactId>
  84.         </dependency>
  85.         <!-- mybatis -->
  86.         <dependency>
  87.             <groupId>org.mybatis</groupId>
  88.             <artifactId>mybatis</artifactId>
  89.         </dependency>
  90.         <dependency>
  91.             <groupId>org.mybatis</groupId>
  92.             <artifactId>mybatis-spring</artifactId>
  93.             <version>1.3.1</version>
  94.         </dependency>
  96.         <!-- mysql驱动 -->
  97.         <dependency>
  98.             <groupId>mysql</groupId>
  99.             <artifactId>mysql-connector-java</artifactId>
  100.             <version>5.1.6</version>
  101.             <scope>runtime</scope>
  102.         </dependency>
  104.         <!-- c3p0 -->
  105.         <dependency>
  106.             <groupId>c3p0</groupId>
  107.             <artifactId>c3p0</artifactId>
  108.             <version>0.9.1.2</version>
  109.         </dependency>
  110.         <!-- slf4j -->
  111.         <dependency>
  112.             <groupId>org.slf4j</groupId>
  113.             <artifactId>slf4j-log4j12</artifactId>
  114.             <version>1.7.2</version>
  115.         </dependency>
  116.         <!-- junit -->
  117.         <dependency>
  118.             <groupId>junit</groupId>
  119.             <artifactId>junit</artifactId>
  120.             <version>4.12</version>
  121.             <scope>test</scope>
  122.         </dependency>
  123.         <dependency>
  124.             <groupId>org.hamcrest</groupId>
  125.             <artifactId>hamcrest-library</artifactId>
  126.             <version>1.3</version>
  127.         </dependency>
  128.         <!-- jstl -->
  129.         <dependency>
  130.             <groupId>javax.servlet</groupId>
  131.             <artifactId>jstl</artifactId>
  132.             <version>1.2</version>
  133.         </dependency>
  135.         <!-- servlet jsp -->
  136.         <dependency>
  137.             <groupId>javax.servlet</groupId>
  138.             <artifactId>servlet-api</artifactId>
  139.             <version>2.5</version>
  140.             <scope>provided</scope>
  141.         </dependency>
  142.         <dependency>
  143.             <groupId>javax.servlet</groupId>
  144.             <artifactId>jsp-api</artifactId>
  145.             <version>2.0</version>
  146.             <scope>provided</scope>
  147.         </dependency>
  148.     </dependencies>
  150.     <build>
  151.         <plugins>
  152.             <plugin>
  153.                 <groupId>org.apache.maven.plugins</groupId>
  154.                 <artifactId>maven-compiler-plugin</artifactId>
  155.                 <configuration>
  156.                     <source>1.8</source>
  157.                     <target>1.8</target>
  158.                     <encoding>UTF-8</encoding>
  159.                 </configuration>
  160.             </plugin>
  161.         </plugins>
  163.         <finalName>ssm</finalName>
  164.     </build>
  167. </project>

2.3 配置service

加入spring。

2.3.1 web.xml

配置spring监听器，设置spring核心文件的位置。

  1. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2.     xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
  3.                       http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
  4.     version="3.1" metadata-complete="true">
  6.     <!-- applicationContext对象仅加载一次，在服务器器启动时加载 -->
  7.     <listener>
  8.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  9.     </listener>
  10.     <context-param>
  11.         <param-name>contextConfigLocation</param-name>
  12.         <param-value>classpath:applicationContext.xml</param-value>
  13.     </context-param>
  15. </web-app>

2.3.2 spring核心文件

依据上一步的设置，在classpath下新建applicationContext.xml

设置spring约束的文件头

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
  4.     xmlns:context="http://www.springframework.org/schema/context"
  5.     xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx"
  6.     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd  
  7.         http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd  
  8.         http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd  
  9.         http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd  
  10.         http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
  12. </beans>

  1. 开启注解功能，并设置扫描路径

    1. <!-- 1、开启注解、自动扫描 -->
    2. <context:annotation-config />
    4. <context:component-scan base-package="com.topvision.ssm">
    5. <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" />
    6. </context:component-scan>


    注意：
    在配置扫描路径时，要避免对Controller注解的扫描，目的是将该注解所标识的bean交给springmvc管理而不是spring管理。

  2. 加载属性文件，如数据库配置文件

    1. <!-- 2、加载properties -->
    2. <!-- <context:property-placeholder location="classpath:jdbc.properties"/> -->
    3. <bean id="propertyConfigurer"
    4.     class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    5.     <property name="locations">
    6.         <list>
    7.             <value>classpath:jdbc.properties</value>
    8.         </list>
    9.     </property>
    10. </bean>

    依上在classpath下新建jdbc.properties文件。

    1. s2sm.jdbc.driverClass  = com.mysql.jdbc.Driver
    2. s2sm.jdbc.url          = jdbc:mysql://localhost:3306/springdb
    3. s2sm.jdbc.username     = root
    4. s2sm.jdbc.password     = 123

  3. 设置数据源

    1. <!--3、 数据库C3P0 -->
    2. <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    3. <property name="driverClass" value="${s2sm.jdbc.driverClass}" />
    4. 	<property name="jdbcUrl" value="${s2sm.jdbc.url}" />
    5. <property name="user" value="${s2sm.jdbc.username}" />
    6. 	<property name="password" value="${s2sm.jdbc.password}" />
    8. <property name="initialPoolSize" value="${s2sm.cpool.initialPoolSize}" />
    9. 	<property name="minPoolSize" value="${s2sm.cpool.minPoolSize}" />
    10. <property name="maxPoolSize" value="${s2sm.cpool.maxPoolSize}" />
    11. 	<property name="acquireIncrement" value="${s2sm.cpool.acquireIncrement}" />
    12. <property name="maxIdleTime" value="${s2sm.cpool.maxIdleTime}" />
    13. 	<property name="acquireRetryAttempts" value="${s2sm.cpool.acquireRetryAttempts}" />
    14. <property name="acquireRetryDelay" value="${s2sm.cpool.acquireRetryDelay}" />
    15. </bean>

  4. 设置SqlSessionFactory

    1. <!-- 4、配置SqlSessionFactory对象 -->
    2. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    3. <!-- 注入数据库连接池 -->
    4. <property name="dataSource" ref="dataSource" />
    5. <!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
    6. <property name="configLocation" value="classpath:sqlMapConfig.xml" />
    7. <!-- 扫描entity包 使用别名 -->
    8. <property name="typeAliasesPackage" value="com.topvision.ssm.domain" />
    9. <!-- 扫描sql配置文件:mapper需要的xml文件 -->
    10. <!-- <property name="mapperLocations" value="classpath:mapper/*.xml" /> -->
    11. <property name="mapperLocations"
    12.     value="classpath*:com/topvision/ssm/dao/mapper/*.xml" />
    13. </bean>

  5. 扫描Dao层接口

    1. <!-- 5、配置扫描Dao接口包，动态实现Dao接口，注入到spring容器中 -->
    2. <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    3. <!-- 注入sqlSessionFactory -->
    4. <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    5. <!-- 给出需要扫描Dao接口包 -->
    6. <property name="basePackage" value="com.topvision.ssm.dao" />
    7. </bean>

  6. Spring事务

    1. <!-- 5、事务,开启注解事务 -->
    2. <tx:annotation-driven transaction-manager="transactionManager" />
    3. <!-- 事务管理器 -->
    4. <bean id="transactionManager"
    5. class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    6. <property name="dataSource" ref="dataSource"></property>
    7. </bean>

    2.4 配置Dao

    根据上面SqlSessionFactory的设置，在classpath下新建SqlMapConfig.xml。

    1. <?xml version="1.0" encoding="UTF-8" ?>
    2. <!DOCTYPE configuration
    3. PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4. "http://mybatis.org/dtd/mybatis-3-config.dtd">
    6. <configuration>
    8. </configuration>

2.5 整合Controller

2.5.1 配置springmvc前端控制器

  1. <servlet>
  2.     <servlet-name>springmvc</servlet-name>
  3.     <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  4.     <!--设置springmvc核心文件路径-->
  5.     <init-param>
  6.         <param-name>contextConfigLocation</param-name>
  7.         <param-value>classpath:spring-mvc.xml</param-value>
  8.     </init-param>
  9. </servlet>
  10. <servlet-mapping>
  11.     <servlet-name>springmvc</servlet-name>
  12.     <!--
  13.     *.action,*.do等，以其结尾的url交由springmvc管理
  14.     / 所有请求交由springmvc，但静态资源（css,js等）交由springmvc是不对的
  15.     /* 此种配置不正确，当请求为jsp页面时，springmvc无法解析
  16.     -->
  17.     <url-pattern>*.do</url-pattern>
  18. </servlet-mapping>

2.5.2 springmvc核心文件

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
  4.     xmlns:context="http://www.springframework.org/schema/context"
  5.     xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
  6.     xsi:schemaLocation="http://www.springframework.org/schema/beans 
  7.         http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 
  8.         http://www.springframework.org/schema/mvc 
  9.         http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd 
  10.         http://www.springframework.org/schema/context 
  11.         http://www.springframework.org/schema/context/spring-context-3.0.xsd 
  12.         http://www.springframework.org/schema/aop 
  13.         http://www.springframework.org/schema/aop/spring-aop-3.0.xsd 
  14.         http://www.springframework.org/schema/tx 
  15.         http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">
  18.     <!-- 可以扫描标记有@controller、@service、@repository、@component的bean -->
  19.     <context:component-scan base-package="com.topvision.ssm.controller">
  20.         <context:include-filter type="annotation"
  21.             expression="org.springframework.stereotype.Controller" />
  22.     </context:component-scan>
  24.     <!-- 注解的处理器映射器和适配器 -->
  25.     <!-- <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping"/> 
  26.         <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter" 
  27.         /> -->
  28.     <!-- 简写 -->
  29.     <mvc:annotation-driven />
  31.     <!-- ViewResolver -->
  32.     <bean
  33.         class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  34.         <property name="prefix" value="/WEB-INF/jsp/" />
  35.         <property name="suffix" value=".jsp" />
  36.     </bean>
  38.     <!--静态资源默认servlet配置 (1)加入对静态资源的处理：js,gif,png (2)允许使用"/"做整体映射 -->
  39.     <!-- <mvc:default-servlet-handler/> -->
  41. </beans>

2.5.3 开发Controller

  1. <!--该注解标识handler-->
  2. @Controller
  3. public class Controller1 {
  5.     @Autowired
  6.     private BookService bookService;
  8.     <!--该注解标识请求路径-->
  9.     @RequestMapping("/queryBook")
  10.     public ModelAndView getBookById() {
  12.         Book book = bookService.findById(1000l);
  13.         ModelAndView modelAndView = new ModelAndView();
  14.         modelAndView.addObject("book", book);
  15.         modelAndView.setViewName("bookDetail");
  16.         return modelAndView;
  17.     }
  19. }
添加新批注
在作者公开此批注前，只有你和作者可见。
回复批注