基于SpringBoot+Mybatis+Vue的一个在线选课系统源码+数据库.zip

package com.onlineclass.controller; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.CrossOrigin; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import com.onlineclass.pojo.ClassTime; import com.onlineclass.pojo.Course; import com.onlineclass.pojo.OnlineClassPage; import com.onlineclass.pojo.Score; import com.onlineclass.pojo.Teacher; import com.onlineclass.service.ClassTimeDaoService; import com.onlineclass.service.CourseDaoService; import com.onlineclass.service.ScoreDaoService; import com.onlineclass.service.TeacherDaoService; /** * * @author indext * @since 2019.11.06 * @version 1.0 */ @CrossOrigin(origins = "*", maxAge = 3600) @Controller public class CourseController { @Autowired private CourseDaoService courseDaoService; @Autowired private ScoreDaoService ScoreDaoService; @Autowired private TeacherDaoService teacherDaoService; @Autowired private ClassTimeDaoService classTimeDaoService; // 分页查询所有课程 @RequestMapping("/courseSel") @ResponseBody public OnlineClassPage courseSelPage(HttpServletRequest request, HttpServletResponse response, HttpSession session) throws Exception { String course_name = request.getParameter("course_name"); String course_cno = request.getParameter("course_cno"); String pageNoss = request.getParameter("pageNopss"); System.out.println("asdasdasd" + course_name); int pageNo = Integer.parseInt(pageNoss); List<Course> courses = courseDaoService.getCourse(course_cno, course_name); // 显示分页的总页数 int pageNos = courses.size() / 10; int pageSize = 10; if (courses.size() % 10 != 0) { pageNos += 1; } // 分页显示记录 List<Course> coursePage = courseDaoService.getCoursePages(course_cno, course_name, pageNo, pageSize); OnlineClassPage onlineClassPage = new OnlineClassPage(); onlineClassPage.setPageNo(pageNos); onlineClassPage.setCourse(coursePage); System.out.println(onlineClassPage.toString()); return onlineClassPage; } // 分页查询所有可选课程 @RequestMapping("/student/courseTeaSel") @ResponseBody public OnlineClassPage courseTeaSel(HttpServletRequest request, HttpServletResponse response, HttpSession session) throws Exception { String course_name = request.getParameter("course_name"); String course_cno = request.getParameter("course_cno"); String teacher_name = request.getParameter("teacher_name"); String pageNoss = request.getParameter("pageNopss"); int pageNo = Integer.parseInt(pageNoss); List<Teacher> courses = courseDaoService.coursesSel(course_name, course_cno, teacher_name); // 显示分页的总页数 int pageNos = courses.size() / 10; int pageSize = 10; if (courses.size() % 10 != 0) { pageNos += 1; } // 分页显示记录 List<Teacher> coursePage = courseDaoService.coursesSelPage(course_name, course_cno, teacher_name, pageNo, pageSize); OnlineClassPage onlineClassPage = new OnlineClassPage(); onlineClassPage.setPageNo(pageNos); onlineClassPage.setTeacher(coursePage); System.out.println(onlineClassPage.toString()); return onlineClassPage; } // 分页显示所有已选课程 @RequestMapping("/courses") @ResponseBody public List<Score> courses(HttpServletRequest request, HttpServletResponse response, HttpSession session) { String student_sno = request.getParameter("student_sno"); String course_cno = request.getParameter("course_cno"); String teacher_tno = request.getParameter("teacher_tno"); List<Score> scores = courseDaoService.scores(student_sno, course_cno, teacher_tno); return scores; } // 显示所有已选课程 @RequestMapping(value = "/student/courses") @ResponseBody public OnlineClassPage studentcourses(HttpServletRequest request, HttpServletResponse response, HttpSession session) { String student_sno = request.getParameter("student_sno"); String course_cno = request.getParameter("course_cno"); String teacher_tno = request.getParameter("teacher_tno"); // 获取所选课程所有页数 List<Score> scores = courseDaoService.scores(student_sno, course_cno, teacher_tno); String pageNoss = request.getParameter("pageNopss"); int pageNo = Integer.parseInt(pageNoss); int pageSize = 10; // 显示分页的总页数 int pageNos = scores.size() / 10; if (scores.size() % 10 != 0) { pageNos += 1; } System.out.println(scores.toString()); // 分页显示记录 List<Score> scoresPage = courseDaoService.scoresPage(student_sno, course_cno, teacher_tno, pageNo, pageSize); OnlineClassPage onlineClassPage = new OnlineClassPage(); onlineClassPage.setPageNo(pageNos); onlineClassPage.setScore(scoresPage); return onlineClassPage; } // 根据学号、姓名、课程名查询学生成绩 @RequestMapping(value = "/student/coursesStu") @ResponseBody public OnlineClassPage coursesStu(HttpServletRequest request, HttpServletResponse response, HttpSession session) { String student_sno = request.getParameter("student_sno"); String student_name = request.getParameter("student_name"); String teacher_name = request.getParameter("teacher_name"); String course_name = request.getParameter("course_name"); System.out.println("student_sno:" + student_sno); System.out.println("student_name:" + student_name); System.out.println("teacher_name:" + teacher_name); System.out.println("course_name:" + course_name); // 获取所选课程所有页数 List<Score> scores = courseDaoService.scoresStu(student_sno, student_name, teacher_name, course_name); String pageNoss = request.getParameter("pageNopss"); int pageNo = Integer.parseInt(pageNoss); int pageSize = 10; // 显示分页的总页数 int pageNos = scores.size() / 10; if (scores.size() % 10 != 0) { pageNos += 1; } System.out.println(scores.toString()); // 分页显示记录 List<Score> scoresPage = courseDaoService.scoresStuPage(student_sno, student_name, teacher_name, course_name, pageNo, pageSize); OnlineClassPage onlineClassPage = new OnlineClassPage(); onlineClassPage.setPageNo(pageNos); onlineClassPage.setScore(scoresPage); return onlineClassPage; } // 修改课程信息 @RequestMapping(value = "/courses/coursesUpdate") @ResponseBody public OnlineClassPage coursesUpdate(HttpServletRequest request, HttpServletResponse response, HttpSession session) { String course_cno = request.getParameter("course_cno"); String course_name = request.getParameter("course_name"); String course_information = request.getParameter("course_information"); System.out.println(course_cno + " " + course_name + " " + course_information); // 获取课程时间 String class_weekend = request.getParameter("class_weekend"); String class_time = request.getParameter("class_time"); int weekend = Integer.parseInt(class_weekend); int times = Integer.parseInt(class_time); System.out.println(class_time + " " + class_weekend); ClassTime classTime = new ClassTime(); classTime.setCourse_cno(course_cno); classTime.setClass_weekend(weekend); classTime.setClass_time(times); String pageNoss = request.getParameter("pageNopss"); int pageNo = Integer.parseInt(pageNoss); List<Course> courses = courseDaoService.getCourse(course_cno, null); // 显示分页的总页数 int pageNos = courses.size() / 10; int pageSize = 10; if (courses.size() % 10 != 0) { pageNos += 1; } if (weekend > 7 || weekend < 1 || times > 6 || times < 1) { System.out.println("修改失败！！！"); List<Course> coursePage = courseDaoService.getCoursePages(course_cno, null, pageNo, pageSize); System.out.println(course_cno); System.out.println(coursePage); OnlineClassPage online