I
运动会成绩管理系统设计与实现
摘 要
高校在举行运动会时，很少甚至没有使用运动会成绩管理系统来处理运动会中的信息，在很大程度上还是依赖人工操作，一般通过文档或者办公软件来处理大量的数据。这种方式给运动会管理人员带来了繁重的工作量，而且效率较为低下，更新缓慢，且容易出错。随着科技的日益发展，学校的信息管理技术已经成为了能够体现学校综合实力的重要指标，而运动会成绩管理是学校信息管理的一个不可或缺的组成部分。因此通过IT技术等信息化手段，使运动会成绩管理信息化、智能化，从而提升学校信息管理水平，是当今学校信息管理的大势所趋。
本次设计在调查了解现状和查阅相关资料的基础上，进行了系统需求分析，并制定出系统设计原则与详细设计方案。在开发时采用传统的MVC开发模式，利用Jsp+Javabean+Servlet技术，使用MySQL数据库存储数据，开发环境选用MyEclipse 8.0。最终基本实现了所需功能，并对系统进行了功能和性能测试，实现了一个B/S模式的能良好管理学生信息、裁判信息、比赛项目信息和成绩信息的运动会成绩管理系统。
关键词：信息化，运动会，成绩管理，JSP
II
Design and Implementation of Sports Competition
Results Management System
ABSTRACT
When Universities hold a sports competition, managers usually do not use or never use the sports competition results management system to handle the information in the sports competition, but used to rely on manual processes, through documentation or office software to process large amounts of data.This way bring to sports competition managers a heavy workload and the efficiency is lower, the update is slow, the error is also more.With the increasing development of technology, the school's information management technology has become an important indicator to reflect the overall strength of the school, and the sports competition results management is an integral part of the school information management. Therefore, by means of information technology, such as IT, make the sports competition results management become intelligent and high efficient, so as to enhance the level of school information management, it is a trend.
In the process of the design, the basic steps are investigate status and collect related informations, and then make the needs analysis, design principles and design details of the system. The development model is the traditional MVC, the development technology are the Jsp,Javabean and Servlet technology, the database is MySQL database and the development environment is MyEclipse 8.0. Eventually the most of the required functions were realized, the functional testing and results testing were done, i achieved a B/S mode system, which can be a good information management of student, referee, competition and grade.
Key words: informatization, sports competition, results management, JSP
III
目 录
摘要 ······································································································· I ABSTRACT ···························································································· II 1 概述 ···································································································· 1
1.1 选题背景及意义 ············································································· 1 1.2 现状分析 ······················································································ 1 2 开发工具及相关技术介绍 ········································································· 2
2.1 Java简介 ······················································································ 2 2.2 JSP技术介绍 ················································································· 2 2.3 JavaBeans介绍 ··············································································· 2 2.4 Java Servlet介绍 ············································································· 3 2.5 MyEclipse开发环境介绍 ··································································· 3 2.6 Tomcat服务器介绍 ·········································································· 3 2.7 MySQL数据库介绍 ········································································· 4 3 系统分析与设计原则 ··············································································· 5
3.1 系统需求分析 ················································································ 5
3.1.1 需求分析过程········································································ 5 3.1.2 系统需求概述········································································ 5 3.2 系统可行性分析 ············································································· 6
3.2.1 经济可行性··········································································· 6 3.2.2 技术可行性··········································································· 6 3.2.3 操作可行性··········································································· 6 3.2.4 社会可行性··········································································· 6 3.3 系统总体设计原则 ·········································································· 6 4 系统概要设计 ························································································ 8
4.1 系统功能模块设计 ·········································································· 8 4.2 数据库设计 ··················································································· 9
4.2.1 实体及其属性图····································································· 9 4.2.2 数据库表设计······································································ 11
5 系统详细设计与实现 ············································································· 14
5.1 系统设计思路 ·············································································· 14 5.2 管理员模块详细设计 ····································································· 14
5.2.1 登录界面············································································ 14
IV
5.2.2 修改个人密码······································································ 15 5.2.3 管理学生信息······································································ 15 5.2.4 管理裁判信息······································································ 19 5.2.5 管理比赛项目信息································································ 20 5.2.6 查看比赛成绩排名································································ 21 5.3 裁判模块详细设计 ········································································ 22
5.3.1 查看个人信息······································································ 22 5.3.2 修改个人密码······································································ 22 5.3.3 查看学生信息······································································ 22 5.3.4 查询成绩排名······································································ 23 5.4 学生模块详细设计 ········································································ 23
5.4.1 修改个人密码······································································ 23 5.4.2 查看个人成绩······································································ 23 5.4.3 查询他人成绩······································································ 24 5.4.4 报名参赛············································································ 25
6 系统测试与分析 ··················································································· 27
6.1 系统测试的重要性 ········································································ 27 6.2 系统测试的常用方法 ····································································· 27 6.3 功能测试 ···················································································· 28 6.4 性能测试 ···················································································· 28 6.5 测试结论 ···················································································· 29 7 总结与展望 ························································································· 30 致 谢 ···································································································· 31 参考文献 ······························································································· 32 附录 ······································································································· 1
运动会成绩管理系统设计与实现 1
1 概述
1.1 选题背景及意义
当今社会，越来越快的生活节奏使人们越来越重视自己身体状况，运动已经成为每个人生活中必不可少的一部分。运动会这一竞技方式也给人们的生活方式带来了很大的变化。
为了提高大学生的身体素质，促进学生德智体美劳全面发展，各所高校每年都会举行运动会比赛，然而各所高校在举行运动会时，很少甚至没有使用过运动会成绩管理系统来处理运动会中的信息，在很大程度上还是依赖人工操作，一般通过文档或者办公软件来处理大量的数据。这种方式给运动会管理人员带来了繁重的工作量，而且效率较为低下，更新缓慢，且容易出错。此外这种方式比较封闭，无论是运动员，还是场外观众，都不能很好地了解比赛场上实时状况，例如所有的比赛项目，参赛人员信息以及成绩排名等。这就不能使每一位同学都真正参与到运动会中去，从而也在一定程度上失去了开展运动会的意义。
随着科技的日益发展，学校的信息管理技术已经成为了能够体现学校综合实力的重要指标。运动会成绩管理是学校信息管理的一个不可或缺的组成部分。因此通过IT技术等信息化手段，使运动会成绩管理信息化、智能化，从而提升学校信息管理水平，是当今学校信息管理的大势所趋。
1.2 现状分析
在目前主要依赖人工操作的运动会成绩管理过程中，经过调查了解，总结归纳出主要存在以下常见问题：
信息的遗漏与延误，由于相关信息在从校级组织者到各个班级、宿舍的层层传递过程中，难免会出现信息的遗漏或延迟，导致学生往往不能及时了解比赛项目设置的情况，错过合适的参赛机会。
信息错误，在比赛过程中，成绩由裁判裁定后，在记录的过程中由于比赛间隔时间短，比赛项目繁多，参赛人员信息量大等因素，容易出现记录错误；而且人工工作效率较低，不能及时的公布比赛成绩排名等情况，在排名过程中也容易出现错误。
学生参与度低，学生不能及时了解到自己或他人的比赛成绩，降低了学生在运动会中的参与感。
纠错效率低，由于主要依赖人工操作，各个模块由不同的人负责，出现报名信息或比赛信息错误时，沟通缓慢，错误难以得到及时修改。
运动会成绩管理系统设计与实现毕业设计
