基于javaweb+mysql的springboot前台+后台在线考试系统设计和实现(java+springboot+ssm+mysql+thymeleaf+html+maven)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SpringBoot前台+后台在线考试系统设计和实现(java+springboot+ssm+mysql+thymeleaf+html+maven)
一、项目简述
本系统主要实现的功能有: 学生以及老师的注册登录,在线考试,错题查询,学生管理,问题管理,错题管理,错题查询,分数查询,试卷管 理,人工组卷。自动组卷,教师,班级,统计等等管理功能。
二、项目运行
环境配置: Jdk1.8 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)
项目技术: Springboot+ SpringMVC + MyBatis + ThymeLeaf + JavaScript + JQuery + Ajax + maven等等
public String addClasse(Classe classe){
classeService.addClasse(classe);
return "redirect:/classe/getAllClasse";
}
//班级去修改页面
@RequestMapping("/toEditClasse/{id}")
public String toEditClasse(@PathVariable("id") Integer id,Model model){
//根据id查询班级
Classe classe=classeService.getClasseById(id);
//过去班级的班主任,回显
int teacherIdd=classe.getTeacherId();
Teacher teacherold=teacherService.getTeacherById(teacherIdd);
//查询可分配班主任得教师
List<Teacher> teachers=teacherService.queryTeacherNotAdvisor();
teachers.add(teacherold);
model.addAttribute("teachers",teachers);
model.addAttribute("classe",classe);
return "classe/classeEdit";
}
//修改具体操作
@RequestMapping("/EditClasse")
public String EditClasse(Classe classe){
classeService.editClasse(classe);
return "redirect:/classe/getAllClasse";
}
//班级删除
@RequestMapping("/deleteClasse/{id}")
public String deleteClasseById(@PathVariable("id") Integer id){
classeService.deleteClasseById(id);
return "redirect:/classe/getAllClasse";
}
}
@RequestMapping("/addQuestion")
public String addQuestion(Question question){
questionService.addQuestion(question);
return "redirect:/question/getAllQuestion";
}
//试题去修改页面
@RequestMapping("/toEditQuestion/{id}")
public String toEditQuestion(@PathVariable("id") Integer id,Model model){
List<Question> questionCourses=questionService.queryAllCourse();
List<Question> questionTypes=questionService.queryAllType();
Question question=questionService.getQuestionById(id);
model.addAttribute("questionTypes",questionTypes);
model.addAttribute("questionCourses",questionCourses);
model.addAttribute("question",question);
return "question/questionEdit";
}
//修改具体操作
@RequestMapping("/EditQuestion")
public String EditQuestion(Question question){
questionService.editQuestion(question);
return "redirect:/question/getAllQuestion";
}
//试题删除
@RequestMapping("/deleteQuestion/{id}")
public String deleteQuestionById(@PathVariable("id") Integer id){
questionService.deleteQuestionById(id);
return "redirect:/question/getAllQuestion";
}
}
@RequestMapping("/toAddExam")
public String toAddExam(Model model){
List<Paper> papers = paperService.getAll();
model.addAttribute("papers",papers);
return "exam/AddExam";
}
//添加操作
@RequestMapping("/addExam")
public String addExam(Exam exam, String examBegins,String examEnds) throws ParseException {
String t1 = examBegins.replace("T", " ");
String t2 = examEnds.replace("T", " ");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
Date begin = sdf.parse(t1);
Date end = sdf.parse(t2);
exam.setExamBegin(begin);
exam.setExamEnd(end);
examService.AddExam(exam);
return "redirect:/exam/getAllExam";
}
@RequestMapping("/deleteExam/{id}")
public String toEditExam(@PathVariable ("id") Integer id,Model model){
examService.deleteById(id);
return "redirect:/exam/getAllExam";
}
}
@Controller
List<Record> ScoreHStu=recordService.queryRankScoreRecord();
List<Record> AccHStu=recordService.queryRankAccRecord();
model.addAttribute("ScoreHStu",ScoreHStu);
model.addAttribute("AccHStu",AccHStu);
model.addAttribute("allPaps",allPaps);
model.addAttribute("allQues",allQues);
model.addAttribute("alllogers",alllogers);
return "index";
}
//前台学生登录考试
@ResponseBody
@RequestMapping("/foreCheck/check")
public Object foreCheck(Student student, HttpServletRequest request){
AjaxResult result=new AjaxResult();
HttpSession session=request.getSession();
Student stud=studentService.check(student);
if(stud!=null){
session.setAttribute("loger",stud);
result.setSuccess(true);
}else {
result.setSuccess(false);
}
return result;
}
//前台登录到展示页面
@RequestMapping("/indexprexam")
public String indexprexam(){
return "stage/prexamed";
}
//退出系统
@RequestMapping(value = {"*/logout","/logout","teacher/logout"})
public String logout(HttpSession session) {
//session里可能不止存放一个数据,移除麻烦,所以让其失效跟直接
session.invalidate();
return "redirect:/";
}
//学生注册
//去添加页面
@RequestMapping("/prexam/toAddStudent")
public String toAddStudent(Model model){
List<Classe> allClasees = classeService.getAll();
model.addAttribute("allClasees",allClasees);
return "stage/studentAdd";
}
}
@RequestMapping("/toHist/{id}")
public String toHist(@PathVariable ("id") Integer id,Model model){
List<Record> records=recordService.queryAllExamById(id);
model.addAttribute("records",records);
return "exam/histplan";
}
//从其他页面跳转到home
@RequestMapping("/toHome")
public String tohome(){
return "redirect:/indexprexam";
}
//来到对应考试页面
@RequestMapping("/toDoExam/{id}")
public String toDoExam(@PathVariable ("id") Integer id,Model model,String examId,HttpServletRequest request){
HttpSession session=request.getSession();
Student stu = (Student) session.getAttribute("loger");
// if() {
// Record record=new Record();
// record.setStudentId(stu.getStudentId());
// record.setPaperId(id);
List<Record> ss= recordService.queryAllExamById(stu.getStudentId());
for (int i = 0; i < ss.size(); i++) {
if(ss.get(i).getPaperId() ==id ) {
return "redirect:/exam/tomError";
}
}
// }
List<QuestionPaper> questionPapers = paperService.paperQueryALlQuestionByIdOrderByType(id);
int exId=Integer.parseInt(examId);
Exam examById = examService.getExamById(exId);
Paper paperName = paperService.queryPaperNameById(examById.getPaperId());
model.addAttribute("paperName",paperName);
model.addAttribute("examById",examById);
model.addAttribute("questionPapers",questionPapers);
return "exam/doExam";
}
//提交试卷
@RequestMapping("/submitExam")
//提交试卷
@RequestMapping("/submitExam")
public String submitExam(Integer paperId, Integer studentId, HttpServletRequest request){
List<QuestionPaper> questionPapers = paperService.paperQueryALlQuestionByIdOrderByType(paperId);
List<String> ans=new ArrayList<>();
List<String> RightAns=new ArrayList<>();
for (QuestionPaper qb:questionPapers){
RightAns.add(qb.getQuestion().getQuestionOpright());
String parameter="";
String []parameters;
if(qb.getQuestion().getQuestionType().equals("y")){
parameters= request.getParameterValues("optionsSelect" + qb.getQuestionId());
if(parameters!=null) {
for(String s:parameters){
parameter+=s;
}
}
}else {
parameter = request.getParameter("optionsSelect" + qb.getQuestionId());
if(parameter==null) {
return "redirect:/exam/toError";
}
}
ans.add(parameter);
}
//核对答案得到成绩
int k=0; //哨兵
Double y=0.0; //正确数
int score=0; //得分
int a=0; //记录单选题个数
int b=0; //记录多选题个数
int c=0; //记录判断题个数
int totalScore=0;
for (QuestionPaper qb:questionPapers){
if(ans==null) {
break;
}
//若为单选题则正确+单选题分数
if(qb.getQuestion().getQuestionType().equals("x")){
if(ans.get(k).equals(RightAns.get(k))){
score+=qb.getPaper().getScoreSin();
y++;
}
a++;
k++;
}else if(qb.getQuestion().getQuestionType().equals("y")){
if(ans.get(k).equals(RightAns.get(k))){
score+=qb.getPaper().getScoreChe();
y++;
}
model.addAttribute("quesIds",quesIds);
PageHelper.startPage(pageNum,pageSize);//这行是重点,表示从pageNum页开始,每页pageSize条数据
List<Question> questions = questionService.getAll(question);
PageInfo<Question> pageInfo = new PageInfo<Question>(questions);
model.addAttribute("questionCourseresRes",questionCourseresRes);
model.addAttribute("questionTypesRes",questionTypesRes);
model.addAttribute("questionTypes",questionTypes);
model.addAttribute("questionCourses",questionCourses);
model.addAttribute("pageInfo",pageInfo);
return "question/questionList";
}
//试题添加或者修改操作,先去添加页面
@RequestMapping("/toAddQuestion")
public String toAddQuestion(Model model){
List<Question> questionCourses=questionService.queryAllCourse();
List<Question> questionTypes=questionService.queryAllType();
model.addAttribute("questionTypes",questionTypes);
model.addAttribute("questionCourses",questionCourses);
return "question/questionAdd";
}
//添加具体操作
@RequestMapping("/addQuestion")
public String addQuestion(Question question){
questionService.addQuestion(question);
return "redirect:/question/getAllQuestion";
}
//试题去修改页面
@RequestMapping("/toEditQuestion/{id}")
public String toEditQuestion(@PathVariable("id") Integer id,Model model){
List<Question> questionCourses=questionService.queryAllCourse();
List<Question> questionTypes=questionService.queryAllType();
Question question=questionService.getQuestionById(id);
model.addAttribute("questionTypes",questionTypes);
model.addAttribute("questionCourses",questionCourses);
model.addAttribute("question",question);
return "question/questionEdit";
}
//修改具体操作
@RequestMapping("/EditQuestion")
public String EditQuestion(Question question){
questionService.editQuestion(question);
return "redirect:/question/getAllQuestion";
recordService.AddToScore(toscore);
}
//保存答题记录
String answer = String.join(",", ans);
Paper paper = paperService.queryPaperNameById(paperId);
String paperName = paper.getPaperName();
Double recordAcc=y/k;
int recordScore=score;
Record record=new Record();
record.setRecordName(paperName);
record.setStudentId(studentId);
record.setPaperId(paperId);
record.setRecordAnswer(answer);
record.setRecordAcc(recordAcc);
record.setRecordScore(recordScore);
recordService.addRecord(record);
return "redirect:/exam/toExam";
}
/**
* 考试后台
* */
//查看所有考试安排后台
@RequestMapping("/getAllExam")
public String getAllExam(Model model){
List<Exam> Exams = examService.getAllS();
model.addAttribute("Exams",Exams);
return "exam/backexamlist";
}
//去往考试添加页面
@RequestMapping("/toAddExam")
public String toAddExam(Model model){
List<Paper> papers = paperService.getAll();
model.addAttribute("papers",papers);
return "exam/AddExam";
}
//添加操作
@RequestMapping("/addExam")
public String addExam(Exam exam, String examBegins,String examEnds) throws ParseException {
String t1 = examBegins.replace("T", " ");
String t2 = examEnds.replace("T", " ");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
Date begin = sdf.parse(t1);
Date end = sdf.parse(t2);
exam.setExamBegin(begin);
exam.setExamEnd(end);
examService.AddExam(exam);
return "redirect:/exam/getAllExam";
}
@RequestMapping("/deleteExam/{id}")
public String toEditExam(@PathVariable ("id") Integer id,Model model){
examService.deleteById(id);
model.addAttribute("questionTypes",questionTypes);
model.addAttribute("questionCourses",questionCourses);
model.addAttribute("pageInfo",pageInfo);
return "question/questionList";
}
//试题添加或者修改操作,先去添加页面
@RequestMapping("/toAddQuestion")
public String toAddQuestion(Model model){
List<Question> questionCourses=questionService.queryAllCourse();
List<Question> questionTypes=questionService.queryAllType();
model.addAttribute("questionTypes",questionTypes);
model.addAttribute("questionCourses",questionCourses);
return "question/questionAdd";
}
//添加具体操作
@RequestMapping("/addQuestion")
public String addQuestion(Question question){
questionService.addQuestion(question);
return "redirect:/question/getAllQuestion";
}
//试题去修改页面
@RequestMapping("/toEditQuestion/{id}")
public String toEditQuestion(@PathVariable("id") Integer id,Model model){
List<Question> questionCourses=questionService.queryAllCourse();
List<Question> questionTypes=questionService.queryAllType();
Question question=questionService.getQuestionById(id);
model.addAttribute("questionTypes",questionTypes);
model.addAttribute("questionCourses",questionCourses);
model.addAttribute("question",question);
return "question/questionEdit";
}
//修改具体操作
@RequestMapping("/EditQuestion")
public String EditQuestion(Question question){
questionService.editQuestion(question);
return "redirect:/question/getAllQuestion";
}
//试题删除
@RequestMapping("/deleteQuestion/{id}")
public String deleteQuestionById(@PathVariable("id") Integer id){
questionService.deleteQuestionById(id);
return "redirect:/question/getAllQuestion";
}
Collections.shuffle(list);
List<QuestionPaper> questionPapers=new ArrayList<>();
for(int i=0;i<QuesNums;i++){
QuestionPaper questionPaper=new QuestionPaper(list.get(i),papid);
questionPapers.add(questionPaper);
}
int nums=questionService.AddAllQues(questionPapers);
return "redirect:/paper/toManagerQuestion/"+papid;
}
@RequestMapping("/deleteAllQues/{id}")
public String deleteAllQues(@PathVariable ("id") Integer papid,Integer []ques){
int nums=questionService.queryIdByPapQue(ques);
return "redirect:/paper/toManagerQuestion/"+papid;
}
}
@Controller
@RequestMapping("/exam")
public class ExamController {
@Autowired
private ExamService examService;
@Autowired
private PaperService paperService;
@Autowired
private RecordService recordService;
//前台跳转
@RequestMapping("/toExam")
public String toExam(Model model){
List<Exam> Exams = examService.getAll();
model.addAttribute("Exams",Exams);
return "exam/examplan";
}
@Controller
@RequestMapping("/record")
public class RecordController {
@Autowired
RecordService recordService;
@Autowired
PaperService paperService;
@Autowired
ClasseService classeService;
//获取所有记录
@RequestMapping("/getAllRecord")
public String getAllRecord(Model model){
List<Record> records=recordService.queryAll();
model.addAttribute("records",records);
return "record/RecordList";
}
//删除记录
@RequestMapping("/deleteRecore/{id}")
public String deleteRecore(@PathVariable ("id") Integer id){
recordService.deleteById(id);
return "redirect:/record/getAllRecord";
}
//根据记录id获取试卷详情
@RequestMapping("/toShowExamHist/{id}")
public String toShowExamHist(@PathVariable ("id")Integer id,Model model){
//通过记录id查找试卷和答题记录
Integer papid=recordService.queryByRecordId(id);
String answers=recordService.queryAnsByRecordId(id);
//原始试卷
List<QuestionPaper> questionPapers = paperService.paperQueryALlQuestionByIdOrderByType(papid);
//提交过的答案
List<String> ans = Arrays.asList(answers.split(","));
model.addAttribute("questionPapers",questionPapers);
}else {
/*若id已存在,是要进行修改操作*/
teacherService.editTeacher(teacher);
}
return "redirect:/teacher/getAllTeacher";
}
//教师去修改页面
@RequestMapping("/{id}")
public String toEditTeacher(@PathVariable("id") Integer id,Model model){
Teacher teacher=teacherService.getTeacherById(id);
model.addAttribute("teacher",teacher);
return "teacher/teacherAdd";
}
//教师删除
@RequestMapping("/deleteTeacher/{id}")
public String deleteTeacherById(@PathVariable("id") Integer id,Model model){
teacherService.deleteTeacherById(id);
return "redirect:/teacher/getAllTeacher";
}
}
@Controller
@RequestMapping("/student")
public class StudentController {
@Autowired
private ClasseMapper classeMapper;
@Autowired
private StudentService studentService;
//查看所有学生
@RequestMapping("/getAllStudent")
public String getAllStudent(Model model){
count.add(Integer.parseInt(map.get(key).toString()));
}
}
}
Paper paperName=paperService.queryPaperNameById(papid);
model.addAttribute("paperName",paperName.getPaperName());
model.addAttribute("count",count);
model.addAttribute("course",course);
model.addAttribute("TotalQuestionNums",TotalQuestionNums);
model.addAttribute("paperId",papid);
model.addAttribute("questionCourses",questionCourses);
return "paper/RandomQuestion";
}
//指定试卷id和课程随机生成试题
@RequestMapping("/RandomADDQuestion/{id}")
public String RandomADDQuestion(@PathVariable ("id") Integer papid,String questionCourse,int QuesNums){
//找到试卷所有未分配的试题
PapIdQuesCourse papIdQuesCourse=new PapIdQuesCourse();
papIdQuesCourse.setPapid(papid);
if(!questionCourse.equals("all")) {
papIdQuesCourse.setQuestionCourse(questionCourse);
}
List<Question> questionsNodivIds=questionService.queryAllQueIdNotInPaperById(papIdQuesCourse);
List<Integer> list=new ArrayList<>();
for(Question question:questionsNodivIds){
list.add(question.getQuestionId());
}
Collections.shuffle(list);
List<QuestionPaper> questionPapers=new ArrayList<>();
for(int i=0;i<QuesNums;i++){
QuestionPaper questionPaper=new QuestionPaper(list.get(i),papid);
questionPapers.add(questionPaper);
}
int nums=questionService.AddAllQues(questionPapers);
return "redirect:/paper/toManagerQuestion/"+papid;
}
@RequestMapping("/deleteAllQues/{id}")
public String deleteAllQues(@PathVariable ("id") Integer papid,Integer []ques){
int nums=questionService.queryIdByPapQue(ques);
return "redirect:/paper/toManagerQuestion/"+papid;
}
}
@Controller
@RequestMapping("/teacher")
public class TeacherController {
@Autowired
private TeacherService teacherService;
@Autowired
private ClasseService classeService;
//查看所有教师
@RequestMapping("/getAllTeacher")
public String getAllTeacher(Model model){
List<Teacher> teachers = teacherService.getAll();
//查找classe表中已存在的教师,将用于表单教师是否可以删除
List<Classe> classes=classeService.queryAllTeacherId();
List<Integer> teaId=new ArrayList<>();
for(Classe cla:classes){
teaId.add(cla.getTeacherId());
}
model.addAttribute("teaId",teaId);
model.addAttribute("teachers",teachers);
return "teacher/teacherList";
}
//教师添加或者修改操作,先去添加页面
@RequestMapping("/toAddTeacher")
public String toAddTeacher(){
return "teacher/teacherAdd";
}
//添加或者修改具体操作
@RequestMapping("/addTeacher")
public String addTeacher(Teacher teacher){
int teacherId = teacher.getTeacherId();
if(teacherId==0){
/*若id为0即是刚添加未分配,要进行增加操作*/
teacherService.addTeacher(teacher);
}else {
/*若id已存在,是要进行修改操作*/
teacherService.editTeacher(teacher);
}
return "redirect:/teacher/getAllTeacher";
}
@Controller
@RequestMapping("/classe")
public class ClasseController {
@Autowired
private ClasseService classeService;
@Autowired
private TeacherService teacherService;
//查看所有班级
@RequestMapping("/getAllClasse")
public String getAllClasse(Model model){
List<Classe> classes = classeService.getAll();
model.addAttribute("classes",classes);
return "classe/classeList";
}
//班级添加或者修改操作,先去添加页面
@RequestMapping("/toAddClasse")
public String toAddClasse(Model model){
List<Teacher> teachers=teacherService.queryTeacherNotAdvisor();
model.addAttribute("teachers",teachers);
return "classe/classeAdd";
}
//添加具体操作
@RequestMapping("/addClasse")
public String addClasse(Classe classe){
classeService.addClasse(classe);
return "redirect:/classe/getAllClasse";
}
//班级去修改页面
@RequestMapping("/toEditClasse/{id}")
public String toEditClasse(@PathVariable("id") Integer id,Model model){
public String getAllExam(Model model){
List<Exam> Exams = examService.getAllS();
model.addAttribute("Exams",Exams);
return "exam/backexamlist";
}
//去往考试添加页面
@RequestMapping("/toAddExam")
public String toAddExam(Model model){
List<Paper> papers = paperService.getAll();
model.addAttribute("papers",papers);
return "exam/AddExam";
}
//添加操作
@RequestMapping("/addExam")
public String addExam(Exam exam, String examBegins,String examEnds) throws ParseException {
String t1 = examBegins.replace("T", " ");
String t2 = examEnds.replace("T", " ");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
Date begin = sdf.parse(t1);
Date end = sdf.parse(t2);
exam.setExamBegin(begin);
exam.setExamEnd(end);
examService.AddExam(exam);
return "redirect:/exam/getAllExam";
}
@RequestMapping("/deleteExam/{id}")
public String toEditExam(@PathVariable ("id") Integer id,Model model){
examService.deleteById(id);
return "redirect:/exam/getAllExam";
}
}
int exId=Integer.parseInt(examId);
Exam examById = examService.getExamById(exId);
Paper paperName = paperService.queryPaperNameById(examById.getPaperId());
model.addAttribute("paperName",paperName);
model.addAttribute("examById",examById);
model.addAttribute("questionPapers",questionPapers);
return "exam/doExam";
}
//提交试卷
@RequestMapping("/submitExam")
public String submitExam(Integer paperId, Integer studentId, HttpServletRequest request){
List<QuestionPaper> questionPapers = paperService.paperQueryALlQuestionByIdOrderByType(paperId);
List<String> ans=new ArrayList<>();
List<String> RightAns=new ArrayList<>();
for (QuestionPaper qb:questionPapers){
RightAns.add(qb.getQuestion().getQuestionOpright());
String parameter="";
String []parameters;
if(qb.getQuestion().getQuestionType().equals("y")){
parameters= request.getParameterValues("optionsSelect" + qb.getQuestionId());
if(parameters!=null) {
for(String s:parameters){
parameter+=s;
}
}
}else {
parameter = request.getParameter("optionsSelect" + qb.getQuestionId());
if(parameter==null) {
return "redirect:/exam/toError";
}
}
ans.add(parameter);
}
//核对答案得到成绩
int k=0; //哨兵
Double y=0.0; //正确数
int score=0; //得分
int a=0; //记录单选题个数
int b=0; //记录多选题个数
int c=0; //记录判断题个数
int totalScore=0;
for (QuestionPaper qb:questionPapers){
if(ans==null) {
break;
}
//若为单选题则正确+单选题分数
if(qb.getQuestion().getQuestionType().equals("x")){
if(ans.get(k).equals(RightAns.get(k))){
score+=qb.getPaper().getScoreSin();
y++;