Spring + SpringMVC整合MyBatis

Dear 丶 2022-05-13 09:54 226阅读 0赞

在上一篇文章[IDEA使用maven搭建Spring + SpringMVC环境][IDEA_maven_Spring _ SpringMVC]的基础上，我们再将MyBatis框架整合进去，这样就可以搭建一个完整的SSM环境了。

1.在pom.xml中添加mysql，jdcb，mybatis依赖并导入依赖，所有依赖如下：

<properties>
          <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
          <maven.compiler.source>1.7</maven.compiler.source>
          <maven.compiler.target>1.7</maven.compiler.target>
          <springVersion>4.2.6.RELEASE</springVersion>
          <mysqlVersion>5.1.38</mysqlVersion>
          <c3p0Version>0.9.1.2</c3p0Version>
          <myBatisVersion>3.4.1</myBatisVersion>
    </properties>
    
    <dependencies>
    
          
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-core</artifactId>
              <version>${springVersion}</version>
          </dependency>
    
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-beans</artifactId>
              <version>${springVersion}</version>
          </dependency>
    
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-context</artifactId>
              <version>${springVersion}</version>
          </dependency>
    
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-aop</artifactId>
              <version>${springVersion}</version>
          </dependency>
    
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-tx</artifactId>
              <version>${springVersion}</version>
          </dependency>
    
          
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-web</artifactId>
              <version>${springVersion}</version>
          </dependency>
    
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-webmvc</artifactId>
              <version>${springVersion}</version>
          </dependency>
    
          
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-jdbc</artifactId>
              <version>${springVersion}</version>
          </dependency>
    
          
          <dependency>
              <groupId>mysql</groupId>
              <artifactId>mysql-connector-java</artifactId>
              <version>${mysqlVersion}</version>
              <scope>runtime</scope>
          </dependency>
    
          
          <dependency>
              <groupId>org.mybatis</groupId>
              <artifactId>mybatis</artifactId>
              <version>${myBatisVersion}</version>
          </dependency>
    
          <dependency>
              <groupId>org.mybatis</groupId>
              <artifactId>mybatis-spring</artifactId>
              <version>1.3.0</version>
          </dependency>
    
          
          <dependency>
              <groupId>c3p0</groupId>
              <artifactId>c3p0</artifactId>
              <version>${c3p0Version}</version>
          </dependency>
    
          
          <dependency>
              <groupId>junit</groupId>
              <artifactId>junit</artifactId>
              <version>4.11</version>
              <scope>test</scope>
          </dependency>
    
         
          <dependency>
              <groupId>org.springframework</groupId>
              <artifactId>spring-test</artifactId>
              <version>${springVersion}</version>
              <scope>test</scope>
          </dependency>
          
      </dependencies>

2.在数据库中添加Book数据表，并填充数据，sql语句如下：

DROP TABLE IF EXISTS `book`;
    CREATE TABLE `book` (
      `book_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '图书ID',
      `name` varchar(100) NOT NULL COMMENT '图书名称',
      `number` int(11) NOT NULL COMMENT '馆藏数量',
      PRIMARY KEY (`book_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=1004 DEFAULT CHARSET=utf8 COMMENT='图书表';
    
    #
    # Data for table "book"
    #
    
    INSERT INTO `book` VALUES (1000,'Java程序设计',9),(1001,'数据结构',7),(1002,'设计模式',7),(1003,'编译原理',9);

3.创建pojo文件夹并新建Book.java类

package pojo;
    
    /**
     * Created By Seven.wk
     * Description: Book对象
     * Created At 2018/09/13
     */
    public class Book {
    
        private int bookId;// 图书ID
    
        private String name;// 图书名称
    
        private int number;// 馆藏数量
    
        public Book() {
        }
    
        public int getBookId() {
            return bookId;
        }
    
        public void setBookId(int bookId) {
            this.bookId = bookId;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public int getNumber() {
            return number;
        }
    
        public void setNumber(int number) {
            this.number = number;
        }
    
        @Override
        public String toString() {
            return "Book{" +
                    "bookId=" + bookId +
                    ", name='" + name + '\'' +
                    ", number=" + number +
                    '}';
        }
    }

4.创建dao层文件夹并创建dao层接口

package dao;
    
    import org.apache.ibatis.annotations.Param;
    import pojo.Book;
    
    import java.util.List;
    
    /**
     * Created By Seven.wk
     * Description: dao层接口
     * Created At 2018/09/13
     */
    public interface BookMapper {
        /**
         * 通过ID查询单本图书
         *
         * @param bookId
         * @return
         */
        Book queryById(int bookId);
    
        /**
         * 查询所有图书
         *
         * @param offset 查询起始位置
         * @param limit 查询条数
         * @return
         */
        List<Book> queryAll(@Param("offset") int offset, @Param("limit") int limit);
    
        /**
         * 减少馆藏数量
         *
         * @param bookId
         * @return 如果影响行数等于>1，表示更新的记录行数
         */
        int reduceNumber(int bookId);
    }

5.在resources文件夹下新建mappers文件夹并存放dao层映射文件

6.新建BookMapper.xml映射文件

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
            PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="dao.BookMapper">
        <resultMap id="BaseResultMap" type="pojo.Book">
            <id column="book_id" property="bookId" jdbcType="BIGINT"/>
            <result column="name" property="name" jdbcType="VARCHAR"/>
            <result column="number" property="number" jdbcType="INTEGER"/>
        </resultMap>
    
        <sql id="Base_Column_List">
            book_id, name, number
        </sql>
    
        <select id="queryById" parameterType="INTEGER" resultMap="BaseResultMap">
            select
            <include refid="Base_Column_List"/>
            from book
            where book_id = #{id}
        </select>
    
        <select id="queryAll" parameterType="Map" resultMap="BaseResultMap">
            select
            <include refid="Base_Column_List"/>
            from book
            limit #{limit}
            offset #{offset}
        </select>
    
        <update id="reduceNumber" parameterType="INTEGER">
            update book
            set number = number - 1
            where
            book_id = #{bookId}
        </update>
    
    </mapper>

7.在resources文件夹下新建jdbc文件夹，存放jdbc.properties作为数据库的配置文件

jdbc.properties

jdbc.driver = com.mysql.jdbc.Driver
    jdbc.url = jdbc:mysql://localhost:3306/servlet?useUnicode=true&characterEncoding=utf8
    jdbc.username = root
    jdbc.password = root

8.在applicationContext.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"
           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">
    
        
        <context:component-scan base-package="service"/>
    
        
        <context:property-placeholder location="classpath:jdbc/jdbc.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="30"/>
            <property name="minPoolSize" value="10"/>
            
            <property name="autoCommitOnClose" value="false"/>
            
            <property name="checkoutTimeout" value="10000"/>
            
            <property name="acquireRetryAttempts" value="2"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="typeAliasesPackage" value="pojo"/>
            
            <property name="mapperLocations" value="classpath:mappers/*.xml"/>
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
            
            <property name="basePackage" value="dao"/>
        </bean>
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
    </beans>

至此，前面没有问题的话，一个ssm环境就简单的整合完成了！下面我们搭建测试环境测试dao层接口

9.在pom.xml引入测试的依赖

<dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${springVersion}</version>
        <scope>test</scope>
    </dependency>

10.新建BookMapper.java 的测试类BookMapperTest.java，并添加上下文，代码如下：

package dao;
    
    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;
    import pojo.Book;
    
    import java.util.List;
    
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration({"classpath:spring/applicationContext.xml"})
    public class BookMapperTest {
    
        @Autowired
        private BookMapper bookMapper;
    
        @Test
        public void queryById() {
            int id = 1003;
            Book book = bookMapper.queryById(id);
            System.out.println(book.toString());
        }
    
        @Test
        public void queryAll() {
            List<Book> bookList = bookMapper.queryAll(1, 3);
            for(Book book : bookList)
                System.out.println(book);
        }
    
        @Test
        public void reduceNumber() {
            int result = bookMapper.reduceNumber(1000);
            System.out.println(result);
        }
    
    }

11.进行测试，测试通过，则环境整合完成！

![70][]

12.项目整体的目录结构如下：

![70 1][]

[IDEA_maven_Spring _ SpringMVC]: https://blog.csdn.net/zai_xia/article/details/82526337
[70]: /images/20220513/2f54bb46d68f48e6b2eb8568bc41379a.png
[70 1]: /images/20220513/fcefe4c5d67242eda52674d0b8f20fab.png