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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

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

管理员：
admin 123456

老师：
2001 123456
2002 123456
2003 123456

学生：
202801001 123456
202801002 123456
202801003 123456
202801004 123456
202801005 123456
202801006 123456
202801007 123456

				BeanUtils.setProperty(student, pName, value);
			} catch (IllegalAccessException | InvocationTargetException e) {
				e.printStackTrace();
			}
		}
		service.addStudent(student);
		response.getWriter().write("success");
	}

	private void studentList(HttpServletRequest request, HttpServletResponse response) throws IOException {
		//年级ID
		String gradeid = request.getParameter("gradeid");
		//班级ID
		String clazzid = request.getParameter("clazzid");
		//获取分页参数
		int page = Integer.parseInt(request.getParameter("page"));
		int rows = Integer.parseInt(request.getParameter("rows"));
		
		//封装参数
		Student student = new Student();
		
		if(!StringTool.isEmpty(gradeid)){
			student.setGradeid(Integer.parseInt(gradeid));
		}
		if(!StringTool.isEmpty(clazzid)){
			student.setClazzid(Integer.parseInt(clazzid));
		}
		
		//获取数据
		String result = service.getStudentList(student, new Page(page, rows));
		//返回数据
        response.getWriter().write(result);
	}
	
}

		deleteExam(request, response);
	} else if("TeacherExamList".equalsIgnoreCase(method)){ //获取属于某个老师的考试
		teacherExamList(request, response);
	} else if("StudentExamList".equalsIgnoreCase(method)){ //获取属于某个学生的考试
		studentExamList(request, response);
	}
	
	
	
}

private void studentExamList(HttpServletRequest request, HttpServletResponse response) throws IOException {
	//获取当前用户
	User user = (User) request.getSession().getAttribute("user");
	String number = user.getAccount();
	
	String result = service.studentExamList(number);
	response.getWriter().write(result);
}

private void teacherExamList(HttpServletRequest request, HttpServletResponse response) throws IOException {
	//获取当前用户
	User user = (User) request.getSession().getAttribute("user");
	String number = user.getAccount();
	String result = service.teacherExamList(number);
	response.getWriter().write(result);
}

private void deleteExam(HttpServletRequest request, HttpServletResponse response) throws IOException {
	//获取要删除的id
	int id = Integer.parseInt(request.getParameter("id"));
	try {
		service.deleteExam(id);
		response.getWriter().write("success");
	} catch (Exception e) {
		response.getWriter().write("fail");
		e.printStackTrace();
	}
}

private void addExam(HttpServletRequest request, HttpServletResponse response) throws IOException {
	//获取参数名
	Enumeration<String> pNames = request.getParameterNames();
	Exam exam = new Exam();
	while(pNames.hasMoreElements()){
		String pName = pNames.nextElement();
		String value = request.getParameter(pName);
		try {
			BeanUtils.setProperty(exam, pName, value);
		} catch (IllegalAccessException | InvocationTargetException e) {
			e.printStackTrace();
		}
	}
	try {

	private void deleteCourse(HttpServletRequest request, HttpServletResponse response) throws IOException {
		int courseid = Integer.parseInt(request.getParameter("courseid"));
		try {
			service.deleteClazz(courseid);
			response.getWriter().write("success");
		} catch (Exception e) {
			response.getWriter().write("fail");
			e.printStackTrace();
		}
	}

	private void addCourse(HttpServletRequest request, HttpServletResponse response) throws IOException {
		String name = request.getParameter("name");
		Course course = new Course();
		course.setName(name);
		service.addCourse(course);
		response.getWriter().write("success");
	}
	
	private void courseList(HttpServletRequest request, HttpServletResponse response) throws IOException {
		String gradeid = request.getParameter("gradeid");
		
		String result = service.getCourseList(gradeid);
		//返回数据
        response.getWriter().write(result);
	}

}

 *
 */
public class VisitFilter implements Filter {

	public void destroy() {
		
	}

	public void doFilter(ServletRequest req, ServletResponse rep, FilterChain chain) throws IOException, ServletException {
		HttpServletRequest request = (HttpServletRequest) req;
		HttpServletResponse response = (HttpServletResponse) rep;
		
		User user = (User) request.getSession().getAttribute("user");
		
		String contextPath = request.getContextPath();
		
		String uri = request.getRequestURI();
		uri = uri.substring(uri.lastIndexOf("/")+1, uri.length());
		
		if(user != null){
			chain.doFilter(request, response);
		} else{
			response.sendRedirect(contextPath+"/index.jsp");
		}
	}

	public void init(FilterConfig arg0) throws ServletException {
		
	}

}



/**
 * 设置request的编码

		response.getWriter().write("success");
	}

	private void clazzDetailList(HttpServletRequest request, HttpServletResponse response) throws IOException {
		//获取参数
		String gradeid = request.getParameter("gradeid");
		//获取分页参数
		int page = Integer.parseInt(request.getParameter("page"));
		int rows = Integer.parseInt(request.getParameter("rows"));
		
		String result = service.getClazzDetailList(gradeid, new Page(page, rows));
		//返回数据
        response.getWriter().write(result);
	}

	private void clazzList(HttpServletRequest request, HttpServletResponse response) throws IOException {
		//获取参数
		String gradeid = request.getParameter("gradeid");
		
		if(StringTool.isEmpty(gradeid)){
			return;
		}
		String result = service.getClazzList(gradeid);
		//返回数据
        response.getWriter().write(result);
	}

}

---

项目链接：
https://javayms.github.io?id=432123020509201ei
https://javayms.pages.dev?id=432123020509201ei