基于java的驾考系统(SSM)

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.taohan.online.exam.po.*; import com.taohan.online.exam.service.*; /** * * <p>Title: StudentInfoHandler</p> * <p>Description: </p> * @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); @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; } @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; } @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"; } @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"; } @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; } @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()); } } @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/suc"); model.addObject("success", "密码错误"); return model; } request.getSession().setAttribute("loginStudent", loginStudent); model.setViewName("reception/suc"); model.addObject("success", "登录成功"); return model; } /** * 退出登录 * @param session * @return */ @RequestMapping("/exit") public String studentClearLogin(HttpSession session) { StudentInfo studnet = (StudentInfo) session.getAttribute("loginStudent"); logger.info("学员 "+studnet.getStudentName()+", 编号 "+studnet.getStudentId()+" 退出登录"); session.removeAttribute("loginStudent"); return "redirect:index.jsp"; } @RequestMapping("/validateAccount") public void validateRegisterAccount(@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("t"); } else { logger.error("注册学员