• 基于SSM实现前后端分离在线考试管理系统

    作者主页：编程指南针

    作者简介：Java领域优质创作者、CSDN博客专家 、掘金特邀作者、多年架构师设计经验、腾讯课堂常驻讲师

    主要内容：Java项目、毕业设计、简历模板、学习资料、面试题库、技术互助

    文末获取源码 

    项目编号：BS-XX-105

    前言：

    互联网的普及给人们带来的便利不需多说。因此如果把题库及试卷管理系统与互联网结合起来，利用My Eclipse编程软件建设题库及试卷管理系统，实现题库及试卷管理系统的网络化。则对于进一步提高教学发展定能起到不少的促进作用。

    题库及试卷管理系统能够通过互联网得到广泛的、全面的宣传，让尽可能多的学校了解和熟知学校的题库及试卷管理系统服务等，不仅为学校提供了服务，而且也推广了自己，让更多的学生了解自己。对于学校而言，若拥有自己的题库及试卷管理系统，通过题库及试卷管理系统让学校的宣传、营销提上一个新台阶，同时提升了学校形象。

    根据本系统的研究现状和发展趋势，系统从需求分析、结构设计、数据库设计，在到系统实现，分别为前端实现和后端实现。论文内容从系统描述、系统分析、系统设计、系统实现、系统测试来阐述系统的开发过程。本系统力求结合实际找出一种切实可行的开发方案，经过反复研究和学习，借助My Eclipse编程软件、SSM技术、MySQL数据库和Tomcat服务器来完成系统的所有功能，最后进行系统测试，来检测系统的权限和漏洞，从而将系统完善，达到符合标准。

    一，项目简介

    本项目主要实现SSM开发框架实现在线考试管理系统，采用前后端分离的方式开发实现，基于接口实现前后端开发对接，后端服务系统主要实现的管理功能有：试题管理、试卷管理、考试管理、用户管理、数据字典管理、系统设置管理。前端用户服务实现的功能有：试题练习、在线考试、会员中心、统计知识掌握情况、统计分析各种考试数据等功能。整体功能比较强大，也比较完整。

    根据前面的各项设计分析，按照系统开发的基本理念对系统进行分解，从模块上主要可分为用户模块和管理员模块。

    用户模块只要是让普通用户使用，包括题库及试卷管理，成绩查询等功能，管理员模块只要是让管理员使用，包括学生信息管理、教师信息管理、试卷管理等功能，可以对数据进行添加、删除、修改及查询等操作。

    系统总体功能结构图如下图所示。

    根据前面的各项设计分析，按照系统开发的基本理念对系统进行分解，从模块上主要可分为用户模块和管理员模块。

    用户模块只要是让普通用户使用，包括题库及试卷管理，成绩查询等功能，管理员模块只要是让管理员使用，包括学生信息管理、教师信息管理、试卷管理等功能，可以对数据进行添加、删除、修改及查询等操作。

    系统总体功能结构图如下图所示。

    二，环境介绍

    语言环境：Java:  jdk1.8

    数据库：Mysql: mysql5.7

    应用服务器：Tomcat:  tomcat8.5.31

    开发工具：IDEA或eclipse

    后台开发技术：SSM框架+SpringSecurity安全框架

    前台开发技术：Bootstrap+Ajax

    三，系统展示

    后台管理界面：

    管理首页

    试题管理

    试题添加

    试卷管理

    创建试卷

    考试管理

    用户管理

    通用数据管理

    系统设置

    教师登陆系统

    试卷管理

    前端用户服务系统

    试题练习

    答题模式

    背题模式

    在线考试

    在线考试

    会员中心

    个人设置

    四，核心代码展示

    1. package com.examstack.management.controller.action;
    2.  
    3. import java.util.ArrayList;
    4. import java.util.List;
    5.  
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.security.core.context.SecurityContextHolder;
    8. import org.springframework.stereotype.Controller;
    9. import org.springframework.ui.Model;
    10. import org.springframework.web.bind.annotation.PathVariable;
    11. import org.springframework.web.bind.annotation.RequestMapping;
    12. import org.springframework.web.bind.annotation.RequestMethod;
    13. import org.springframework.web.bind.annotation.ResponseBody;
    14.  
    15. import com.examstack.common.domain.exam.ExamHistory;
    16. import com.examstack.common.domain.exam.ExamPaper;
    17. import com.examstack.common.domain.question.PointStatistic;
    18. import com.examstack.common.domain.question.Question;
    19. import com.examstack.common.domain.question.QuestionFilter;
    20. import com.examstack.common.domain.user.User;
    21. import com.examstack.common.util.Page;
    22. import com.examstack.management.security.UserInfo;
    23. import com.examstack.management.service.ExamPaperService;
    24. import com.examstack.management.service.ExamService;
    25. import com.examstack.management.service.QuestionService;
    26. import com.examstack.management.service.UserService;
    27.  
    28. @Controller
    29. public class DashBoardAction {
    30. 	
    31. 	@Autowired
    32. 	private QuestionService questionService;
    33. 	@Autowired
    34. 	private UserService userService;
    35. 	@Autowired
    36. 	private ExamPaperService examPaperService;
    37. 	@Autowired
    38. 	private ExamService examService;
    39. 	@RequestMapping(value = "/secure/dashboard/baseinfo", method = RequestMethod.GET)
    40. 	public @ResponseBody List baseInfo(Model model) {
    41. 		
    42. 		UserInfo userInfo = (UserInfo) SecurityContextHolder.getContext()
    43. 			    .getAuthentication()
    44. 			    .getPrincipal();
    45. 		Page pageUser = new Page();
    46. 		pageUser.setPageNo(1);
    47. 		pageUser.setPageSize(1);
    48. 		userService.getUserListByRoleId(userInfo.getRoleMap().get("ROLE_STUDENT").getRoleId(), pageUser);
    49. 		
    50. 		Page pageQuestion = new Page();
    51. 		pageQuestion.setPageNo(1);
    52. 		pageQuestion.setPageSize(1);
    53. 		QuestionFilter qf = new QuestionFilter();
    54. 		qf.setFieldId(0);
    55. 		qf.setKnowledge(0);
    56. 		qf.setQuestionType(0);
    57. 		qf.setTag(0);
    58. 		qf.setSearchParam("-1");
    59. 		questionService.getQuestionList(pageQuestion, qf);
    60. 		
    61. 		Page pageExamPaper = new Page();
    62. 		pageExamPaper.setPageNo(1);
    63. 		pageExamPaper.setPageSize(1);
    64. 		examPaperService.getEnabledExamPaperList(userInfo.getUsername(), pageExamPaper);
    65. 		List l = new ArrayList();
    66. 		l.add(pageQuestion.getTotalRecord());
    67. 		l.add(pageExamPaper.getTotalRecord());
    68. 		l.add(pageUser.getTotalRecord());
    69. 		return l;
    70. 	}
    71.  
    72. 	@RequestMapping(value = "/secure/dashboard/studentApprovedList", method = RequestMethod.GET)
    73. 	public @ResponseBody List studentApprovedList(Model model) {
    74. 		Page page = new Page();
    75. 		page.setPageNo(1);
    76. 		page.setPageSize(4);
    77. 		List histList = examService.getUserExamHistList(page, 0);
    78. 		
    79. 		return histList;
    80. 	}
    81.  
    82. 	@RequestMapping(value = "/secure/dashboard/StudentMarkList", method = RequestMethod.GET)
    83. 	public @ResponseBody List studentMarkList(Model model) {
    84. 		Page page = new Page();
    85. 		page.setPageNo(1);
    86. 		page.setPageSize(4);
    87. 		List histList = examService.getUserExamHistList(page, 2);
    88. 		
    89. 		return histList;
    90. 	}
    91.  
    92. 	@RequestMapping(value = "/secure/dashboard/chartinfo/{fieldId}", method = RequestMethod.GET)
    93. 	public @ResponseBody List chartInfo(Model model,@PathVariable("fieldId") int fieldId) {
    94.  
    95. 		List pointStatisticList = questionService.getPointCount(fieldId, null);
    96. 		List l = new ArrayList();
    97. 		
    98. 		for(PointStatistic ps : pointStatisticList){
    99. 			FieldNumber fieldNumber = new FieldNumber();
    100. 			fieldNumber.name = ps.getPointName();
    101. 			fieldNumber.amount = ps.getAmount();
    102. 			l.add(fieldNumber);
    103. 		}
    104. 		
    105. 		return l;
    106. 	}
    107. 	
    108. 	
    109. 	class FieldNumber{
    110. 		private String name;
    111. 		private int amount;
    112. 		public String getName() {
    113. 			return name;
    114. 		}
    115. 		public void setName(String name) {
    116. 			this.name = name;
    117. 		}
    118. 		public int getAmount() {
    119. 			return amount;
    120. 		}
    121. 		public void setAmount(int amount) {
    122. 			this.amount = amount;
    123. 		}
    124. 		
    125. 	}
    126.  
    127. }
    1. package com.examstack.management.controller.action;
    2.  
    3. import java.util.List;
    4.  
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.web.bind.annotation.PathVariable;
    8. import org.springframework.web.bind.annotation.RequestBody;
    9. import org.springframework.web.bind.annotation.RequestMapping;
    10. import org.springframework.web.bind.annotation.RequestMethod;
    11. import org.springframework.web.bind.annotation.ResponseBody;
    12.  
    13. import com.examstack.common.domain.exam.AnswerSheet;
    14. import com.examstack.common.domain.exam.AnswerSheetItem;
    15. import com.examstack.common.domain.exam.ExamPaper;
    16. import com.examstack.common.domain.exam.Message;
    17. import com.examstack.management.service.ExamPaperService;
    18. import com.examstack.management.service.ExamService;
    19. import com.google.gson.Gson;
    20.  
    21. @Controller
    22. public class ExamAction {
    23. 	@Autowired
    24. 	private ExamPaperService examPaperService;
    25. 	@Autowired
    26. 	private ExamService examService;
    27. 	@RequestMapping(value = "/api/exampaper/{id}", method = RequestMethod.GET)
    28. 	public @ResponseBody ExamPaper getExamPaper(@PathVariable("id") int id){
    29. 		ExamPaper paper = examPaperService.getExamPaperById(id);
    30. 		return paper;
    31. 	}
    32. 	
    33. 	@RequestMapping(value = "/api/answersheet", method = RequestMethod.POST)
    34. 	public @ResponseBody Message submitAnswerSheet(@RequestBody AnswerSheet answerSheet){
    35.  
    36. 		List itemList = answerSheet.getAnswerSheetItems();
    37. 		
    38. 		//全部是客观题，则状态更改为已阅卷
    39. 		int approved = 3;
    40. 		for(AnswerSheetItem item : itemList){
    41. 			if(item.getQuestionTypeId() != 1 && item.getQuestionTypeId() != 2 && item.getQuestionTypeId() != 3){
    42. 				approved = 2;
    43. 				break;
    44. 			}
    45. 		}
    46. 		Gson gson = new Gson();		
    47. 		examService.updateUserExamHist(answerSheet, gson.toJson(answerSheet),approved);
    48. 		
    49. 		return new Message();
    50. 	}
    51. 	
    52. }
    1. package com.examstack.management.controller.action;
    2.  
    3. import java.io.FileNotFoundException;
    4. import java.util.ArrayList;
    5. import java.util.Date;
    6. import java.util.HashMap;
    7. import java.util.List;
    8.  
    9. import javax.servlet.http.HttpServletRequest;
    10. import javax.servlet.http.HttpServletResponse;
    11.  
    12. import org.springframework.beans.factory.annotation.Autowired;
    13. import org.springframework.security.core.context.SecurityContextHolder;
    14. import org.springframework.security.core.userdetails.UserDetails;
    15. import org.springframework.stereotype.Controller;
    16. import org.springframework.ui.Model;
    17. import org.springframework.web.bind.annotation.PathVariable;
    18. import org.springframework.web.bind.annotation.RequestBody;
    19. import org.springframework.web.bind.annotation.RequestMapping;
    20. import org.springframework.web.bind.annotation.RequestMethod;
    21. import org.springframework.web.bind.annotation.ResponseBody;
    22.  
    23. import com.examstack.common.domain.exam.Message;
    24. import com.examstack.common.domain.question.KnowledgePoint;
    25. import com.examstack.common.domain.question.Question;
    26. import com.examstack.common.domain.question.QuestionTag;
    27. import com.examstack.common.util.file.FileUploadUtil;
    28. import com.examstack.management.security.UserInfo;
    29. import com.examstack.management.service.QuestionService;
    30. import com.google.gson.Gson;
    31. import com.google.gson.JsonElement;
    32. import com.google.gson.JsonParser;
    33. import com.google.gson.reflect.TypeToken;
    34.  
    35. @Controller
    36. public class QuestionAction {
    37.  
    38. 	@Autowired
    39. 	private QuestionService questionService;
    40.  
    41. 	/**
    42. 	 * 添加试题
    43. 	 * 
    44. 	 * @param question
    45. 	 * @return
    46. 	 */
    47. 	@RequestMapping(value = "/secure/question/question-add", method = RequestMethod.POST)
    48. 	public @ResponseBody Message addQuestion(@RequestBody Question question) {
    49.  
    50. 		UserDetails userDetails = (UserDetails) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
    51. 		Message message = new Message();
    52. 		Gson gson = new Gson();
    53. 		question.setContent(gson.toJson(question.getQuestionContent()));
    54. 		question.setCreate_time(new Date());
    55. 		question.setCreator(userDetails.getUsername());
    56. 		try {
    57. 			questionService.addQuestion(question);
    58. 		} catch (Exception e) {
    59. 			// TODO Auto-generated catch block
    60. 			message.setResult("error");
    61. 			message.setMessageInfo(e.getClass().getName());
    62. 			e.printStackTrace();
    63. 		}
    64.  
    65. 		return message;
    66. 	}
    67.  
    68. 	/**
    69. 	 * 获取试题的标签列表
    70. 	 * 
    71. 	 * @param questionId
    72. 	 * @return
    73. 	 */
    74. 	@RequestMapping(value = "/secure/question/question-tag/{questionId}", method = RequestMethod.GET)
    75. 	public @ResponseBody Message getQuestionTag(@PathVariable("questionId") int questionId) {
    76. 		Message message = new Message();
    77. 		UserInfo userInfo = (UserInfo) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
    78. 		List tagList = questionService.getQuestionTagByQuestionIdAndUserId(questionId,
    79. 				userInfo.getUserid(), null);
    80. 		message.setObject(tagList);
    81. 		return message;
    82. 	}
    83.  
    84. 	/**
    85. 	 * 为试题添加标签
    86. 	 * 
    87. 	 * @param questionId
    88. 	 * @param questionTagList
    89. 	 * @return
    90. 	 */
    91. 	@RequestMapping(value = "/secure/question/add-question-tag", method = RequestMethod.POST)
    92. 	public @ResponseBody Message addQuestionTag(@RequestBody int questionId,
    93. 			@RequestBody List questionTagList) {
    94. 		Message message = new Message();
    95. 		UserInfo userInfo = (UserInfo) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
    96. 		try {
    97. 			questionService.addQuestionTag(questionId, userInfo.getUserid(), questionTagList);
    98. 		} catch (Exception e) {
    99. 			e.printStackTrace();
    100. 			message.setResult(e.getClass().getName());
    101. 		}
    102.  
    103. 		return message;
    104. 	}
    105.  
    106. 	/**
    107. 	 * 获取试题详细信息
    108. 	 * @param questionId
    109. 	 * @return
    110. 	 */
    111. 	@RequestMapping(value = "/secure/question/question-detail/{questionId}", method = RequestMethod.GET)
    112. 	public @ResponseBody Message getQuestionDetail(@PathVariable("questionId") int questionId) {
    113. 		Message message = new Message();
    114. 		//UserInfo userInfo = (UserInfo) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
    115. 		try {
    116. 			Question question = questionService.getQuestionDetail(questionId, 0);
    117. 			message.setObject(question);
    118. 		} catch (Exception e) {
    119. 			// TODO Auto-generated catch block
    120. 			e.printStackTrace();
    121. 			message.setResult(e.getCause().getMessage());
    122. 		}
    123. 		return message;
    124. 	}
    125. 	/**
    126. 	 * 修改试题知识点
    127. 	 * 
    128. 	 * @param questionId
    129. 	 * @param pointId
    130. 	 * @param questionTagList
    131. 	 * @return
    132. 	 */
    133. 	@RequestMapping(value = "/secure/question/question-update/{questionId}/{pointId}", method = RequestMethod.POST)
    134. 	public @ResponseBody Message updateQuestionKnowledge(@PathVariable int questionId, @PathVariable int pointId,
    135. 			@RequestBody List questionTagList) {
    136.  
    137. 		Message message = new Message();
    138. 		UserInfo userInfo = (UserInfo) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
    139. 		Question question = new Question();
    140. 		question.setId(questionId);
    141. 		List pointIdList = new ArrayList();
    142. 		pointIdList.add(pointId);
    143. 		question.setPointList(pointIdList);
    144. 		try {
    145. 			questionService.updateQuestionPoint(question, userInfo.getUserid(), questionTagList);
    146. 		} catch (Exception e) {
    147. 			message.setResult(e.getClass().getName());
    148. 		}
    149.  
    150. 		return message;
    151. 	}
    152. 	
    153. 	@RequestMapping(value = "/secure/question/question-update", method = RequestMethod.POST)
    154. 	public @ResponseBody Message updateQuestion(@RequestBody String jsonStr){
    155. 		Message msg = new Message();
    156. 		Gson gson = new Gson();
    157. 		JsonParser parser = new JsonParser();
    158. 		JsonElement element = parser.parse(jsonStr);
    159. 		List questionTagList = gson.fromJson(element.getAsJsonObject().get("tags"), new TypeToken>(){}.getType());
    160. 		Question question = gson.fromJson(element.getAsJsonObject().get("question"), Question.class);
    161. 		try {
    162. 			questionService.updateQuestion(question, questionTagList);
    163. 			
    164. 		} catch (Exception e) {
    165. 			// TODO Auto-generated catch block
    166. 			e.printStackTrace();
    167. 			msg.setResult(e.getCause().getMessage());
    168. 		}
    169. 		//TO-DO:需要提交到数据库，保证在事务中提交
    170. 		return msg;
    171. 	}
    172.  
    173. 	@RequestMapping(value = "/secure/question/get-knowledge-point/{fieldId}", method = RequestMethod.GET)
    174. 	public @ResponseBody Message getQuestionPointByFieldId(@PathVariable int fieldId) {
    175. 		Message message = new Message();
    176. 		HashMap pointMap = new HashMap();
    177. 		List pointList = questionService.getKnowledgePointByFieldId(fieldId, null);
    178. 		for (KnowledgePoint point : pointList) {
    179. 			pointMap.put(point.getPointId(), point.getPointName());
    180. 		}
    181. 		message.setObject(pointMap);
    182. 		return message;
    183. 	}
    184.  
    185. 	@RequestMapping(value = "/secure/question/delete-question/{questionId}", method = RequestMethod.GET)
    186. 	public @ResponseBody Message deleteQuestion(Model model, @PathVariable("questionId") int questionId) {
    187.  
    188. 		// UserDetails userDetails = (UserDetails)
    189. 		// SecurityContextHolder.getContext().getAuthentication().getPrincipal();
    190. 		Message message = new Message();
    191. 		try {
    192. 			questionService.deleteQuestionByQuestionId(questionId);
    193. 		} catch (Exception ex) {
    194. 			message.setResult(ex.getClass().getName());
    195. 		}
    196.  
    197. 		return message;
    198. 	}
    199.  
    200. 	@RequestMapping(value = "/secure/upload-uploadify-img", method = RequestMethod.POST)
    201. 	public @ResponseBody String uploadImg(HttpServletRequest request, HttpServletResponse response) {
    202. 		UserInfo userInfo = (UserInfo) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
    203. 		List filePathList = new ArrayList();
    204. 		try {
    205. 			filePathList = FileUploadUtil.uploadImg(request, response, userInfo.getUsername());
    206. 		} catch (FileNotFoundException e) {
    207. 			// TODO Auto-generated catch block
    208. 			e.printStackTrace();
    209. 		} catch (Exception ex) {
    210. 			ex.printStackTrace();
    211. 		}
    212.  
    213. 		if (filePathList.size() == 0) {
    214. 			return "系统错误";
    215. 		}
    216.  
    217. 		return filePathList.get(0);
    218. 	}
    219.  
    220. 	@RequestMapping(value = "/secure/upload-uploadify", method = RequestMethod.POST)
    221. 	public @ResponseBody String uploadFile(HttpServletRequest request, HttpServletResponse response) {
    222. 		UserInfo userInfo = (UserInfo) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
    223. 		List filePathList = new ArrayList();
    224. 		try {
    225. 			filePathList = FileUploadUtil.uploadFile(request, response, userInfo.getUsername());
    226. 		} catch (FileNotFoundException e) {
    227. 			// TODO Auto-generated catch block
    228. 			e.printStackTrace();
    229. 		} catch (Exception ex) {
    230. 			ex.printStackTrace();
    231. 		}
    232.  
    233. 		if (filePathList.size() == 0) {
    234. 			return "系统错误";
    235. 		}
    236.  
    237. 		return filePathList.get(0);
    238. 	}
    239. 	
    240. 	@RequestMapping(value = "/secure/question-import/{id}", method = RequestMethod.POST)
    241. 	public @ResponseBody Message courseImport(@RequestBody String filePath, @PathVariable("id") int id) {
    242. 		Message message = new Message();
    243. 		UserInfo userInfo = (UserInfo) SecurityContextHolder.getContext()
    244. 				.getAuthentication().getPrincipal();
    245. 		if(id == 0){
    246. 			message.setResult("error");
    247. 			message.setMessageInfo("请选择题库");
    248. 			return message;
    249. 		}
    250. 		try{
    251. 			questionService.uploadQuestions(filePath, userInfo.getUsername(),id);
    252. 		}catch(RuntimeException e){
    253. 			message.setResult(e.getClass().getName() + ":" + e.getMessage());
    254. 			message.setMessageInfo(e.getMessage());
    255. 		}
    256. 		
    257. 		return message;
    258. 	}
    259. }

    五，项目总结

  • 相关阅读:
    Prompt工程师指南[从基础到进阶篇]：用于开发和优化提示，以有效地使用语言模型（LMs）进行各种应用和研究主题
    【深入理解Linux内核锁】六、信号量
    【ARM】使用Ubuntu-base构建根文件系统
    Docker-compose
    @selector() 与SEL 到底是啥
    Python机器视觉--OpenCV入门--OpenCV鼠标绘制图形
    含文档+PPT+源码等]精品微信小程序ssm超市购物系统小程序+后台管理系统|前后分离VUE[包运行成功]微信小程序项目源码Java毕业设计
    java项目-第99期基于spring+springmvc+hibernate的在线问卷答题系统-计算机毕业设计
    【网络编程】网络层——IP协议
    appium实现自动化测试原理
  • 原文地址：https://blog.csdn.net/whirlwind526/article/details/127576511