Java源码社

基于javaweb的JSP+Servlet校园运动会管理系统(java+jsp+servlet+javabean+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

410023412402

420023412402

430023412402

440023412402

450023412402

460023412402

基于javaweb的JSP+Servlet校园运动会管理系统(java+jsp+servlet+javabean+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+Servlet+JavaBean+MySQL+css+javascript

使用说明

  1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven; 若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行； 3. 将项目中src/util/DB.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，输入localhost:8080/jspyundonghuimanager/ 登录 注：tomcat中配置项目路径必须为jspyundonghuimanager，否则会有异常 管理员账号/密码：admin/admin 学生运动员角色账号/密码：student/123456 裁判老师角色账号/密码：teacher/123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

public class GetCountPageServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		this.doPost(req, resp);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		// 获取总页数
		TeacherImpl teacherImpl = new TeacherImpl();
		StudentImpl studentImpl = new StudentImpl();
		SubjectImpl subjectImpl = new SubjectImpl();
		Operator operator;
		Student student;
		Teacher teacher;
		int countPage = 0;
		operator = (Operator) request.getSession().getAttribute("log_operator");
		int ope_rol_id = operator.getRole().getId();
		String search_type = request.getParameter("search_type");
		String search_value = java.net.URLDecoder.decode(request
				.getParameter("value"), "UTF-8");
		if (ope_rol_id == 1) {
			// 管理员的查询
			if (search_type.equals("stu_all")) {
				countPage = subjectImpl.getCountPage("all", search_value);
			} else {
				countPage = subjectImpl.getCountPage(search_type, search_value);
			}
		} else if (ope_rol_id == 2) {
			// 裁判员老师的查询
			teacher = teacherImpl.query("ope_id", operator.getId() + "").get(0);
			// teacher = teacherImpl.query("ope_id", 2+ "").get(0);
			if (search_type.equals("stu_all")) {
				countPage = subjectImpl.getCountPage("tec_stu_all", teacher
						.getId()
						+ "");
			} else if (search_type.equals("sub_name")) {
				countPage = subjectImpl.getCountPage("tec_sub_name", teacher
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

	}
}
package score.servlet;





public class SearchScoreServlet extends HttpServlet {

	private static final long serialVersionUID = 1L;

	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		this.doPost(req, resp);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		try {
			// AJAX异步查询成绩
			StudentImpl studentImpl = new StudentImpl();
			TeacherImpl teacherImpl = new TeacherImpl();
			ScoreImpl scoreImpl = new ScoreImpl();
			Operator operator;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
// 添加新学生运动员
try {
	SmartUpload sm = new SmartUpload();
	sm.initialize(getServletConfig(), request, response);
	sm.upload();

	Student student = new Student();
	Operator operator = new Operator();

	// 为学生运动员添加操作员信息记录
	operator.setName(sm.getRequest().getParameter("ope_name"));
	operator.setPwd(sm.getRequest().getParameter("ope_pwd"));
	operator.setRole(roleImpl.query("rol_id", "3").get(0));
	operator = operatorImpl.add(operator);

	// 将学生运动员添加到学生运动员表
	student.setOperator(operator);
	student.setNo(sm.getRequest().getParameter("no"));
	student.setName(sm.getRequest().getParameter("name"));
	student
			.setSex(sm.getRequest().getParameter("sex").equals("male") ? "男"
					: "女");
	student.setBirth(sdf.parse(sm.getRequest().getParameter("birth")));
	student.setClasses(classesImpl.query("cla_id",
			sm.getRequest().getParameter("cla_id")).get(0));
	pictureImpl.check(getServletConfig(), request, response, sm,
			student);
	int i = studentImpl.add(student);
	student = studentImpl.query("ope_id", operator.getId() + "").get(0);
	if (i == 1) {
		request.getSession().setAttribute("message", "添加学生运动员成功！");
	} else {
		request.getSession().setAttribute("message", "添加学生运动员失败！");
	}

	// 为学生运动员添加比赛项目成绩记录信息

	List<Subject> list_subject = subjectImpl.query("stu_id", student
			.getId()
			+ "");
	List<Cla2Sub> list_cla2sub = new Cla2SubImpl().query("stu_id",
			student.getId() + "");
	for (int x = 0; x < list_subject.size(); x++) {
		Score score = new Score();
		score.setStudent(student);
		score.setSubject(list_subject.get(x));
		score.setCla2sub(list_cla2sub.get(x));
		scoreImpl.add(score);
	}
} catch (Exception e) {
	e.printStackTrace();
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
			teacher.setBirth(sdf.parse((request.getParameter("tec_birth"))));
		} catch (ParseException e) {
			e.printStackTrace();
		}
		operator.setName(request.getParameter("ope_name"));
		operator.setPwd(request.getParameter("ope_pwd"));
		operator.setRole(roleImpl.query("rol_id", "2").get(0));
		teacher.setSex((request.getParameter("tec_sex")).equals("male") ? "男"
				: "女");
		teacher.setMajor(request.getParameter("tec_major"));
		teacher.setPhone(request.getParameter("tec_phone"));
		teacher.setName(request.getParameter("tec_name"));
		operator = operatorImpl.add(operator);
		teacher.setOperator(operator);
		int i = teacherImpl.add(teacher);
		if (i == 1) {
			request.getSession().setAttribute("message", "添加裁判员老师成功！");
		} else {
			request.getSession().setAttribute("message", "添加裁判员老师失败！");
		}
		response.sendRedirect("pages/add_teacher.jsp");
	}
}
package teacher.servlet;





public class UpdateTeacherServlet extends HttpServlet {

	private static final long serialVersionUID = 1L;

	@Override
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		this.doPost(req, resp);
	}

	@Override
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
		list_student = studentImpl.query("cla_id", classes.getId() + "");

		String[] sub_ids = request.getParameterValues("sub_ids");
		for (String id : sub_ids) {
			Subject subject = subjectImpl.query("sub_id", id).get(0);
			Cla2Sub cla2Sub = new Cla2Sub();
			cla2Sub.setClasses(classes);
			cla2Sub.setSubject(subject);
			cla2Sub.setTeacher(teacher);
			int i = cla2SubImpl.add(cla2Sub);
			// 为该班级的学生运动员添加该运动项目的成绩
			for (Student stu : list_student) {
				Score score = new Score();
				score.setStudent(stu);
				score.setSubject(subject);
				score.setCla2sub(cla2SubImpl.findCla2sub(classes.getId(),
						teacher.getId(), subject.getId()));
				scoreImpl.add(score);
			}
			if (i == 1) {
				request.getSession().setAttribute("message", "添加比赛项目成功！");
			} else {
				request.getSession().setAttribute("message", "添加比赛项目失败！");
			}
		}
		response.sendRedirect("/jspyundonghuimanager/PlanAddCla2SubSevlet");
	}
}
package teacher.servlet;





public class AddTeacherServlet extends HttpServlet {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

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