SSM 类别编辑

2018-01-23

用于编辑的超链

1	<a href="admin_category_edit?id=${c.id}"><span class="glyphicon glyphicon-edit"></span></a>

增加通过id获取Category对象的sql语句

<?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.how2java.tmall.mapper.CategoryMapper">
    <select id="list" resultType="Category">
        select * from   category         order by id desc
        <if test="start!=null and count!=null">
            limit #{start},#{count}
        </if>
 
    </select>
    <select id="total" resultType="int">
        select count(*) from category
    </select>
    <insert id="add"  keyProperty="id"  useGeneratedKeys="true" parameterType="Category" >
        insert into category ( name ) values (#{name})
    </insert>
    <delete id="delete">
        delete from category where id= #{id}
    </delete>
 
    <select id="get" resultType="Category">
        select * from category  where id= #{id}
    </select>
</mapper>

CategoryMapper增加get方法

import java.util.List;
 
public interface CategoryMapper {
     List<Category> list(Page page);
 
     int total();
 
     void add(Category category);
 
     void delete(int id);
 
     Category get(int id);
}

CategoryController

增加edit方法

映射admin_category_edit路径的访问
参数id用来接受注入
通过categoryService.get获取Category对象
把对象放在“c”上
返回editCategory.jsp

@RequestMapping("admin_category_edit")
public String edit(int id,Model model) throws IOException {
    Category c= categoryService.get(id);
    model.addAttribute("c", c);
    return "admin/editCategory";
}

editCategory.jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8" import="java.util.*"%>
 
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@include file="../include/admin/adminHeader.jsp"%>
<%@include file="../include/admin/adminNavigator.jsp"%>
 
<title>编辑分类</title>
 
<script>
    $(function(){
 
        $("#editForm").submit(function(){
            if(!checkEmpty("name","分类名称"))
                return false;
 
            return true;
        });
    });
 
</script>
 
<div class="workingArea">
 
    <ol class="breadcrumb">
        <li><a href="admin_category_list">所有分类</a></li>
        <li class="active">编辑分类</li>
    </ol>
 
    <div class="panel panel-warning editDiv">
        <div class="panel-heading">编辑分类</div>
        <div class="panel-body">
            <form method="post" id="editForm" action="admin_category_update"  enctype="multipart/form-data">
                <table class="editTable">
                    <tr>
                        <td>分类名称</td>
                        <td><input  id="name" name="name" value="${c.name}" type="text" class="form-control"></td>
                    </tr>
                    <tr>
                        <td>分类圖片</td>
                        <td>
                            <input id="categoryPic" accept="image/*" type="file" name="image" />
                        </td>
                    </tr>
                    <tr class="submitTR">
                        <td colspan="2" align="center">
                            <input type="hidden" name="id" value="${c.id}">
                            <button type="submit" class="btn btn-success">提 交</button>
                        </td>
                    </tr>
                </table>
            </form>
        </div>
    </div>
</div>

编辑页面提交数据

1 2	<form method="post" id="editForm" action="admin_category_update" enctype="multipart/form-data">

CategoryMapper.xml增加修改的sql语句

<?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.how2java.tmall.mapper.CategoryMapper">
    <select id="list" resultType="Category">
        select * from   category         order by id desc
        <if test="start!=null and count!=null">
            limit #{start},#{count}
        </if>
 
    </select>
    <select id="total" resultType="int">
        select count(*) from category
    </select>
    <insert id="add"  keyProperty="id"  useGeneratedKeys="true" parameterType="Category" >
        insert into category ( name ) values (#{name})
    </insert>
    <delete id="delete">
        delete from category where id= #{id}
    </delete>
 
    <select id="get" resultType="Category">
        select * from category  where id= #{id}
    </select>
 
    <update id="update" parameterType="Category" >
        update category set name=#{name} where id=#{id}
    </update>
</mapper>

CategoryMapper增加update方法

import java.util.List;
 
public interface CategoryMapper {
     List<Category> list(Page page);
 
     int total();
 
     void add(Category category);
 
     void delete(int id);
 
     Category get(int id);
 
     void update(Category category);
}

CategoryController

add方法映射路径admin_category_update的访问
通过categoryService更新c对象
首先判断是否有上传图片，如果有上传，那么通过session获取ControllerContext,再通过getRealPath定位存放分类图片的路径。
根据分类id创建文件名
通过UploadedImageFile 把浏览器传递过来的图片保存在上述指定的位置
通过ImageUtil.change2jpg(file); 确保图片格式一定是jpg，而不仅仅是后缀名是jpg.

客户端跳转到admin_category_list

@RequestMapping("admin_category_update")
public String update(Category c, HttpSession session, UploadedImageFile uploadedImageFile) throws IOException {
    categoryService.update(c);
    MultipartFile image = uploadedImageFile.getImage();
    if(null!=image &&!image.isEmpty()){
        File  imageFolder= new File(session.getServletContext().getRealPath("img/category"));
        File file = new File(imageFolder,c.getId()+".jpg");
        image.transferTo(file);
        BufferedImage img = ImageUtil.change2jpg(file);
        ImageIO.write(img, "jpg", file);
    }
    return "redirect:/admin_category_list";
}