• Java项目：ssm在线答题系统

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    ssm在线答题系统

    技术框架

    使用SSM+Vue的形式来实现，SSM框架用于处理后台的数据逻辑，Vue框架用于前端的数据显示

    系统分为客户端，管理端

    注意事项

    1 数据库文件在一级目录下，命名为answerWeb.sql，部署时，需要在answerWeb/config/dbconfig.properties配置文件中配置好数据库
    2 管理端用户表为'admins'表
    3 客户端用户表为'user'表，用户端登录页登录帐号为邮箱
    4 管理端，在创建题目时，在选择完图片后，图片会立即上传到百度云BOS对象存储中（需要在util包的BOSUtil工具类你的BOS对象存储），未点击添加题目时，此时试题的资源（图片，视频）是在BOS的临时文件夹下（在QuestionController类定义路径），当点击添加题目后，会把此试题的资源添加到目标文件夹下（在QuestionController类定义路径），临时文件夹下的东西可以设置任务调度器进行定时删除，防止浪费BOS存储空间。

    5 项目的jar包除了用maven管理外，有一部分jar需要手动导入（answerWeb/WebRoot/WEB-INF/lib）

    运行截图

     

     

     

     

     

     

     

    相关代码 

    管理员登入

    1. package cn.edu.lingnan.controller;
    2.  
    3. import java.util.Map;
    4.  
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.web.bind.annotation.RequestMapping;
    8.  
    9. import cn.edu.lingnan.pojo.Admins;
    10. import cn.edu.lingnan.service.AdminsService;
    11.  
    12. @Controller
    13. public class AdminController extends BaseController {
    14.  
    15. 	@Autowired
    16. 	private AdminsService adminsService;
    17. 	
    18. 	/**
    19. 	 * 管理员登入
    20. 	 * @param admins
    21. 	 * @param map
    22. 	 * @author lizhi
    23. 	 */
    24. 	@RequestMapping("/adminLogin")
    25. 	public String adminLogin(Admins admins,Map map){
    26. 		if(adminsService.login(admins).size()<=0){
    27. 			map.put("loginError", "帐号或密码错误");
    28. 			return "/admin/login";
    29. 		}
    30. 		super.session.setAttribute("admins", adminsService.login(admins).get(0));
    31. 		return "redirect:/selectUserByExample";
    32. 	}
    33. 	
    34. 	/**
    35. 	 * 更新管理员资料（修改密码）
    36. 	 * @param admins
    37. 	 * @author lizhi
    38. 	 */
    39. 	@RequestMapping("/changeAdminPassword")
    40. 	public String changeAdminPassword(Admins admins){
    41. 		adminsService.updateSelective(admins);
    42. 		return "redirect:/selectUserByExample";
    43. 	}
    44. 	
    45. 	/**
    46. 	 * 注销
    47. 	 * @return
    48. 	 */
    49. 	@RequestMapping("/logout")
    50. 	public String logout(){
    51. 		session.invalidate();
    52. 		return "/admin/login";
    53. 	}
    54. 	
    55. }

     获取题目基础类型

    1. package cn.edu.lingnan.controller;
    2.  
    3. import java.util.ArrayList;
    4. import java.util.HashMap;
    5. import java.util.List;
    6. import java.util.Map;
    7.  
    8. import org.springframework.beans.factory.annotation.Autowired;
    9. import org.springframework.stereotype.Controller;
    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. import org.springframework.web.servlet.ModelAndView;
    15.  
    16. import cn.edu.lingnan.pojo.Options;
    17. import cn.edu.lingnan.pojo.Question;
    18. import cn.edu.lingnan.pojo.QuestionOption;
    19. import cn.edu.lingnan.pojo.QuestionType;
    20. import cn.edu.lingnan.pojo.User;
    21. import cn.edu.lingnan.pojo.WeChatUser;
    22. import cn.edu.lingnan.service.AnswerService;
    23.  
    24. @Controller
    25. public class AnswerController extends BaseController {
    26. 	
    27. 	public static final int QUESTION_NUMBER = 10;
    28. 	
    29. 	@Autowired
    30. 	private AnswerService answerService;
    31. 	
    32. 	/**
    33. 	 * @author huang
    34. 	 * 获取题目基础类型
    35. 	 */
    36. 	@ResponseBody
    37. 	@RequestMapping(value="user/getType")
    38. 	public Map getQuestionType() {
    39. 		Map map = new HashMap();
    40. 		List firstlist = answerService.findType();
    41. 		if (firstlist.size() <= 0) {
    42. 			map.put("error", "系统错误：一级菜单获取失败");
    43. 		} else {
    44. 			map.put("firstlist", firstlist);
    45. 		}
    46. 		return map;
    47. 	}
    48. 	
    49. 	/**
    50. 	 * @author huang
    51. 	 * 获取题目具体类型
    52. 	 */
    53. 	@ResponseBody
    54. 	@RequestMapping(value="user/getType/{id}")
    55. 	public Map getQuestionType(@PathVariable int id) {
    56. 		Map map = new HashMap();
    57. 		List secondlist = answerService.findType(id);
    58. 		if (secondlist.size() <= 0) {
    59. 			map.put("error", id);
    60. 		} else {
    61. 			//判断是否为3级菜单
    62. 			List thirdList = answerService.findType(secondlist.get(0).getTypeno());
    63. 			if(thirdList.size() <= 0) 
    64. 				map.put("grade", "two");
    65. 			else 
    66. 				map.put("grade", "third");
    67. 			map.put("secondlist", secondlist);
    68. 		}
    69. 		return map;
    70. 	}
    71. 	
    72. 	/**
    73. 	 * @author huang
    74. 	 * 根据类型获取题目
    75. 	 */
    76. 	@ResponseBody
    77. 	@RequestMapping(value="user/getQuestion/{typeno}")
    78. 	public Map getQuestion(@PathVariable int typeno) {
    79. 		Map map = new HashMap();
    80. 		List questionList = answerService.getQuestionByType(typeno);
    81. 		List questionOptionsList = new ArrayList();
    82. 		for (Question q : questionList) {
    83. 			List optionlist = answerService.getOptionsByQuestion(q.getQuestionno());
    84. 			QuestionOption questionOption = new QuestionOption(q,optionlist);
    85. 			questionOptionsList.add(questionOption);
    86. 		}
    87. 		map.put("question",questionOptionsList);
    88. 		map.put("maxnumber", QUESTION_NUMBER);
    89. 		map.put("title", answerService.getQuestionTypeByID(typeno).getTypename());
    90. 		return map;
    91. 	}
    92. 	
    93. 	/**
    94. 	 * @author huang
    95. 	 * 用户答题更新记录
    96. 	 */
    97. 	@RequestMapping(value="user/refreshRecord/{typeno}/{status}")
    98. 	public void refreshRecord(@PathVariable int typeno, @PathVariable int status){
    99. 		User user = (User) super.session.getAttribute("user");
    100. 		WeChatUser weuser = (WeChatUser) super.session.getAttribute("weChatUser");
    101. 		if (user != null)
    102. 			answerService.answerRecord(user.getUserno(), typeno, status, 0);
    103. 		else if (weuser != null)
    104. 			answerService.answerRecord(weuser.getWechatuserno(), typeno, status, 1);
    105. 	}		
    106. }

    可根据条件分页查询所有候选答案

    1. package cn.edu.lingnan.controller;
    2.  
    3. import java.util.List;
    4. import java.util.Map;
    5.  
    6. import org.springframework.beans.factory.annotation.Autowired;
    7. import org.springframework.stereotype.Controller;
    8. import org.springframework.web.bind.annotation.RequestMapping;
    9. import org.springframework.web.bind.annotation.RequestParam;
    10.  
    11. import com.github.pagehelper.PageHelper;
    12. import com.github.pagehelper.PageInfo;
    13.  
    14. import cn.edu.lingnan.pojo.Options;
    15. import cn.edu.lingnan.pojo.OptionsExample;
    16. import cn.edu.lingnan.service.OptionsService;
    17.  
    18. @Controller
    19. public class OptionsController extends BaseController {
    20.  
    21. 	@Autowired
    22. 	private OptionsService optionsService;
    23.  
    24. 	/**
    25. 	 * 可根据条件分页查询所有候选答案
    26. 	 * @return
    27. 	 * @author lizhi
    28. 	 */
    29. 	@RequestMapping("/selectOptions")
    30. 	public String selectOptions(OptionsExample options, Map map,
    31. 			@RequestParam(value = "pn", defaultValue = "1") Integer pn) {
    32. 		// 每页显示八条数据，且当前页是参数pn
    33. 		PageHelper.startPage(pn, 8);
    34. 		List list = optionsService.selectOptionsByExample(options);
    35. 		// 对数据进行分页处理
    36. 		PageInfo pageInfo = new PageInfo(list);
    37. 		map.put("optionsListPageInfo", pageInfo);
    38. 		// 到时候前端写出网页后再修改到具体的页面
    39. 		return "admin/index";
    40. 	}
    41. 	
    42. 	/**
    43. 	 * 更新候选答案
    44. 	 * @return
    45. 	 * @author lizhi
    46. 	 */
    47. 	@RequestMapping("/updateOptions")
    48. 	public String updateOptions(Options options){
    49. 		optionsService.updateByPrimaryKey(options);
    50. 		return "admin/index";
    51. 	}
    52. 	
    53. 	
    54.  
    55. }

    QuestionController

    1. package cn.edu.lingnan.controller;
    2.  
    3. import java.io.IOException;
    4. import java.text.SimpleDateFormat;
    5. import java.util.Date;
    6. import java.util.List;
    7. import java.util.Map;
    8. import java.util.concurrent.ThreadLocalRandom;
    9.  
    10. import org.springframework.beans.factory.annotation.Autowired;
    11. import org.springframework.stereotype.Controller;
    12. import org.springframework.web.bind.annotation.RequestMapping;
    13. import org.springframework.web.bind.annotation.RequestParam;
    14. import org.springframework.web.bind.annotation.ResponseBody;
    15. import org.springframework.web.multipart.MultipartFile;
    16.  
    17. import com.github.pagehelper.PageHelper;
    18. import com.github.pagehelper.PageInfo;
    19.  
    20. import cn.edu.lingnan.pojo.Options;
    21. import cn.edu.lingnan.pojo.OptionsList;
    22. import cn.edu.lingnan.pojo.Question;
    23. import cn.edu.lingnan.pojo.TempUrl;
    24. import cn.edu.lingnan.service.OptionsService;
    25. import cn.edu.lingnan.service.QuestionService;
    26. import cn.edu.lingnan.service.QuestionTypeService;
    27. import cn.edu.lingnan.service.TempUrlService;
    28. import cn.edu.lingnan.utils.BOSUtil;
    29.  
    30. @Controller
    31. public class QuestionController extends BaseController {
    32. 	
    33. 	@Autowired
    34. 	private QuestionService questionService;
    35. 	
    36. 	@Autowired
    37. 	private QuestionTypeService questionTypeService;
    38. 	
    39. 	@Autowired
    40. 	private OptionsService optionsService;
    41. 	
    42. 	@Autowired
    43. 	private TempUrlService tempUrlService;
    44. 	
    45.  
    46. 	/**
    47. 	 * 分页根据条件查找试题
    48. 	 * @param question
    49. 	 * @param map
    50. 	 * @param pn
    51. 	 * @author lizhi
    52. 	 */
    53. 	@RequestMapping("/selectQuestion")
    54. 	public String selectQuestion(Question question, Map map,
    55. 			@RequestParam(value = "pn", defaultValue = "1") Integer pn,@RequestParam("toid")Integer toid) {
    56. 		// 每页显示八条数据，且当前页是参数pn
    57. 		PageHelper.startPage(pn, 6);
    58. 		List list = questionService.selectQuestionByExample(question);
    59. 		// 对数据进行分页处理
    60. 		PageInfo pageInfo = new PageInfo(list);
    61. 		map.put("pageInfo", pageInfo);
    62. 		//找出所有三级菜单类型，返回到前端多条件选择
    63. 		map.put("questionTypeList",questionTypeService.getAllQuestionType());
    64. 		//在选项卡一中显示
    65. 		map.put("toid", toid);
    66. 		// 到时候前端写出网页后再修改到具体的页面
    67. 		return "/admin/questionList";
    68. 	}
    69. 	
    70. 	/**
    71. 	 * 更新试题第一步
    72. 	 * @param question
    73. 	 * @author lizhi
    74. 	 */
    75. 	@RequestMapping("/updateQuestionFirst")
    76. 	public String updateQuestionFirst(@RequestParam("questionno")Integer questionno,Map map,@RequestParam("pn") Integer pn){
    77. 		//找出具体题目
    78. 		map.put("question",questionService.getQuestionByKey(questionno));
    79. 		//找出题目的候选答案
    80. 		map.put("optionsList",optionsService.getQuestionOptions(questionno));
    81. 		//找出所有三级菜单类型，返回到更新页面
    82. 		map.put("questionTypeList",questionTypeService.getAllQuestionType());
    83. 		map.put("pn",pn);
    84. 		return "/admin/updateQuestion";
    85. 	}
    86. 	
    87. 	/**
    88. 	 * 更新试题第二步
    89. 	 * @param question
    90. 	 * @param pn
    91. 	 * @author lizhi
    92. 	 */
    93. 	@RequestMapping("/updateQuestionSecond")
    94. 	public String updateQuestionSecond(Question question,@RequestParam("pn") Integer pn,OptionsList optionsList,String oldContent,String oldDescription){
    95. 		
    96. 		//如果不同文件名，就要移动
    97. 		if(!question.getContent().equals(oldContent)){
    98. 		String strExtension = question.getContent().substring(question.getContent().lastIndexOf('.') + 1);
    99. 		String path = "/resource/images/question/";
    100. 		if(strExtension.equals("mp3")){
    101. 			path = "/resource/audio/";
    102. 			//将文件从临时文件夹移动到目标文件夹
    103. 			BOSUtil.moveFile("/temp/"+question.getContent(),path+question.getContent());
    104. 		}else if(strExtension.equals("mp4")){
    105. 			path = "/resource/video/";
    106. 			//将文件从临时文件夹移动到目标文件夹
    107. 			BOSUtil.moveFile("/temp/"+question.getContent(),path+question.getContent());
    108. 		}else if(strExtension.equals("jpg")||strExtension.equals("gif") ||strExtension.equals("png") || strExtension.equals("bmp")){
    109. 			//将文件从临时文件夹移动到目标文件夹
    110. 			BOSUtil.moveFile("/temp/"+question.getContent(),path+question.getContent());
    111. 			}
    112. 		}
    113. 		
    114. 		//如果不同文件名，就要删除原来的
    115. 		if(!question.getContent().equals(oldContent)){
    116. 			//把原来的文件删除
    117. 			String path="";
    118. 			String oldExtension = oldContent.substring(oldContent.lastIndexOf('.') + 1);
    119. 			String oldpath = "/resource/images/question/";
    120. 			if(oldExtension.equals("mp3")){
    121. 				path = "/resource/audio/";
    122. 				BOSUtil.deleteFile(path+oldContent);
    123. 			}else if(oldExtension.equals("mp4")){
    124. 				path = "/resource/video/";
    125. 				BOSUtil.deleteFile(path+oldContent);
    126. 			}else if(oldExtension.equals("jpg")||oldExtension.equals("gif") || oldExtension.equals("png") || oldExtension.equals("bmp")){
    127. 				BOSUtil.deleteFile(path+oldContent);
    128. 			}
    129. 		}
    130. 		
    131. 		
    132. 		//对答案图片进行更新
    133. 		if(question.getDesstatus()==2){
    134. 			if(!question.getDescription().equals(oldDescription)){
    135. 				String path = "/resource/images/answer/";
    136. 				//移动答案图片
    137. 				BOSUtil.moveFile("/temp/"+question.getDescription(),path+question.getDescription());
    138. 				//删除原来的答案图片
    139. 				BOSUtil.deleteFile(path+oldDescription);
    140. 			}
    141. 		}
    142. 		
    143. 		
    144. 		
    145. 		questionService.updateSelective(question);
    146. 		for(Options options:optionsList.getOptionsList()){
    147. 			optionsService.updateByPrimaryKey(options);
    148. 		}
    149. 		redirectAttributes.addAttribute("pn",pn);
    150. 		redirectAttributes.addAttribute("toid",1);
    151. 		return "redirect:/selectQuestion";
    152. 	}
    153. 	
    154. 	
    155. 	
    156.  
    157. 	/**
    158. 	 * 上传题目的图片，视频，音频
    159. 	 * @param file
    160. 	 * @param typename
    161. 	 * @return
    162. 	 * @throws IllegalStateException
    163. 	 * @throws IOException
    164. 	 */
    165. 	@ResponseBody
    166. 	@RequestMapping(value = "/addQuestionFile", produces = "text/html;charset=UTF-8")
    167. 	public String addQuestionFile(@RequestParam(value = "file", required = false) MultipartFile file,@RequestParam(value="desFile",required=false) MultipartFile desFile
    168. 			,@RequestParam(value="flag",required=false) Integer flag	) throws IllegalStateException, IOException {
    169. 		if(flag == 1){
    170. 	/*	String strExtension = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf('.') + 1);
    171. 		String path = "/resource/images/question/";
    172. 		if(strExtension.equals("mp3")){
    173. 			path = "/resource/audio/";
    174. 		}else if(strExtension.equals("mp4")){
    175. 			path = "/resource/video/";
    176. 		}*/
    177.  
    178. 		// fileName唯一性
    179. 		int a = ThreadLocalRandom.current().nextInt(100,999);
    180. 		String fileName =+ a +"-"+ System.currentTimeMillis()+ file.getOriginalFilename();
    181. 	 
    182. 		 //上传到临时文件夹
    183.         String typeImagesTempPath = "/temp/"+fileName;
    184. 		BOSUtil.upload(file, typeImagesTempPath);
    185. 		
    186. 		//插入上传记录
    187. 		SimpleDateFormat format = new SimpleDateFormat("yyyyMMddhhmmss");
    188. 		TempUrl tempUrl = new TempUrl(null,fileName,format.format(new Date()));
    189. 		tempUrlService.addTempUrl(tempUrl);
    190. 		return fileName;
    191. 		
    192. 		//这是答案详解图片的预览
    193. 		}else if(flag == 2){
    194. 			String path = "/resource/images/answer/";
    195. 			// fileName唯一性
    196. 			int a = ThreadLocalRandom.current().nextInt(100,999);
    197. 			String fileName =+ a +"-"+ System.currentTimeMillis()+ desFile.getOriginalFilename();
    198.  
    199. 			 //上传到临时文件夹
    200. 	        String typeImagesTempPath = "/temp/"+fileName;
    201. 			BOSUtil.upload(desFile, typeImagesTempPath);
    202. 			
    203. 			//插入上传记录
    204. 			SimpleDateFormat format = new SimpleDateFormat("yyyyMMddhhmmss");
    205. 			TempUrl tempUrl = new TempUrl(null,fileName,format.format(new Date()));
    206. 			tempUrlService.addTempUrl(tempUrl);
    207. 			return fileName;
    208. 		}
    209. 		return "error";
    210. 	}
    211. 	
    212. 	
    213. 	/**
    214. 	 * 增加试题
    215. 	 * @param question
    216. 	 * @author lizhi
    217. 	 * @throws IOException 
    218. 	 * @throws IllegalStateException 
    219. 	 */
    220. 	@RequestMapping("/addQuestion")
    221. 	public String addQuestion(Question question,OptionsList optionsList,@RequestParam("pn") Integer pn) throws IllegalStateException, IOException{
    222. 		
    223. 		
    224. 		String strExtension = question.getContent().substring(question.getContent().lastIndexOf('.') + 1);
    225. 		String path = "/resource/images/question/";
    226. 		if(strExtension.equals("mp3")){
    227. 			path = "/resource/audio/";
    228. 			//将文件从临时文件夹移动到目标文件夹
    229. 			BOSUtil.moveFile("/temp/"+question.getContent(),path+question.getContent());
    230. 		}else if(strExtension.equals("mp4")){
    231. 			path = "/resource/video/";
    232. 			//将文件从临时文件夹移动到目标文件夹
    233. 			BOSUtil.moveFile("/temp/"+question.getContent(),path+question.getContent());
    234. 		}else if(strExtension.equals("jpg") || strExtension.equals("gif") || strExtension.equals("png") || strExtension.equals("bmp")){
    235. 			//将文件从临时文件夹移动到目标文件夹
    236. 			BOSUtil.moveFile("/temp/"+question.getContent(),path+question.getContent());
    237. 		}
    238. 		
    239. 		
    240. 		//移动答案图片
    241. 		if(question.getDesstatus()==2){
    242. 				String desImapgePath = "/resource/images/answer/";
    243. 				//移动答案图片
    244. 				BOSUtil.moveFile("/temp/"+question.getDescription(),desImapgePath+question.getDescription());
    245. 		}
    246. 		
    247. 		
    248. 		//插入数据库
    249. 		questionService.insertQuestion(question);
    250. 		for(Options options:optionsList.getOptionsList()){
    251. 			options.setQuestionno(question.getQuestionno());
    252. 			optionsService.insert(options);
    253. 		}
    254. 		redirectAttributes.addAttribute("pn",pn);
    255. 		redirectAttributes.addAttribute("toid",1);
    256. 		return "redirect:/selectQuestion";
    257. 	}
    258. 	
    259. 	/**
    260. 	 * 根据试题id删除试题
    261. 	 * @param id
    262. 	 * @author lizhi
    263. 	 */
    264. 	/*@RequestMapping(value="/deleteQuestion/{id}",method=RequestMethod.DELETE)
    265. 	public String deleteQuestion(@PathVariable(value="id") Integer id){
    266. 		questionService.deleteQuestion(id);
    267. 		return "/admin/index";
    268. 	}*/
    269. 	
    270. 	/**
    271. 	 * 根据试题id删除试题
    272. 	 * @param id
    273. 	 * @author lizhi
    274. 	 */
    275. 	@RequestMapping(value="/deleteQuestion")
    276. 	public String deleteQuestion(@RequestParam("questionno") Integer questionno,@RequestParam("pn") Integer pn){
    277. 		Question question = questionService.getQuestionByKey(questionno);
    278. 		
    279. 		questionService.deleteQuestion(questionno);
    280. 		redirectAttributes.addAttribute("pn", pn);
    281. 		redirectAttributes.addAttribute("toid",1);
    282. 		
    283. 		//删除题目内容对应的资源
    284. 		if(question.getConstatus()!=1){
    285. 			String contentExtension = question.getContent().substring(question.getContent().lastIndexOf('.') + 1);
    286. 			String path = "/resource/images/question/";
    287. 			if(contentExtension.equals("mp3")){
    288. 				path = "/resource/audio/";
    289. 				BOSUtil.deleteFile(path+question.getContent());
    290. 			}else if(contentExtension.equals("mp4")){
    291. 				path = "/resource/video/";
    292. 				BOSUtil.deleteFile(path+question.getContent());
    293. 			}else if(contentExtension.equals("jpg") || contentExtension.equals("gif") || contentExtension.equals("png") || contentExtension.equals("bmp")){
    294. 				BOSUtil.deleteFile(path+question.getContent());
    295. 			}
    296. 		}
    297. 		//删除题目答案对应的资源
    298. 		if(question.getDesstatus()==2){
    299. 			BOSUtil.deleteFile("/resource/images/answer/"+question.getDescription());
    300. 		}
    301. 		
    302. 		return "redirect:/selectQuestion";
    303. 	}
    304. 	
    305. }

    如果也想学习本系统，下面领取。关注并回复：017ssm 

  • 相关阅读:
    【3D建模制作技巧分享】3dmax如何设置视图布局
    ARM接口编程—RTC(exynos 4412平台)
    为什么HttpContextAccessor要这么设计?
    【差旅游记】启程-新疆哈密（1）
    信道估计 | 信道
    October 2019 Twice SQL Injection
    zookeeper应用场景（二）
    Android SystemUI去掉拖动亮度条QSPanel界面隐藏功能
    Makefile相关操作
    Docker - 镜像、容器、仓库
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126797862