jsp+ssm+mysql实现在线考试系统

package com.taohan.online.exam.handler; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import oracle.net.aso.l; import org.apache.log4j.Logger; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.*; import org.springframework.web.servlet.ModelAndView; import org.springframework.web.servlet.mvc.support.RedirectAttributes; import com.mysql.fabric.Response; import com.taohan.online.exam.po.*; import com.taohan.online.exam.service.*; /** * * <p>Title: StudentInfoHandler</p> * <p>Description: </p> * @author: taohan * @date: 2018-8-16 * @time: 上午10:22:22 * @version: 1.0 */ @Controller @SuppressWarnings("all") public class StudentInfoHandler { @Autowired private StudentInfoService studentInfoService; @Autowired private ClassInfoService classInfoService; @Autowired private ExamSubjectMiddleInfoService examSubjectMiddleInfoService; @Autowired private ExamHistoryPaperService examHistoryPaperService; @Autowired private ExamChooseInfoService examChooseInfoService; @Autowired private ExamSubjectMiddleInfo esm; @Autowired private ClassInfo classInfo; @Autowired private ExamPaperInfo examPaper; @Autowired private GradeInfo grade; @Autowired private StudentInfo student; @Autowired private ExamPaperInfoService examPaperInfoService; private Logger logger = Logger.getLogger(StudentInfoHandler.class); /** * 获取学生集合 * @param studentId 学生编号 * @param classId 班级编号 * @param gradeId 年级编号 * @param startPage 起始页 default=1 * @param pageShow 页容量 default=10 * @return */ @RequestMapping("/students") public ModelAndView getCourses(@RequestParam(value = "studentId", required = false) Integer studentId, @RequestParam(value = "classId", required = false) Integer classId, @RequestParam(value = "gradeId", required = false) Integer gradeId, @RequestParam(value="startPage", required=false, defaultValue="1") Integer startPage, @RequestParam(value="pageShow", required=false, defaultValue="10") Integer pageShow ) { logger.info("获取学生集合 classId="+classId+", gradeId="+gradeId+", startPage="+startPage+", pageShow="+pageShow); ModelAndView model = new ModelAndView(); model.setViewName("/admin/students"); //查询条件处理 StudentInfo student = new StudentInfo(); if (studentId != null) student.setStudentId(studentId); if (classId != null) { classInfo.setClassId(classId); student.setClassInfo(classInfo); } if (gradeId != null) { grade.setGradeId(gradeId); student.setGrade(grade); } Map<String, Object> map = new HashMap<String, Object>(); //计算当前查询起始数据索引 int startIndex = (startPage-1) * pageShow; map.put("student", student); map.put("startIndex", startIndex); map.put("pageShow", pageShow); List<StudentInfo> students = studentInfoService.getStudents(map); model.addObject("students", students); //获取学生总量 int studentTotal = studentInfoService.getStudentTotal(); //计算总页数 int pageTotal = 1; if (studentTotal % pageShow == 0) pageTotal = studentTotal / pageShow; else pageTotal = studentTotal / pageShow + 1; model.addObject("pageTotal", pageTotal); model.addObject("pageNow", startPage); return model; } /** * 根据编号获取学生信息 * @param studentId * @return */ @RequestMapping("/student/{studentId}") public ModelAndView getCourseById(@PathVariable("studentId") Integer studentId) { logger.info("获取学生 " + studentId); ModelAndView model = new ModelAndView(); model.setViewName("/admin/studentedit"); StudentInfo student = studentInfoService.getStudentById(studentId); model.addObject("student", student); List<ClassInfo> classes = classInfoService.getClasses(null); model.addObject("classes", classes); return model; } /** * 添加/修改学生信息 * @param studentId * @param isUpdate 操作标识 * @param studentName * @param studentAccount * @param studentPwd * @param classId * @return */ @RequestMapping(value = "/student/student", method = RequestMethod.POST) public String isUpdateOrAddCourse( @RequestParam(value = "studentId", required = false) Integer studentId, @RequestParam(value = "isupdate", required = false) Integer isUpdate, @RequestParam(value = "studentName", required = false) String studentName, @RequestParam("studentAccount") String studentAccount, @RequestParam("studentPwd") String studentPwd, @RequestParam("classId") Integer classId) { StudentInfo student = new StudentInfo(); student.setStudentId(studentId); student.setStudentName(studentName); student.setStudentAccount(studentAccount); student.setStudentPwd(studentPwd); classInfo.setClassId(classId); student.setClassInfo(classInfo); if (isUpdate != null) { logger.info("修改学生 " + student + " 的信息"); int row = studentInfoService.isUpdateStudent(student); } else { logger.info("添加学生 " + student + " 的信息"); int row = studentInfoService.isAddStudent(student); } return "redirect:/students"; } /** * 删除学生 * @param studentId * @return */ @RequestMapping(value = "/student/{studentId}", method = RequestMethod.DELETE) public String isDelTeacher(@PathVariable("studentId") Integer studentId) { logger.info("删除学生 " + studentId); int row = studentInfoService.isDelStudent(studentId); return "redirect:/students"; } /** * 预添加学生 * @return */ @RequestMapping("/preAddStudent") public ModelAndView preAddStudent() { logger.info("预添加学生信息"); ModelAndView model = new ModelAndView(); model.setViewName("/admin/studentedit"); List<ClassInfo> classes = classInfoService.getClasses(null); model.addObject("classes", classes); return model; } /** * 学生考试登录验证 * * 此处验证并不合理 登录验证实现如下： * 前台学生登录传入账户，后台根据账户获取学生密码 * 返回学生密码，前台登录焦点离开密码框使用 JavaScript 判断 * * @param studentAccount 学生登录账户 * @param response * @throws IOException */ @RequestMapping("/validateLoginStudent") public void validateLoginStudent(@RequestParam("studentAccount") String studentAccount, HttpServletResponse response) throws IOException { logger.info("学生账户 "+studentAccount+"，尝试登录考试"); //获取需要登录的学生对象 StudentInfo student = studentInfoService.getStudentByAccountAndPwd(studentAccount); if (student == null) { logger.error("登录学生账户 "+studentAccount+" 不存在"); response.getWriter().print("n"); } else { logger.error("登录学生账户 "+studentAccount+" 存在"); response.getWriter().print(student.getStudentPwd()); } } /** * 学生登录考试 * @param student 登录学生 * @param request * @return */ @RequestMapping(value="/studentLogin", method=RequestMethod.POST) public ModelAndView studentLogin(StudentInfo student, HttpServletRequest request) { ModelAndView model = new ModelAndView(); StudentInfo loginStudent = studentInfoService.getStudentByAccountAndPwd(student.getStudentAccount()); logger.info("学生 "+loginStudent+" 有效登录"); if(loginStudent == null || !student.getStudentPwd().equals(loginStudent.getStudentPwd())){ model.setViewName("reception/