基于javaweb和mysql的ssm+maven网上选课系统(java+ssm+jsp+mysql+maven)
·
基于javaweb和mysql的ssm+maven网上选课系统(java+ssm+jsp+mysql+maven)
私信源码获取及调试交流
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb的SSM+Maven网上选课系统(java+ssm+jsp+mysql+maven)
一、项目简述
功能： 系统分为三个角色。最高权限管理员，学生，教师，包括 学生管理，教师管理，课程管理，选课，退课，成绩查 询。，教学课程，查看选课名单等等功能完全齐备。
二、项目运行
环境配置： Jdk1.8 + Tomcat8.5 + Mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)
项目技术： JSP +Spring + SpringMVC + MyBatis + Bootstrap4+ css + JavaScript + JQuery + Ajax + particles.js+ maven等等。
out.flush();
out.close();
}
@RequestMapping(value="/existTime",method = RequestMethod.POST)
public void existTime(@RequestParam("coursetime") String coursetime,@RequestParam("courseweek") String courseweek,
@RequestParam("classroom") String classroom,HttpServletResponse response,HttpServletRequest request) throws IOException{
response.setContentType("text/html;charset=UTF-8");
response.setHeader("Cache-Control", "no-cache");
PrintWriter out=null;
System.out.println("--------------------------");
System.out.println(coursetime+"---"+courseweek+"---"+classroom);
out=response.getWriter();
if(coursePlanService.ajaxGetCoursePlan(coursetime,courseweek,classroom) != null){
out.println("此功能排重正在开发中.....");
}else {
out.println("此功能排重正在开发中.....");
}
out.flush();
out.close();
}
}
/**
*
* @ProjectName: StudentInfo
* @Package: net.fuzui.StudentInfo.interceptor
* @ClassName: StudentLoginInterceptor
* @Description: 学生登录拦截
* @UpdateUser: 王泽
* @UpdateRemark: 新建
* @Version: 1.0
System.out.println(courseList);
return "teacher/addCou";
}
}
//修改课程方案
@RequestMapping("/modicouplan/{courseclass}")
public String modiCouPlan(@PathVariable(value = "courseclass") String courseclass, Model model,
HttpSession httpSession) {
List<CoursePlan> cPlanList = new ArrayList<CoursePlan>();
cPlanList = coursePlanService.getByCoursePlanCourseclass(1,10,courseclass);
if (cPlanList != null) {
httpSession.setAttribute("cPlanList", cPlanList);
System.out.println(cPlanList);
return "teacher/modCouPlan";
} else {
return "fail";
}
}
//修改
@RequestMapping("/moditycouplan/{tid}")
public ModelAndView modityCouPlan(@PathVariable(value = "tid") String tid, CoursePlan coursePlan) {
if (coursePlanService.modifyCoursePlan(coursePlan) != 0) {
return new ModelAndView(new RedirectView("/StudentSystem/TeacherHandler/managecou/{tid}/1"));
} else {
return new ModelAndView(new RedirectView("/StudentSystem/fail.jsp"));
}
}
//删除
@RequestMapping("/delcouplan/{courseclass}/{tid}")
public ModelAndView modityCouPlan(@PathVariable(value = "courseclass") String courseclass,
@PathVariable(value = "tid") String tid, HttpSession httpSession) {
if (coursePlanService.deleteCoursePlan(courseclass) != 0) {
return new ModelAndView(new RedirectView("/StudentSystem/index.jsp"));
}
// 学生登录
@RequestMapping("/studentlogin")
public ModelAndView loginStudent(@RequestParam("sid") String sid, @RequestParam("spassword") String spassword,
Model model, HttpSession httpSession, HttpServletRequest httpRequest) {
Student student = new Student();
student = studentService.getByStuSid(sid);
if (studentService.queryByNamePwd(sid, spassword) != null) {
httpSession.setAttribute("sid", sid);
httpSession.setAttribute("sname", student.getSname());
return new ModelAndView(new RedirectView("../student/studentFace.jsp"));
} else {
httpRequest.setAttribute("msg","账号或密码不正确，登录失败!");
return new ModelAndView(new RedirectView("../fail.jsp"));
}
}
// 学生退出登录
@RequestMapping("/studentlogout")
public ModelAndView studentLogout(HttpSession httpSession) {
httpSession.removeAttribute("sid");
httpSession.removeAttribute("sname");
httpSession.removeAttribute("courseList");
httpSession.removeAttribute("ssrList");
httpSession.removeAttribute("sesList");
return new ModelAndView(new RedirectView("/StudentSystem/index.jsp"));
}
// 教师登录
@RequestMapping("/teacherlogin")
public ModelAndView loginTeacher(@RequestParam("tid") String tid, @RequestParam("tpassword") String tpassword,
Model model, HttpSession httpSession) {
if (teacherService.queryByNamePwd(tid, tpassword) != null) {
Teacher teacher = new Teacher();
teacher = teacherService.getByTeaTid(tid);
// model.addAttribute("tid", tid);
httpSession.setAttribute("tid", tid);
httpSession.setAttribute("tname", teacher.getTname());
// httpSession.setAttribute("teachername", teacher.getTname());
return new ModelAndView(new RedirectView("../teacher/teacherFace.jsp"));
} else {
public String queryVita(@PathVariable(value = "sid") String sid, Model model) {
Grade grade = new Grade();
String credits = gradeService.queryCreditsSum(sid);
Student student = new Student();
student = studentService.getByStuSid(sid);
model.addAttribute("sid", student.getSid());
model.addAttribute("sname", student.getSname());
model.addAttribute("sidcard", student.getSidcard());
model.addAttribute("ssex", student.getSsex());
model.addAttribute("spassword", student.getSpassword());
model.addAttribute("sage", student.getSage());
model.addAttribute("classr", student.getClassr());
model.addAttribute("profession", student.getProfession());
model.addAttribute("college", student.getCollege());
model.addAttribute("credits", credits);
System.out.println(student);
System.out.println(student.getSpassword());
return "student/queryVitaStu";
}
// 跳转页面
@RequestMapping("/moditypwstu/{sid}")
public ModelAndView teacherModi(@PathVariable(value = "sid") String sid, Model model) {
return new ModelAndView(new RedirectView("/StudentSystem/student/modityPwStu.jsp"));
}
// 修改
@RequestMapping("/moditypasswordstu/{sid}")
public ModelAndView teacherModiPw(@PathVariable(value = "sid") String tid,
@RequestParam("spassword") String spassword, Model model) {
if (studentService.modifyStudentPwd(spassword, tid) != 0) {
return new ModelAndView(new RedirectView("../queryvitastu/{sid}"));
} else {
return new ModelAndView(new RedirectView("../fail.jsp"));
}
}
public void pageIn(Model model, List list) {
PageInfo page = new PageInfo(list, 5);
model.addAttribute("pageInfo", page);
}
// 查询
@RequestMapping(value = "/queryy/{pn}", method = RequestMethod.GET)
return "student/noseling";
}
}
// 加入课程
@RequestMapping("/seling")
public String confirmSelect(@RequestParam("cid") String cid, @RequestParam("sid") String sid, Model model,
HttpSession httpSession, HttpServletRequest httpRequest) {
// 判断是否加入过此课程
if (selectCourseService.existCourse(cid, sid) != null) {
httpRequest.setAttribute("msg", "已经加入过该课程，不能重复加入!");
System.out.println("已经加入过该课程，不能重复加入!");
return "fail";
}
if (selectCourseService.selectCourse(cid, sid) != 0) {
System.out.println(cid);
System.out.println(sid);
return "success";
} else {
return "fail";
}
}
// 退出
@RequestMapping("/backseling/{cid}")
public ModelAndView backConfirmSelect(@PathVariable(value = "cid") String cid) {
return new ModelAndView(new RedirectView("/StudentSystem/StudentHandler/selqueryy/1"));
}
// 跳转页面
@RequestMapping("/selqueryy/{pn}")
public String selQueryy(HttpServletRequest request, @PathVariable(value = "pn") String pn, Model model) {
int no = Integer.parseInt(pn);
List<Course> courseList = new ArrayList<Course>();
PageHelper.startPage(no, 5);
courseList = courseService.selectCourseBySql(1, 10);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
return "student/selCourse";
}
// 学生查询本人选课
@RequestMapping(value = "/selcouresult/{sid}/{pn}", method = RequestMethod.GET)
public String selcouresult(@PathVariable("sid") String sid, StuSelectResult ssr, HttpServletRequest request,
@PathVariable(value = "pn") String pn, Model model) {
List<StuSelectResult> ssrList = new ArrayList<StuSelectResult>();
ssrList = selectCourseService.getSCBySid(1, 10, sid);
pageIn(model, ssrList);
// ------------------此处有bug
List<CoursePlan> lists = coursePlanService.getCidByCoursePlanTid(1, 3, tid);
List<Course> courses = courseService.selectCourseBySql(1, Integer.MAX_VALUE);
for (CoursePlan coursePlan : coursePlanList) {
for (Course cours : courses) {
if (cours.getCid().equals(coursePlan.getCid())) {
coursePlan.setCoursename(cours.getCname());
}
}
}
httpSession.setAttribute("coursePlanList", coursePlanList);
httpSession.setAttribute("couList", couList);
System.out.println(coursePlanList);
System.out.println(couList);
return "teacher/manageCourse";
}
// 修改
@RequestMapping("/moditypw/{tid}")
public ModelAndView teacherModi(@PathVariable(value = "tid") String tid, Model model, HttpServletRequest request) {
System.out.print(request.getRemoteAddr());
return new ModelAndView(new RedirectView("../../teacher/modityPw.jsp"));
}
@RequestMapping("/moditypassword/{tid}")
public ModelAndView teacherModiPw(@PathVariable(value = "tid") String tid,
@RequestParam("tpassword") String tpassword, Model model) {
if (teacherService.modifyTeacherPwd(tpassword, tid) != 0) {
return new ModelAndView(new RedirectView("../queryvita/{tid}"));
} else {
return new ModelAndView(new RedirectView("../fail.jsp"));
}
}
@RequestMapping(value = "/sercsc/{tid}/{pn}", method = RequestMethod.GET)
public String sercChoose(@PathVariable("tid") String tid, StuSelectResult ssr, Model model, HttpSession httpSession,
@PathVariable(value = "pn") String pn) {
System.out.println("------------------------------------------------------------------------------------------------");
// studentList = studentService.selectStudentBySql(1,10);
// //model.addAttribute("studentList", studentList);
// request.setAttribute("slist", studentList);
// System.out.println("00000"+request.getAttribute("slist"));
// System.out.println(studentList);
studentList = studentService.selectStudentBySql(1,10);
pageIn(model, studentList);
request.setAttribute("slist", studentList);
return "admin/queryStudent";
//根据学号查询
} else if (serc.equals("sid")) {
studentList = studentService.getByStudentSid(1,10,condition);
pageIn(model, studentList);
request.setAttribute("slist", studentList);
System.out.println("sid");
return "admin/queryStudent";
//根据学院查询
} else if (serc.equals("col")) {
studentList = studentService.getByStudentCol(1,10,condition);
pageIn(model, studentList);
request.setAttribute("slist", studentList);
System.out.println(studentList);
System.out.println("col");
return "admin/queryStudent";
//根据专业查询
} else if (serc.equals("pro")) {
studentList = studentService.getByStudentPro(1,10,condition);
pageIn(model, studentList);
request.setAttribute("slist", studentList);
System.out.println(studentList);
System.out.println("pro");
return "admin/queryStudent";
//根据班级查询
} else {
return new ModelAndView(new RedirectView("../fail.jsp"));
}
}
// 教师退出登录
@RequestMapping("/teacherlogout")
public ModelAndView teacherLogout(HttpSession httpSession) {
httpSession.removeAttribute("tid");
httpSession.removeAttribute("tname");
httpSession.removeAttribute("couList");
httpSession.removeAttribute("sesList");
httpSession.removeAttribute("lookList");
return new ModelAndView(new RedirectView("/StudentSystem/index.jsp"));
}
}
/**
*
*/
@Controller
@RequestMapping("/AjaxHandler")
public class AjaxHandler {
@Autowired
httpSession.removeAttribute("couList");
httpSession.removeAttribute("coursePlanList");
return new ModelAndView(new RedirectView("/StudentSystem/TeacherHandler/managecou/{tid}/1"));
} else {
return new ModelAndView(new RedirectView("/StudentSystem/fail.jsp"));
}
}
}
/**
*
* @ProjectName: StudentInfo
* @Package: net.fuzui.StudentInfo.handler
* @ClassName: CourseHandler
* @Description: 课程handler类（servlet）
* 根据cid查学分
*/
if (grade >= 60) {
Integer credits = coursePlanService.getCreditsByCid(cid);
g.setCredits(credits);
}
gradeService.insertGrade(g);
System.out.println(g.toString());
return "teacher/endCourse";
}
}
public ModelAndView backConfirmSelect(@PathVariable(value = "cid") String cid) {
return new ModelAndView(new RedirectView("/StudentSystem/StudentHandler/selqueryy/1"));
}
// 跳转页面
@RequestMapping("/selqueryy/{pn}")
public String selQueryy(HttpServletRequest request, @PathVariable(value = "pn") String pn, Model model) {
int no = Integer.parseInt(pn);
List<Course> courseList = new ArrayList<Course>();
PageHelper.startPage(no, 5);
courseList = courseService.selectCourseBySql(1, 10);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
return "student/selCourse";
}
// 学生查询本人选课
@RequestMapping(value = "/selcouresult/{sid}/{pn}", method = RequestMethod.GET)
public String selcouresult(@PathVariable("sid") String sid, StuSelectResult ssr, HttpServletRequest request,
@PathVariable(value = "pn") String pn, Model model) {
List<StuSelectResult> ssrList = new ArrayList<StuSelectResult>();
ssrList = selectCourseService.getSCBySid(1, 10, sid);
pageIn(model, ssrList);
request.setAttribute("ssrList", ssrList);
return "student/selectedCourse";
}
// 所选课程列表详情-----退选
@RequestMapping(value = "/exitchoose/{sid}/{pn}", method = RequestMethod.GET)
public String exitChoose(@PathVariable("sid") String sid, StuSelectResult ssr, HttpServletRequest request,
@PathVariable(value = "pn") String pn, Model model) {
List<StuExitSelect> sesList = new ArrayList<StuExitSelect>();
sesList = selectCourseService.getExitBysid(1, 10, sid);
pageIn(model, sesList);
request.setAttribute("sesList", sesList);
return "student/exitSel";
}
// 退选
@RequestMapping(value = "/exitsel/{cid}/{sid}", method = RequestMethod.GET)
public ModelAndView exitSel(@PathVariable("cid") String cid, @PathVariable("sid") String sid) {
if (selectCourseService.deleteSC(cid, sid) != 0) {
return new ModelAndView(new RedirectView("/StudentSystem/StudentHandler/exitchoose/{sid}/1"));
} else {
return new ModelAndView(new RedirectView("../fail.jsp"));
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("cla");
return "admin/queryCourse";
} else if (serc.equals("col")) {
courseList = courseService.getByCourseCol(1,10,condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("col");
return "admin/queryCourse";
} else if (serc.equals("type")) {
courseList = courseService.getByCourseType(1,10,condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("pro");
return "admin/queryCourse";
} else {
courseList = courseService.selectCourseBySql(1,10);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
return "admin/queryCourse";
}
}
//删除学生
@RequestMapping(value = "/delete/{cid}", method = RequestMethod.GET)
public String deleteStudent(@PathVariable(value = "cid") String cid, HttpServletRequest request) {
if (courseService.deleteCourse(cid) != 0) {
System.out.println("success");
queryCou(request);
return "success";
} else {
System.out.println("fail");
return "fail";
}
}
//跳转到queryCourse页面
@RequestMapping(value = "/finalPage", method = RequestMethod.GET)
Grade grade = new Grade();
String credits = gradeService.queryCreditsSum(sid);
Student student = new Student();
student = studentService.getByStuSid(sid);
model.addAttribute("sid", student.getSid());
model.addAttribute("sname", student.getSname());
model.addAttribute("sidcard", student.getSidcard());
model.addAttribute("ssex", student.getSsex());
model.addAttribute("spassword", student.getSpassword());
model.addAttribute("sage", student.getSage());
model.addAttribute("classr", student.getClassr());
model.addAttribute("profession", student.getProfession());
model.addAttribute("college", student.getCollege());
model.addAttribute("credits", credits);
System.out.println(student);
System.out.println(student.getSpassword());
return "student/queryVitaStu";
}
// 跳转页面
@RequestMapping("/moditypwstu/{sid}")
public ModelAndView teacherModi(@PathVariable(value = "sid") String sid, Model model) {
return new ModelAndView(new RedirectView("/StudentSystem/student/modityPwStu.jsp"));
}
// 修改
@RequestMapping("/moditypasswordstu/{sid}")
public ModelAndView teacherModiPw(@PathVariable(value = "sid") String tid,
@RequestParam("spassword") String spassword, Model model) {
if (studentService.modifyStudentPwd(spassword, tid) != 0) {
return new ModelAndView(new RedirectView("../queryvitastu/{sid}"));
} else {
return new ModelAndView(new RedirectView("../fail.jsp"));
}
}
return new ModelAndView(new RedirectView("/StudentSystem/index.jsp"));
}
// 教师登录
@RequestMapping("/teacherlogin")
public ModelAndView loginTeacher(@RequestParam("tid") String tid, @RequestParam("tpassword") String tpassword,
Model model, HttpSession httpSession) {
if (teacherService.queryByNamePwd(tid, tpassword) != null) {
Teacher teacher = new Teacher();
teacher = teacherService.getByTeaTid(tid);
// model.addAttribute("tid", tid);
httpSession.setAttribute("tid", tid);
httpSession.setAttribute("tname", teacher.getTname());
// httpSession.setAttribute("teachername", teacher.getTname());
return new ModelAndView(new RedirectView("../teacher/teacherFace.jsp"));
} else {
return new ModelAndView(new RedirectView("../fail.jsp"));
}
}
// 教师退出登录
@RequestMapping("/teacherlogout")
public ModelAndView teacherLogout(HttpSession httpSession) {
httpSession.removeAttribute("tid");
httpSession.removeAttribute("tname");
httpSession.removeAttribute("couList");
httpSession.removeAttribute("sesList");
httpSession.removeAttribute("lookList");
return new ModelAndView(new RedirectView("/StudentSystem/index.jsp"));
}
}
// 查询课程
@RequestMapping(value = "/query/{pn}", method = RequestMethod.GET)
public String redirect(@RequestParam("serc") String serc, @RequestParam("condition") String condition,
HttpServletRequest request,@PathVariable(value = "pn") String pn,Model model) {
int no = Integer.parseInt(pn);
List<Course> courseList = new ArrayList<Course>();
PageHelper.startPage(no, 5);
request.setAttribute("serc", serc);
request.setAttribute("condition", condition);
if (serc.equals("all")) {
courseList = courseService.selectCourseBySql(1,10);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
return "admin/queryCourse";
} else if (serc.equals("sid")) {
courseList = courseService.getByCourseCid(1,10,condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println("sid");
return "admin/queryCourse";
} else if (serc.equals("nam")) {
courseList = courseService.getByCourseCname(1,10,condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("cla");
return "admin/queryCourse";
} else if (serc.equals("col")) {
courseList = courseService.getByCourseCol(1,10,condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("col");
return "admin/queryCourse";
} else if (serc.equals("type")) {
courseList = courseService.getByCourseType(1,10,condition);
public void queryCou(HttpServletRequest request) {
List<Course> courseList = new ArrayList<Course>();
courseList = courseService.selectCourseBySql(1,10);
request.setAttribute("courseList", courseList);
}
// 查询课程
@RequestMapping(value = "/query/{pn}", method = RequestMethod.GET)
public String redirect(@RequestParam("serc") String serc, @RequestParam("condition") String condition,
HttpServletRequest request,@PathVariable(value = "pn") String pn,Model model) {
int no = Integer.parseInt(pn);
List<Course> courseList = new ArrayList<Course>();
PageHelper.startPage(no, 5);
request.setAttribute("serc", serc);
request.setAttribute("condition", condition);
if (serc.equals("all")) {
courseList = courseService.selectCourseBySql(1,10);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
return "admin/queryCourse";
} else if (serc.equals("sid")) {
courseList = courseService.getByCourseCid(1,10,condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println("sid");
return "admin/queryCourse";
} else if (serc.equals("nam")) {
courseList = courseService.getByCourseCname(1,10,condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("cla");
return "admin/queryCourse";
} else if (serc.equals("col")) {
courseList = courseService.getByCourseCol(1,10,condition);
} else if (serc.equals("nam")) {
courseList = courseService.getByCourseCname(1, 10, condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("cla");
return "student/selCourse";
} else if (serc.equals("col")) {
courseList = courseService.getByCourseCol(1, 10, condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("col");
return "student/selCourse";
} else if (serc.equals("type")) {
courseList = courseService.getByCourseType(1, 10, condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("pro");
return "student/selCourse";
} else {
courseList = courseService.selectCourseBySql(1, 10);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
return "student/selCourse";
}
}
// 查询,根据cid查询老师
@RequestMapping(value = "/selcou/{cid}", method = RequestMethod.GET)
public String selCou(@PathVariable(value = "cid") String cid, Model model) {
if (serc.equals("all")) {
courseList = courseService.selectCourseBySql(1, 10);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
return "student/selCourse";
} else if (serc.equals("sid")) {
courseList = courseService.getByCourseCid(1, 10, condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println("sid");
return "student/selCourse";
} else if (serc.equals("nam")) {
courseList = courseService.getByCourseCname(1, 10, condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("cla");
return "student/selCourse";
} else if (serc.equals("col")) {
courseList = courseService.getByCourseCol(1, 10, condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("col");
return "student/selCourse";
} else if (serc.equals("type")) {
courseList = courseService.getByCourseType(1, 10, condition);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
System.out.println("pro");
return "student/selCourse";
} else {
courseList = courseService.selectCourseBySql(1, 10);
pageIn(model, courseList);
request.setAttribute("courseList", courseList);
System.out.println(courseList);
return "student/selCourse";
}
}
汇聚全球AI编程工具，助力开发者即刻编程。
更多推荐
5
0- 0
已为社区贡献57条内容
所有评论(0)