翠花，上快餐：SSM整合案例详解

今天的文章威哥给大家上个快餐，啥意思，快餐就一定要快，快速搞定SSM整合案例，一步一步手把手撸各个细节，有小伙伴会说，SSM整合还挺麻烦的，为什么不直接用SpringBoot呢，威哥想说，没有经历风雨，怎能体会生活的美好，怎能深刻理解SpringBoot带来便利的背后原因，所以，SSM的原生整合，对于Java程序员来说，必须了解，好了，开干。

数据库创建

为了测试案例，先需要创建一个数据库表：

CREATE TABLE productTab(
	id int PRIMARY KEY auto_increment,
	product_id VARCHAR(200) NOT NULL,
	product_name VARCHAR(200) NOT NULL,
	product_price FLOAT(10,2) NOT NULL,
	product_desc VARCHAR(200) NOT NULL
)

INSERT INTO productTab(product_id,product_name,product_price,product_desc)
VALUES('A001','牛仔裤',99,'蓝黑色，柔软有弹性')

创建项目

有了表，咱麻溜的打开IDEA，创建一个Maven工程项目，项目结构如下：

1、添加依赖

打开pom.xml文件，添加依赖：

        <!-- mybatis依赖 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>

        <!-- mysql 依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

        <!-- lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
            <scope>provided</scope>
        </dependency>

        <!-- junit -->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>


        <!-- pagehelper 分页组件 -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.2.0</version>
        </dependency>

        <!-- log4j 组件 -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

        <!-- druid 数据库连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.6</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring-version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</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-test</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>${spring-version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${spring-version}</version>
        </dependency>

        <!-- mybatis-spring 支持库-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.2</version>
        </dependency>

        <!-- jstl标签库 -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

        <!-- jsp-api -->
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>javax.servlet.jsp-api</artifactId>
            <version>2.3.3</version>
            <scope>provided</scope>
        </dependency>
        <!-- servlet-api -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>

2、改造项目为WEB项目

2.1 添加pom.xml文件添加 war配置

  <packaging>war</packaging>

2.2、修改工程结构

3、mybatis配置

3.1、创建mybatis-config.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>


</configuration>

3.2、创建项目包结构

3.3、创建实体类

创建实体类，咱使用插件Lombok，如果你的IDEA还没有添加这个插件的话，请按下图添加。

有了Lombok插件，就可以使用注解添加，get/set，构造器，toString等

@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
public class Product {
    private int id;
    private String productId;
    private String productName;
    private double productPrice;
    private String productDesc;
    
}

3.4、创建DAO接口

接下来创建DAO接口：

/**
 * @description:
 * @author: Vin
 * @weixin: finally-vince
 */
public interface ProductDAO {
    public List<Product> list();

    public Product findByProductId(String productId);

    public int updateProduct(Product product);

    public int addProduct(Product product);

    public int deleteProduct(String productId);
}

3.5、编写DAO接口对应Mapper文件：ProductMapper.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.qfedu.dao.ProductDAO">

    <resultMap id="productMap" type="Product">
        <id column="id" property="id"/>
        <result column="product_id" property="productId"/>
        <result column="product_name" property="productName"/>
        <result column="product_price" property="productPrice"/>
        <result column="product_desc" property="productDesc"/>
    </resultMap>
    
    <select id="list" resultMap="productMap">
        select id,product_id,product_name,product_price,product_desc 
        from productTab
    </select>
</mapper>

4、Spring配置

4.1 创建spring-context.xml 用于配置IOC基础配置

<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:annotation-config/>

    <!-- 声明Spring工厂注解的扫描范围 -->
    <context:component-scan base-package="com.qfedu"/>

</beans>

4.2、创建 spring-mvc.xml 配置文件 用于配置MVC相关的内容

<?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:aop="http://www.springframework.org/schema/aop"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/aop
       http://www.springframework.org/schema/aop/spring-aop.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <!--声明MVC采用注解方式驱动-->
    <mvc:annotation-driven/>
    <mvc:resources mapping="/css/**" location="/css/"/>
    <mvc:resources mapping="/images/**" location="/images/"/>
    <mvc:resources mapping="/js/**" location="/js/"/>
    <mvc:resources mapping="/pages/**" location="/pages/"/>
    <mvc:resources mapping="/pages/product/**" location="/pages/product/"/>

</beans>

4.3、创建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:tx="http://www.springframework.org/schema/tx"
       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
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd">

    <!--加载druid.properties配置文件-->
    <context:property-placeholder location="druid.properties"/>

    <!--使用注解配置事务管理-->
    <tx:annotation-driven transaction-manager="transactionManager"/>
    
    <!--配置DruidDataSource数据源，交给Spring管理（创建）-->
    <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${druid.driver}"/>
        <property name="url" value="${druid.url}"/>
        <property name="username" value="${druid.username}"/>
        <property name="password" value="${druid.password}"/>

        <property name="initialSize" value="${druid.pool.init}"/>
        <property name="minIdle" value="${druid.pool.minIdle}"/>
        <property name="maxActive" value="${druid.pool.maxActive}"/>
        <property name="maxWait" value="${druid.pool.maxWait}"/>
    </bean>

    <!--配置SqlSessionFactory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--配置数据源-->
        <property name="dataSource" ref="druidDataSource"/>
        <!--配置Mapper文件-->
        <property name="mapperLocations" value="classpath:mappers/*Mapper.xml"/>
        <!--配置包下的所有实体类别名，别名：类名-->
        <property name="typeAliasesPackage" value="com.qfedu.pojo"/>
        <!--配置mybatis主配置文件-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
    </bean>
    <!--加载dao包的所有接口，通过SqlSessionFactory创建SqlSession,再通过SqlSession创建具体的DAO对象放到Spring容器-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        <property name="basePackage" value="com.qfedu.dao"/>
    </bean>

    <!--把Spring-jdbc提供的事务管理器，配置给Spring容器管理-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="druidDataSource"/>
    </bean>

</beans>

4.4、在web.xml文件中配置SpringMVC的核心控制器

<?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">

    <!--配置spring核心控制器在web应用启动时加载-->
    <servlet>
        <servlet-name>dispatcherServlet</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>
    </servlet>

    <!--配置SpringMVC拦截的URL-->
    <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

</web-app>

5、搭建视图层目录结构

6、实现DAO接口Mapper

<?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.qfedu.dao.ProductDAO">

    <resultMap id="productMap" type="Product">
        <id column="id" property="id"/>
        <result column="product_id" property="productId"/>
        <result column="product_name" property="productName"/>
        <result column="product_price" property="productPrice"/>
        <result column="product_desc" property="productDesc"/>
    </resultMap>

    <select id="list" resultMap="productMap">
        select id,product_id,product_name,product_price,product_desc
        from productTab
    </select>
    <insert id="insertProduct" useGeneratedKeys="true" keyProperty="id">
        insert into productTab (id,product_id,product_name,product_price,product_desc) 
        values (#{id},#{productId},#{productName},#{productPrice},#{productDesc})
    </insert>
    <update id="updateProduct" keyProperty="id" useGeneratedKeys="true">
        update productTab set product_name=#{productName},product_price=#{productPrice},product_desc=#{productDesc}
        where product_id=#{productId}
    </update>
    <delete id="deleteProduct">
        delete from productTab where product_id=#{productId}
    </delete>
    <select id="findByProductId" resultMap="productMap">
        select id,product_id,product_name,product_price,product_desc
        from productTab where product_id=#{productId}
    </select>
</mapper>

7、实现Service接口及实现类

7.1 创建Service接口

package com.qfedu.service;

import com.qfedu.pojo.Product;

import java.util.List;

/**
 * @description:
 * @author: Vin
 * @weixin: finally-vince
 */
public interface ProductService {

    public List<Product> list();

    public Product findByProductId(String productId);

    public int modifyProduct(Product product);

    public int addProduct(Product product);

    public int removeProduct(String productId);
}

7.2、创建service接口的实现类

package com.qfedu.service.impl;

import com.qfedu.dao.ProductDAO;
import com.qfedu.pojo.Product;
import com.qfedu.service.ProductService;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;
import java.util.List;

/**
 * @description:
 * @author: Vin
 * @weixin: finally-vince
 */
@Service
@Transactional(isolation = Isolation.REPEATABLE_READ,propagation = Propagation.REQUIRED)
public class ProductServiceImpl implements ProductService {

    @Resource
    private ProductDAO productDAO;

    @Transactional(isolation = Isolation.REPEATABLE_READ,propagation = Propagation.SUPPORTS)
    public List<Product> list() {
        return productDAO.list();
    }

    @Transactional(isolation = Isolation.REPEATABLE_READ,propagation = Propagation.SUPPORTS)
    public Product findByProductId(String productId) {
        return productDAO.findByProductId(productId);
    }


    public int modifyProduct(Product product) {
        return productDAO.updateProduct(product);
    }

    public int addProduct(Product product) {
        return productDAO.insertProduct(product);
    }

    public int removeProduct(String productId) {
        return productDAO.deleteProduct(productId);
    }
}

8、实现视图层Controller和页面

8.1、创建ProductController控制器类

8.1.1、实现查询商品列表功能

package com.qfedu.controller;

import com.qfedu.pojo.Product;
import com.qfedu.service.ProductService;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;
import java.util.List;

/**
 * @description:
 * @author: Vin
 * @weixin: finally-vince
 */
@Controller
@RequestMapping("/product")
public class ProductController {

    @Resource
    private ProductService productService;

    @RequestMapping("/list")
    public ModelAndView list(){
        List<Product> list = productService.list();
        //转发
        ModelAndView modelAndView = new ModelAndView("/pages/product/list.jsp");
        modelAndView.addObject("list",list);
        return modelAndView;
    }
}

8.1.2、实现list.jsp页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<html>
<head>
    <title>product list</title>
    <link type="text/css" href="<%=request.getContextPath()%>/css/text.css"/>
</head>
<body>
    <div class="titlediv"><h1>所有商品列表</h1></div>
    <table border="1">
        <tr>
            <th>商品编号</th>
            <th>商品名称</th>
            <th>商品价格</th>
            <th>商品信息</th>
            <th>操作</th>
        </tr>
        <c:forEach items="${list}" var="product">
            <tr>
                <td>${product.productId}</td>
                <td>${product.productName}</td>
                <td>${product.productPrice}</td>
                <td>${product.productDesc}</td>
                <td>
                    <a href="<%=request.getContextPath()%>/product/view?id=${product.productId}">查询|修改</a>
                    <a></a>
                </td>
            </tr>
        </c:forEach>
    </table>
</body>
</html>

8.1.3、实现根据商品ID查询商品功能

@RequestMapping("/view")
    public ModelAndView view(String productId){
        Product product = productService.findByProductId(productId);
        ModelAndView modelAndView = new ModelAndView("/pages/product/edit.jsp");
        modelAndView.addObject("product",product);
        return modelAndView;
    }

8.1.4、实现edit.jsp页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Edit and View</title>
</head>
<body>
    
    <h1>查看与编辑商品信息</h1>
    <form action="<%=request.getContextPath()%>/product/update" method="get">
        <p><input type="hidden" value="${product.id}" name="id"/></p>
        <p><input type="hidden" value="${product.productId}" name="productId"/></p>
        <p><input type="text" value="${product.productName}" name="productName"/></p>
        <p><input type="text" value="${product.productPrice}" name="productPrice"/></p>
        <p><input type="text" value="${product.productDesc}" name="productDesc"/></p>
        <input type="submit" value="提交修改"/>
    </form>

</body>
</html>

8.1.5、修改list.jsp页面，添加“查看|修改” 链接：

<a href="<%=request.getContextPath()%>/product/view?id=${product.productId}">查询|修改</a>

8.1.6、实现修改控制器功能

@RequestMapping("/update")
    public ModelAndView update(Product product){
        int i = productService.modifyProduct(product);
        ModelAndView modelAndView = new ModelAndView("redirect:/product/list");
        return modelAndView;
    }

8.1.7、实现新增商品功能

@RequestMapping("/add")
    public ModelAndView add(Product product){
        int i = productService.addProduct(product);
        ModelAndView modelAndView = new ModelAndView("redirect:/product/list");
        return modelAndView;
    }

8.1.8、修改list.jsp页面，添加新增按钮

<tr>
            <td colspan="5">
                <input type="button" class="inputbutton" value="新增商品" id="addButton"/>
                <script type="text/javascript">
                    $("#addButton").click(function () {
                        document.location.href = "<%=request.getContextPath()%>/pages/product/new.jsp";
                    });
                </script>
            </td>
        </tr>

8.1.9、实现new.jsp页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>new product</title>
    <link type="text/css" href="<%=request.getContextPath()%>/css/text.css"/>
</head>
<body>

<div class="contentdiv"><h1>新增商品信息</h1></div>
<form action="<%=request.getContextPath()%>/product/add" method="get">
    <p><input type="hidden" value="0" name="id"/></p>
    <p>商品编号：<input type="text" value="" name="productId"/></p>
    <p>商品名称：<input type="text" value="" name="productName"/></p>
    <p>商品价格：<input type="text" value="" name="productPrice"/></p>
    <p>商品信息：<input type="text" value="" name="productDesc"/></p>
    <input type="submit" value="提交"/>
</form>

</body>
</html>

8.1.10、实现删除控制器功能

@RequestMapping("/del")
    public ModelAndView del(@RequestParam("id") String productId){
        int i = productService.removeProduct(productId);
        ModelAndView modelAndView = new ModelAndView("redirect:/product/list");
        return modelAndView;
    }

8.1.11、修改list.jsp页面，添加删除链接：

<a href="<%=request.getContextPath()%>/product/del?id=${product.productId}">删除</a>

9、处理乱码问题

9.1、数据库和表编码统一使用UTF-8 / GBK

9.2、Tomcat conf/server.xml  找到配置：

9.3、配置过滤器，在web.xml文件中配置：

<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>

9.4、在页面上统一使用UTF-8编码

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

好了，到这，咱们基本就完成SSM的整合过程，通过案例步骤的操作，相信你一定可以跟着操作把这个案例搭起来，也相信你会在这个过程中，体会到SSM的流程还是比较繁琐的，而SpringBoot的诞生，就是解决这个问题的根本。