本 科 学 生 毕 业 论 文
年 月 日
论文题目：
基于 SSH 的学校在线考试系统的设计
与实现
学 院：
（黑体三号字）
年 级：
（黑体三号字）
专 业：
（黑体三号字）
姓 名：
（黑体三号字）
学 号：
（黑体三号字）
指导教师：
（黑体三号字）
目 录
摘 要......................................................................................................................1
Abstract ..................................................................................................................2
1 绪 论................................................................................................................3
1.1 网站分析..................................................................................................3
1.2 研究现状.................................................................................................3
1.3 功能需求.................................................................................................4
1.5 研究内容..................................................................................................4
1.6 相关支撑.................................................................................................4
1.6.1 硬件设备.......................................................................................4
1.6.2 支持技术.......................................................................................4
1.6.3 SSM 框架技术..............................................................................5
1.6.4 MySQL 技术.................................................................................5
2 系统总体设计....................................................................................................6
2.1 需求调研.................................................................................................6
2.2 可行性分析..............................................................................................7
2.2.1 经济可行性...................................................................................7
2.2.2 技术可行性...................................................................................7
2.2.3 操作可行性...................................................................................8
2.2 功能性需求分析......................................................................................8
2.3 数据流程分析..........................................................................................9
2.4 非功能需求分析....................................................................................10
2.5 管理员流程分析...................................................................................10
2.6 系统性能的分析需求............................................................................11
2.6.1 系统所存在的安全性.................................................................11
2.6.2 所存在数据的完整性.................................................................11
第 3 章 系统设计................................................................................................12
3.1 设计的思路............................................................................................12
3.2 系统结构设计.......................................................................................12
3.3 数据库设计...........................................................................................13
3.3.1 数据库设计概述.......................................................................13
3.3.2 概念设计...................................................................................13
3.3.3 表设计.......................................................................................15
3.4 数据库的连接........................................................................................17
第四章 系统实现................................................................................................19
4.1 系统登录页面实现...............................................................................19
4.2 管理员操作界面实现............................................................................19
4.3 学生添加管理实现...............................................................................20
4.4 教室列表管理实现................................................................................20
4.5 课程添加管理实现...............................................................................21
4.7 题库管理实现........................................................................................21
4.8 添加题库管理实现................................................................................22
4.9 试卷添加管理实现................................................................................23
4.10 试卷批改管理实现..............................................................................23
4.11 学生在线考试功能实现......................................................................24
第五章 系统测试................................................................................................25
5.1 测试的目的............................................................................................25
5.2 测试的步骤............................................................................................25
5.3 测试分类................................................................................................26
5.3.1 功能测试....................................................................................26
5.3.2 集成测试....................................................................................26
5.3.3 性能测试....................................................................................26
5.4 测试用例................................................................................................27
5.5 性能测试...............................................................................................27
5.6 测试结果分析......................................................................................28
结 语......................................................................................................................1
1 论文工作总结............................................................................................1
2 问题与展望..............................................................................................1
参考文献................................................................................................................3
1
摘 要
在现如今这个互联网以及信息技术飞速发展的时代，信息技术被广泛地运用于人们
的日常生活与生产中，并有效地提高了办事、办公效率。教育信息化的高速发展，使得
学校在线考试系统，作为一种新的考试管理工具，在各大院校及相关教育机构的运用日
趋普遍。绝大多数的考试机构需要不断地推进自身信息化的建设，而在考务管理方面，
以往手工记账、登记信息的方式，已经逐渐不能满足现如今大数据量、高效率完成的要
求，使用学校在线考试系统，对学校及相关教育机构的考试事宜管理已成当下教育信息
化发展的必要手段。现代化的考试机构都应该进行学校在线考试系统的替换工作，学校
在线考试系统一经推出，便在考试机构范围内引起了极大地反响。
本次学校在线考试系统的实现过程，它的开发使用 B/S 结构即浏览器和服务器结构
框架，采用 SSM 框架技术，数据库使用了 mysql 数据库，页面设计采用了 MVC 框架，后
端采用了 SSM 框架技术 scrip 等其他一些脚本语言，使用到在大学里面学的软件工程导
论课程、mysql 数据库、数据库原理、SSM 框架技术高级程序设计等方面的知识完成本
系统。本文结合全流程网站系统开发过程，详细介绍了此次学校在线考试系统的设计理
念、模型结构，将所学知识融入到本网站的开发实践中，简略介绍了研究的背景和系统
存在的现实意义，开发使用的技术背景，并对系统概要设计、系统实现与系统测试等进
行了详细的介绍。
关 键 词 ： SSM 框 架 技 术 ； MySQL ； MVC ； 在 线 考 试
2
Abstract
In today's era of rapid development of Internet and information technology, information
technology is widely used in people's daily life and production, and effectively improve the
efficiency of work and office. With the rapid development of education informatization,
online examination system, as a new examination management tool, is widely used in
Colleges and related educational institutions. The vast majority of examination institutions
need to constantly promote the construction of their own information, and in terms of
examination management, the previous manual bookkeeping and registration of information
has gradually failed to meet the requirements of large amount of data and high efficiency. It is
necessary to use the school online examination system to manage the examination matters of
schools and related educational institutions Means. Modern examination institutions should
replace the school online examination system. Once the school online examination system is
launched, it will be convenient It has aroused great repercussions within the scope of
examination institutions.
This school online examination system implementation process, its development uses B /
S structure, namely browser and server structure framework, adopts SSM framework
technology, database uses MySQL database, page design uses MVC framework, back-end
uses SSM 框 架 技 术 Script and other script language, uses the introduction to software
engineering course, MySQL database, database principles learned in the University SSM
framework technology, advanced programming and other aspects of knowledge to complete
the system. Combined with the whole process of website system development, this paper
introduces the design concept and model structure of the school online examination system in
detail, integrates the learned knowledge into the development practice of this website, briefly
introduces the research background, the practical significance of the system, the technical
background of development and use, and makes a detailed analysis of the system outline
design, system implementation and system testing Introduction.
Key words: SSM framework technology; MySQL; MVC; online examination
