搜索
摘要利用网络和数据库技术，结合目前硬件价格普遍下跌与宽带网大力建设的有利优势，我们基于B/S模式研究开发了试题库与在线考试系统这一ASP程序。它运用方便、操作简单，效率很高，已具有试题（卷）录入、修改和查询，手工组卷与自动组卷以及进行在线考试等重要功能，也就是说实现了真正的无纸化考试，满足任何授权的考生随时随地考试并迅速获得成绩，并给出其详细的成绩分析与试卷评估，同时也大大减轻了教师出题、组卷和改卷等繁重的工作量。关键词：数据库，ASP技术，在线考试,系统管理AbstractUsenetworkandthedatabasetechnology,theunionthehardwarepricegenerallyfallsatpresenttheadvantageoussuperioritywhichconstructsvigorouslywiththebroadbandnetworks,webasedonB/TheSpatternresearchdevelopedhastriedthequestionbankandtheonlinetestsystemthisASPprocedure.Itutilizes,theoperationconvenientlyissimple,theefficiencyisveryhigh,hadthetestquestiontoinput,therevisionandtheinquiry,thehandworkteamorgroupvolumeandtheautomaticgroupvolumeaswellascarriesontheonlinetestandsoontheimportantfunction,inotherwords,hasrealizedthetruepaperlesstest,satisfiesanyauthorizationtheexamineetakesatestanytimeandanywhereandobtainstheresultrapidly,andgivesitsdetailedresultanalysisandtheexaminationpaperappraised,simultaneouslyalsogreatlyreducedtheteachertosetthetopicofacomposition,thegroupvolumeandchangesthevolumeandsoonthearduousworkload.Keyword:Database,ASPtechnology,onlinetest,Systemadministration目录第一章绪论.............................................................................................................................................21.1选题背景...................................................................................................................................21.2在线考试系统设计概述............................................................................................................3第二章在线考试系统需求分析..............................................................................................................52.1系统总体需求分析.....................................................................................................................52.2系统所能完成的基本功能.........................................................................................................52.3系统的技术需求分析.................................................................................................................52.3.1系统性能需求.................................................................................................................62.4系统总体设计.............................................................................................................................72.4.1系统的软件结构及开发环境.........................................................................................72.4.2系统栏目设置.................................................................................................................72.4.3系统功能描述.................................................................................................................8第三章在线考试系统详细设计............................................................................................................153.1数据库设计.............................................................................................................................153.1.1数据库的概念设计......................................................................................................153.1.2E-R模型图...................................................................................................................163.1.3数据库的逻辑设计.......................................................................................................173.2数据库详细设计......................................................................................................................18第四章关键技术与系统实现................................................................................................................214.1数据库访问..............................................................................................................................224.2科目管理登陆...........................................................................................................................224.3考生考试中提前交卷、到时交卷的实现。...........................................................................274.4自动组卷的实现.......................................................................................................................30第五章结束语.......................................................................................................................................31参考文献：.............................................................................................................................................32附录：.....................................................................................................................................................34外文文献翻译：.............................................................................................................................34第一章绪论1.1选题背景在当今信息飞速发展的时代，计算机已经越来越深入每个人的学习、生活当中，掌握计算机知识已经成为每个人必须的生存技能。考试是对我们学习效果检验的最直接，也是最传统的一种方式。而随着社会时代的不断发展，我国计算机不断发展和普及，传统的纸面考试完全可以被计算机辅助考试系统所取代。传统的纸面考试不仅费时、费力，费财，而且批改起来也十分费力。现阶段，学校与社会上的各种考试大都采用传统的考试方式，在此方式下，组织一次考试至少要经过五个步骤，即人工出卷、考生考试、人工阅卷、成绩评估和试卷分析。显然，随着考试类型的不断增加及考试要求的不断提高，教师的工作量将会越来越大，并且其工作将是一件十分烦琐和非常容易出错的事情，可以说传统的考试方式已经不能适应现代考试的需要。随着计算机应用的迅猛发展，网络应用不断扩大，如远程教育和虚拟大学的出现等等，且这些应用正逐步深入到千家万户。人们迫切