• Java项目：SSM学生选课管理系统

    作者主页：夜未央5788

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

    文末获取源码

    项目介绍

    由SpringMVC+MyBatis为主要框架，mysql8.0配置主从复制实现读写分离。前端主要由bootstrap完成，背景用particles.js插件。数据库交互查询用到pagehelper分页。在添加修改相关功能时通过ajax来验证其主键是否存在可用。代码层次清晰，输入框约束较高，已配置登录拦截。

    项目主要分为管理员、教师、学生三种角色；

    管理员角色包含以下功能：

    管理员登录,学生管理,教师管理,课程管理等功能。

    教师角色包含以下功能：
    登录界面,查看课程,建立课程计划,管理教学课程,成绩查询结课等功能。

    学生角色包含以下功能：

    登录界面,选课,确认选课,查看选课结果,退选界面,查看已修课程,管理个人信息等功能。

    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 

    5.数据库：MySql 5.7版本；

    6.是否Maven项目：是；

    技术栈

    1. 后端：Spring+SpringMVC+Mybatis

    2. 前端：JavaScript、jQuery、bootstrap4、particles.js、ajax

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中applicationContext.xml配置文件中的数据库配置改为自己的配置;注：因为此处为读写分离的，需要配置2处；
    4. 运行项目，输入localhost:8080/ 登录
    管理员账号/密码：admin/admin
    教师账号/密码： 0002/123456

    学生账号/密码：201507021227/123456

    运行截图

    管理员角色

     

     

     

    学生管理

     

     

     

     

    教师角色

     

     

     

     

     

    相关代码

    AdminHandler

    1. package net.fuzui.StudentInfo.handler;
    2.  
    3. import net.fuzui.StudentInfo.pojo.Student;
    4. import net.fuzui.StudentInfo.pojo.Teacher;
    5. import net.fuzui.StudentInfo.service.AdminService;
    6. import net.fuzui.StudentInfo.service.CoursePlanService;
    7. import net.fuzui.StudentInfo.service.CourseService;
    8. import net.fuzui.StudentInfo.service.SelectCourseService;
    9. import net.fuzui.StudentInfo.service.StudentService;
    10. import net.fuzui.StudentInfo.service.TeacherService;
    11. import net.fuzui.StudentInfo.service.impl.AdminServiceImpl;
    12. import org.springframework.beans.factory.annotation.Autowired;
    13. import org.springframework.http.HttpRequest;
    14. import org.springframework.stereotype.Controller;
    15. import org.springframework.ui.Model;
    16. import org.springframework.web.bind.annotation.PathVariable;
    17. import org.springframework.web.bind.annotation.RequestMapping;
    18. import org.springframework.web.bind.annotation.RequestMethod;
    19. import org.springframework.web.bind.annotation.RequestParam;
    20. import org.springframework.web.bind.annotation.SessionAttributes;
    21. import org.springframework.web.servlet.ModelAndView;
    22. import org.springframework.web.servlet.view.RedirectView;
    23.  
    24. import com.github.pagehelper.PageHelper;
    25. import com.github.pagehelper.PageInfo;
    26.  
    27. import java.util.ArrayList;
    28. import java.util.List;
    29.  
    30. import javax.servlet.http.HttpServletRequest;
    31. import javax.servlet.http.HttpSession;
    32.  
    33. @Controller
    34. @RequestMapping("/AdminHandler")
    35. //@SessionAttributes("studentList")
    36. //@SessionAttributes("teacherList")
    37. public class AdminHandler {
    38.  
    39.  
    40.     @Autowired
    41. 	StudentService studentService;
    42. 	@Autowired
    43. 	TeacherService teacherService;
    44. 	@Autowired
    45. 	CoursePlanService coursePlanService;
    46. 	@Autowired
    47.     CourseService courseService;
    48. 	@Autowired
    49. 	SelectCourseService selectCourseService;
    50.  
    51.  
    52. 	/**
    53. 	 * JavaScript学的不好，目前只能通过这种方式把三级联动下拉列表的val改变为以下值传给数据库。
    54. 	 * 
    55. 	 */
    56. 	String[] arr_belongcoll = {"计算机学院","建筑学院","外国语学院","人文学院"};
    57. 	String[][] arr_belongpro = {
    58.                     {"网络工程","软件工程","物联网","信息管理"},
    59.                     {"土木工程","测绘工程","工程造价", "城市规划"},
    60.                     {"英语", "日语", "俄语", "西班牙语"},
    61.                     {"汉语言", "历史", "新闻", "网络新媒体"}
    62. 				};
    63. 	String[][][] arr_belongcla = {
    64.                 {
    65.                     {"网络B151","网络B152","网络B161","网络B162","网络B171","网络B172"},
    66.                     {"软件B151","软件B152","软件B161","软件B162","软件B171","软件B172"},
    67.                     {"物联B151","物联B152","物联B161","物联B162","物联B171","物联B172"},
    68.                     {"信管B151","信管B152","信管B161","信管B162","信管B171","信管B172"}
    69.                     
    70.                 },
    71.                 {
    72.                     {"土木B151","土木B152","土木B161","土木B162","土木B171","土木B172"},
    73.                     {"测绘B151","测绘B152","测绘B161","测绘B162","测绘B171","测绘B172"},
    74.                     {"造价B151","造价B152","造价B161","造价B162","造价B171","造价B172"},
    75.                     {"规划B151","规划B152","规划B161","规划B162","规划B171","规划B172"}
    76.                     
    77.                 },
    78.                 {
    79.                     {"英语B151","英语B152","英语B161","英语B162","英语B171","英语B172"},
    80.                     {"日语B151","日语B152","日语B161","日语B162","日语B171","日语B172"},
    81.                     {"俄语B151","俄语B152","俄语B161","俄语B162","俄语B171","俄语B172"},
    82.                     {"牙语B151","牙语B152","牙语B161","牙语B162","牙语B171","牙语B172"}
    83.                     
    84. 				},
    85.                 {
    86.                     {"汉语B151","汉语B152","汉语B161","汉语B162","汉语B171","汉语B172"},
    87.                     {"历史B151","历史B152","历史B161","历史B162","历史B171","历史B172"},
    88.                     {"新闻B151","新闻B152","新闻B161","新闻B162","新闻B171","新闻B172"},
    89.                     {"网媒B151","网媒B152","网媒B161","网媒B162","网媒B171","网媒B172"}
    90.                     
    91. 				}
    92. 		};
    93.  
    94.  // 添加
    95.  	@RequestMapping("/addStudent")
    96.  	public String addStudent(Student student, Model model) {
    97.  		
    98.  		
    99.  		
    100.  		
    101.  		int col = Integer.parseInt(student.getCollege());
    102.  		int pro = Integer.parseInt(student.getProfession());
    103.  		int cla = Integer.parseInt(student.getClassr());
    104.  		//总感觉前端js写的有问题。
    105.  		student.setCollege(arr_belongcoll[pro]);
    106.  		student.setProfession(arr_belongpro[pro][col]);
    107.  		student.setClassr(arr_belongcla[pro][col][cla]);
    108.  		
    109.  		
    110.  		
    111.  		if (studentService.insertStudent(student) != 0) {
    112.  			model.addAttribute("student", student);
    113.  			return "success";
    114.  			// return "admin/addStudent";
    115.  		} else {
    116.  			return "fail";
    117.  		}
    118.  
    119.  	}
    120.  	//查询全部学生方法
    121.  	public void queryStu(HttpServletRequest request) {
    122.  		List studentList = new ArrayList();
    123.  		studentList = studentService.selectStudentBySql(1,10);
    124.  		
    125.  		
    126.  		request.setAttribute("slist", studentList);
    127.  	}
    128.  
    129.  	public void pageIn(Model model,List list) {
    130.  		PageInfo page = new PageInfo(list, 5);
    131. 	 	model.addAttribute("pageInfo", page);
    132.  	}
    133.  	
    134.  	// 查询
    135.  	@RequestMapping(value = "/query/{pn}", method = RequestMethod.GET)
    136.  	public String redirect(@RequestParam("serc") String serc, @RequestParam("condition") String condition,HttpServletRequest request,
    137.  			@PathVariable(value = "pn") String pn,Model model) {
    138.  
    139.  		int no = Integer.parseInt(pn);
    140. // 		System.out.println("-----"+no+"----");
    141.  		List studentList = new ArrayList();
    142.  		PageHelper.startPage(no, 5);
    143.  		request.setAttribute("serc", serc);
    144. 		request.setAttribute("condition", condition);
    145.  		//查询全部
    146.  		if (serc.equals("all")) {
    147.  			
    148.  			
    149.  			
    150.  	 		
    151.  			System.out.println("------------------------------------------------------------------------------------------------");
    152. // 			studentList = studentService.selectStudentBySql(1,10);
    153. // 			//model.addAttribute("studentList", studentList);
    154. // 			request.setAttribute("slist", studentList);
    155. // 			System.out.println("00000"+request.getAttribute("slist"));
    156. // 			System.out.println(studentList);
    157.  			studentList = studentService.selectStudentBySql(1,10);
    158.  			pageIn(model, studentList);
    159.  	 		request.setAttribute("slist", studentList);
    160.  			return "admin/queryStudent";
    161.  
    162.  		//根据学号查询
    163.  		} else if (serc.equals("sid")) {
    164.  
    165.  			studentList = studentService.getByStudentSid(1,10,condition);
    166.  			pageIn(model, studentList);
    167.  			request.setAttribute("slist", studentList);
    168.  			System.out.println("sid");
    169.  
    170.  			return "admin/queryStudent";
    171.  
    172.  		//根据学院查询
    173.  		} else if (serc.equals("col")) {
    174.  			
    175.  			
    176.  			studentList = studentService.getByStudentCol(1,10,condition);
    177.  			pageIn(model, studentList);
    178.  			request.setAttribute("slist", studentList);
    179.  			System.out.println(studentList);
    180.  			System.out.println("col");
    181.  			return "admin/queryStudent";
    182.  
    183.  		//根据专业查询
    184.  		} else if (serc.equals("pro")) {
    185.  			studentList = studentService.getByStudentPro(1,10,condition);
    186.  			pageIn(model, studentList);
    187.  			request.setAttribute("slist", studentList);
    188.  			System.out.println(studentList);
    189.  			System.out.println("pro");
    190.  			return "admin/queryStudent";
    191.  
    192.  		//根据班级查询
    193.  		} else if (serc.equals("cla")) {
    194.  			studentList = studentService.getByStudentCla(1,10,condition);
    195.  			pageIn(model, studentList);
    196.  			//model.addAttribute("studentList", studentList);
    197.  			request.setAttribute("slist", studentList);
    198. // 			System.out.println(studentList);
    199. // 			System.out.println("cla");
    200.  			return "admin/queryStudent";
    201.  
    202.  		} else {
    203.  
    204. // 			studentList = studentService.selectStudentBySql(1,10);
    205. // 			model.addAttribute("studentList", studentList);
    206. // 			request.setAttribute("slist", studentList);
    207. // 			System.out.println("00000"+request.getAttribute("slist"));
    208. // 			System.out.println(studentList);
    209.  			studentList = studentService.selectStudentBySql(1,10);
    210.  			pageIn(model, studentList);
    211.  	 		request.setAttribute("slist", studentList);
    212.  			return "admin/queryStudent";
    213.  
    214.  		}
    215.  
    216.  	}
    217.  
    218.  	// 删除学生
    219.  	@RequestMapping(value = "/delete/{sid}", method = RequestMethod.GET)
    220.  	public String deleteStudent(@PathVariable(value = "sid") String sid, Model model) {
    221.  
    222.  
    223.  		if (studentService.deleteStudent(sid) != 0) {
    224.  			System.out.println("success");
    225.  			
    226.  			return "success";
    227.  		} else {
    228.  			System.out.println("fail");
    229.  			return "fail";
    230.  		}
    231.  
    232.  	}
    233.  
    234.  	// 跳转页面
    235.  	@RequestMapping(value = "/finalPage", method = RequestMethod.GET)
    236.  	public String finalPage(HttpServletRequest request) {
    237.  		queryStu(request);
    238.  		return "admin/queryStudent";
    239.  	}
    240.  
    241.  	// 修改定位
    242.  	@RequestMapping(value = "/moditystu/{sid}", method = RequestMethod.GET)
    243.  	public String editPre(@PathVariable("sid") String sid, HttpServletRequest request) {
    244.  
    245.  		List studentList = new ArrayList();
    246.  		studentList = studentService.getByStudentSid(1,10,sid);
    247.  		
    248.  		request.setAttribute("studentList", studentList);
    249.  		System.out.println("-----进入修改");
    250.  		return "admin/modiStudent";
    251.  	}
    252.  
    253.  	
    254.  	
    255.  	// 修改
    256.  	@RequestMapping(value = "/moditystud/{sid}", method = RequestMethod.GET)
    257.  	public String update(@PathVariable("sid") String sid, Student student, HttpServletRequest request) {
    258.  
    259.  		int col = Integer.parseInt(student.getCollege());
    260.  		int pro = Integer.parseInt(student.getProfession());
    261.  		int cla = Integer.parseInt(student.getClassr());
    262.  		//总感觉前端js写的有问题。
    263.  		student.setCollege(arr_belongcoll[pro]);
    264.  		student.setProfession(arr_belongpro[pro][col]);
    265.  		student.setClassr(arr_belongcla[pro][col][cla]);
    266.  		
    267.  		if (studentService.modifyStudent(student) != 0) {
    268.  			System.out.println("----修改成功--------------------------------------------------------------------------------------------------------");
    269.  			return "success";
    270.  		} else {
    271.  			System.out.println("----修改失败----------------------------------------------------------------");
    272.  			return "fail";
    273.  		}
    274.  	}
    275.  	
    276.  	
    277.  	
    278.  
    279.  	// 跳转页面
    280.  	@RequestMapping("/managestu/{pn}")
    281.  	public String manageStudent(HttpServletRequest request,
    282.  			@PathVariable(value = "pn") String pn,Model model) {
    283.  		int no = Integer.parseInt(pn);
    284.  		
    285.  		PageHelper.startPage(no, 5);
    286.  		List studentList = new ArrayList();
    287.  		studentList = studentService.selectStudentBySql(1,100);
    288.  		pageIn(model, studentList);
    289.  		request.setAttribute("slist", studentList);
    290.  		return "admin/queryStudent";
    291.  	}
    292.  		
    293.  	// 跳转页面
    294.  	@RequestMapping("/managetea/{pn}")
    295.  	public String manageTeacher(HttpServletRequest request,
    296.  			@PathVariable(value = "pn") String pn,Model model) {
    297.  		int no = Integer.parseInt(pn);
    298.  		PageHelper.startPage(no, 5);
    299.  		List teacherList = new ArrayList();
    300. 	 	teacherList = teacherService.selectTeacherBySql(1,10);
    301. 	 	pageIn(model, teacherList);
    302. 	 	request.setAttribute("teacherList", teacherList);
    303.  		return "admin/queryTeacher";
    304.  	}
    305.  
    306.  
    307.  	// 跳转页面
    308.  	@RequestMapping("/addstu")
    309.  	public String adStudent() {
    310.  		return "admin/addStudent";
    311.  	}
    312.  
    313.  	// 跳转页面
    314.  	@RequestMapping("/addtea")
    315.  	public String adTeacher() {
    316.  		return "admin/addTeacher";
    317.  	}
    318.  
    319.  	// 跳转页面
    320.  	@RequestMapping("/addcou")
    321.  	public String adCourse() {
    322.  		return "admin/addCourse";
    323.  	}
    324.  	
    325.  // 添加
    326.  	@RequestMapping("/addTeacher")
    327.  	public String addTeacher(Teacher teacher, Model model, HttpSession httpSession) {
    328.  
    329.  		if (teacherService.insertTeacher(teacher) != 0) {
    330.  			model.addAttribute("teacher", teacher);
    331.  
    332.  			//---------------------------------待优化-----同样不能实时刷新--------------------------------------------
    333.  			return "success";
    334.  			//return new ModelAndView(new RedirectView("/StudentInfo/TeacherHandler/finalPage"));
    335.  			// return "techer/teacherFace";
    336.  		} else {
    337.  			return "fail";
    338.  			//return new ModelAndView(new RedirectView("fail"));
    339.  		}
    340.  
    341.  	}
    342.  
    343.  	
    344.  	/**
    345.  	 * 教师相关
    346.  	 */
    347.  	
    348.  	//查询全部教师方法
    349.  	 	public void queryTea(HttpServletRequest request) {
    350.  	 		List teacherList = new ArrayList();
    351.  	 		teacherList = teacherService.selectTeacherBySql(1,10);
    352.  	 		request.setAttribute("teacherList", teacherList);
    353.  	 	}
    354.  	
    355.  	// 查询
    356.  	@RequestMapping(value = "/queryTea/{pn}", method = RequestMethod.GET)
    357.  	public String redirectTea(@RequestParam("serc") String serc, @RequestParam("condition") String condition,HttpServletRequest request,
    358.  			@PathVariable(value = "pn") String pn,Model model) {
    359.  		int no = Integer.parseInt(pn);
    360.  		PageHelper.startPage(no, 5);
    361.  		List teacherList = new ArrayList();
    362.  		request.setAttribute("serc", serc);
    363. 		request.setAttribute("condition", condition);
    364.  		
    365.  		if (serc.equals("all")) {
    366.  
    367.  			teacherList = teacherService.selectTeacherBySql(1,10);
    368.  			pageIn(model, teacherList);
    369.  	 		request.setAttribute("teacherList", teacherList);
    370.  			return "admin/queryTeacher";
    371.  
    372.  		} else if (serc.equals("tid")) {
    373.  
    374.  			teacherList = teacherService.getByTeacherTid(1,10,condition);
    375.  			pageIn(model, teacherList);
    376.  			request.setAttribute("teacherList", teacherList);
    377.  			System.out.println("tid");
    378.  
    379.  			return "admin/queryTeacher";
    380.  
    381.  		} else {
    382.  
    383.  			teacherList = teacherService.selectTeacherBySql(1,10);
    384.  			pageIn(model, teacherList);
    385.  	 		request.setAttribute("teacherList", teacherList);
    386.  			return "admin/queryTeacher";
    387.  
    388.  		}
    389.  
    390.  	}
    391.  	
    392.  	
    393.  
    394.  	//删除教师
    395.  	@RequestMapping(value = "/deleteTea/{tid}", method = RequestMethod.GET)
    396.  	public String deleteTeacher(@PathVariable(value = "tid") String tid, Model model) {
    397.  
    398.  
    399.  		if (teacherService.deleteTeacher(tid) != 0) {
    400.  			System.out.println("success");
    401.  //------------------------代优化，现状：删除后需要手动刷新界面或者重新查询，不能实时刷新。---------------------------------------------------
    402.  			return "success";
    403.  		} else {
    404.  			System.out.println("fail");
    405.  			return "fail";
    406.  			
    407.  		}
    408.  
    409.  	}
    410.  
    411.  	@RequestMapping(value = "/finalPageTea", method = RequestMethod.GET)
    412.  	public String finalPageTea(HttpServletRequest request) {
    413.  		queryTea(request);
    414.  		return "admin/queryTeacher";
    415.  	}
    416.  
    417.  	//修改定位，可优化
    418.  	@RequestMapping(value = "/modityTea/{tid}", method = RequestMethod.GET)
    419.  	public String editPreTea(@PathVariable("tid") String tid, HttpServletRequest request) {
    420.  
    421.  		List teacherList = new ArrayList();
    422.  		teacherList = teacherService.getByTeacherTid(1,10,tid);
    423.  		//model.addAttribute("teacherList", teacherList);
    424.  		request.setAttribute("teacherList", teacherList);
    425.  
    426.  		return "admin/modiTeacher";
    427.  	}
    428.  
    429.  	// 修改
    430.  	@RequestMapping(value = "/modityTeac/{tid}", method = RequestMethod.GET)
    431.  	public String update(@PathVariable("tid") String tid, Teacher teacher, HttpServletRequest request) {
    432.  
    433.  		if (teacherService.modifyTeacher(teacher) != 0) {
    434.  			return "success";
    435.  		} else {
    436.  			return "fail";
    437.  		}
    438.  	}
    439.     
    440.     
    441. }

    AjaxHandler

    1. package net.fuzui.StudentInfo.handler;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import java.io.UnsupportedEncodingException;
    6.  
    7. import javax.servlet.http.HttpServletRequest;
    8. import javax.servlet.http.HttpServletResponse;
    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.RequestMethod;
    14. import org.springframework.web.bind.annotation.RequestParam;
    15.  
    16. import net.fuzui.StudentInfo.service.CoursePlanService;
    17. import net.fuzui.StudentInfo.service.CourseService;
    18. import net.fuzui.StudentInfo.service.StudentService;
    19. import net.fuzui.StudentInfo.service.TeacherService;
    20.  
    21. @Controller
    22. @RequestMapping("/AjaxHandler")
    23. public class AjaxHandler {
    24. 	@Autowired
    25.     CourseService courseService;
    26. 	@Autowired
    27. 	StudentService studentService;
    28. 	@Autowired
    29. 	TeacherService teacherService;
    30. 	@Autowired
    31. 	CoursePlanService coursePlanService;
    32. 	
    33. 	/**
    34. 	 * ajax验证课程编号是否存在
    35. 	 * @param cid
    36. 	 * @param response
    37. 	 * @param request
    38. 	 * @throws IOException
    39. 	 */
    40. 	@RequestMapping(value="/existCid",method = RequestMethod.POST)
    41. 	public void existCid(@RequestParam("cid") String cid,HttpServletResponse response,HttpServletRequest request) throws IOException{
    42. 		System.out.println("课程编号="+cid);
    43.  
    44. 		response.setContentType("text/html;charset=UTF-8");
    45. 		response.setHeader("Cache-Control", "no-cache");
    46. 		System.out.println(cid+"----------");
    47. 		PrintWriter out=null;
    48. 		
    49. 		out=response.getWriter();
    50. 		if(courseService.getByCouCid(cid) != null && cid !=null && !"".equals(cid)){
    51. 			out.println("课程编号已存在");
    52. 		}else if(cid !=null && !"".equals(cid)){
    53. 			out.println("此课程编号可以使用");
    54. 		}else {
    55. 			out.println("课程编号不能为空");
    56. 		}
    57. 		out.flush();
    58. 		out.close();
    59. 		
    60. 	}
    61. 	
    62. 	@RequestMapping(value="/existSid",method = RequestMethod.POST)
    63. 	public void existSid(@RequestParam("sid") String sid,HttpServletResponse response,HttpServletRequest request) throws IOException{
    64. 		System.out.println("学号="+sid);
    65.  
    66. 		response.setContentType("text/html;charset=UTF-8");
    67. 		response.setHeader("Cache-Control", "no-cache");
    68. 		PrintWriter out=null;
    69. 		
    70. 		out=response.getWriter();
    71. 		if(studentService.getByStuSid(sid) != null && sid.length() ==12){
    72. 			out.println("学号已存在");
    73. 		}else if(sid.length() ==12){
    74. 			out.println("学号可以使用");
    75. 		}else {
    76. 			out.println("学号必须是12位");
    77. 		}
    78. 		out.flush();
    79. 		out.close();
    80. 		
    81. 	}
    82. 	//ajax验证教师id
    83. 	@RequestMapping(value="/existTid",method = RequestMethod.POST)
    84. 	public void existTid(@RequestParam("tid") String tid,HttpServletResponse response,HttpServletRequest request) throws IOException{
    85.  
    86. 		response.setContentType("text/html;charset=UTF-8");
    87. 		response.setHeader("Cache-Control", "no-cache");
    88. 		PrintWriter out=null;
    89. 		
    90. 		out=response.getWriter();
    91. 		if(teacherService.getByTeaTid(tid) != null && tid.length() <=5){
    92. 			out.println("教师编号已存在");
    93. 		}else if(tid.length() <=12){
    94. 			out.println("教师编号可以使用");
    95. 		}else {
    96. 			out.println("教师编号必须小于等于5位");
    97. 		}
    98. 		out.flush();
    99. 		out.close();
    100. 		
    101. 	}
    102.  
    103. 	
    104. 	@RequestMapping(value="/existTime",method = RequestMethod.POST)
    105. 	public void existTime(@RequestParam("coursetime") String coursetime,@RequestParam("courseweek") String courseweek,
    106. 			@RequestParam("classroom") String classroom,HttpServletResponse response,HttpServletRequest request) throws IOException{
    107.  
    108. 		response.setContentType("text/html;charset=UTF-8");
    109. 		response.setHeader("Cache-Control", "no-cache");
    110. 		PrintWriter out=null;
    111. 		System.out.println("--------------------------");
    112. 		System.out.println(coursetime+"---"+courseweek+"---"+classroom);
    113. 		out=response.getWriter();
    114. 		if(coursePlanService.ajaxGetCoursePlan(coursetime,courseweek,classroom) != null){
    115. 			out.println("此功能排重正在开发中.....");
    116. 		}else {
    117. 			out.println("此功能排重正在开发中.....");
    118. 		}
    119. 		out.flush();
    120. 		out.close();
    121. 		
    122. 	}
    123. 	
    124. }

    CourseHandler

    1. package net.fuzui.StudentInfo.handler;
    2.  
    3. import java.util.ArrayList;
    4. import java.util.List;
    5.  
    6. import javax.servlet.http.HttpServletRequest;
    7. import javax.servlet.http.HttpSession;
    8.  
    9. import org.springframework.beans.factory.annotation.Autowired;
    10. import org.springframework.stereotype.Controller;
    11. import org.springframework.ui.Model;
    12. import org.springframework.web.bind.annotation.PathVariable;
    13. import org.springframework.web.bind.annotation.RequestMapping;
    14. import org.springframework.web.bind.annotation.RequestMethod;
    15. import org.springframework.web.bind.annotation.RequestParam;
    16. import org.springframework.web.bind.annotation.SessionAttributes;
    17.  
    18. import com.github.pagehelper.PageHelper;
    19. import com.github.pagehelper.PageInfo;
    20.  
    21. import net.fuzui.StudentInfo.pojo.Course;
    22. import net.fuzui.StudentInfo.pojo.Teacher;
    23. import net.fuzui.StudentInfo.service.CourseService;
    24.  
    25. @Controller
    26. @RequestMapping("/CourseHandler")
    27. @SessionAttributes("courseList")
    28. public class CourseHandler {
    29. 	@Autowired
    30.     CourseService courseService;
    31.  
    32. 	// 添加课程
    33. 	@RequestMapping("/addCourse")
    34. 	public String addCourse(Course course, Model model) {
    35. 		
    36.  
    37. 		if (courseService.insertCourse(course) != 0) {
    38. 			model.addAttribute("course", course);
    39. 			return "success";
    40. 		} else {
    41. 			return "fail";
    42. 		}
    43. 	}
    44.  
    45. 	public void pageIn(Model model,List list) {
    46.  		PageInfo page = new PageInfo(list, 5);
    47. 	 	model.addAttribute("pageInfo", page);
    48.  	}
    49. 	
    50. 	public void queryCou(HttpServletRequest request) {
    51. 		List courseList = new ArrayList();
    52. 	 	courseList = courseService.selectCourseBySql(1,10);
    53. 	 	request.setAttribute("courseList", courseList);
    54. 	}
    55.  
    56. 	// 查询课程
    57. 	@RequestMapping(value = "/query/{pn}", method = RequestMethod.GET)
    58. 	public String redirect(@RequestParam("serc") String serc, @RequestParam("condition") String condition,
    59. 			HttpServletRequest request,@PathVariable(value = "pn") String pn,Model model) {
    60.  
    61. 		int no = Integer.parseInt(pn);
    62. 		List courseList = new ArrayList();
    63. 		PageHelper.startPage(no, 5);
    64. 		request.setAttribute("serc", serc);
    65. 		request.setAttribute("condition", condition);
    66. 		
    67. 		
    68. 		if (serc.equals("all")) {
    69.  
    70. 	
    71. 		 	courseList = courseService.selectCourseBySql(1,10);
    72. 		 	pageIn(model, courseList);
    73. 		 	request.setAttribute("courseList", courseList);
    74. 			System.out.println(courseList);
    75. 			return "admin/queryCourse";
    76.  
    77. 		} else if (serc.equals("sid")) {
    78.  
    79. 			courseList = courseService.getByCourseCid(1,10,condition);
    80. 			pageIn(model, courseList);
    81. 			request.setAttribute("courseList", courseList);
    82. 			System.out.println("sid");
    83.  
    84. 			return "admin/queryCourse";
    85.  
    86. 		} else if (serc.equals("nam")) {
    87. 			courseList = courseService.getByCourseCname(1,10,condition);
    88. 			pageIn(model, courseList);
    89. 			request.setAttribute("courseList", courseList);
    90. 			System.out.println(courseList);
    91. 			System.out.println("cla");
    92. 			return "admin/queryCourse";
    93.  
    94. 		} else if (serc.equals("col")) {
    95. 			courseList = courseService.getByCourseCol(1,10,condition);
    96. 			pageIn(model, courseList);
    97. 			request.setAttribute("courseList", courseList);
    98. 			System.out.println(courseList);
    99. 			System.out.println("col");
    100. 			return "admin/queryCourse";
    101.  
    102. 		} else if (serc.equals("type")) {
    103. 			courseList = courseService.getByCourseType(1,10,condition);
    104. 			pageIn(model, courseList);
    105. 			request.setAttribute("courseList", courseList);
    106. 			System.out.println(courseList);
    107. 			System.out.println("pro");
    108. 			return "admin/queryCourse";
    109.  
    110. 		} else {
    111.  
    112. 			courseList = courseService.selectCourseBySql(1,10);
    113. 		 	pageIn(model, courseList);
    114. 		 	request.setAttribute("courseList", courseList);
    115. 			return "admin/queryCourse";
    116.  
    117. 		}
    118.  
    119. 	}
    120.  
    121. 	//删除学生
    122. 	@RequestMapping(value = "/delete/{cid}", method = RequestMethod.GET)
    123. 	public String deleteStudent(@PathVariable(value = "cid") String cid, HttpServletRequest request) {
    124.  
    125.  
    126. 		if (courseService.deleteCourse(cid) != 0) {
    127. 			System.out.println("success");
    128. 			queryCou(request);
    129. 			return "success";
    130. 		} else {
    131. 			System.out.println("fail");
    132. 			return "fail";
    133. 		}
    134.  
    135. 	}
    136.  
    137. 	//跳转到queryCourse页面
    138. 	@RequestMapping(value = "/finalPage", method = RequestMethod.GET)
    139. 	public String finalPage(HttpSession httpSession,HttpServletRequest request) {
    140. 		Object admin = request.getSession().getAttribute("courseList");
    141.  		System.out.println(admin+"111111111111111111111111111111111111111111111111111111111111111111111111111");
    142. 		return "admin/queryCourse";
    143. 	}
    144.  
    145. 	/**
    146. 	 * 	修改课程定位
    147. 	 * @param cid
    148. 	 * @param model
    149. 	 * @return
    150. 	 */
    151. 	@RequestMapping(value = "/moditystu/{cid}", method = RequestMethod.GET)
    152. 	public String editPre(@PathVariable("cid") String cid, HttpServletRequest request) {
    153.  
    154. 		
    155. 		List courseList = new ArrayList();
    156. 		courseList = courseService.getByCourseCid(1,10,cid);
    157. 		request.setAttribute("courseList", courseList);
    158.  
    159. 		return "admin/modiCourse";
    160. 	}
    161.  
    162. 	//修改课程信息
    163. 	@RequestMapping(value = "/moditystud/{cid}", method = RequestMethod.GET)
    164. 	public String update(@PathVariable("cid") String cid, Course course, Model model) {
    165. 		
    166. 		if (courseService.modifyCourse(course) != 0) {
    167. 			return "success";
    168. 		} else {
    169. 			return "fail";
    170. 		}
    171. 	}
    172.  
    173. 	
    174. 	//跳转到queryCourse页面
    175. 	@RequestMapping("/managecou/{pn}")
    176. 	public String manageCourse(HttpServletRequest request,@PathVariable(value = "pn") String pn,Model model) {
    177. 		int no = Integer.parseInt(pn);
    178. 		List courseList = new ArrayList();
    179. 		PageHelper.startPage(no, 5);
    180. 		courseList = courseService.selectCourseBySql(1,10);
    181. 	 	pageIn(model, courseList);
    182. 	 	request.setAttribute("courseList", courseList);
    183. 		return "admin/queryCourse";
    184. 	}
    185. }
    186.

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

  • 相关阅读:
    【C++进阶之路】第九篇：特殊类设计
    使用js原生customElements.define()API 实现类似godot游戏引擎的colorRect类
    19.删除链表的倒数第 N 个节点
    100张照片带你了解澳大利亚
    电子学会青少年软件编程 Python编程等级考试二级真题解析(判断题)2021年12月
    Go中的channel
    synchronized详解
    java企业数据管理系统
    [C++随笔录] stack && queue使用
    BSA-PEI，牛血清白蛋白-聚乙烯亚胺，BSA-聚乙烯亚胺的保存
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126651944