基于javaweb和mysql的jsp+servlet教务管理系统(java+jsp+springmvc+jdbc+layui+mysql)

2501_93031130

440人浏览 · 2025-09-28 22:42:47

2501_93031130 · 2025-09-28 22:42:47 发布

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的JSP+Servlet教务管理系统(java+jsp+springmvc+jdbc+layui+mysql)

项目介绍

本项目为基于WEB的教务管理系统。主要系统功能包括：学生管理：显示所有学生、添加学生；课程管理：显示所有课程、添加课程；学院管理：显示所有学院、添加学院；专业管理：所有专业、设置专业；

环境需要

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版本；

技术栈

后端：springmvc+jdbc 2. 前端：JSP+css+javascript+layui

使用说明

使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 将项目中util/ConnectionUtil.java修改数据库信息 4. 运行项目，在浏览器中输入http://localhost:8080/student-sys 登录管理员用户名：123456 密码：123456

		ModelAndView mv=new ModelAndView();
		mv.setViewName("addAcademy");
		return mv;
	}
	
	//添加学院
	@RequestMapping("/addAcademy.do")
	public ModelAndView addAcademy(AcademyDomain domain){
		service.addAcademy(domain);
		return new ModelAndView("redirect:/students/showAllAcademy.do");
	}
	//修改学院
	@RequestMapping("/modifyAcademy.do")
	public ModelAndView modifyAcademy(Integer id,AcademyDomain domain){
		service.modifyAcademy(id, domain);
		return new ModelAndView("redirect:/students/showAllAcademy.do");
	}
	
}

@Controller
@RequestMapping("/students")
public class CourseController {
	@Autowired
	private CourseService service;
	@Autowired
	private AcademyService aService;
	
	public AcademyService getaService() {
		return aService;
	}

	public void setaService(AcademyService aService) {

		return aService;
	}

	public void setaService(AcademyService aService) {
		this.aService = aService;
	}

	public CourseService getService() {
		return service;
	}

	public void setService(CourseService service) {
		this.service = service;
	}
	
	@RequestMapping("/showAllCourse.do")
	public ModelAndView showAllCourse(){
		ModelAndView mv=new ModelAndView();
		mv.setViewName("showAllCourse");
		List<CourseDomain> list=service.findAllCourse();
		mv.addObject("list",list);
		return mv;
	}
	//添加课程预处理
	@RequestMapping("/preAddCourse.do")
	public ModelAndView preAdd(){
		ModelAndView mv=new ModelAndView();
		List<AcademyDomain> list=aService.findAllAcademy1();
		mv.addObject("list",list);
		mv.setViewName("addcourse");
		return mv;
	}
	//
	@RequestMapping("/addCourse.do")
	public ModelAndView addCourse(CourseDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
		request.setCharacterEncoding("UTF-8" );
		response.setCharacterEncoding("UTF-8");
		service.addCourse(domain);
		return new ModelAndView("redirect:/students/showAllCourse.do");
	}
	@RequestMapping("/delCourse.do")
	public ModelAndView delCourse(Integer id){
		service.delCourse(id);
		return new ModelAndView("redirect:/students/showAllCourse.do");
	}
	
	@RequestMapping("/preModifyCourse.do")
	public ModelAndView preModifyCourse(Integer id) throws Exception{

	private CourseService courseService;
	@Autowired 
	private MajorService majorService;
	
	public CourseService getCourseService() {
		return courseService;
	}
	public void setCourseService(CourseService courseService) {
		this.courseService = courseService;
	}
	public MajorService getMajorService() {
		return majorService;
	}
	public void setMajorService(MajorService majorService) {
		this.majorService = majorService;
	}
	public AcademyService getService() {
		return service;
	}
	public void setService(AcademyService service) {
		this.service = service;
	}
	
	//显示所有学院信息
	@RequestMapping("/showAllAcademy.do")
	public ModelAndView findAllAcademy( Integer page,Integer perPage,HttpServletRequest request){
		ModelAndView mv=new ModelAndView();
		HttpSession session = request.getSession();
		String error = (String) session.getAttribute("error");
		request.setAttribute("error", error);
		mv.setViewName("showAllAcademy");
		session.removeAttribute("error");
		Pager<AcademyDomain> list=service.findAllAcademy(page,perPage);
		mv.addObject("Pager",list);
		return mv;
	}
	//删除学院
	@RequestMapping("/delAcademy.do")
	public ModelAndView delAcademy(Integer id,HttpServletRequest req){
		HttpSession session = req.getSession();
		String error = "";
		if (majorService.findByAId(id)) {

		HttpSession session = req.getSession();
		String error = "";
		if (majorService.findByAId(id)) {
			error= "该学院下有专业，不能删除该学院！！！";
			session.setAttribute("error", error);
		}else {
			if (courseService.findByAId(id)) {
				error= "该学院下有课程，不能删除该学院！！！";
				session.setAttribute("error", error);
			}else {
				service.delAcademy(id);
			}
		}
		return new ModelAndView("redirect:/students/showAllAcademy.do");
	}
	//添加预处理
	@RequestMapping("/preAddAcademy.do")
	public ModelAndView preAddAcademy(){
		ModelAndView mv=new ModelAndView();
		mv.setViewName("addAcademy");
		return mv;
	}
	
	//添加学院
	@RequestMapping("/addAcademy.do")
	public ModelAndView addAcademy(AcademyDomain domain){
		service.addAcademy(domain);
		return new ModelAndView("redirect:/students/showAllAcademy.do");
	}
	//修改学院
	@RequestMapping("/modifyAcademy.do")
	public ModelAndView modifyAcademy(Integer id,AcademyDomain domain){
		service.modifyAcademy(id, domain);
		return new ModelAndView("redirect:/students/showAllAcademy.do");
	}
	
}

			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		service.addStudent(domain);
		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 显示所有
	@RequestMapping("/findForPager.do")
	// page, perPage 数据绑定
	// 获取参数
	public ModelAndView findForPager(@RequestParam(required = false) Integer page,
			@RequestParam(required = false) Integer perPage) {

		ModelAndView mv = new ModelAndView();
		Pager<StudentDomain> pager = service.findForPager(page, perPage);
		mv.setViewName("showAll");
		mv.addObject("pager", pager);
		return mv;
	}

	// 删除
	@RequestMapping("/delStudents.do")
	public ModelAndView delStuent(String id) {
		service.DelStudent(id);
		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 修改
	@RequestMapping("/preModifyStudents.do")
	public ModelAndView preModifyStudent(Integer id) throws Exception {
		List<MajorDomain> list = null;
		list = majorservice.findAll();
		ModelAndView mv = new ModelAndView();
		StudentDomain studentDomain = service.findById(id);
		mv.addObject("mojorList", list);
		mv.addObject("student", studentDomain);
		mv.setViewName("modifystudent");
		return mv;
	}

	// 修改
	@RequestMapping("/modifyStudents.do")
	public ModelAndView modifyStudent(Integer id, StudentDomain stu, HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		service.Modify(id, stu);
		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 按姓名查找
	@RequestMapping("/findByName.do")

		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 显示所有
	@RequestMapping("/findForPager.do")
	// page, perPage 数据绑定
	// 获取参数
	public ModelAndView findForPager(@RequestParam(required = false) Integer page,
			@RequestParam(required = false) Integer perPage) {

		ModelAndView mv = new ModelAndView();
		Pager<StudentDomain> pager = service.findForPager(page, perPage);
		mv.setViewName("showAll");
		mv.addObject("pager", pager);
		return mv;
	}

	// 删除
	@RequestMapping("/delStudents.do")
	public ModelAndView delStuent(String id) {
		service.DelStudent(id);
		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 修改
	@RequestMapping("/preModifyStudents.do")
	public ModelAndView preModifyStudent(Integer id) throws Exception {
		List<MajorDomain> list = null;
		list = majorservice.findAll();
		ModelAndView mv = new ModelAndView();
		StudentDomain studentDomain = service.findById(id);
		mv.addObject("mojorList", list);
		mv.addObject("student", studentDomain);
		mv.setViewName("modifystudent");
		return mv;
	}

	// 修改
	@RequestMapping("/modifyStudents.do")
	public ModelAndView modifyStudent(Integer id, StudentDomain stu, HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		service.Modify(id, stu);
		return new ModelAndView("redirect:/students/findForPager.do");

		mv.setViewName("addcourse");
		return mv;
	}
	//
	@RequestMapping("/addCourse.do")
	public ModelAndView addCourse(CourseDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
		request.setCharacterEncoding("UTF-8" );
		response.setCharacterEncoding("UTF-8");
		service.addCourse(domain);
		return new ModelAndView("redirect:/students/showAllCourse.do");
	}
	@RequestMapping("/delCourse.do")
	public ModelAndView delCourse(Integer id){
		service.delCourse(id);
		return new ModelAndView("redirect:/students/showAllCourse.do");
	}
	
	@RequestMapping("/preModifyCourse.do")
	public ModelAndView preModifyCourse(Integer id) throws Exception{
		ModelAndView mv=new ModelAndView();
		List<AcademyDomain> alist=aService.findAllAcademy1();
		CourseDomain courseDomain = service.findById(id);
		mv.addObject("courseDomain", courseDomain);
		mv.addObject("alist",alist);
		mv.setViewName("modifyCourse");
		return mv;
	}
	
	@RequestMapping("/modifyCourse.do")
	public ModelAndView modifyCourse(Integer id,CourseDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		service.modifyCourse(id, domain);
		return new ModelAndView("redirect:/students/showAllCourse.do");
	}
}


@Controller
@RequestMapping("/students")
public class MajorController {
	@Autowired
	private MajorService service;
	@Autowired
	private AcademyService aService;
	@Autowired
	private StudentService studentService;
	
	public StudentService getStudentService() {
		return studentService;
	}

	public void setStudentService(StudentService studentService) {
		this.studentService = studentService;
	}

	public AcademyService getaService() {
		return aService;
	}

	public void setaService(AcademyService aService) {
		this.aService = aService;
	}

	public MajorService getService() {
		return service;
	}

	public void setService(MajorService service) {
		this.service = service;
	}
	//显示所有
	@RequestMapping("/showAllMajor.do")
	public ModelAndView findAll(HttpServletRequest request){
		HttpSession session = request.getSession();
		ModelAndView mv=new ModelAndView();
		String error = (String) session.getAttribute("error");

		ModelAndView mv=new ModelAndView();
		String error = (String) session.getAttribute("error");
		request.setAttribute("error", error);
		mv.setViewName("showAllMajor");
		session.removeAttribute("error");
		List<MajorDomain> list=service.findAll();
		mv.addObject("list",list);
		return mv;
	}
	
	
	//添加预处理
	@RequestMapping("/preAddMajor.do")
	public ModelAndView preAdd(){
		ModelAndView mv=new ModelAndView();
		List<AcademyDomain> majorList=aService.findAllAcademy1();
		mv.addObject("majorList",majorList);
		mv.setViewName("addMajor");
		return mv;
	}
	
	//添加专业
	@RequestMapping("/addMajor.do")
	public ModelAndView addMajor(MajorDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
		request.setCharacterEncoding("UTF-8" );
		response.setCharacterEncoding("UTF-8");
		service.addMajor(domain);	
		return new ModelAndView("redirect:/students/showAllMajor.do");
	}
	//删除
	@RequestMapping("/delMajor.do")
	public ModelAndView delMajor(Integer id,HttpServletRequest req){
		HttpSession session = req.getSession();
		String error = "";
		if (studentService.findByMajorId(id)) {
			error= "该专业类别下有学生，不能删除该专业！！！";
			session.setAttribute("error", error);
		}else {
			service.delMajor(id);
			
		}
		return new ModelAndView("redirect:/students/showAllMajor.do");
	}
	
	//修改
		@RequestMapping("/preModifyMajor.do")
		public ModelAndView preModifyMajor(Integer id ){
			ModelAndView mv=new ModelAndView();
			List<AcademyDomain> academList=aService.findAllAcademy1();
			MajorDomain majorDomain = service.findById(id);
			mv.addObject("majorDomain",majorDomain);
			mv.addObject("majorList",academList);
			mv.setViewName("modifyMajor");

		public ModelAndView preModifyMajor(Integer id ){
			ModelAndView mv=new ModelAndView();
			List<AcademyDomain> academList=aService.findAllAcademy1();
			MajorDomain majorDomain = service.findById(id);
			mv.addObject("majorDomain",majorDomain);
			mv.addObject("majorList",academList);
			mv.setViewName("modifyMajor");
			return mv;
		}
	
	//修改
	@RequestMapping("/modifyMajor.do")
	public ModelAndView modifyMajor(Integer id ,MajorDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
		request.setCharacterEncoding("UTF-8" );
		response.setCharacterEncoding("UTF-8");
		service.modifyMajor(id, domain);
		return new ModelAndView("redirect:/students/showAllMajor.do");
	}
	
}

public class StudentController {
	@Autowired // 自动注入 ( byName byType)
	private StudentService service;
	@Autowired
	private MajorService majorservice;

	public MajorService getMajorservice() {
		return majorservice;
	}

	public void setMajorservice(MajorService majorservice) {
		this.majorservice = majorservice;
	}

	public StudentService getService() {
		return service;
	}

	public void setService(StudentService service) {
		this.service = service;
	}

	// 添加学生预处理
	@RequestMapping("/preAdd.do")
	public ModelAndView preAddStudent() {
		List<MajorDomain> list = null;
		list = majorservice.findAll();
		ModelAndView mv = new ModelAndView();
		mv.addObject("list", list);
		mv.setViewName("addstudent");
		return mv;
	}

	@RequestMapping("/create.do")
	public ModelAndView createStudent(StudentDomain domain, HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		service.addStudent(domain);
		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 显示所有
	@RequestMapping("/findForPager.do")
	// page, perPage 数据绑定
	// 获取参数

	public void setaService(AcademyService aService) {
		this.aService = aService;
	}

	public CourseService getService() {
		return service;
	}

	public void setService(CourseService service) {
		this.service = service;
	}
	
	@RequestMapping("/showAllCourse.do")
	public ModelAndView showAllCourse(){
		ModelAndView mv=new ModelAndView();
		mv.setViewName("showAllCourse");
		List<CourseDomain> list=service.findAllCourse();
		mv.addObject("list",list);
		return mv;
	}
	//添加课程预处理
	@RequestMapping("/preAddCourse.do")
	public ModelAndView preAdd(){
		ModelAndView mv=new ModelAndView();
		List<AcademyDomain> list=aService.findAllAcademy1();
		mv.addObject("list",list);
		mv.setViewName("addcourse");
		return mv;
	}
	//
	@RequestMapping("/addCourse.do")
	public ModelAndView addCourse(CourseDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
		request.setCharacterEncoding("UTF-8" );
		response.setCharacterEncoding("UTF-8");
		service.addCourse(domain);
		return new ModelAndView("redirect:/students/showAllCourse.do");
	}
	@RequestMapping("/delCourse.do")
	public ModelAndView delCourse(Integer id){
		service.delCourse(id);
		return new ModelAndView("redirect:/students/showAllCourse.do");
	}
	
	@RequestMapping("/preModifyCourse.do")
	public ModelAndView preModifyCourse(Integer id) throws Exception{
		ModelAndView mv=new ModelAndView();
		List<AcademyDomain> alist=aService.findAllAcademy1();
		CourseDomain courseDomain = service.findById(id);

	@RequestMapping("/preModifyStudents.do")
	public ModelAndView preModifyStudent(Integer id) throws Exception {
		List<MajorDomain> list = null;
		list = majorservice.findAll();
		ModelAndView mv = new ModelAndView();
		StudentDomain studentDomain = service.findById(id);
		mv.addObject("mojorList", list);
		mv.addObject("student", studentDomain);
		mv.setViewName("modifystudent");
		return mv;
	}

	// 修改
	@RequestMapping("/modifyStudents.do")
	public ModelAndView modifyStudent(Integer id, StudentDomain stu, HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		service.Modify(id, stu);
		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 按姓名查找
	@RequestMapping("/findByName.do")
	public ModelAndView findByName(String name, HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		ModelAndView mv = new ModelAndView();
		Pager<StudentDomain> list = service.findByName(name);
		mv.setViewName("showAll");
		mv.addObject("pager", list);
		return mv;
	}

}


@Controller
@RequestMapping("/students")
public class AdminController {

	@Autowired
	private AdminService service;

	public AdminService getService() {
		return service;
	}

	public void setService(AdminService service) {
		this.service = service;
	}

	// 判断登录
	@RequestMapping("/login.do")
	public ModelAndView doLogin(AdminDomain ae, HttpServletRequest req) {
		HttpSession session = req.getSession();
		List<AdminDomain> list = service.findAll();
		ModelAndView mv = new ModelAndView();
		for (AdminDomain ad : list) {
			if (ae.getName().equals(ad.getName()) && ae.getPassword().equals(ad.getPassword())) {
				mv.addObject("ae", ae);
				session.setAttribute("user", ae);
				mv.setViewName("Main");
				return mv;
			}
		}
		mv.setViewName("loginFailure");
		return mv;

	}
}

/** 
 * @description 认证Filter 
 */
public class AuthenticationFilter implements Filter{

			return mv;
		}
	
	//修改
	@RequestMapping("/modifyMajor.do")
	public ModelAndView modifyMajor(Integer id ,MajorDomain domain,HttpServletRequest request,HttpServletResponse response) throws Exception{
		request.setCharacterEncoding("UTF-8" );
		response.setCharacterEncoding("UTF-8");
		service.modifyMajor(id, domain);
		return new ModelAndView("redirect:/students/showAllMajor.do");
	}
	
}

@Controller
@RequestMapping("/students")
public class AcademyController {
	@Autowired
	private AcademyService service;
	@Autowired
	private CourseService courseService;
	@Autowired 
	private MajorService majorService;
	
	public CourseService getCourseService() {
		return courseService;
	}
	public void setCourseService(CourseService courseService) {
		this.courseService = courseService;
	}
	public MajorService getMajorService() {
		return majorService;
	}
	public void setMajorService(MajorService majorService) {

	}

	public void setService(StudentService service) {
		this.service = service;
	}

	// 添加学生预处理
	@RequestMapping("/preAdd.do")
	public ModelAndView preAddStudent() {
		List<MajorDomain> list = null;
		list = majorservice.findAll();
		ModelAndView mv = new ModelAndView();
		mv.addObject("list", list);
		mv.setViewName("addstudent");
		return mv;
	}

	@RequestMapping("/create.do")
	public ModelAndView createStudent(StudentDomain domain, HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		service.addStudent(domain);
		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 显示所有
	@RequestMapping("/findForPager.do")
	// page, perPage 数据绑定
	// 获取参数
	public ModelAndView findForPager(@RequestParam(required = false) Integer page,
			@RequestParam(required = false) Integer perPage) {

		ModelAndView mv = new ModelAndView();
		Pager<StudentDomain> pager = service.findForPager(page, perPage);
		mv.setViewName("showAll");
		mv.addObject("pager", pager);
		return mv;
	}

	// 删除
	@RequestMapping("/delStudents.do")
	public ModelAndView delStuent(String id) {
		service.DelStudent(id);
		return new ModelAndView("redirect:/students/findForPager.do");
	}

	// 修改


public class DoLogin implements Filter{
	public void destroy() {
		// TODO Auto-generated method stub
		
	}

	
	public void doFilter(ServletRequest request, ServletResponse response,
			FilterChain chain) throws IOException, ServletException {
		//获取session，request，response对象
		HttpServletRequest servletRequest=(HttpServletRequest)request;
		HttpServletResponse servletResponse=(HttpServletResponse)response;
		HttpSession session=servletRequest.getSession();
		//获取请求URI
		String path=servletRequest.getRequestURI();
		//从Session中获取管理员
		
		String adminName=(String) session.getAttribute("name");
		
		String password=(String)session.getAttribute("password");
		
		if(path.indexOf("/index.jsp")>-1)
		{
			chain.doFilter(servletRequest, servletResponse);
			return;
		}
		if(password==null||"".equals(password))
			servletResponse.sendRedirect("/StudentInfo/index.jsp");
		else{
			chain.doFilter(request, response);
		}	
	}

	public void init(FilterConfig filterConfig) throws ServletException {
		// TODO Auto-generated method stub
	}

}

请添加图片描述

AI Agent技术社区

Agent 垂直技术社区，欢迎活跃、内容共建。

更多推荐

深入理解 AI Agent 02｜混合检索与重排序实战：BM25、RRF 与 Cross-Encoder 的工程实践

AI Agent技术社区

Agent联调崩了三次：Demo跑通后，权限和日志才是真门槛

AI Agent技术社区

从 Dialog-RSN-1 看语音 Agent 走向：企业如何评估音频原生模型与 API 服务

语音交互技术正迈向实时整合阶段，PolyAI发布的Dialog-RSN-1模型突破传统级联流程，将语音识别、对话决策和响应生成融合为音频原生系统。该架构通过直接处理音频数据，改善轮次判断精度，减少对话中断，适用于预约查询等高交互场景。企业需根据业务需求评估价值：提升复杂来电完成率、优化运营效率或降低资源占用。但该模型当前仅限英语且通过封闭平台提供，开发者需注意接入限制。建议企业分四步落地：明确场景