基于javaweb和mysql的jsp+servlet教务处学生成绩管理系统(java+jsp+bootstrap+servlet+mysql)

2501_93031130

744人浏览 · 2025-09-28 22:41:31

2501_93031130 · 2025-09-28 22:41:31 发布

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb的JSP+Servlet教务处学生成绩管理系统(java+jsp+bootstrap+servlet+mysql)

项目介绍

本项目包含管理员、教师、学生三种角色；

用户角色包含以下功能：

修改密码,查看自己的信息,查看自己的成绩,登录界面等功能。

管理员角色包含以下功能：修改示例,增删改查学生信息,增删改查教师信息,增删改查课程信息,管理员修改密码等功能。

老师角色包含以下功能：个人信息查看,修改成绩信息,增加成绩信息,管理学生成绩信息等功能。

环境需要

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项目：否；

技术栈

JSP+CSS+JavaScript+jquery+bootstrap+servlet+mysql

使用说明

使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中dbconfig.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入http://localhost:8080/ 登录管理员账号/密码：admin/admin 教师账号/密码： 20194101/123456 学生账号/密码： 202041404237/123456

		doGet(request, response);
	}

}

public class AddScoreServlet extends HttpServlet {

	private BusinessService service = new BusinessServiceImpl();
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/jsp;charset=utf-8");
		response.setCharacterEncoding("utf-8");
		Teacher teacher = (Teacher) request.getSession()
				.getAttribute("teacher");
		if (teacher == null) {
			request.setAttribute("message",
			request.getRequestDispatcher("/index.jsp").forward(request,
					response);
			return;
		} else {
			// 时间戳
			String timeStamp = String.valueOf(new java.util.Date().getTime());
			HttpSession session = request.getSession();
			// 创建新令牌值
			String tokenStr = session.getId() + timeStamp;
			// 识别令牌,不合法将中止页面运行
			// 更新令牌
			session.setAttribute("CONTROL_REFRESH", tokenStr);

			String sno = request.getParameter("sno");
			String sname = request.getParameter("sname");
			String cno = request.getParameter("cno");

				}
				String pageNum = request.getParameter("pageNum");
				Page page = service.findStudentsRecords(pageNum);
				page.setUrl("/LoginServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/admin_main.jsp")
						.forward(request, response);
			}
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

public class AddCourseServlet extends HttpServlet {
	private BusinessService service = new BusinessServiceImpl();
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/jsp;charset=utf-8");
		response.setCharacterEncoding("utf-8");
		Admin admin = (Admin) request.getSession().getAttribute("admin");
		if (admin == null) {
			request.setAttribute("message",
			request.getRequestDispatcher("/index.jsp").forward(request,
					response);
			return;
		} else {
			// 时间戳

					request.getRequestDispatcher("/update_stu_pwd.jsp")
							.forward(request, response);
				} else {
					boolean flag = service.updateStudentPwd(student.getSno(), newPwd);
					if (flag) {
						request.setAttribute("message",
						request.getSession().invalidate();
						request.getRequestDispatcher("/index.jsp").forward(
								request, response);
					}

				}
			}
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

public class UpdateTeaPwdServlet extends HttpServlet {

	private BusinessService service = new BusinessServiceImpl();
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/jsp;charset=utf-8");

			return;
		} else {
			// 时间戳
			String timeStamp = String.valueOf(new java.util.Date().getTime());
			HttpSession session = request.getSession();
			// 创建新令牌值
			String tokenStr = session.getId() + timeStamp;
			// 识别令牌,不合法将中止页面运行
			// 更新令牌
			session.setAttribute("CONTROL_REFRESH", tokenStr);
			
			String tno = request.getParameter("tno");
			String tname = request.getParameter("tname");
			String sex = request.getParameter("sex");
			String password = request.getParameter("password");
			String degree = request.getParameter("degree");
			String department = request.getParameter("department");
			String title = request.getParameter("title");
			Teacher teacher = new Teacher(tno, tname, password, sex, department, degree, title);
			boolean flag = false;
			if (tname != null && tno != null && sex != null && password != null
					&& department != null && degree != null && title != null) {
				flag = service.addTeacher(teacher);
				if (flag) {
					request.setAttribute("message",
				}else{
					request.setAttribute("message",
				}
				String pageNum = request.getParameter("pageNum");
				Page page = service.findTeachersRecords(pageNum);
				page.setUrl("/AdminToTeaServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/admin_teacher.jsp")
						.forward(request, response);
			}
		}

	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

			throws ServletException, IOException {
		doGet(request, response);
	}

}

public class AddTeaServlet extends HttpServlet {

	private BusinessService service = new BusinessServiceImpl();
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/jsp;charset=utf-8");
		response.setCharacterEncoding("utf-8");
		Admin admin = (Admin) request.getSession().getAttribute("admin");
		if (admin == null) {
			request.setAttribute("message",
			request.getRequestDispatcher("/index.jsp").forward(request,
					response);
			return;
		} else {
			// 时间戳
			String timeStamp = String.valueOf(new java.util.Date().getTime());
			HttpSession session = request.getSession();
			// 创建新令牌值
			String tokenStr = session.getId() + timeStamp;
			// 识别令牌,不合法将中止页面运行
			// 更新令牌
			session.setAttribute("CONTROL_REFRESH", tokenStr);
			
			String tno = request.getParameter("tno");
			String tname = request.getParameter("tname");
			String sex = request.getParameter("sex");
			String password = request.getParameter("password");
			String degree = request.getParameter("degree");

			// 更新令牌
			String tno = request.getParameter("tno");
			session.setAttribute("CONTROL_REFRESH", tokenStr);
			boolean flag = service.deleteTeacher(tno);
			if (flag) {
				request.setAttribute("message",
			} else {
				request.setAttribute("message",
			}
			// 设置页码
			String pageNum = request.getParameter("pageNum");
			Page page = service.findTeachersRecords(pageNum);
			request.setAttribute("page", page);
			page.setUrl("/AdminToTeaServlet");
			request.getRequestDispatcher("/WEB-INF/admin_teacher.jsp").forward(request,
					response);
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

public class UpdateStuPwdServlet extends HttpServlet {

	private BusinessService service = new BusinessServiceImpl();
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)


public class AddScoreServlet extends HttpServlet {

	private BusinessService service = new BusinessServiceImpl();
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/jsp;charset=utf-8");
		response.setCharacterEncoding("utf-8");
		Teacher teacher = (Teacher) request.getSession()
				.getAttribute("teacher");
		if (teacher == null) {
			request.setAttribute("message",
			request.getRequestDispatcher("/index.jsp").forward(request,
					response);
			return;
		} else {
			// 时间戳
			String timeStamp = String.valueOf(new java.util.Date().getTime());
			HttpSession session = request.getSession();
			// 创建新令牌值
			String tokenStr = session.getId() + timeStamp;
			// 识别令牌,不合法将中止页面运行
			// 更新令牌
			session.setAttribute("CONTROL_REFRESH", tokenStr);

			String sno = request.getParameter("sno");
			String sname = request.getParameter("sname");
			String cno = request.getParameter("cno");
			String cname = request.getParameter("cname");
			String credit = request.getParameter("credit");
			String type = request.getParameter("type");
			String exam_method = request.getParameter("exam_method");
			String property = request.getParameter("property");
			String grade = request.getParameter("grade");
			String get_credit = request.getParameter("get_credit");
			String GPA = request.getParameter("GPA");

						.forward(request, response);
			}

		} else {

			if ("管理员".equals(type)) {
				String username = request.getParameter("username");
				String password = request.getParameter("password");

				admin = service.queryAdmin(username);
				if (admin == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);
					return;
				}
				admin = service.queryAdmin(username, password);
				if (admin == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);
					return;
				}
				request.getSession().setAttribute("admin", admin);
				// 此段代码用于防止刷新后的重复提交
				// 时间戳
				String timeStamp = String.valueOf(new java.util.Date().getTime());
				HttpSession session = request.getSession();
				// 创建新令牌值
				String tokenStr = session.getId() + timeStamp;
				// 识别令牌,不合法将中止页面运行
				// 更新令牌
				session.setAttribute("CONTROL_REFRESH", tokenStr);
				// 设置页码
				String pageNum = request.getParameter("pageNum");
				Page page = service.findStudentsRecords(pageNum);
				page.setUrl("/LoginServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/admin_main.jsp")
						.forward(request, response);
			} else if ("教师".equals(type)) {
				String username = request.getParameter("username");
				String password = request.getParameter("password");

				teacher = service.queryTeacher(username);
				if (teacher == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);


			if (sno != null && grade != null && cno != null
					&& get_credit != null && GPA != null && credit_GPA != null) {
				boolean flag = service.updateScore(sno, cno, grade, get_credit,
						GPA, credit_GPA);
				if (flag) {
					request.setAttribute("message",
				} else {
					request.setAttribute("message",
				}
				String pageNum = request.getParameter("pageNum");
				Page page = service.findScoresRecordsByTno(teacher.getTno(),
						pageNum);
				page.setUrl("/LoginServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/teacher_main.jsp")
						.forward(request, response);
			}
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

public class UpdateStuServlet extends HttpServlet {

	private BusinessService service = new BusinessServiceImpl();

		request.setCharacterEncoding("utf-8");
		response.setContentType("text/jsp;charset=utf-8");
		response.setCharacterEncoding("utf-8");
		Admin admin = (Admin) request.getSession().getAttribute("admin");
		if (admin == null) {
			request.setAttribute("message",
			request.getRequestDispatcher("/index.jsp").forward(request,
					response);
			return;
		} else {
			// 时间戳
			String timeStamp = String.valueOf(new java.util.Date().getTime());
			HttpSession session = request.getSession();
			// 创建新令牌值
			String tokenStr = session.getId() + timeStamp;
			// 识别令牌,不合法将中止页面运行
			// 更新令牌
			session.setAttribute("CONTROL_REFRESH", tokenStr);

			String tname = request.getParameter("tname");
			String tno = request.getParameter("tno");
			String sex = request.getParameter("sex");
			String password = request.getParameter("password");
			String department = request.getParameter("department");
			String degree = request.getParameter("degree");
			String title = request.getParameter("title");
			
			if (tname != null && tno != null && sex != null && password != null
					&& department != null && degree != null && title != null) {
				Teacher teacher = new Teacher(tno, tname, password, sex, department, degree, title);
				boolean flag = service.updateTeacher(teacher);
				if (flag) {
					request.setAttribute("message",
				} else {
					request.setAttribute("message",
				}
				String pageNum = request.getParameter("pageNum");
				Page page = service.findTeachersRecords(pageNum);
				page.setUrl("/AdminToTeaServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/admin_teacher.jsp")
						.forward(request, response);
			}
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

				}
			}
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

public class AddTeaServlet extends HttpServlet {

	private BusinessService service = new BusinessServiceImpl();
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/jsp;charset=utf-8");
		response.setCharacterEncoding("utf-8");
		Admin admin = (Admin) request.getSession().getAttribute("admin");
		if (admin == null) {
			request.setAttribute("message",
			request.getRequestDispatcher("/index.jsp").forward(request,
					response);
			return;
		} else {
			// 时间戳
			String timeStamp = String.valueOf(new java.util.Date().getTime());
			HttpSession session = request.getSession();

				.getAttribute("teacher");

		// 如果session存在则刷新页面
		if (student != null || admin != null || teacher != null) {
			if (student != null) {
				String pageNum = request.getParameter("pageNum");
				Page page = service
						.findScoresRecords(student.getSno(), pageNum);
				page.setUrl("/LoginServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/student_main.jsp")
						.forward(request, response);
			}
			if (admin != null) {
				String pageNum = request.getParameter("pageNum");
				Page page = service.findStudentsRecords(pageNum);
				page.setUrl("/LoginServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/admin_main.jsp")
						.forward(request, response);
			}
			if (teacher != null) {
				String pageNum = request.getParameter("pageNum");
				Page page = service.findScoresRecordsByTno(teacher.getTno(), pageNum);
				page.setUrl("/LoginServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/teacher_main.jsp")
						.forward(request, response);
			}

		} else {

			if ("管理员".equals(type)) {
				String username = request.getParameter("username");
				String password = request.getParameter("password");

				admin = service.queryAdmin(username);
				if (admin == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);
					return;
				}
				admin = service.queryAdmin(username, password);
				if (admin == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);

			System.out.println(sesValue);
			String reqValue = request.getParameter("tokenStr");
			System.out.println(reqValue);
			if (!sesValue.equals(reqValue)) {
				// 设置页码
				String pageNum = request.getParameter("pageNum");
				Page page = service.findStudentsRecords(pageNum);
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/admin_main.jsp")
						.forward(request, response);
				return;
			}
			// 更新令牌
			String sno = request.getParameter("sno");
			session.setAttribute("CONTROL_REFRESH", tokenStr);
			boolean flag = service.deleteStudent(sno);
			if (flag) {
				request.setAttribute("message",
			} else {
				request.setAttribute("message",
			}
			// 设置页码
			String pageNum = request.getParameter("pageNum");
			Page page = service.findStudentsRecords(pageNum);
			request.setAttribute("page", page);
			page.setUrl("/LoginServlet");
			request.getRequestDispatcher("/WEB-INF/admin_main.jsp").forward(request,
					response);
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

		if (admin == null) {
			request.setAttribute("message",
			request.getRequestDispatcher("/index.jsp").forward(request,
					response);
			return;
		} else {
			// 时间戳
			String timeStamp = String.valueOf(new java.util.Date().getTime());
			HttpSession session = request.getSession();
			// 创建新令牌值
			String tokenStr = session.getId() + timeStamp;
			// 识别令牌,不合法将中止页面运行
			// 更新令牌
			session.setAttribute("CONTROL_REFRESH", tokenStr);

			String tname = request.getParameter("tname");
			String tno = request.getParameter("tno");
			String sex = request.getParameter("sex");
			String password = request.getParameter("password");
			String department = request.getParameter("department");
			String degree = request.getParameter("degree");
			String title = request.getParameter("title");
			
			if (tname != null && tno != null && sex != null && password != null
					&& department != null && degree != null && title != null) {
				Teacher teacher = new Teacher(tno, tname, password, sex, department, degree, title);
				boolean flag = service.updateTeacher(teacher);
				if (flag) {
					request.setAttribute("message",
				} else {
					request.setAttribute("message",
				}
				String pageNum = request.getParameter("pageNum");
				Page page = service.findTeachersRecords(pageNum);
				page.setUrl("/AdminToTeaServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/admin_teacher.jsp")
						.forward(request, response);
			}
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

			}else{
				request.setAttribute("message",
				request.getRequestDispatcher("/index.jsp").forward(request,
						response);
				return;
			}
		}

	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

public class AddScoreServlet extends HttpServlet {

	private BusinessService service = new BusinessServiceImpl();
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/jsp;charset=utf-8");
		response.setCharacterEncoding("utf-8");
		Teacher teacher = (Teacher) request.getSession()


				student = service.queryStudent(username);
				if (student == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);
					return;
				}
				student = service.queryStudent(username, password);
				if (student == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);
					return;
				}
				request.getSession().setAttribute("student", student);
				// 此段代码用于防止刷新后的重复提交
				// 时间戳
				String timeStamp = String.valueOf(new java.util.Date().getTime());
				HttpSession session = request.getSession();
				// 创建新令牌值
				String tokenStr = session.getId() + timeStamp;
				// 识别令牌,不合法将中止页面运行
				// 更新令牌
				session.setAttribute("CONTROL_REFRESH", tokenStr);
				// 设置页码
				String pageNum = request.getParameter("pageNum");
				Page page = service
						.findScoresRecords(student.getSno(), pageNum);
				page.setUrl("/LoginServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/student_main.jsp")
						.forward(request, response);
			} else if("请选择身份".equals(type)){
				request.setAttribute("message",
				request.getRequestDispatcher("/index.jsp").forward(request,
						response);
				return;
			}else{
				request.setAttribute("message",

				request.getRequestDispatcher("/WEB-INF/teacher_main.jsp")
						.forward(request, response);
			} else if ("学生".equals(type)) {
				String username = request.getParameter("username");
				String password = request.getParameter("password");

				student = service.queryStudent(username);
				if (student == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);
					return;
				}
				student = service.queryStudent(username, password);
				if (student == null) {
					request.setAttribute("message",
					request.getRequestDispatcher("/index.jsp").forward(request,
							response);
					return;
				}
				request.getSession().setAttribute("student", student);
				// 此段代码用于防止刷新后的重复提交
				// 时间戳
				String timeStamp = String.valueOf(new java.util.Date().getTime());
				HttpSession session = request.getSession();
				// 创建新令牌值
				String tokenStr = session.getId() + timeStamp;
				// 识别令牌,不合法将中止页面运行
				// 更新令牌
				session.setAttribute("CONTROL_REFRESH", tokenStr);
				// 设置页码
				String pageNum = request.getParameter("pageNum");
				Page page = service
						.findScoresRecords(student.getSno(), pageNum);
				page.setUrl("/LoginServlet");
				request.setAttribute("page", page);
				request.getRequestDispatcher("/WEB-INF/student_main.jsp")
						.forward(request, response);
			} else if("请选择身份".equals(type)){
				request.setAttribute("message",
				request.getRequestDispatcher("/index.jsp").forward(request,
						response);
				return;
			}else{

请添加图片描述

AI Agent技术社区

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

更多推荐

SeedVR2终极指南：如何用单步扩散模型实现专业级视频修复

还在为老旧视频的模糊画质而烦恼吗？面对抖动严重的监控录像或褪色的家庭影像，你是否曾希望有一种简单高效的修复方案？SeedVR2正是为解决这些痛点而生的一站式视频修复工具。作为字节跳动推出的先进视频修复模型，它能够在单步推理中实现专业级的视频质量提升，彻底改变了传统视频修复的工作流程。## 核心价值：为什么选择SeedVR2进行视频修复？**传统视频修复的三大瓶颈**：1. **计算成本高

AI Agent技术社区

深度解析Amlogic S9xxx电视盒子Armbian系统：从闲置设备到Linux服务器的终极实战指南

你是否拥有一台闲置的Amlogic S9xxx系列电视盒子？想让它摆脱单一的视频播放功能，变身为功能强大的Linux服务器、开发平台或家庭媒体中心？本指南将为你详细解析如何通过Armbian系统实现这一转变，让你的电视盒子重获新生，成为高性能的Linux设备。Armbian系统基于Debian/Ubuntu构建，专为ARM芯片优化，提供了完整的Linux生态支持。## 🎯 核心价值与独特优势

AI Agent技术社区

CANN/runtime Event管理API

本章节描述 CANN Runtime 的 Event 管理接口，用于事件的创建、记录、同步、计时及 IPC 跨进程共享。- [`aclError aclrtCreateEvent(aclrtEvent *event)`](#aclrtCreateEvent)：创建Event，创建出来的Event可用于统计两个Event之间的耗时、多Stream之间的任务同步等场景。- [`aclError