devbox
我家自动化
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Java项目:考试在线报名管理系统(java+SSM+HTML+JS+jsp+mysql)_搭建报名系统 csdn

作者：我家自动化 | 2024-04-25 14:47:37

赞

踩

搭建报名系统 csdn

源码获取：俺的博客首页 "资源" 里下载！

项目介绍

考务管理员角色包含以下功能：
考务管理员登录,教务办公室管理,考场管理,考试管理,考场分配管理,报名管理等功能。

管理员角色包含以下功能：
管理员登录,学院管理,班级管理,学生管理,考务管理员管理,管理员管理等功能。

学生角色包含以下功能：
学生登录,查看我的报名,报名考试,密码修改,缴费等功能。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 
5.数据库：MySql 5.7版本；


技术栈

1. 后端：Spring+SpringMVC+Mybatis
2. 前端：HTML+CSS+JavaScript+jsp


使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
3. 将项目中application.yml配置文件中的数据库配置改为自己的配置;
4. 运行项目，输入localhost:8080/ 登录

 

 

 

 

 

学生考试信息管理控制层：

  1. @Controller
  2. public class StudentExamInfoHandler {
  3.  
  4. 	@Autowired
  5. 	private StudentExamInfoService studentExamInfoService;
  6. 	@Autowired
  7. 	private ClassInfoService classInfoService;
  8. 	@Autowired
  9. 	private StudentInfoService studentInfoService;
  10. 	@Autowired
  11. 	private Gson gson;
  12.  
  13. 	private Logger logger = Logger.getLogger(StudentExamInfoHandler.class);
  14.  
  15. 	/**
  16. 	 * 所有学生考试信息 图表 Json 字符串生成
  17. 	 * 
  18. 	 * @param teacherId
  19. 	 * @param response
  20. 	 * @throws IOException
  21. 	 */
  22. 	@RequestMapping("/examCount")
  23. 	public void getStudentExamCount(@RequestParam("tid") Integer teacherId, HttpServletResponse response)
  24. 			throws IOException {
  25. 		if (teacherId == null) {
  26. 			response.getWriter().print("TID-NULL");
  27. 		} else {
  28. 			// 获取当前班主任对应的班级
  29. 			ClassInfo classInfo = classInfoService.getClassByTeacherId(teacherId);
  30. 			// 获取学生考试信息
  31. 			List<StudentExamInfo> stuExamInfos = studentExamInfoService
  32. 					.getStudentExamCountByClassId(classInfo.getClassId());
  33.  
  34. 			response.getWriter().print(StudentExamInfoCharts.createExamCountBarJson(stuExamInfos));
  35. 		}
  36. 	}
  37.  
  38. 	/**
  39. 	 * 获取班级中的所有学生
  40. 	 * 
  41. 	 * @param teacherId
  42. 	 * @param response
  43. 	 * @throws IOException
  44. 	 */
  45. 	@RequestMapping("/stus")
  46. 	public void getStudentsByClassId(@RequestParam("tid") Integer teacherId, HttpServletResponse response)
  47. 			throws IOException {
  48. 		if (teacherId == null) {
  49. 			response.getWriter().print("TID-NULL");
  50. 		} else {
  51. 			// 获取当前班主任对应的班级
  52. 			ClassInfo classInfo = classInfoService.getClassByTeacherId(teacherId);
  53. 			// 获取所有学生信息
  54. 			List<StudentInfo> stus = studentInfoService.getStudentsByClassId(classInfo.getClassId());
  55.  
  56. 			response.getWriter().print(gson.toJson(stus));
  57. 		}
  58. 	}
  59.  
  60. 	/**
  61. 	 * 班级下所有学生考试平均分等信息 图表 Json 生成
  62. 	 * 
  63. 	 * @param teacherId
  64. 	 * @param response
  65. 	 * @throws IOException
  66. 	 */
  67. 	@RequestMapping("/avgcounts")
  68. 	public void getAllStudentAvgScoreCount(@RequestParam("tid") Integer teacherId, HttpServletResponse response)
  69. 			throws IOException {
  70. 		if (teacherId == null) {
  71. 			response.getWriter().print("TID-NULL");
  72. 		} else {
  73. 			// 获取当前班主任对应的班级
  74. 			ClassInfo classInfo = classInfoService.getClassByTeacherId(teacherId);
  75. 			// 获取所有学生信息 平局分等信息
  76. 			List<StudentExamInfo> stuExamInfos = studentExamInfoService
  77. 					.getAllStudentAvgScoreCount(classInfo.getClassId());
  78.  
  79. 			response.getWriter().print(StudentExamInfoCharts.createAvgCountLineJson(stuExamInfos));
  80. 		}
  81. 	}
  82.  
  83. 	@RequestMapping("/stuexam")
  84. 	public void getStudentExamInfoById(@RequestParam("stuId") Integer studentId, HttpServletResponse response)
  85. 			throws IOException {
  86. 		// 获取学生考试信息
  87. 		List<StudentExamInfo> stuExamInfos = studentExamInfoService.getStudentExamInfo(studentId);
  88.  
  89. 		response.getWriter().print(StudentExamInfoCharts.createStudentExamLineJson(stuExamInfos));
  90. 	}
  91. }

班级管理控制层：

  1. @Controller
  2. @SuppressWarnings("all")
  3. public class ClassInfoHandler {
  4.  
  5. 	@Autowired
  6. 	private ClassInfoService classInfoService;
  7. 	@Autowired
  8. 	private GradeInfoService gradeInfoService;
  9. 	@Autowired
  10. 	private TeacherInfoService teacherInfoService;
  11. 	@Autowired
  12. 	private TeacherInfo teacher;
  13. 	@Autowired
  14. 	private ClassInfo classInfo;
  15. 	@Autowired
  16. 	private Gson gson;
  17.  
  18. 	private Logger logger = Logger.getLogger(ClassInfoHandler.class);
  19.  
  20. 	/**
  21. 	 * 获取所有班级
  22. 	 * 
  23. 	 * @param gradeId
  24. 	 *            系部编号
  25. 	 * @param className
  26. 	 *            班级名称 可用于模糊查询
  27. 	 * @param classId
  28. 	 *            班级编号
  29. 	 * @return
  30. 	 */
  31. 	@RequestMapping(value = "/classes", method = RequestMethod.GET)
  32. 	public ModelAndView getClasses(@RequestParam(value = "gradeId", required = false) Integer gradeId,
  33. 			@RequestParam(value = "className", required = false) String className,
  34. 			@RequestParam(value = "classId", required = false) Integer classId) {
  35. 		ModelAndView model = new ModelAndView();
  36. 		ClassInfo classInfo = new ClassInfo();
  37. 		/* 处理查询条件 */
  38. 		if (gradeId != null) {
  39. 			GradeInfo gradeInfo = new GradeInfo();
  40. 			gradeInfo.setGradeId(gradeId);
  41. 			classInfo.setGrade(gradeInfo);
  42. 		}
  43. 		if (classId != null)
  44. 			classInfo.setClassId(classId);
  45. 		if (className != null) {
  46. 			if (className.trim() != "")
  47. 				classInfo.setClassName(className);
  48. 		}
  49.  
  50. 		List<ClassInfo> classes = classInfoService.getClasses(classInfo);
  51. 		model.setViewName("admin/clazz/classes");
  52. 		model.addObject("classes", classes);
  53.  
  54. 		return model;
  55. 	}
  56.  
  57. 	/**
  58. 	 * 预添加班级处理
  59. 	 * 
  60. 	 * @return
  61. 	 */
  62. 	@RequestMapping("/preAddClass")
  63. 	public ModelAndView preAddClass(@RequestParam(name = "gid",required = false,defaultValue = "")Integer gid) {
  64.  
  65. 		ModelAndView model = new ModelAndView();
  66. 		// 获取系部信息
  67. 		List<GradeInfo> grades = gradeInfoService.getGrades();
  68. 		model.setViewName("admin/clazz/classedit");
  69. 		model.addObject("grades", grades);
  70. 		// 获取不是班主任的教师
  71. 		teacher.setIsWork(0);
  72. 		Map<String, Object> map = new HashMap<String, Object>();
  73. 		map.put("startIndex", null);
  74. 		map.put("pageShow", null);
  75. 		map.put("teacher", teacher);
  76. 		List<TeacherInfo> teachers = teacherInfoService.getTeachers(map);
  77. 		model.addObject("teachers", teachers);
  78. 		model.addObject("editClass", new ClassInfo());
  79. 		model.addObject("gid",gid);
  80. 		return model;
  81. 	}
  82.  
  83. 	/**
  84. 	 * 添加班级
  85. 	 * 
  86. 	 * @param classInfo
  87. 	 *            班级信息
  88. 	 * @param request
  89. 	 * @return
  90. 	 */
  91. 	@RequestMapping(value = "/class", method = RequestMethod.POST)
  92. 	public String isAddClass(ClassInfo classInfo, HttpServletRequest request) {
  93. 		//判断班级名是否存在
  94. 		ClassInfo byClassName = classInfoService.findByClassName(classInfo.getClassName());
  95. 		if(byClassName!=null){
  96. 			request.setAttribute("error", "该班级名称已存在！");
  97. 			return "error";
  98. 		}
  99. 		// 修改教师班主任状态
  100. 		String returnMsg = isChangeTeacherWork(1, classInfo.getTeacher().getTeacherId());
  101. 		if (returnMsg != null) {
  102. 			request.setAttribute("error", "修改教师班主任状态 对应教师编号有误");
  103. 			return "error";
  104. 		}
  105.  
  106. 		// 添加
  107. 		int row = classInfoService.isAddClass(classInfo);
  108. 		if (row < 1) {
  109. 			request.setAttribute("error", "班级 " + classInfo.getClassName() + " 添加失败，请稍后再试！");
  110. 			return "error";
  111. 		}
  112.  
  113. 		return "redirect:/classes";
  114. 	}
  115.  
  116. 	/**
  117. 	 * 删除班级
  118. 	 * 
  119. 	 * @param classId
  120. 	 *            班级编号
  121. 	 * @param request
  122. 	 * @return
  123. 	 */
  124. 	@RequestMapping(value = "/del/class/{classId}", method = RequestMethod.DELETE)
  125. 	public String isDelClass(@PathVariable("classId") Integer classId, HttpServletRequest request) {
  126. 		logger.info("删除班级 " + classId);
  127.  
  128. 		// 将删除班级对于之前班主任改为 非班主任状态
  129. 		// 需要在删除班级之前修改，如果先删除了班级，再根据班级获取教师编号，就不能获取
  130. 		ClassInfo delClass = classInfoService.getClassById(classId);
  131. 		String returnMsg = isChangeTeacherWork(0, delClass.getTeacher().getTeacherId());
  132. 		if (returnMsg != null) {
  133. 			request.setAttribute("error", "修改教师班主任状态 对应教师编号有误");
  134. 			return "error";
  135. 		}
  136.  
  137. 		// 删除
  138. 		int row = classInfoService.isDelClass(classId);
  139. 		if (row < 1) {
  140. 			logger.error("班级 " + classId + " 删除失败");
  141.  
  142. 			request.setAttribute("error", "班级删除失败，请稍后再试！");
  143. 			return "../error";
  144. 		}
  145.  
  146. 		return "redirect:/classes";
  147. 	}
  148.  
  149. 	/**
  150. 	 * 预修改班级处理
  151. 	 * 
  152. 	 * @param classId
  153. 	 *            班级编号
  154. 	 * @return
  155. 	 */
  156. 	@RequestMapping(value = "edit/class/{classId}", method = RequestMethod.GET)
  157. 	public ModelAndView preUpdateClass(@PathVariable("classId") Integer classId) {
  158. 		logger.info("预修改班级处理");
  159.  
  160. 		ModelAndView model = new ModelAndView();
  161. 		// 获取要修改班级
  162. 		ClassInfo classInfo = classInfoService.getClassById(classId);
  163. 		model.setViewName("/admin/clazz/classedit");
  164. 		model.addObject("editClass", classInfo);
  165. 		List<GradeInfo> grades = gradeInfoService.getGrades();
  166. 		// 获取不是班主任的教师
  167. 		teacher.setIsWork(0);
  168. 		Map<String, Object> map = new HashMap<String, Object>();
  169. 		map.put("startIndex", null);
  170. 		map.put("pageShow", null);
  171. 		map.put("teacher", teacher);
  172. 		List<TeacherInfo> teachers = teacherInfoService.getTeachers(map);
  173. 		// 如果没有可用班主任
  174. 		if (teachers.size() == 0 || teachers == null) {
  175. 			teacher.setTeacherId(classInfo.getTeacher().getTeacherId());
  176. 			teacher.setTeacherName("暂无剩余教师");
  177. 			teachers.add(teacher);
  178. 		}
  179. 		model.addObject("teachers", teachers);
  180. 		model.addObject("grades", grades);
  181.  
  182. 		return model;
  183. 	}
  184.  
  185. 	/**
  186. 	 * 修改班级信息
  187. 	 * 
  188. 	 * @param classInfo
  189. 	 *            班级信息
  190. 	 * @param request
  191. 	 * @param lastTeacherId
  192. 	 *            上一个班主任编号，修改其 班主任状态
  193. 	 * @return
  194. 	 */
  195. 	@RequestMapping(value = "edit/class/class", method = RequestMethod.POST)
  196. 	public String isUpdateClass(ClassInfo classInfo, HttpServletRequest request,
  197. 			@RequestParam(value = "lastTeacher", required = false) Integer lastTeacherId) {
  198. 		ClassInfo byClassName = classInfoService.findByClassName(classInfo.getClassName());
  199. 		if(byClassName!=null){
  200. 			if(!byClassName.getClassId().equals(classInfo.getClassId())){
  201. 				request.setAttribute("error", "该班级名称已存在！");
  202. 				return "../../error";
  203. 			}
  204. 		}
  205. 		// 修改上一教师不为班主任状态
  206. 		if (lastTeacherId != null) {
  207. 			String returnMsg = isChangeTeacherWork(0, lastTeacherId);
  208. 			if (returnMsg != null) {
  209. 				request.setAttribute("error", "修改教师班主任状态 对应教师编号有误");
  210. 				return "../error";
  211. 			}
  212. 		}
  213. 		// 修改当前教师为班主任状态
  214. 		String returnMsg = isChangeTeacherWork(1, classInfo.getTeacher().getTeacherId());
  215. 		if (returnMsg != null) {
  216. 			request.setAttribute("error", "修改教师班主任状态 对应教师编号有误");
  217. 			return "../error";
  218. 		}
  219.  
  220. 		int row = classInfoService.isUpdateClass(classInfo);
  221. 		if (row < 1) {
  222. 			logger.error("班级 " + classInfo + " 修改失败");
  223.  
  224. 			request.setAttribute("error", "班级修改失败，请稍后再试！");
  225. 			return "../error";
  226. 		}
  227. 		return "redirect:/classes";
  228. 	}
  229.  
  230. 	/**
  231. 	 * 获取指定系部下的班级
  232. 	 * 
  233. 	 * @param gradeId
  234. 	 *            系部编号
  235. 	 * @param response
  236. 	 * @throws IOException
  237. 	 */
  238. 	@RequestMapping(value = "/gradeclass/{gradeId}", method = RequestMethod.GET)
  239. 	public void getClassesByGradeId(@PathVariable("gradeId") Integer gradeId, HttpServletResponse response)
  240. 			throws IOException {
  241. 		List<ClassInfo> classes = classInfoService.getClassByGradeId(gradeId);
  242. 		String json = gson.toJson(classes);
  243. 		response.getWriter().print(json);
  244. 	}
  245.  
  246. 	/**
  247. 	 * 修改教师(班主任)工作状态
  248. 	 * 
  249. 	 * @param status
  250. 	 *            是否为班主任标识
  251. 	 * @param teacherId
  252. 	 *            教师编号
  253. 	 */
  254. 	private String isChangeTeacherWork(int status, Integer teacherId) {
  255. 		teacher.setIsWork(status);
  256. 		if (teacherId == null) {
  257. 			logger.error("修改教师班主任状态 对应教师编号有误");
  258. 			return "修改教师班主任状态 对应教师编号有误";
  259. 		}
  260. 		teacher.setTeacherId(teacherId);
  261. 		int row = teacherInfoService.updateTeacherIsWork(teacher);
  262. 		return null;
  263. 	}
  264.  
  265. 	@RequestMapping("/stuCount")
  266. 	public void getStudentCountForClass(@RequestParam(value = "gradeId", required = false) Integer gradeId,
  267. 			HttpServletResponse response) throws IOException {
  268. 		Map<String, Object> map = classInfoService.getStudentCountForClass(gradeId);
  269. 		String json = StudentCount.createBarJson(map);
  270.  
  271. 		response.getWriter().print(json);
  272. 	}
  273.  
  274. 	/**
  275. 	 * 预添加班级处理
  276. 	 * 
  277. 	 * @return
  278. 	 */
  279. 	@RequestMapping("/preStudentCount")
  280. 	public ModelAndView preStudentCount() {
  281.  
  282. 		ModelAndView model = new ModelAndView();
  283. 		// 获取系部信息
  284. 		List<GradeInfo> grades = gradeInfoService.getGrades();
  285. 		model.setViewName("admin/charts/studentCount");
  286. 		model.addObject("grades", grades);
  287.  
  288. 		return model;
  289. 	}
  290.  
  291. }

科目管理控制层： 

  1. @Controller
  2. @SuppressWarnings("all")
  3. public class CourseInfoHandler {
  4. 	@Autowired
  5. 	private CourseInfoService courseInfoService;
  6. 	@Autowired
  7. 	private GradeInfoService gradeInfoService;
  8.  
  9. 	private Logger logger = Logger.getLogger(CourseInfoHandler.class);
  10.  
  11. 	/**
  12. 	 * 获取科目信息
  13. 	 * 
  14. 	 * @param gradeId
  15. 	 *            系部编号
  16. 	 * @param division
  17. 	 *            分科情况
  18. 	 * @return
  19. 	 */
  20. 	@RequestMapping("/courses")
  21. 	public ModelAndView getCourses(@RequestParam(value = "gradeId", required = false) Integer gradeId,
  22. 			@RequestParam(value = "division", required = false) Integer division) {
  23. 		ModelAndView model = new ModelAndView();
  24. 		model.setViewName("/admin/course/courses");
  25.  
  26. 		CourseInfo course = new CourseInfo();
  27. 		if (gradeId != null)
  28. 			course.getGrade().setGradeId(gradeId);
  29. 		if (division != null)
  30. 			course.setDivision(division);
  31. 		List<CourseInfo> courses = courseInfoService.getCourses(course);
  32. 		model.addObject("courses", courses);
  33.  
  34. 		return model;
  35. 	}
  36.  
  37. 	/**
  38. 	 * 根据科目编号获取学科信息
  39. 	 * 
  40. 	 * @param courseId
  41. 	 *            科目编号
  42. 	 * @return
  43. 	 */
  44. 	@RequestMapping("/course/{courseId}")
  45. 	public ModelAndView getCourseById(@PathVariable("courseId") Integer courseId) {
  46. 		ModelAndView model = new ModelAndView();
  47. 		model.setViewName("/admin/course/courseedit");
  48.  
  49. 		CourseInfo course = courseInfoService.getCourseById(courseId);
  50. 		model.addObject("course", course);
  51. 		/** 获取所有系部列表 */
  52. 		List<GradeInfo> grades = gradeInfoService.getGrades();
  53. 		model.addObject("grades", grades);
  54.  
  55. 		return model;
  56. 	}
  57.  
  58. 	/**
  59. 	 * 添加/修改科目信息
  60. 	 * 
  61. 	 * @param courseId
  62. 	 *            科目编号
  63. 	 * @param isUpdate
  64. 	 *            标识是否为修改操作
  65. 	 * @param courseName
  66. 	 *            科目名称
  67. 	 * @param division
  68. 	 *            分科情况
  69. 	 * @param gradeId
  70. 	 *            系部编号
  71. 	 * @return
  72. 	 */
  73. 	@RequestMapping(value = "/course/course", method = RequestMethod.POST)
  74. 	public String isUpdateOrAddCourse(@RequestParam(value = "courseId", required = false) Integer courseId,
  75. 			@RequestParam(value = "isupdate", required = false) Integer isUpdate,
  76. 			@RequestParam("courseName") String courseName, @RequestParam("division") Integer division,
  77. 			@RequestParam("gradeId") Integer gradeId) {
  78.  
  79. 		CourseInfo course = new CourseInfo();
  80. 		course.setCourseId(courseId);
  81. 		course.setCourseName(courseName);
  82. 		course.setDivision(division);
  83. 		GradeInfo grade = new GradeInfo();
  84. 		grade.setGradeId(gradeId);
  85. 		course.setGrade(grade);
  86. 		// 修改
  87. 		if (isUpdate != null) {
  88. 			int row = courseInfoService.isUpdateCourse(course);
  89. 		}
  90. 		// 添加
  91. 		else {
  92. 			int row = courseInfoService.isAddCourse(course);
  93. 		}
  94. 		return "redirect:/courses";
  95. 	}
  96.  
  97. 	/**
  98. 	 * 删除科目
  99. 	 * 
  100. 	 * @param courseId
  101. 	 *            待删除科目编号
  102. 	 * @return
  103. 	 */
  104. 	@RequestMapping(value = "/course/{courseId}", method = RequestMethod.DELETE)
  105. 	public String isDelTeacher(@PathVariable("courseId") Integer courseId) {
  106. 		int row = courseInfoService.isDelCourse(courseId);
  107. 		return "redirect:/courses";
  108. 	}
  109.  
  110. 	/**
  111. 	 * 预添加科目信息
  112. 	 * 
  113. 	 * @return
  114. 	 */
  115. 	@RequestMapping("/preAddCourse")
  116. 	public ModelAndView preAddCourse() {
  117. 		ModelAndView model = new ModelAndView();
  118. 		model.setViewName("/admin/course/courseedit");
  119. 		/** 获取系部集合 */
  120. 		List<GradeInfo> grades = gradeInfoService.getGrades();
  121. 		model.addObject("grades", grades);
  122. 		return model;
  123. 	}
  124. }

 源码获取：俺的博客首页 "资源" 里下载！

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家自动化/article/detail/485853
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号