基于springboot +mybatis +thymeleaf 的学生信息管理系统

package com.wdd.studentmanager.controller; import com.wdd.studentmanager.domain.Score; import com.wdd.studentmanager.domain.ScoreStats; import com.wdd.studentmanager.domain.Student; import com.wdd.studentmanager.service.CourseService; import com.wdd.studentmanager.service.ScoreService; import com.wdd.studentmanager.service.SelectedCourseService; import com.wdd.studentmanager.service.StudentService; import com.wdd.studentmanager.util.AjaxResult; import com.wdd.studentmanager.util.Const; import com.wdd.studentmanager.util.PageBean; import org.apache.poi.xssf.usermodel.XSSFCell; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.util.StringUtils; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import java.io.IOException; import java.io.InputStream; import java.net.URLEncoder; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; /** * @Classname ScoreController * @Description 成绩控制器 * @Date 2019/7/3 11:38 * @Created by WDD */ @Controller @RequestMapping("/score") public class ScoreController { @Autowired private ScoreService scoreService; @Autowired private StudentService studentService; @Autowired private CourseService courseService; @Autowired private SelectedCourseService selectedCourseService; @GetMapping("/score_list") public String scoreList(){ return "/score/scoreList"; } /** * 异步加载成绩数据列表 * @param page * @param rows * @param studentid * @param courseid * @param from * @param session * @return */ @RequestMapping("/getScoreList") @ResponseBody public Object getScoreList(@RequestParam(value = "page", defaultValue = "1")Integer page, @RequestParam(value = "rows", defaultValue = "100")Integer rows, @RequestParam(value = "studentid", defaultValue = "0")String studentid, @RequestParam(value = "courseid", defaultValue = "0")String courseid, String from, HttpSession session){ Map<String,Object> paramMap = new HashMap(); paramMap.put("pageno",page); paramMap.put("pagesize",rows); if(!studentid.equals("0")) paramMap.put("studentid",studentid); if(!courseid.equals("0")) paramMap.put("courseid",courseid); //判断是老师还是学生权限 Student student = (Student) session.getAttribute(Const.STUDENT); if(!StringUtils.isEmpty(student)){ //是学生权限，只能查询自己的信息 paramMap.put("studentid",student.getId()); } PageBean<Score> pageBean = scoreService.queryPage(paramMap); if(!StringUtils.isEmpty(from) && from.equals("combox")){ return pageBean.getDatas(); }else{ Map<String,Object> result = new HashMap(); result.put("total",pageBean.getTotalsize()); result.put("rows",pageBean.getDatas()); return result; } } /** * 添加成绩 * @param score * @return */ @PostMapping("/addScore") @ResponseBody public AjaxResult addScore(Score score){ AjaxResult ajaxResult = new AjaxResult(); //判断是否已录入成绩 if(scoreService.isScore(score)){ //true为已签到 ajaxResult.setSuccess(false); ajaxResult.setMessage("已录入，请勿重复录入！"); }else{ int count = scoreService.addScore(score); if(count > 0){ //签到成功 ajaxResult.setSuccess(true); ajaxResult.setMessage("录入成功"); }else{ ajaxResult.setSuccess(false); ajaxResult.setMessage("系统错误，请重新录入"); } } return ajaxResult; } /** * 修改学生成绩 * @param score * @return */ @PostMapping("/editScore") @ResponseBody public AjaxResult editScore(Score score){ AjaxResult ajaxResult = new AjaxResult(); try { int count = scoreService.editScore(score); if(count > 0){ //签到成功 ajaxResult.setSuccess(true); ajaxResult.setMessage("修改成功"); }else{ ajaxResult.setSuccess(false); ajaxResult.setMessage("系统错误，请重新修改"); } } catch (Exception e) { e.printStackTrace(); ajaxResult.setSuccess(false); ajaxResult.setMessage("系统错误，请重新修改"); } return ajaxResult; } /** * 删除学生成绩 * @param id * @return */ @PostMapping("/deleteScore") @ResponseBody public AjaxResult deleteScore(Integer id){ AjaxResult ajaxResult = new AjaxResult(); try { int count = scoreService.deleteScore(id); if(count > 0){ ajaxResult.setSuccess(true); ajaxResult.setMessage("删除成功"); }else{ ajaxResult.setSuccess(false); ajaxResult.setMessage("系统错误，请重新删除"); } } catch (Exception e) { e.printStackTrace(); ajaxResult.setSuccess(false); ajaxResult.setMessage("系统错误，请重新删除"); } return ajaxResult; } /** * 导入xlsx表 并存入数据库 * @param importScore * @param response */ @PostMapping("/importScore") @ResponseBody public void importScore(@RequestParam("importScore") MultipartFile importScore, HttpServletResponse response){ response.setCharacterEncoding("UTF-8"); try { InputStream inputStream = importScore.getInputStream(); XSSFWorkbook xssfWorkbook = new XSSFWorkbook(inputStream); XSSFSheet sheetAt = xssfWorkbook.getSheetAt(0); int count = 0; String errorMsg = ""; for(int rowNum = 1; rowNum <= sheetAt.getLastRowNum(); rowNum++){ XSSFRow row = sheetAt.getRow(rowNum); // 获取第rowNum行 //第0列 XSSFCell cell = row.getCell(0); // 获取第rowNum行的第0列 即坐标（rowNum，0） if(cell == null){ errorMsg += "第" + rowNum + "行学生缺失！\n"; continue; } //第1列 cell = row.getCell(1); if(cell == null){ errorMsg += "第" + rowNum + "行课程缺失！\n"; continue; } //第2列 cell = row.getCell(2); if(cell == null){ errorMsg += "第" + rowNum + "行成绩缺失！\n"; continue; } double scoreValue = cell.getNumericCellValue(); //第3列 cell = row.getCell(3); String remark = null; if(cell != null){ remark = cell.getStringCellValue(); } //将学生，课程转换为id,存入数据库 // 1)首先获取对应的id int studentId = studentService.findByName(row.getCell(0).getStringCellValue()); int courseId = courseService.findByN