ssm增删改查

public void setGrade(Date grade) {
        this.grade = grade;
    }
    public Integer getCollegeid() {
        return collegeid;
    }
    public void setCollegeid(Integer collegeid) {
        this.collegeid = collegeid;
    }
}public class Student {
    private Integer userid;
    private String username;
    private String sex;
    private Date birthyear;
    private Date grade;
    private Integer collegeid;
    public Integer getUserid() {
        return userid;
    }
    public void setUserid(Integer userid) {
        this.userid = userid;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username == null ? null : username.trim();
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex == null ? null : sex.trim();
    }
    public Date getBirthyear() {
        return birthyear;
    }
    public void setBirthyear(Date birthyear) {
        this.birthyear = birthyear;
    }
    public Date getGrade() {
        return grade;
    }

3、主要程序代码

@Resource(name = "studentServiceImpl")
private StudentService studentService;

@Resource(name = "teacherServiceImpl")
private TeacherService teacherService;

@Resource(name = "courseServiceImpl")
private CourseService courseService;

@Resource(name = "collegeServiceImpl")
private CollegeService collegeService;

@Resource(name = "userloginServiceImpl")
private UserloginService userloginService;
/*<<<<<<<<<<学生操作>>>>>>>>>*/
//  学生信息显示
@RequestMapping("/showStudent")
public String showStudent(Model model, Integer page) throws Exception {

    List list = null;
    //页码对象
    PagingVO pagingVO = new PagingVO();
    //设置总页数pagingVO.setTotalCount(studentService.getCountStudent());
    if (page == null || page == 0) {
        pagingVO.setToPageNo(1);
        list = studentService.findByPaging(1);
    } else {
        pagingVO.setToPageNo(page);
        list = studentService.findByPaging(page);
    }
    model.addAttribute("studentList", list);
    model.addAttribute("pagingVO", pagingVO);

    return "admin/showStudent";
}
//  添加学生信息页面显示
@RequestMapping(value = "/addStudent", method = {RequestMethod.GET})
public String addStudentUI(Model model) throws Exception {
    List list = collegeService.finAll();
    model.addAttribute("collegeList", list);
    return "admin/addStudent";
}
 // 添加学生信息操作
@RequestMapping(value = "/addStudent", method = {RequestMethod.POST})
public String addStudent(StudentCustom studentCustom, Model model) throws Exception {
    Boolean result = studentService.save(studentCustom);
    if (!result) {
        model.addAttribute("message", "学号重复");
        return "error";
    }
    //添加成功后，也添加到登录表
    Userlogin userlogin = new Userlogin();
userlogin.setUsername(studentCustom.getUserid().toString());
    userlogin.setPassword("123");
    userlogin.setRole(2);
    userloginService.save(userlogin);
    //重定向
    return "redirect:/admin/showStudent";
}

// 修改学生信息页面显示
@RequestMapping(value = "/editStudent", method = {RequestMethod.GET})
public String editStudentUI(Integer id, Model model) throws Exception {
    if (id == null) {
        //加入没有带学生id就进来的话就返回学生显示页面
        return "redirect:/admin/showStudent";
    }
    StudentCustom studentCustom = studentService.findById(id);
    if (studentCustom == null) {
        throw new CustomException("未找到该名学生");
    }
    List list = collegeService.finAll()
    model.addAttribute("collegeList", list);
    model.addAttribute("student", studentCustom);
    return "admin/editStudent";
}
// 修改学生信息处理
@RequestMapping(value = "/editStudent", method = {RequestMethod.POST})
public String editStudent(StudentCustom studentCustom) throws Exception {
studentService.updataById(studentCustom.getUserid(), studentCustom);
    //重定向
    return "redirect:/admin/showStudent";
}
// 删除学生
@RequestMapping(value = "/removeStudent", method = {RequestMethod.GET} )
private String removeStudent(Integer id) throws Exception {
    if (id == null) {
        //加入没有带学生id就进来的话就返回学生显示页面
        return "admin/showStudent";
    }
    studentService.removeById(id);
    userloginService.removeByName(id.toString());

    return "redirect:/admin/showStudent";
}
// 搜索学生
@RequestMapping(value = "selectStudent", method = {RequestMethod.POST})
private String selectStudent(String findByName, Model model) throws Exception {
    List list = studentService.findByName(findByName);
    model.addAttribute("studentList", list);
    return "admin/showStudent";
}
/*<<<<<<<<<<<教师操作>>>>>>>>>>>>>*/
// 教师页面显示
@RequestMapping("/showTeacher")
public String showTeacher(Model model, Integer page) throws Exception {
    List list = null;
    //页码对象
    PagingVO pagingVO = new PagingVO();
    //设置总页数
pagingVO.setTotalCount(teacherService.getCountTeacher());
    if (page == null || page == 0) {
        pagingVO.setToPageNo(1);
        list = teacherService.findByPaging(1);
    } else {
        pagingVO.setToPageNo(page);
        list = teacherService.findByPaging(page);
    }
    model.addAttribute("teacherList", list);
    model.addAttribute("pagingVO", pagingVO);
    return "admin/showTeacher";
}
// 添加教师信息
@RequestMapping(value = "/addTeacher", method = {RequestMethod.GET})
public String addTeacherUI(Model model) throws Exception {
    List list = collegeService.finAll();
    model.addAttribute("collegeList", list)
    return "admin/addTeacher";
// 添加教师信息处理
@RequestMapping(value = "/addTeacher", method = {RequestMethod.POST})
public String addTeacher(TeacherCustom teacherCustom, Model model) throws Exception {
    Boolean result = teacherService.save(teacherCustom);
    if (!result) {
        model.addAttribute("message", "工号重复");
        return "error";
    }
    //添加成功后，也添加到登录表
    Userlogin userlogin = new Userlogin();
  userlogin.setUsername(teacherCustom.getUserid().toString());
    userlogin.setPassword("123");
    userlogin.setRole(1);
    userloginService.save(userlogin);
    //重定向
    return "redirect:/admin/showTeacher";
}
// 修改教师信息页面显示
@RequestMapping(value = "/editTeacher", method = {RequestMethod.GET})
public String editTeacherUI(Integer id, Model model) throws Exception {
    if (id == null) {
        return "redirect:/admin/showTeacher";
    }
    TeacherCustom teacherCustom = teacherService.findById(id);
    if (teacherCustom == null) {
        throw new CustomException("未找到该名学生");
    }
    List list = collegeService.finAll();
    model.addAttribute("collegeList", list);
    model.addAttribute("teacher", teacherCustom)
    return "admin/editTeacher";
}
// 修改教师信息页面处理
@RequestMapping(value = "/editTeacher", method = {RequestMethod.POST})
public String editTeacher(TeacherCustom teacherCustom) throws Exception {
teacherService.updateById(teacherCustom.getUserid(), teacherCustom);
    //重定向
    return "redirect:/admin/showTeacher";
}
//删除教师
@RequestMapping("/removeTeacher")
public String removeTeacher(Integer id) throws Exception {
    if (id == null) {
        //加入没有带教师id就进来的话就返回教师显示页面
        return "admin/showTeacher";
    }
    teacherService.removeById(id);
    userloginService.removeByName(id.toString());
    return "redirect:/admin/showTeacher";
}
//搜索教师
@RequestMapping(value = "selectTeacher", method = {RequestMethod.POST})
private String selectTeacher(String findByName, Model model) throws Exception {
    List list = teacherService.findByName(findByName);
    model.addAttribute("teacherList", list);
    return "admin/showTeacher";
}
/*<<<<<<<<课程操作>>>>>>>>>>>*/
// 课程信息显示
@RequestMapping("/showCourse")
public String showCourse(Model model, Integer page) throws Exception {
    List list = null;
    //页码对象
    PagingVO pagingVO = new PagingVO();
    //设置总页数
pagingVO.setTotalCount(courseService.getCountCouse());
    if (page == null || page == 0) {
        pagingVO.setToPageNo(1);
        list = courseService.findByPaging(1);
    } else {
        pagingVO.setToPageNo(page);
        list = courseService.findByPaging(page);
    }
    model.addAttribute("courseList", list);
    model.addAttribute("pagingVO", pagingVO);
    return "admin/showCourse";
}
//添加课程
@RequestMapping(value = "/addCourse", method = {RequestMethod.GET})
public String addCourseUI(Model model) throws Exception {
    List list = teacherService.findAll();
    List collegeList = collegeService.finAll();
    model.addAttribute("collegeList", collegeList);
    model.addAttribute("teacherList", list);
    return "admin/addCourse";
}
// 添加课程信息处理
@RequestMapping(value = "/addCourse", method = {RequestMethod.POST})
public String addCourse(CourseCustom courseCustom, Model model) throws Exception {
    Boolean result = courseService.save(courseCustom);
    if (!result) {
        model.addAttribute("message", "课程号重复");
        return "error";
    }
    //重定向
    return "redirect:/admin/showCourse";
}
// 修改教师信息页面显示
@RequestMapping(value = "/editCourse", method = {RequestMethod.GET})
public String editCourseUI(Integer id, Model model) throws Exception {
    if (id == null) {
        return "redirect:/admin/showCourse";
    }
    CourseCustom courseCustom = courseService.findById(id);
    if (courseCustom == null) {
        throw new CustomException("未找到该课程");
    }
    List list = teacherService.findAll();
    List collegeList = collegeService.finAll();

    model.addAttribute("teacherList", list);
    model.addAttribute("collegeList", collegeList);
    model.addAttribute("course", courseCustom);
    return "admin/editCourse";

// 修改教师信息页面处理
@RequestMapping(value = "/editCourse", method = {RequestMethod.POST})
public String editCourse(CourseCustom courseCustom) throws Exception {
courseService.upadteById(courseCustom.getCourseid(), courseCustom);
    //重定向
    return "redirect:/admin/showCourse";
}
// 删除课程信息
@RequestMapping("/removeCourse")
public String removeCourse(Integer id) throws Exception {
    if (id == null) {
        //加入没有带教师id就进来的话就返回教师显示页面
        return "admin/showCourse";
    }
    courseService.removeById(id);
    return "redirect:/admin/showCourse";
}
//搜索课程
@RequestMapping(value = "selectCourse", method = {RequestMethod.POST})
private String selectCourse(String findByName, Model model) throws Exception {

    List list = courseService.findByName(findByName);

    model.addAttribute("courseList", list);
    return "admin/showCourse";
}
/*<<<<<<<<<<<其他操作>>>>>>>>>>>>>>*/

// 普通用户账号密码重置
@RequestMapping("/userPasswordRest")
public String userPasswordRestUI() throws Exception {
    return "admin/userPasswordRest";
}

// 普通用户账号密码重置处理
@RequestMapping(value = "/userPasswordRest", method = {RequestMethod.POST})
public String userPasswordRest(Userlogin userlogin) throws Exception {
    Userlogin u = userloginService.findByName(userlogin.getUsername());
    if (u != null) {
        if (u.getRole() == 0) {
            throw new CustomException("该账户为管理员账户，没法修改");
        }
        u.setPassword(userlogin.getPassword());
        userloginService.updateByName(userlogin.getUsername(), u);
    } else {
        throw new CustomException("没找到该用户");
    }
    return "admin/userPasswordRest";
}
// 本账户密码重置
@RequestMapping("/passwordRest")
public String passwordRestUI() throws Exception {
    return "admin/passwordRest";