基于Springboot+mybatis+mysql+html教育培训中心教学系统

package com.chenxiufang.bishe.cxf.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.chenxiufang.bishe.cxf.entity.*; import com.chenxiufang.bishe.cxf.service.*; import com.chenxiufang.bishe.entity.User; import com.chenxiufang.bishe.mapper.QuestionMapper; import com.chenxiufang.bishe.service.UserService; import com.chenxiufang.bishe.util.jasper.PageUtil; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.http.HttpHeaders; import org.springframework.http.HttpStatus; import org.springframework.http.ResponseEntity; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.util.CollectionUtils; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.ServletContext; import javax.servlet.http.HttpSession; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; /** * <p> * 前端控制器 * </p> * * @author chenxiufang * @since 2022-03-09 */ @Controller public class StudentController { public static final String DEFAULT_PASSWORD = "111111"; public static final String FILE_DIRECTORY = "fileDirectory"; @Autowired private StudentService studentService; @Autowired private TeacherService teacherService; @Autowired private ManagerService managerService; @Autowired private CourseService courseService; @Autowired private UserService userService; @Autowired private HttpSession httpSession; @Autowired private AuditService auditService; @Autowired private QuestionService questionService; @Autowired private AttendanceService attendanceService; @Autowired private WorkService workService; @Autowired private CourseSelectionService courseSelectionService; @Autowired private WorkFinishService workFinishService; @Autowired private ItemService itemService; @Autowired private NewsService newsService; @Autowired private RedisTemplate redisTemplate; @Autowired private RoomService roomService; // 学生信息管理的分页 @GetMapping("/user/studentManage_{pageCurrent}_{pageSize}_{pageCount}") public String itemManage(@PathVariable Integer pageCurrent, @PathVariable Integer pageSize, @PathVariable Integer pageCount, Model model) { if (pageSize == 0) pageSize = 20; if (pageCurrent == 0) pageCurrent = 1; Page<Student> page = new Page<>(pageCurrent, pageSize); // wrapper是后面用来查询的条件 final QueryWrapper<Student> wrapper = new QueryWrapper<>(); wrapper.orderByDesc("student_id"); studentService.page(page, wrapper); //调用方法时候，底层封装，把分页所有数据封装到pageTeacher对象里面 long total = page.getTotal();//总记录数 List<Student> studentList = page.getRecords(); //数据list集合 int rows = studentService.count(null); if (pageCount == 0) pageCount = rows % pageSize == 0 ? (rows / pageSize) : (rows / pageSize) + 1; model.addAttribute("studentList", studentList); String pageHTML = PageUtil.getPageContent("studentManage_{pageCurrent}_{pageSize}_{pageCount}", pageCurrent, pageSize, pageCount); model.addAttribute("pageHTML", pageHTML); return "cxf/studentManage"; } // 教师信息管理的分页 @GetMapping("/user/teacherManage_{pageCurrent}_{pageSize}_{pageCount}") public String teacherManage(@PathVariable Integer pageCurrent, @PathVariable Integer pageSize, @PathVariable Integer pageCount, Model model) { if (pageSize == 0) pageSize = 20; if (pageCurrent == 0) pageCurrent = 1; Page<Teacher> page = new Page<>(pageCurrent, pageSize); final QueryWrapper<Teacher> wrapper = new QueryWrapper<>(); wrapper.orderByAsc("teacher_id"); teacherService.page(page, wrapper); long total = page.getTotal(); List<Teacher> studentList = page.getRecords(); //数据list集合 int rows = teacherService.count(null); if (pageCount == 0) pageCount = rows % pageSize == 0 ? (rows / pageSize) : (rows / pageSize) + 1; model.addAttribute("teacherList", studentList); String pageHTML = PageUtil.getPageContent("teacherManage_{pageCurrent}_{pageSize}_{pageCount}", pageCurrent, pageSize, pageCount); model.addAttribute("pageHTML", pageHTML); return "cxf/teacherManage"; } // 管理员信息的分页 @GetMapping("/user/managerManage_{pageCurrent}_{pageSize}_{pageCount}") public String manageManage(@PathVariable Integer pageCurrent, @PathVariable Integer pageSize, @PathVariable Integer pageCount, Model model) { if (pageSize == 0) pageSize = 20; if (pageCurrent == 0) pageCurrent = 1; Page<Manager> page = new Page<>(pageCurrent, pageSize); final QueryWrapper<Manager> wrapper = new QueryWrapper<>(); wrapper.orderByAsc("manager_id"); managerService.page(page, wrapper); long total = page.getTotal(); List<Manager> studentList = page.getRecords(); //数据list集合 int rows = managerService.count(null); if (pageCount == 0) pageCount = rows % pageSize == 0 ? (rows / pageSize) : (rows / pageSize) + 1; model.addAttribute("managerList", studentList); String pageHTML = PageUtil.getPageContent("managerManage_{pageCurrent}_{pageSize}_{pageCount}", pageCurrent, pageSize, pageCount); model.addAttribute("pageHTML", pageHTML); return "cxf/managerManage"; } // get请求响应添加学生的页面 @GetMapping("/user/addStudent") public String addStudent( Model model) { return "cxf/addStudent"; } // get请求添加器材的教室界面 @GetMapping("/user/addItem") public String addItem( Model model, @RequestParam Integer roomId) { Room room = roomService.getById(roomId); List<Manager> list = managerService.list(null); model.addAttribute("managerList", list); model.addAttribute("item", new Item()); model.addAttribute("roomId",roomId); return "cxf/addItem"; } // post请求选择哪一间教室添加器材 @PostMapping("/user/addItem") public String addItemPost(Model model, Item item, HttpSession httpSession) { User user = (User)httpSession.getAttribute("user"); item.setManagerId(user.getUniqueId()); item.setStatus(2); item.setBeginTime(new Date()); itemService.save(item); return "redirect:itemManage_0_0_0/" + item.getRoomId(); } // get请求响应添加教师的页面 @GetMapping("/user/addTeacher") public String addTeacher(Model model) { return "cxf/addTeacher"; } // post请求 @PostMapping("/user/addStudent") public String userManagePost(Model model, Student student, HttpSession httpSession) { studentService.save(student); User user = new User(); user.setUserName(student.getName()); user.setPassword(DEFAULT_PASSWORD);