毕 业 设 计（论 文）
学生信息管理系统设计与实现
I
摘 要
传统办法管理学生信息首先需要花费的时间比较多，其次数据出错率比较高，
而且对错误的数据进行更改也比较困难，最后，检索数据费事费力。因此，在计
算机上安装学生信息管理系统软件来发挥其高效地信息处理的作用，可以规范学
生信息管理流程，让管理工作可以系统化和程序化，同时，学生信息管理系统的
有效运用可以帮助管理人员准确快速地处理信息。
学生信息管理系统在对开发工具的选择上也很慎重，为了便于开发实现，选
择的开发工具为 Eclipse，选择的数据库工具为 Mysql。以此搭建开发环境实现学
生信息管理系统的功能。其中管理员管理班级和课程的关系，管理奖惩类型，课
程和专业信息。老师负责学生成绩和学生奖惩信息的管理，查询任课课程。学生
主要查询成绩，查询奖惩信息，查看班级和班级课程。
学生信息管理系统是一款运用软件开发技术设计实现的应用系统，在信息处
理上可以达到快速的目的，不管是针对数据添加，数据维护和统计，以及数据查
询等处理要求，学生信息管理系统都可以轻松应对。
关键词：学生信息管理系统；学生成绩；奖惩信息；班级课程
II
Abstract
The traditional method of managing student information first takes more time,
secondly, the data error rate is relatively high, and it is more difficult to modify the
wrong data, and finally, it is laborious and laborious to retrieve data. Therefore,
installing the student information management system software on the computer to
play its role in efficient information processing can standardize the student
information management process, so that the management work can be systematized
and programmed. At the same time, the effective use of the student information
management system can help management Personnel process information accurately
and quickly.
The student information management system is also very cautious in the
selection of development tools. In order to facilitate the development and realization,
the selected development tool is Eclipse, and the selected database tool is Mysql. To
build a development environment to realize the functions of the student information
management system. Among them, the administrator manages the relationship
between classes and courses, and manages the types of rewards and punishments,
courses and professional information. The teacher is responsible for the management
of student performance and student rewards and punishments, and inquires about the
courses. Students mainly check grades, check rewards and punishments, check classes
and class courses.
The student information management system is an application system designed
and implemented using software development technology. It can achieve rapid goals
in information processing. Whether it is for processing requirements such as data
addition, data maintenance and statistics, and data query, the student information
management system can It can be handled easily.
Key Words ： Student Information Management System; Student Performance;
Rewards and Punishment Information; Class Curriculum
III
目 录
第 1 章 绪论 ..................................................................................................................1
1.1 选题动因 ..........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 ..................................................................................................2
第 2 章 开发环境与技术 ..............................................................................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 TOMCAT 介绍...................................................................................................3
2.3 JSP 技术 ...........................................................................................................4
第 3 章 系统分析 ..........................................................................................................5
3.1 可行性分析 ......................................................................................................5
3.1.1 操作可行性分析 ...................................................................................5
3.1.2 经济可行性分析 ...................................................................................5
3.1.3 技术可行性分析 ...................................................................................5
3.2 系统流程分析 ..................................................................................................6
3.3 系统性能分析 ..................................................................................................7
3.4 系统功能分析 ..................................................................................................8
第 4 章 系统设计 ........................................................................................................11
4.1 界面设计原则 ................................................................................................11
4.2 功能结构设计 ................................................................................................11
4.3 数据库设计 ....................................................................................................14
4.3.1 数据库概念设计 .................................................................................15
4.3.2 数据库物理设计 ................................................................................17
第 5 章 系统实现 ........................................................................................................21
5.1 管理员功能实现 ............................................................................................21
5.1.1 班级和课程关系管理 .........................................................................21
5.1.2 老师管理 .............................................................................................21
IV
5.1.3 奖惩类型管理 .....................................................................................22
5.2 老师功能实现 ...............................................................................................22
5.2.1 成绩管理 .............................................................................................22
5.2.2 学生奖惩管理 .....................................................................................23
5.2.3 课程管理 .............................................................................................23
5.3 学生功能实现 ...............................................................................................24
5.3.1 班级管理 .............................................................................................24
5.3.2 查询成绩 .............................................................................................24
5.3.3 修改密码 .............................................................................................25
第 6 章 系统测试 ........................................................................................................26
6.1 系统测试方法 ...............................................................................................26
6.2 功能测试 .......................................................................................................26
6.2.1 登录功能测试 ....................................................................................27
6.2.2 查询课程功能测试 ............................................................................27
6.3 测试结果分析 ...............................................................................................27
结 论 ..........................................................................................................................28
参考文献 ......................................................................................................................30
致 谢 ..........................................................................................................................31
