SSM 类别删除

2018-03-14

用于删除的超链

1	<a deleteLink="true" href="admin_category_delete?id=${c.id}"><span class=" glyphicon glyphicon-trash"></span></a>

删除前的确认操作

$(function(){
	$("a").click(function(){
		var deleteLink = $(this).attr("deleteLink");
		console.log(deleteLink);
		if("true"==deleteLink){
			var confirmDelete = confirm("确认要删除");
			if(confirmDelete)
				return true;
			return false;
			
		}
	});
})

增加删除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>
</mapper>

CategoryController

映射路径admin_category_delete
提供参数接受id注入
提供session参数，用于后续定位文件位置
通过categoryService删除数据
通过session获取ControllerContext然后获取分类图片位置，接着删除分类图片
客户端跳转到 admin_category_list

@RequestMapping("admin_category_delete")
  public String delete(int id,HttpSession session) throws IOException {
      categoryService.delete(id);
      File  imageFolder= new File(session.getServletContext().getRealPath("img/category"));
      File file = new File(imageFolder,id+".jpg");
      file.delete();
      return "redirect:/admin_category_list";
  }