mybatis详解-(23)spring整合

╰+攻爆jí腚メ 2022-06-03 09:26 160阅读 0赞

Spring是一个开放源代码的设计层面框架，他解决的是业务逻辑层和其他各层的松耦合问题，因此它将面向接口的编程思想贯穿整个系统应用。Spring是于2003 年兴起的一个轻量级的Java 开发框架，由Rod Johnson创建。简单来说，Spring是一个分层的JavaSE/EEfull-stack(一站式) 轻量级开源框架。  
本篇还是以示例的形式介绍一下spring是如何整合mybatis。

# 1.使用maven构建web项目 #

![这里写图片描述][SouthEast]

pom.xml文件配置

<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>org.mybatis</groupId>
      <artifactId>mybatis-study-02</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <packaging>jar</packaging>
    
      <name>mybatis-study-02</name>
      <url>http://maven.apache.org</url>
    
      <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <spring4.version>4.2.4.RELEASE</spring4.version>
      </properties>
    
      <dependencies>
        
        <dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>4.12</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.1</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-ehcache</artifactId>
          <version>1.0.0</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.2.0</version>
        </dependency>
    
        
        <dependency>
            <groupId>net.sf.ehcache</groupId>
            <artifactId>ehcache-core</artifactId>
            <version>2.6.10</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>4.2.4.RELEASE</version>
            
            <exclusions>
                <exclusion>
                    <groupId>commons-logging</groupId>
                    <artifactId>commons-logging</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-expression</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>4.2.4.RELEASE</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.7.12</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.6</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>commons-logging</groupId>
            <artifactId>commons-logging</artifactId>
            <version>1.2</version>
        </dependency>
    
        
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.35</version>
        </dependency>
    
        
        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.1</version>
        </dependency>
    
        
        <dependency>    
            <groupId>javax.servlet</groupId>    
            <artifactId>servlet-api</artifactId>    
            <version>2.5</version>    
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
    
        
    
        
        
      </dependencies>
    </project>

# 2.mybatis主配置文件 #

mybatis-config.xml  
使用了spring之后，mybatis主配置文件配置较少了。具体存放位置看上图的整个工程架构。

<?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>
    
        
    
        <settings>
            <setting name="mapUnderscoreToCamelCase" value="true"/>
        </settings>
    
        
    
    </configuration>

# 3.mybatis映射配置文件 #

按照业务区分开。具体存放位置看上图的整个工程架构。  
这里只展示一个文件的简单配置：

<?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="org.mybatis.dao.SysuserMapper">
    
        
        <select id="getEmployeeById" resultType="org.mybatis.bean.Employee">
            select * from mybatis_employee where id = #{id}
        </select>
    
        
        
        
        <select id="getEmployeeByIdAndLastName" resultType="org.mybatis.bean.Employee">
            select * from mybatis_employee where id = #{id} and last_name = #{lastName}
        </select>
    
    
        <select id="getEmployeeByEmployeeField" resultType="org.mybatis.bean.Employee">
            select * from mybatis_employee where id = #{id} and last_name = #{lastName}
        </select>
    
    
        <select id="getEmployeeByMap" resultType="org.mybatis.bean.Employee">
            select * from mybatis_employee where id = #{id} and last_name = #{lastName}
        </select>
    
        
        <insert id="addEmployee" parameterType="org.mybatis.bean.Employee" useGeneratedKeys="true" keyProperty="id">
            insert into mybatis_employee 
            (last_name,email,gender) 
            values 
            (#{lastName},#{email},#{gender});
        </insert>
    
        
        <insert id="addEmployeeo">
            
            <selectKey keyProperty="id" order="BEFORE" resultType="Integer">
                select employees_seq from dual;
            </selectKey>
    
            insert into mybatis_employee 
            (id,last_name,email,gender) 
            values 
            (#{id},#{lastName},#{email},#{gender});
        </insert>
    
        
        <update id="updateEmployee">
            update mybatis_employee
            set
            last_name = #{lastName},
            email = #{email},
            gender = #{gender}
            where 
            id = #{id}
        </update>
    
        
        <delete id="deleteEmployee">
            delete from mybatis_employee where id = #{id}
        </delete>
    
    </mapper>

# 4.spring配置文件 #

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" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring" xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd 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-4.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd">
    
        
        <context:component-scan base-package="org.mybatis">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
    
        
    
        
        <context:property-placeholder location="classpath:db.properties"/>
    
        
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="jdbcUrl" value="${mysql.url}"></property>
            <property name="driverClass" value="${mysql.driver}"></property>
            <property name="user" value="${mysql.username}"></property>
            <property name="password" value="${mysql.password}"></property>
        </bean>
    
        
        <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"></property>
        </bean>
    
        
        <tx:annotation-driven transaction-manager="dataSourceTransactionManager"/>
    
        
         <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"></property>
            
            <property name="configLocation" value="classpath:mybatis-config.xml"></property>
            
            <property name="mapperLocations" value="classpath:mapper/*/*.xml"></property>
         </bean>
    
        
        <mybatis-spring:scan base-package="org.mybatis.dao"/>
        
    </beans>

# 5.spring-mvc配置文件 #

spring-mvc.xml  
视图解析器没什么好解释的，按照固定格式配置就行了。  
包扫描，因为spring-mvc只负责v层的页面控制，所以只扫描所有的controller就足够了。

# 6.配置web.xml #

引入spring和spring-mvc的配置文件，编码过滤

<?xml version="1.1" encoding="UTF-8"?>
    <web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
    
        <display-name>Archetype Created Web Application</display-name>
    
        
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:applicationContext.xml</param-value>
        </context-param>
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
    
        
        <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-mvc.xml</param-value>
            </init-param>
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>springmvc</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
    
         <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>
            <init-param>
                <param-name>forceEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>encodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
    </web-app>

# 7.创建页面 #

这里使用欢迎页index.jsp，跳转页面WEB-INF/pages/loginsuccess.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>主页</title>
    </head>
    <body>
        <h1>Index Page</h1>
    
        
        <a href="sysuser/login">welcome</a>
        <br><br>
    
    </body>
    </html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>login</title>
    </head>
    <body>
    login success
    </body>
    </html>

# 8.创建controller层 #

package org.mybatis.controller;
    
    import org.mybatis.service.SysuserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    
    @Controller
    @RequestMapping("/sysuser")
    public class SysUserController { 
    
        @Autowired
        private SysuserService sysuserService;
    
        @RequestMapping(value="/login",method=RequestMethod.GET)
        private String sysuserlogin(){
            Integer userId = 2;
            String loginStatus = sysuserService.login(userId);
            System.out.println(loginStatus);
            return "loginsuccess";
        }
    }

# 9.创建service层 #

package org.mybatis.service;
    
    public interface SysuserService { 
    
        public String login(Integer userId);
    }

package org.mybatis.service;
    
    import org.mybatis.bean.Employee;
    import org.mybatis.dao.SysuserMapper;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    @Service("sysuserService")
    public class SysuserServiceImpl implements SysuserService{ 
    
        @Autowired
        private SysuserMapper sysuserMapper;
    
        public String login(Integer userId) {
            Employee emp = sysuserMapper.getEmployeeById(userId);
            System.out.println(emp);
            return "loginsuccess";
        }
    
    }

# 10.创建mapper接口 #

package org.mybatis.dao;
    
    import java.util.Map;
    
    import org.apache.ibatis.annotations.Param;
    import org.mybatis.bean.Employee;
    import org.springframework.stereotype.Repository;
    
    @Repository("sysuserMapper")
    public interface SysuserMapper { 
    
        public Employee getEmployeeById(int id);
    
    }

# 11.测试 #

![这里写图片描述][SouthEast 1]

跳转结果

![这里写图片描述][SouthEast 2]

打印结果

> DEBUG - DispatcherServlet with name ‘springmvc’ processing GET request for \[/mybatis-study-02/sysuser/login\]  
> DEBUG - Looking up handler method for path /sysuser/login  
> DEBUG - Returning handler method \[private java.lang.String org.mybatis.controller.SysUserController.sysuserlogin()\]  
> DEBUG - Returning cached instance of singleton bean ‘sysUserController’  
> DEBUG - Last-Modified value for \[/mybatis-study-02/sysuser/login\] is: -1  
> DEBUG - Creating a new SqlSession  
> DEBUG - SqlSession \[org.apache.ibatis.session.defaults.DefaultSqlSession@6edbe1dd\] was not registered for synchronization because synchronization is not active  
> DEBUG - Fetching JDBC Connection from DataSource  
> DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@74e22cc5 \[managed: 3, unused: 2, excluded: 0\] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@7f446405)  
> DEBUG - JDBC Connection \[com.mchange.v2.c3p0.impl.NewProxyConnection@66803b47\] will not be managed by Spring  
> DEBUG - ooo Using Connection \[com.mchange.v2.c3p0.impl.NewProxyConnection@66803b47\]  
> DEBUG - ==> Preparing: select \* from mybatis\_employee where id = ?  
> DEBUG - ==> Parameters: 2(Integer)  
> DEBUG - Closing non transactional SqlSession \[org.apache.ibatis.session.defaults.DefaultSqlSession@6edbe1dd\]  
> DEBUG - Returning JDBC Connection to DataSource  
> DEBUG - trace com.mchange.v2.resourcepool.BasicResourcePool@74e22cc5 \[managed: 3, unused: 2, excluded: 0\] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@7f446405)  
> Employee \[id=2, lastName=lisi, email=tang\_greatman@qq.com, gender=1\]  
> loginsuccess  
> DEBUG - Invoking afterPropertiesSet() on bean with name ‘loginsuccess’  
> DEBUG - Rendering view \[org.springframework.web.servlet.view.JstlView: name ‘loginsuccess’; URL \[/WEB-INF/pages/loginsuccess.jsp\]\] in DispatcherServlet with name ‘springmvc’  
> DEBUG - Forwarding to resource \[/WEB-INF/pages/loginsuccess.jsp\] in InternalResourceView ‘loginsuccess’  
> DEBUG - Successfully completed request  
> DEBUG - Returning cached instance of singleton bean ‘sqlSessionFactoryBean’

本文是在前面系列文章的基础之上实现的，如果对mybatis的一些基本使用不会的，建议先参考前面的mybatis详解-(1)到mybatis详解-(22)系列文章。实现都是手把手搭建和测试的。

到此mybatis的使用就介绍完了。

后续还会写一些什么内容呢？敬请期待….

[SouthEast]: /images/20220603/1b3315b07bd3422a8124781e90dbd5c2.png
[SouthEast 1]: /images/20220603/ad61270fce9341cdaf5b302511c82470.png
[SouthEast 2]: /images/20220603/2397885a9299468bbcbc64ca9df432e3.png