JavaWeb_(SpringMVC框架)测试SpringMVC&Spring&MyBatis三大整合

时间：2023-03-08 19:34:24

　　搭建 SpringMVC&Spring&MyBatis三大整合 传送门

1、准备 测试搭建S pringMVC&Spring&MyBatis三大整合 用例  

　　a)准备 – 测试数据：

　　　　i.Bean -> 根据个人喜好；

　　　　ii.数据库表 -> 根据个人喜好；

　　b)导入 – 测试数据 -> 学习项目 -> 后台页面

　　JavaWeb_(SpringMVC框架)测试SpringMVC&Spring&MyBatis三大整合

　　在ssm_springmvc数据库中创建一张item_info的表

　　JavaWeb_(SpringMVC框架)测试SpringMVC&Spring&MyBatis三大整合

　　将这些数据显示在item_list.jsp上

                                        <thead>

                                            <tr>

                                                <!--描述：商品数据标签-->

                                                <th>ID</th>

                                                <th>游戏名称</th>

                                                <th>类型</th>

                                                <th>原价</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                               <c:forEach items="${itemList }" var="item">

                                                <tr>

                                                    <td>${item.item_id }</td>

                                                    <td>${item.item_name }</td>

                                                    <td>${item.item_type }</td>

                                                    <td>${item.item_price }</td>

                                                    <td data-value="1">

                                                        <a herf="#" id="edit_btn" class="btn btn-xs btn-info" data-toggle="modal" data-target="#editLayer" onclick="editGoods('${item.item_id}')">修改</a>

                                                        <a herf="#"  id="del_btn" class="btn btn-xs btn-danger" onclick="deleteGoods('${item.item_id}')">删除</a>

                                                    </td>

                                                   </tr>

                                            </c:forEach>

                                        </tbody>

JavaWeb_(SpringMVC框架)测试SpringMVC&Spring&MyBatis三大整合

package com.Gary.bean;

public class ItemInfo {

    //id

    private String item_id;

    //name

    private String item_name;

    //type

    private String item_type;

    //price

    private Double item_price;

    public String getItem_id() {

        return item_id;

    }

    public void setItem_id(String item_id) {

        this.item_id = item_id;

    }

    public String getItem_name() {

        return item_name;

    }

    public void setItem_name(String item_name) {

        this.item_name = item_name;

    }

    public String getItem_type() {

        return item_type;

    }

    public void setItem_type(String item_type) {

        this.item_type = item_type;

    }

    public Double getItem_price() {

        return item_price;

    }

    public void setItem_price(Double item_price) {

        this.item_price = item_price;

    }

    @Override

    public String toString() {

        return "ItemInfo [item_id=" + item_id + ", item_name=" + item_name + ", item_type=" + item_type

                + ", item_price=" + item_price + "]";

    }

}

ItemInfo.java

package com.Gary.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.servlet.ModelAndView;

import com.Gary.bean.ItemInfo;

import com.Gary.service.ItemService;

//游戏信息管理

@Controller

@RequestMapping("/item/")

public class ItemController {

    @Autowired

    private ItemService itemService;

    @RequestMapping("allList.do")

    public ModelAndView list() {

        ModelAndView mav = new ModelAndView();

        List<ItemInfo> itemList = itemService.selectAll();

        //查询 将结果赋值给mav

        mav.addObject("itemList",itemList);

        //设置试图名称

        mav.setViewName("item_list");

        return mav;

    }

}

ItemController.java

package com.Gary.mapper;

import java.util.List;

import com.Gary.bean.ItemInfo;

public interface ItemMapper {

    //查询全部

    public List<ItemInfo> selectAll();

}

ItemMapper.java

<?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.Gary.mapper.ItemMapper">

      <select id="selectAll" resultType="ItemInfo">

          SELECT * FROM item_info

      </select>

     </mapper>

ItemMapper.xml

package com.Gary.service;

import java.util.List;

import com.Gary.bean.ItemInfo;

public interface ItemService {

    //查询全部

        public List<ItemInfo> selectAll();

}

ItemService.java

package com.Gary.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import com.Gary.bean.ItemInfo;

import com.Gary.mapper.ItemMapper;

@Service

public class ItemServiceImpl implements ItemService{

    @Autowired

    private ItemMapper itemMapper;

    @Override

    public List<ItemInfo> selectAll() {

        return itemMapper.selectAll();

    }

}

ItemServiceImpl.java

<?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:aop="http://www.springframework.org/schema/aop"

    xmlns:mvc="http://www.springframework.org/schema/mvc"

    xmlns:tx="http://www.springframework.org/schema/tx"

    xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd

        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd

        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd

        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd

        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">

        <!-- 读取配置文件 数据库 -->

        <context:property-placeholder location="classpath:db.properties"/>

        <!-- 配置数据源 -->

        <bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

            <property name="driverClass" value="${jdbc.driverClass}"/>

            <property name="jdbcUrl" value="${jdbc.jdbcUrl}"/>

            <property name="user" value="${jdbc.user}"/>

            <property name="password" value="${jdbc.password}"/>

        </bean>

        <!-- 开启注解扫描 -->

        <context:component-scan base-package="com.Gary"></context:component-scan>

        <!-- 事务核心管理器 -->

        <bean name="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

            <property name="dataSource" ref="dataSource"/>

        </bean>

        <!-- 开启注解事务 -->

        <tx:annotation-driven/>

        <!-- 配置视图解析器 -->

        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">

            <property name="prefix" value="/WEB-INF/jsp/"/>

            <property name="suffix" value=".jsp"/>

        </bean>

        <!-- 配置mybatis -->

        <bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

            <property name="dataSource" ref="dataSource"/>

            <property name="typeAliasesPackage" value="com.Gary.bean"/>

        </bean>

        <!-- mapper工厂 -->

        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

            <property name="basePackage" value="com.Gary.mapper"/>

        </bean>

</beans>

applicationContext.xml

jdbc.driverClass=com.mysql.jdbc.Driver

jdbc.jdbcUrl=jdbc:mysql://localhost:3306/ssm_springmvc

jdbc.user=root

jdbc.password=123456

db.properties

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

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

    <head>

        <meta charset="UTF-8">

        <title>游戏管理后台</title>

        <meta name="viewport" content="initial-scale=1.0,maximum-scale=1.0,user-scalable=no">

        <meta http-equiv="X-UA-Compatible" content="IE=edge">

           <!-- bootstrap framework -->

        <link href="${pageContext.request.contextPath }/css/bootstrap.min.css" rel="stylesheet" media="screen">

        <!-- main stylesheet -->

        <link href="${pageContext.request.contextPath }/css/main.min.css" rel="stylesheet" media="screen" id="mainCss">

        <!-- elegant icons -->

        <link href="${pageContext.request.contextPath }/css/style.css" rel="stylesheet" media="screen">

        <!-- datepicker -->

        <link href="${pageContext.request.contextPath }/css/datepicker3.css" rel="stylesheet" media="screen">

        <!-- jBox -->

        <link href="${pageContext.request.contextPath }/css/jbox.css" rel="stylesheet" media="screen">

        <link href="${pageContext.request.contextPath }/css/noticeborder.css" rel="stylesheet" media="screen">

    </head>

    <body class="side_menu_active side_menu_expanded">

        <div id="page_wrapper">

            <!-- header -->

            <header id="main_header">

                <div class="container-fluid">

                    <!--logo-->

                    <div class="brand_section">

                        <a href="#"><img src="${pageContext.request.contextPath }/picture/logo01.png" alt="site_logo" width="108" height="40" style="margin-top: 5px"></a>

                    </div>

                    <div class="header_user_actions dropdown">

                        <div data-toggle="dropdown" class="dropdown-toggle user_dropdown">

                            <div class="user_avatar">

                                <img src="${pageContext.request.contextPath }/picture/head01.png" width="38" height="38">

                            </div>

                            <span class="caret"></span>

                        </div>

                        <ul class="dropdown-menu dropdown-menu-right">

                            <li><a href="#">个人中心</a></li>

                            <li><a href="#">注销</a></li>

                        </ul>

                    </div>

                </div>

            </header>

            <!-- main content -->

            <div id="main_wrapper">

                <div class="container-fluid">

                    <div class="row">

                        <div class="col-md-12">

                            <div class="row">

                                <div class="col-md-10">

                                    <table class="table table-yuk2 toggle-arrow-tiny" id="footable_demo" data-filter="#textFilter" data-page-size="5">

                                        <thead>

                                            <tr>

                                                <!--描述：商品数据标签-->

                                                <th>ID</th>

                                                <th>游戏名称</th>

                                                <th>类型</th>

                                                <th>原价</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                               <c:forEach items="${itemList }" var="item">

                                                <tr>

                                                    <td>${item.item_id }</td>

                                                    <td>${item.item_name }</td>

                                                    <td>${item.item_type }</td>

                                                    <td>${item.item_price }</td>

                                                    <td data-value="1">

                                                        <a herf="#" id="edit_btn" class="btn btn-xs btn-info" data-toggle="modal" data-target="#editLayer" onclick="editGoods('${item.item_id}')">修改</a>

                                                        <a herf="#"  id="del_btn" class="btn btn-xs btn-danger" onclick="deleteGoods('${item.item_id}')">删除</a>

                                                    </td>

                                                   </tr>

                                            </c:forEach>

                                        </tbody>

                                        <tfoot class="hide-if-no-paging">

                                            <tr>

                                                <td colspan="5">

                                                    <ul class="pagination pagination-sm"></ul>

                                                </td>

                                            </tr>

                                        </tfoot>

                                    </table>

                                </div>

                            </div>

                        </div>

                    </div>

                </div>

            </div>

            <!-- edit layer -->

            <div class="modal fade" id="editLayer">

                <div class="modal-dialog modal-content">

                    <div class="modal-content">

                        <div class="modal-header">

                            <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>

                            <h4 class="modal-title">修改游戏信息</h4>

                        </div>

                       <div class="modal-body">

                        <!--游戏修改详情弹出层表单-->

                        <form class="form-horizontal" id="edit_item_form">

                            <!-- 游戏id隐藏域 -->

                            <input type="hidden" id="edit_item_id" name="item_id"/>

                            <!-- 游戏名称 -->

                            <div class="form-group">

                                <label for="edit_item_name" class="col-sm-2 control-label">游戏名称</label>

                                <div class="col-sm-10">

                                    <input type="text" class="form-control" id="edit_item_name" placeholder="游戏名称" name="item_name">

                                </div>

                            </div>

                            <!-- 游戏类型 -->

                            <div class="form-group">

                                <label for="edit_item_price" class="col-sm-2 control-label">类型</label>

                                <div class="col-sm-10">

                                    <input type="text" class="form-control" id="edit_item_price" placeholder="类型" name="item_price">

                                </div>

                            </div>

                            <!-- 游戏原价 -->

                            <div class="form-group">

                                <label for="edit_item_price" class="col-sm-2 control-label">原价</label>

                                <div class="col-sm-10">

                                    <input type="text" class="form-control" id="edit_item_price" placeholder="原价" name="item_price">

                                </div>

                            </div>

                        </form>

                    </div>

                        <div class="modal-footer">

                            <button type="button" class="btn btn-default btn-sm" data-dismiss="modal">取消</button>

                            <button type="button" class="btn btn-primary btn-sm" onclick="updateItem()">确认修改</button>

                        </div>

                    </div>

                </div>

            </div>

             <!-- add layer -->

            <div class="modal fade" id="addLayer">

                <div class="modal-dialog modal-content">

                    <div class="modal-content">

                        <div class="modal-header">

                            <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>

                            <h4 class="modal-title">新增游戏</h4>

                        </div>

                       <div class="modal-body">

                        <!--添加游戏弹出层表单-->

                        <form class="form-horizontal" id="add_item_form">

                            <!-- 游戏id隐藏域 -->

                            <input type="hidden" id="add_item_id" name="item_id"/>

                            <!-- 游戏名称 -->

                            <div class="form-group">

                                <label for="add_item_name" class="col-sm-2 control-label">游戏名称</label>

                                <div class="col-sm-10">

                                    <input type="text" class="form-control" id="add_item_name" placeholder="游戏名称" name="item_name">

                                </div>

                            </div>

                            <!-- 游戏类型 -->

                            <div class="form-group">

                                <label for="add_item_price" class="col-sm-2 control-label">类型</label>

                                <div class="col-sm-10">

                                    <input type="text" class="form-control" id="add_item_price" placeholder="类型" name="item_price">

                                </div>

                            </div>

                            <!-- 游戏原价 -->

                            <div class="form-group">

                                <label for="add_item_price" class="col-sm-2 control-label">原价</label>

                                <div class="col-sm-10">

                                    <input type="text" class="form-control" id="add_item_price" placeholder="原价" name="item_price">

                                </div>

                            </div>

                        </form>

                    </div>

                        <div class="modal-footer">

                            <button type="button" class="btn btn-default btn-sm" data-dismiss="modal">取消</button>

                            <button type="button" class="btn btn-primary btn-sm" onclick="addItem()">确认修改</button>

                        </div>

                    </div>

                </div>

            </div>

            <!-- main menu -->

            <nav id="main_menu">

                <div class="menu_wrapper">

                    <ul>

                        <li class="first_level">

                            <a href="javascript:void(0)">

                                <span class="icon_document_alt first_level_icon"></span>

                                <span class="menu-title">游戏管理</span>

                            </a>

                            <ul>

                                <li class="submenu-title">游戏管理</li>

                                <!-- <li><a href="#" data-toggle="modal" data-target="#addLayer">商品添加</a></li> -->

                                <li><a href="${pageContext.request.contextPath }/item/myitemlist.do">游戏列表</a></li>

                            </ul>

                        </li>

                    </ul>

                </div>

                <div class="menu_toggle">

                    <span class="icon_menu_toggle">

                        <i class="arrow_carrot-2left toggle_left"></i>

                        <i class="arrow_carrot-2right toggle_right" style="display:none"></i>

                    </span>

                </div>

            </nav>

        </div>

        <!-- jQuery -->

        <script src="${pageContext.request.contextPath }/js/jquery.min.js"></script>

        <!-- jQuery Cookie -->

        <script src="${pageContext.request.contextPath }/js/jquerycookie.min.js"></script>

        <!-- Bootstrap Framework -->

        <script src="${pageContext.request.contextPath }/js/bootstrap.min.js"></script>

        <!-- retina images -->

        <script src="${pageContext.request.contextPath }/js/retina.min.js"></script>

        <!-- switchery -->

        <script src="${pageContext.request.contextPath }/js/switchery.min.js"></script>

        <!-- typeahead -->

        <script src="${pageContext.request.contextPath }/js/typeahead.bundle.min.js"></script>

        <!-- fastclick -->

        <script src="${pageContext.request.contextPath }/js/fastclick.min.js"></script>

        <!-- match height -->

        <script src="${pageContext.request.contextPath }/js/jquery.matchheight-min.js"></script>

        <!-- scrollbar -->

        <script src="${pageContext.request.contextPath }/js/jquery.mcustomscrollbar.concat.min.js"></script>

        <!-- moment.js (date library) -->

        <script src="${pageContext.request.contextPath }/js/moment-with-langs.min.js"></script>

        <!-- Yukon Admin functions -->

        <script src="${pageContext.request.contextPath }/js/yukon_all.min.js"></script>

        <!-- page specific plugins -->

        <!-- footable -->

        <script src="${pageContext.request.contextPath }/js/footable.min.js"></script>

        <script src="${pageContext.request.contextPath }/js/footable.paginate.min.js"></script>

        <script src="${pageContext.request.contextPath }/js/footable.filter.min.js"></script>

           <!-- datepicker -->

        <script src="${pageContext.request.contextPath }/js/bootstrap-datepicker.js"></script>

           <!-- jBox -->

        <script src="${pageContext.request.contextPath }/js/jbox.min.js"></script>

        <script type="text/javascript">

            $(function() {

                //footable

                yukon_footable.goodslist();

                //datepicker

                yukon_datepicker.p_forms_extended();

            })

            //修改弹框回显

               function toEdit(id) {

                   $.ajax({

                       type:"post",

                       url:"${pageContext.request.contextPath }/item/toEdit",

                       data:{"id":id},

                       success:function(data) {

                           $("#edit_item_name").val(data.item_name);

                           $("#edit_item_type").val(data.item_type);

                           $("#edit_item_price").val(data.item_price);

                       },

                       dataType:"json"

                   });

               }

            //确认修改

            function updateItem() {

                $.post(

                    "${pageContext.request.contextPath }/item/update.do",

                    $("#edit_item_form").serialize(),

                    function(data){

                        alert("游戏信息更新成功!");

                        window.location.reload();

                });

            }

            //确认删除

            function deleteItem(id) {

                if(confirm('确实要删除该游戏吗?')) {

                    $.post(

                        "${pageContext.request.contextPath }/item/delete.do",

                        {"id":id},

                        function(data){

                            window.location.reload();

                    });

                }

            }

            //添加游戏

            function addItem() {

                $.post(

                    "${pageContext.request.contextPath }/item/save.do",

                    $("#add_item_form").serialize(),

                    function(data){

                        alert("游戏添加成功!");

                        window.location.reload();

                });

            }

        </script>

    </body>

</html>

item_list.jsp