I
楚水高中在线考试系统设计与实现
摘 要
本楚水高中在线考试系统是针对目前楚水高中在线考试的实际需求，从实际工作出
发，对过去的楚水高中在线考试系统存在的问题进行分析，结合计算机系统的结构、概
念、模型、原理、方法，在计算机各种优势的情况下，采用目前最流行的 B/S 结构和 java
中流行的 MVC 三层设计模式和 eclipse 编辑器、MySQL 数据库设计并实现的 。本楚水高
中在线考试系统主要包括系统用户管理模块、课程信息管理模块、教师信息管理、学生
信息题管理、试卷信息管理、登录模块、和退出模块等多个模块。它帮助楚水高中在线
考试系统实现了信息化、网络化，通过测试，实现了系统设计目标，相比传统的管理模
式，本系统合理的利用了楚水高中在线考试系统数据资源，有效的减少了楚水高中在线
考试系统的经济投入，大大提高了楚水高中在线考试系统的效率。
关键词：楚水高中在线考试系统；eclipse 编辑器；MySQL 数据库
II
ABSTRACT
The online examination system of the Chushui High School is aimed at the actual needs
of the current online examination of Chushui High School. From the actual work, the
problems existing in the online examination system of the Chushui High School in the past
are analyzed, and the structure, concept, model, principle, and method of the computer system
are combined. Under the various advantages of the computer, the most popular B/S structure
and the popular MVC three-layer design model in Java and the clipse editor, MySQL
database design and implementation are used. The online examination system of Benchushui
High School mainly includes system user management module, course information
management module, teacher information management, student information problem
management, test paper information management, login module, and exit module. It helped
the Chushui High School Online Examination System to realize information and networking.
Through testing, it achieved the goal of system design. Compared with the traditional
management model, the system reasonably used the data resources of the Chushui High
School Online Examination System. It effectively reduces the economic investment of
Chushui High School Online Examination System and greatly improves the efficiency of
Chushui High School Online Examination System.
【key words】：Chushui High School Online Examination System; The MVC
pattern;MySQL database
III
目 录
楚水高中在线考试系统设计与实现 .................................................................................I
摘 要 ...................................................................................................................................I
ABSTRACT ........................................................................................................................I
目 录...............................................................................................................................III
第 1 章 绪论.......................................................................................................................1
1.1 开发背景................................................................................................................1
1.2 开发意义................................................................................................................1
1.3 研究内容................................................................................................................1
第 2 章 主要技术和工具介绍...........................................................................................1
2.1 SSM 框架..............................................................................................................1
2.1.1. Spring 框架 ................................................................................................1
2.1.2 SpringMVC..................................................................................................2
2.1.3. MyBatis 的选用.........................................................................................2
2.2 mysql 数据库.........................................................................................................2
2.3 eclipse 与 Tomcat 简介 .........................................................................................2
第 3 章 系统分析...............................................................................................................1
3.1 可行性分析............................................................................................................1
3.1.1 经济可行性..................................................................................................1
3.1.2 技术可行性..................................................................................................1
3.1.3 操作可行性..................................................................................................1
3.2 需求分析................................................................................................................1
3.3 业务流程分析........................................................................................................2
3.4 数据流程分析........................................................................................................3
第 4 章 系统设计...............................................................................................................6
IV
4.1 系统结构设计........................................................................................................6
4.2 功能模块设计........................................................................................................6
4.3 数据库设计............................................................................................................7
4.3.1 数据库设计概述..........................................................................................7
4.3.1 概念设计......................................................................................................7
4.3.2 表设计..........................................................................................................8
第 5 章 系统实现...........................................................................................................13
5.1 基本任务..............................................................................................................13
5.2 登录模块的实现..................................................................................................14
5.2.1 首页实现....................................................................................................14
5.2.2 管理员后台登录........................................................................................14
5.3 教师用户模块的实现..........................................................................................17
5.3.1 试题信息管理模块的实现........................................................................17
5.3.2 试卷生成管理模块的实现........................................................................18
5.4 管理员模块的实现..............................................................................................20
5.4.1 系统用户管理模块的实现........................................................................20
5.4.2 课程信息管理模块的实现........................................................................21
5.4.3 教师信息管理模块的实现........................................................................23
5.4.4 学生信息管理模块的实现........................................................................25
5.5 学生管理模块的实现..........................................................................................26
5.5.1 在线考试模块的实现................................................................................26
5.5.2 我的成绩管理模块的实现........................................................................27
第 6 章 系统测试...........................................................................................................29
6.1 测试目的..............................................................................................................29
6.2 测试概述..............................................................................................................29
V
6.3 单元测试..............................................................................................................29
6.3.1 注册测试....................................................................................................29
6.3.2 登录测试....................................................................................................30
6.4 集成测试..............................................................................................................31
第 7 章 总结...................................................................................................................32
致 谢...............................................................................................................................33
参考文献...........................................................................................................................33
