分类号：TP315 U D C：D10621-408-(2007)5967-0
密 级：公 开 编 号：2003031199
成 都 信 息 工 程 学 院
学 位 论 文
基于 B/S 的计算机等级考试系统的设计与实现
论文作者姓名：
赵 书 平
申请学位专业：
计算机科学与技术
申请学位类别：
工学学士
指导教师姓名（职称）：
曾令明（讲师）
论文提交日期：
2007 年 06 月 08 日
基于 B/S 的计算机等级考试系统的设计与实现
摘 要
随着计算机技术的发展及计算机的日益普及，基于 B/S 结构的考试系统与无
纸化办公一样已成为大势所趋。论文详细论述了一个基于 B/S 结构的计算机等级
考试系统的设计过程。软件采用 ASP.NET 2005 作开发平台，C#作编程语言，SQL
Server 2005 作数据库管理系统，实现了试题管理、试卷生成、在线考试、试卷评
判、权限管理、在线报名及站内公告等功能。系统符合全国计算机等级考试的要
求。
论文组织如下：首先阐述了该系统的开发背景、意义；其次介绍了相关的开
发工具及技术基础；接着对系统的需求进行了分析，并提出了具体的设计方案和
数据库模型；然后展现了整个系统的具体实现，包括数据库的设计和连接，各功
能模块的实现；最后对该软件进行了严格的测试。
关键词： B/S 结构；计算机等级考试；考试系统
The Design and Implementation of Computer Rank
Examination System based on B/S
Abstract
With the development of the computer technology and the popularization of
computers, the examination system based on B/S structure has become the trend of
the times the same as the paperless office. The paper discusses in detail the
development and design process of a computer rank examination system based on B/S
structure. It uses ASP.NET 2005 as the development platform, C# as the
programming language, SQL Server 2005 as the database management system, and
includes test questions management, examination paper production, online
examinations, examination paper judgment, authority management, online enrollment
and site notice, etc.. It can accord with the requirement of the national computer rank
examination.
The paper is organized as following: Firstly, analyzes the background and
significance; Secondly, introduces the development tools and the foundation of the
technology; Thirdly, analyses the demand of the system, gives a specific design
project and a database model; Then shows the implementation of the whole system,
which includes the design and linkage of the database and the implementation of
every module. Finally gives a test of the system.
Key words: B/S structure; Computer rank test; Examination system
目 录
论文总页数：31 页
1 引 言............................................................................................................................................1
2 技术背景........................................................................................................................................2
2.1 B/S 结构...................................................................................................................................2
2.2 开发工具简介 .........................................................................................................................2
2.2.1 Visual C# 2005 简介.........................................................................................................2
2.2.2 SQL Sever 2005 简介.......................................................................................................3
3 系统分析.........................................................................................................................................3
3.1 需求分析..................................................................................................................................3
3.1.1 系统需要解决的主要问题...............................................................................................3
3.1.2 系统应该具备的基本功能...............................................................................................4
3.2 可行性分析..............................................................................................................................4
3.2.1 技术可行性分析...............................................................................................................4
3.2.2 经济可行性分析..............................................................................................................5
3.2.3 社会因素方面的可行性分析..........................................................................................5
4 总体设计.........................................................................................................................................5
4.1 基本设计思想及流程图 .........................................................................................................5
4.2 系统功能结构图 .....................................................................................................................5
4.3 系统架构 .................................................................................................................................6
4.3.1 数据访问层.......................................................................................................................6
4.3.2 业务逻辑层.......................................................................................................................7
4.3.3 页面显示层.......................................................................................................................7
4.4 数据库的设计..........................................................................................................................8
4.4.1 创建数据库......................................................................................................................8
4.4.2 创建表..............................................................................................................................8
4.4.3 关系设计.........................................................................................................................10
4.5 数据访问接口及通用组件....................................................................................................10
4.5.1 获取安全数据（GetSafeData） ...................................................................................10
4.5.2 构造 SQL 语句（SQLString）.....................................................................................10
4.5.3 字符串加密（Security） ..............................................................................................11
5 网站后台主要功能模块...............................................................................................................11
5.1 用户登录模块设计 .............................................................................................................11
5.1.1 前台页面设计.................................................................................................................11
5.1.2 后台功能代码.................................................................................................................11
5.2 后台管理页面设计 .............................................................................................................12
5.2.1 人员管理页面设计.........................................................................................................13
5.2.2 试题管理页面设计.........................................................................................................14
5.2.3 公告管理页面设计.........................................................................................................15
5.2.4 密码管理页面设计.........................................................................................................17
5.2.5 试卷成绩信息管理页面设计.........................................................................................17
6 网站前台主要功能模块...............................................................................................................19
6.1 网站公告页面设计................................................................................................................19
6.2 考生在线报名页面设计........................................................................................................20
6.3 考生登录页面设计................................................................................................................21
6.4 考生在线考试页面设计 .......................................................................................................22
7 系统测试......................................................................................................................................25
7.1 测试环境 ...............................................................................................................................25
7.1.1 硬件环境........................................................................................................................25
7.1.2 软件环境........................................................................................................................25
7.2 主要模块测试 .......................................................................................................................26
7.2.1 登录模块测试................................................................................................................26
7.2.2 考生考试模块测试........................................................................................................26
7.2.3 管理员/阅卷员模块测试...............................................................................................27
结 论..........................................................................................................................................28
参考文献..........................................................................................................................................29
致 谢..........................................................................................................................................30
声 明..........................................................................................................................................31
