03_springmvc整合mybatis

本是古典何须时尚 2024-04-18 22:34 3阅读 0赞

### 一.整合思路 ###

**springmvc+mybaits的系统架构：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2phdHBlbg_size_16_color_FFFFFF_t_70][]

**第一步整合dao层：**mybatis和spring整合：通过spring管理mapper接口，使用mapper的扫描器自动扫描mapper接口在spring中注册。

**第二步整合service层：**通过spring管理service接口，通过配置方式将service接口配置在spring配置文件中，实现事务控制。注意：事务控制一般在service层。

**第三步整合springmvc：**由于springmvc是spring的模块，不需要配置。

## 二 .环境准备 ##

mysql5.1、jdk1.8、idea、

**所需要的jar包：**

数据库驱动包、mybatis的jar、spring整合mybatis的jar、log4j、dbcp数据库连接池包、spring4.2的jar包、

### 三.整合dao（mapper） ###

**1.配置sqlMapConfig.xml**

<?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>
        
      
        
        <typeAliases>
            
            
            
            <package name="com.ssm.po"></package>
        </typeAliases>
        
        
    
        
            
            
            
            
           
        
    </configuration>

**2.applicationContext-dao.xml**

配置数据源、事务管理、配置SqlSessionFactory、mapper扫描器、

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	   xmlns="http://www.springframework.org/schema/beans"
    	   xmlns:context="http://www.springframework.org/schema/context"
    	   xmlns:aop="http://www.springframework.org/schema/aop"
    	   xmlns:tx="http://www.springframework.org/schema/tx"
    	   xsi:schemaLocation="http://www.springframework.org/schema/context
    	   http://www.springframework.org/schema/context/spring-context-4.2.xsd
    	   http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
    	   http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd
    	   http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd ">
    	
    	<context:property-placeholder location="classpath:config/db.properties"></context:property-placeholder>
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="driverClassName" value="${jdbc.driver}"></property>
    		<property name="url" value="${jdbc.url}"></property>
    		<property name="username" value="${jdbc.username}"></property>
    		<property name="password" value="${jdbc.password}"></property>
    		<property name="maxActive" value="10"></property>
    		<property name="maxIdle" value="5"></property>
    	</bean>
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="configLocation" value="classpath:config/mybatis/sqlMapConfig.xml"></property>
    		
    		<property name="dataSource" ref="dataSource"></property>
    	</bean>
    
    	
    	
    		
    	
    
    	
    	
    		
    		
    		
    	
    	
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="basePackage" value="com.ssm.mapper"></property>
    		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    	</bean>
    	
    	
    		
    		
    		
    	
    </beans>

**3.逆向工程生成po类和mapper（单表进行增删改查）**

![20190912201243554.png][]

**4.自定义mapper，配置mapper.xml和mapper.java**

针对综合查询mapper，一般情况会有关联查询，建议自定义mapper

ItemsMapperCustom.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="com.ssm.mapper.ItemsMapperCustom" >
      
      
      <sql id="queryItemsWhere">
        <if test="itemsCustom!=null">
            <if test="itemsCustom.name!=null and itemsCustom.name!=''">
              items.name like '%${itemsCustom.name}%'
            </if>
        </if>
      </sql>
    
      <select id="findItemsList" parameterType="com.ssm.po.ItemsQueryVo" resultType="com.ssm.po.ItemsCustom">
            select * from items
            <where>
              <include refid="queryItemsWhere"/>
            </where>
      </select>
    </mapper>

ItemsMapperCustom.java

## 四.整合service ##

**作用：**1.service由spring管理

2.spring对service进行事务管理

**1.定义service接口**

package com.ssm.service;
    
    import com.ssm.po.ItemsCustom;
    import com.ssm.po.ItemsQueryVo;
    
    import java.util.List;
    
    /**
     * Description:ItemsService
     * User: jiatp
     * Date:2019/9/7 0007 下午 5:22
    */
    
    public interface ItemsService {
        //商品查询
        public List<ItemsCustom> findItemsList(ItemsQueryVo itemsQueryVo)throws Exception;
    
        //根据id查询商品信息
        public ItemsCustom findItemsById(int id)throws Exception;
    
        //根据id修改商品信息
        public void updateItems(Integer id,ItemsCustom itemsCustom)throws Exception;
        //根据id删除商品信息
        public void deleteItems(Integer[] ids)throws Exception;
    
    
    }

ItemsServiceImpl.java

package com.ssm.service;
    
    import com.ssm.exception.CustomException;
    import com.ssm.mapper.ItemsMapper;
    import com.ssm.mapper.ItemsMapperCustom;
    import com.ssm.po.Items;
    import com.ssm.po.ItemsCustom;
    import com.ssm.po.ItemsQueryVo;
    import org.junit.Before;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.BeanUtils;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import javax.annotation.Resource;
    import java.util.List;
    
    /**
     * Description:
     * User: jiatp
     * Date:2019/9/7 0007 下午 5:25
    */
    public class ItemsServiceImpl implements ItemsService {
        @Autowired
        private ItemsMapperCustom itemsMapperCustom;
        @Autowired
        private ItemsMapper itemsMapper;
    
        @Override
        public List<ItemsCustom> findItemsList(ItemsQueryVo itemsQueryVo) throws Exception {
            //直接调用方法
            List<ItemsCustom> itemsList = itemsMapperCustom.findItemsList(itemsQueryVo);
            return itemsList;
        }
    
        @Override
        public ItemsCustom findItemsById(int id) throws Exception {
            Items items = itemsMapper.selectByPrimaryKey(id);
            if(items==null){
                throw new CustomException("修改商品信息不存在！--sevice");
            }
            //中间会进行业务处理。。。
    
            //返回的是itemsCustom
            ItemsCustom itemsCustom = null;
            if(items!=null){
                itemsCustom = new ItemsCustom();
                //将items内容拷贝到itemsCustom
                BeanUtils.copyProperties(items,itemsCustom);
            }
            return itemsCustom;
        }
    
        @Override
        public void updateItems(Integer id, ItemsCustom itemsCustom) throws Exception {
            //添加一些业务校验，通常在service中对关键参数进行校验
            //校验id是否为空，如果为空则抛出异常
            //更新商品信息  根据id更新items中所有字段，包括大文本
            itemsCustom.setId(id);
            itemsMapper.updateByPrimaryKeyWithBLOBs(itemsCustom);
        }
    
        @Override
        public void deleteItems(Integer[] ids) throws Exception {
            //这里进行删除
            if(ids!=null){
            //循环删除
                for(Integer id:ids) {
                    itemsMapper.deleteByPrimaryKey(id);
                }
            }
        }
    }

**2.在spring中配置service接口（applicationContext-service.xml**)

创建applicationContext-service.xml，文件中配置service

**事务控制：applicationContext-transaction.xml**

## 五.整合springmvc ##

创建springmvc.xml文件，配置处理器映射器、适配器、视图解析器。

**1.创建springmvc.xml文件**

**2.配置前端控制器**

<?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">
        
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>/WEB-INF/classes/spring/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:config/spring/springmvc.xml</param-value>
            </init-param>
        </servlet>
        
        
        
        
        
        <servlet-mapping>
            <servlet-name>springmvc</servlet-name>
            <url-pattern>*.action</url-pattern>
    
        </servlet-mapping>
    </web-app>

**3.编写controller**

package com.ssm.controller;
    
    import com.ssm.exception.CustomException;
    import com.ssm.po.ItemsCustom;
    import com.ssm.po.ItemsQueryVo;
    import com.ssm.service.ItemsService;
    import com.ssm.validation.ValidGroup1;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.http.HttpRequest;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.validation.BindingResult;
    import org.springframework.validation.ObjectError;
    import org.springframework.validation.annotation.Validated;
    import org.springframework.web.bind.annotation.*;
    import org.springframework.web.multipart.MultipartFile;
    import org.springframework.web.servlet.ModelAndView;
    
    import javax.annotation.Resource;
    import javax.servlet.annotation.MultipartConfig;
    import javax.servlet.http.HttpServletRequest;
    import java.io.File;
    import java.util.*;
    
    /**
     * Description:
     * User: jiatp
     * Date:2019/9/7 0007 下午 8:40
    */
    
    @Controller
    @RequestMapping("/items")
    public class ItemsController {
    
        @Autowired
        private ItemsService itemsService;
    
        //商品信息查询
        @RequestMapping("/queryItems")
        public ModelAndView queryItems(HttpServletRequest request, ItemsQueryVo itemsQueryVo) throws Exception{
            String id = request.getParameter("id");
            System.out.println(id);
            //调用service查找数据库，查询商品列表，这里使用静态模拟
            List<ItemsCustom> itemsList = itemsService.findItemsList(itemsQueryVo);
    
            //返回ModelAndView
            ModelAndView modelAndView = new ModelAndView();
    
            modelAndView.addObject("itemsList",itemsList);//相当于request.setAtttributes
            modelAndView.setViewName("items/itemsList");//指定返回的视图
            return modelAndView;
        }
    ｝

**4.编写jsp**

将从数据库中的数据查询出来，显示在页面。

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt"  prefix="fmt"%>
    <!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>
    当前用户：${username}
    <c:if test="${username!=null}">
    
    	<a href="${pageContext.request.contextPath}/logout.action" >退出</a>
    </c:if>
    <form name="itemsForm" action="${pageContext.request.contextPath}/items/queryItems.action" method="post">
    查询条件：
    <table width="100%" border=1>
    <tr>
    <td>商品名称：<input name="itemsCustom.name"/>
    	商品类型：
    	<select name="itemtype">
    		<c:forEach items="${itemtypes }" var="itemtype">
    			<option value="${itemtype.key }">${itemtype.value }</option>
    		</c:forEach>
    	</select>
    
    </td>
    	<td><input type="button" value="查询" onclick="queryItems()"/></td>
    </tr>
    </table>
    商品列表：
    <table width="100%" border=1>
    <tr>
    	<td>选择</td>
    	<td>商品名称</td>
    	<td>商品价格</td>
    	<td>生产日期</td>
    	<td>商品描述</td>
    	<td>操作</td>
    </tr>
    <c:forEach items="${itemsList }" var="item">
    <tr>
    	<td><input type="checkbox" name="items_id" value="${item.id}"/></td>
    	<td>${item.name }</td>
    	<td>${item.price }</td>
    	<td><fmt:formatDate value="${item.createtime}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
    	<td>${item.detail }</td>
    	<td><a href="${pageContext.request.contextPath }/items/editItems.action?id=${item.id}">修改</a></td>
    </tr>
    </c:forEach>
    
    </table>
    </form>
    </body>
    
    </html>

**5.加载spring容器**

将mapper、service、controller加载到spring容器中。

![20190912204355483.png][]

建议使用通配符加载上边的配置文件。在web.xml中，添加spring容器监听器，加载spring容器。

![20190912204500388.png][]

测试：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2phdHBlbg_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2phdHBlbg_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/a83789a03beb4b28b874e8099c6e84f7.png
[20190912201243554.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/b1b4cd3447294a8589620e7bf8607365.png
[20190912204355483.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/d4d88caa03554a2790c5363bfcee8ff6.png
[20190912204500388.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/17e4d0b46c1e4984a587fc00965a2140.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2phdHBlbg_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/407f9b893c2f4bcba46c329ce402b57d.png