SpringMVC整合MyBatis

青旅半醒 2022-03-09 13:42 242阅读 0赞

使用IntelliJ IDEA 2017.3.4搭一下ssm（spring+springMVC+Mybatis）

### 一、项目结构 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R5cDE4MDU_size_16_color_FFFFFF_t_70][]

使用版本：

*  spring.version：4.3.5.RELEASE
 *  mybatis.version：3.4.1
 *  pagehelper.version：4.2.1
 *  springMVC.version：4.0.5.RELEASE

### 二、创建项目 ###

**1、pom.xml依赖文件**

<?xml version="1.0" encoding="UTF-8"?>
    
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.springmvc.mybatis.demo</groupId>
        <artifactId>springmvc-mybatis</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <name>springmvc-mybatis Maven Webapp</name>
        <url>http://www.example.com</url>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
            <spring.version>4.3.5.RELEASE</spring.version>
            <mybatis.version>3.4.1</mybatis.version>
            <mybatis-spring.version>1.3.1</mybatis-spring.version>
            <c3p0.version>0.9.5.2</c3p0.version>
            <jstl.version>1.2</jstl.version>
            <lombok.version>1.16.18</lombok.version>
            <pagehelper.version>4.2.1</pagehelper.version>
            <fastjson.version>1.2.41</fastjson.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>javax</groupId>
                <artifactId>javaee-api</artifactId>
                <version>6.0</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
            
            <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-classic</artifactId>
                <version>1.2.2</version>
            </dependency>
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>2.8.7</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.41</version>
                <scope>runtime</scope>
            </dependency>
            
            <dependency>
                <groupId>com.mchange</groupId>
                <artifactId>c3p0</artifactId>
                <version>${c3p0.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>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-web</artifactId>
                <version>4.0.5.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>4.0.5.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>${jstl.version}</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet.jsp.jstl</groupId>
                <artifactId>jstl-api</artifactId>
                <version>${jstl.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.glassfish.web</groupId>
                <artifactId>jstl-impl</artifactId>
                <version>${jstl.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>${lombok.version}</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>${fastjson.version}</version>
            </dependency>
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper</artifactId>
                <version>${pagehelper.version}</version>
            </dependency>
        </dependencies>
    
        <build>
            <finalName>springmvc-mybatis</finalName>
            <plugins>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                    </configuration>
                </plugin>
            </plugins>
        </build>
    </project>

**2、配置spring-mvc.xml**

**3、配置web.xml文件**

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
             version="3.1">
      <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
      </welcome-file-list>
    
      <display-name>springmvc-mybatis</display-name>
      <description>springmvc-mybatis_0.0.1</description>
    
      <filter>
        <filter-name>encodingFilter</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>
      </filter>
      <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
      </filter-mapping>
    
      <servlet>
        <servlet-name>SpringMVC</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:spring-*.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
        <async-supported>true</async-supported>
      </servlet>
      <servlet-mapping>
        <servlet-name>SpringMVC</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
    </web-app>

**4、配置spring-mybatis.xml文件**

<?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"
           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">
    
        
        <context:component-scan base-package="com.springmvc.mybatis.demo.service"/>
    
        
        <context:property-placeholder location="classpath:db.properties"/>
    
        
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="${jdbc.driver}"/>
            <property name="jdbcUrl" value="${jdbc.url}"/>
            <property name="user" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
            <property name="maxPoolSize" value="${c3p0.maxPoolSize}"/>
            <property name="minPoolSize" value="${c3p0.minPoolSize}"/>
            <property name="autoCommitOnClose" value="${c3p0.autoCommitOnClose}"/>
            <property name="checkoutTimeout" value="${c3p0.checkoutTimeout}"/>
            <property name="acquireRetryAttempts" value="${c3p0.acquireRetryAttempts}"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="typeAliasesPackage" value="com.springmvc.mybatis.demo.entity"/>
            
            <property name="mapperLocations" value="classpath: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>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
            
            <property name="basePackage" value="com.springmvc.mybatis.demo.mapper"/>
        </bean>
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        <tx:annotation-driven transaction-manager="transactionManager"/>
    </beans>

**5、数据库信息配置db.properties文件**

jdbc.driver=com.mysql.jdbc.Driver
    #数据库地址
    jdbc.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8
    #用户名
    jdbc.username=root
    #密码
    jdbc.password=admin
    #最大连接数
    c3p0.maxPoolSize=30
    #最小连接数
    c3p0.minPoolSize=10
    #关闭连接后不自动commit
    c3p0.autoCommitOnClose=false
    #获取连接超时时间
    c3p0.checkoutTimeout=10000
    #当获取连接失败重试次数
    c3p0.acquireRetryAttempts=2

**6、业务逻辑就不在这里赘述了**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R5cDE4MDU_size_16_color_FFFFFF_t_70 1][]

**7、数据库表**

![20190313112918212.png][]

所有整合完成，编写测试类进行测试。

### 三、测试 ###

**1、简单的根据id查询测试**

package com.springmvc.mybatis.demo.mapper;
    
    import com.alibaba.fastjson.JSON;
    import com.springmvc.mybatis.demo.entity.User;
    import lombok.extern.slf4j.Slf4j;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    
    /**
     * 路径：com.springmvc.mybatis.demo.mapper
     * 类名：
     * 功能：《用一句描述一下》
     * 备注：
     * 创建人：typ
     * 创建时间：2019/3/12 14:55
     * 修改人：
     * 修改备注：
     * 修改时间：
     */
    @Slf4j
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration({"classpath:spring-mybatis.xml"})
    public class UserMapperTest {
    
        @Autowired
        private UserMapper userMapper;
    
        @Test
        public void qryById() {
            // 1001、1002、1003
            User user = userMapper.qryById(1001);
            log.info("测试出参：{}", JSON.toJSON(user));
        }
    
    }

测试结果：

11:26:00.141 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.qryById - ==>  Preparing: SELECT id,username,password FROM user WHERE id = ? 
    11:26:00.187 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.qryById - ==> Parameters: 1001(Integer)
    11:26:00.205 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.qryById - <==      Total: 1
    11:26:00.210 [main] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4e07b95f]
    11:26:00.324 [main] INFO com.springmvc.mybatis.demo.mapper.UserMapperTest - 测试出参：{"password":"123456","id":1001,"username":"zhangsan"}

**2、分页测试：**

package com.springmvc.mybatis.demo.controller;
    
    import com.alibaba.fastjson.JSON;
    import com.github.pagehelper.PageInfo;
    import com.springmvc.mybatis.demo.entity.User;
    import com.springmvc.mybatis.demo.service.UserService;
    import lombok.extern.slf4j.Slf4j;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    
    /**
     * 路径：com.springmvc.mybatis.demo.controller
     * 类名：
     * 功能：《用一句描述一下》
     * 备注：
     * 创建人：typ
     * 创建时间：2019/3/13 10:10
     * 修改人：
     * 修改备注：
     * 修改时间：
     */
    @Slf4j
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration({"classpath:spring-mybatis.xml"})
    public class UserControllerTest {
    
        @Autowired
        private UserService userService;
    
        @Test
        public void pageList(){
            PageInfo<User> pageList = userService.pageList(1,1);
            log.info("测试出参：{}", JSON.toJSON(pageList));
        }
    }

测试结果：

11:27:35.273 [main] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@3e6f3f28 [wrapping: com.mysql.jdbc.JDBC4Connection@7e19ebf0]] will not be managed by Spring
    11:27:35.288 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.list_COUNT - ==>  Preparing: SELECT count(0) FROM user 
    11:27:35.338 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.list_COUNT - ==> Parameters: 
    11:27:35.359 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.list_COUNT - <==      Total: 1
    11:27:35.365 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.list - ==>  Preparing: SELECT id,username,password FROM user limit ?,? 
    11:27:35.366 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.list - ==> Parameters: 0(Integer), 1(Integer)
    11:27:35.367 [main] DEBUG com.springmvc.mybatis.demo.mapper.UserMapper.list - <==      Total: 1
    11:27:35.368 [main] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6736fa8d]
    11:27:35.501 [main] INFO com.springmvc.mybatis.demo.controller.UserControllerTest - 测试出参：{"lastPage":3,"navigatepageNums":[1,2,3],"startRow":1,"hasNextPage":true,"prePage":0,"nextPage":2,"endRow":1,"pageSize":1,"list":[{"password":"123456","id":1001,"username":"zhangsan"}],"pageNum":1,"navigatePages":8,"navigateFirstPage":1,"total":3,"pages":3,"firstPage":1,"size":1,"isLastPage":false,"hasPreviousPage":false,"navigateLastPage":3,"isFirstPage":true}

**3、JSP页面测试（这里只是简单的测试）**

main.jsp页面：

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
    <html>
    <body>
    <table border="1" width="80%">
        <tr>
            <th>ID</th>
            <th>用户名</th>
            <th>用户密码</th>
            <th>操作</th>
        </tr>
        <c:forEach var="entity" items="${userList}">
            <tr>
                <th>${entity.id}</th>
                <td>${entity.username}</td>
                <td>${entity.password}</td>
                <td>
                    <a href="edit/${entity.id}">编辑 | </a>
                    <a href="deleteUserById/${entity.id}">删除</a>
                </td>
            </tr>
        </c:forEach>
    </table>
    </body>
    </html>

用tomcat启动：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R5cDE4MDU_size_16_color_FFFFFF_t_70 2][]

浏览器请求：[http://localhost:8080/user/main][http_localhost_8080_user_main]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R5cDE4MDU_size_16_color_FFFFFF_t_70 3][]

**源码下载：**[https://download.csdn.net/download/typ1805/11015947][https_download.csdn.net_download_typ1805_11015947]

友情提示：没有积分的可以留言，直接发你源码哦！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R5cDE4MDU_size_16_color_FFFFFF_t_70]: /images/20220309/817fee5f8e4445c9b336102d5197d564.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R5cDE4MDU_size_16_color_FFFFFF_t_70 1]: /images/20220309/f76f2c29414a4a53bcf4d74ee07194fb.png
[20190313112918212.png]: /images/20220309/165fe495bcbb4581912cdb0492fb1436.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R5cDE4MDU_size_16_color_FFFFFF_t_70 2]: /images/20220309/678b281c415a44098bcca4f762282b93.png
[http_localhost_8080_user_main]: http://localhost:8080/user/main
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3R5cDE4MDU_size_16_color_FFFFFF_t_70 3]: /images/20220309/eb50c9e37c1c48ae9638fc46e22a3d64.png
[https_download.csdn.net_download_typ1805_11015947]: https://download.csdn.net/download/typ1805/11015947