ssm 框架实现增删改查CRUD操作（Spring + SpringMVC + Mybatis 实现增删改查）

SpringBoot 项目整合

一、项目准备

1.1 ssm 框架环境搭建

博客地址：ssm项目框架搭建

1.2 项目结构图如下

1.3 数据表结构图如下

CREATE TABLE `department` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `sn` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

1.4 运行结果

二、项目实现

1. EmployeeController 控制器

package com.yy.homework.web.controller;

import com.github.pagehelper.PageInfo;
import com.yy.homework.anno.RequiredPermission;
import com.yy.homework.domain.Department;
import com.yy.homework.qo.DepartmentPageObject;
import com.yy.homework.service.IDepartmentService;
import com.yy.homework.service.IDepartmentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;

@Controller
@RequestMapping("/department")
public class DepartmentController {
   
    @Autowired
    private IDepartmentService departmentService;

    @RequestMapping("/list")
    @RequiredPermission(name = "部门查询", expression = "department:list")
    public String selectAll(Model model, @ModelAttribute("qo")DepartmentPageObject qo) {
   
    	// Mybatis分页插件 PageHelper
    	//qo：页面模糊查询传入的值和分页查询传入的当前页和每页条数分装成 DepartmentPageObject 对象
        PageInfo<Department> pageInfo = departmentService.selectForList(qo);
        model.addAttribute("pageInfo", pageInfo);
        return "department/list";
    }

    @RequestMapping("/input")
    @RequiredPermission(name = "部门新增或修改", expression = "department:saveOrUpdate")
    public String input(Department department, Model model) {
   
        if (department.getId() != null) {
   
            Department e = departmentService.selectById(department.getId());
            model.addAttribute("department", e);
        }
        return "department/input";
    }

    @RequestMapping("/saveOrUpdate")
    @RequiredPermission(name = "部门新增或修改", expression = "department:saveOrUpdate")
    public String saveOrUpdate(Department department) {
   
        if (department.getId() != null) {
   
            departmentService.update(department);
        } else {
   
            departmentService.insert(department);
        }
        return "redirect:/department/list";
    }

    @RequestMapping("/delete")
    @RequiredPermission(name = "部门删除", expression = "department:delete")
    public String delete(Long id) {
   
        departmentService.delete(id);
        return "redirect:/department/list";
    }
}

2. IDepartmentService 接口

package com.yy.homework.service;

import com.github.pagehelper.PageInfo;
import com.yy.hom