简单的在线考试系统(JSP+MysqL)

北方民族大学课程设计报告系（部、中心）计算机科学与工程学院姓名于淼学号20113185专业计算机科学与技术班级（2）班同组人员尚娜、农晓蕾、杨柳课程名称网络程序设计设计题目名称在线考试系统起止日期2013.10.10-2013.12.8成绩________________________________指导老师签名________________________在线考试系统摘要基于Web的在线考试系统——随着计算机及网络技术的飞速发展，Internet/Intranet应用在全球范围内日益普及，当今社会正快速向信息化社会前进，信息自动化的作用也越来越大，从而使我们从繁杂的事务中解放出来，提高了我们的工作效率。在众多的网络服务中，Web给人耳目一新的感觉，而在这其中，JSP技术和基于Struts框架技术则因为可以进行复杂的数据库操作、很强的交互性以及方便用户控制和管理备受青睐。目前存在各级各类的考试，而它们的各种工作主要还是依赖于手工完成，手工管理还存在这许多弊端，由于不可避免的人为因素，造成数据的遗漏、误报。计算机信息化管理有着储存量大，速度快等许多优点，因此我们可以利用计算机网络，利用ASP技术实现动态的管理。随着计算机网络技术的进一步发展和普及，利用JSP技术开发的各种网络在线考系统必将大行其道。关键字：JSP技术；Struts；在线考试系统目录：1、在线考试系统的需求分析·················································41.1硬件，软件环境说明···················································41.1.1硬件环境说明······················································41.1.2软件环境说明·······················································41.1.3在线考试系统网站的技术说明·········································71.1.3.1关于对B/S架构的理解············································71.1.3.2B/S架构带来的巨大好处············································81.2功能需求分析···························································82、在线考试系统的总体规划与结构框图········································82.1在线考试系统总体设计···················································82.2在线考试系统的总体规划设计·············································82.2.1学生模块·····························································92.2.2管理员模块··························································92.3在线考试系统各个模块之间的关系图及动作分解·····························102.3.1各个子模块之间的关系和操作动作分解···································102.3.2管理员模块下各个子模块之间的关系及动作分解···························103、在线考试系统数据库设计···················································113.1数据库的需求分析························································113.2在线考试系统概念结构设计················································113.2.1在线考试系统数据库的实体设计·········································113.2.2在线考试系统数据库的E-R图···········································123.3数据库的逻辑结构设计···················································133.3.1在线考试系统数据库逻辑结构设计·······································134、针对具体的功能模块写出设计流程图与关键的程序代码·························144.1在线考试系统设计流程图··················································144.2在线考试系统管理模块设计流程图··········································144.3在线考试系统用户登录模块设计············································154.4系统关键程序代码························································164.4.1dl.jsp源代码···························································164.4.2zc.jsp源代码···························································184.4.3zxks(1).jsp源代码·······················································234.4.4xgzl.jsp源代码·························································264.4.5htdl.jsp源代码·························································314.4.6gl_student.jsp源代码····················································334.4.7gl_addstudent.jsp源代码·················································354.4.8gl_lesson.jsp源代码····················································404.4.9gl_addlesson.jsp源代码··················································424.4.10gl_timu.jsp源代码·····················································464.4.11gl_addtimu源代码·····················································485.测试和演示系统并抓取图形界面··············································535.1系统开发与运行环境的配置················································535.1.1JDK的安装与配置····················································535.1.2Tomcat的安装与配置··················································535.1.3DreamweaverCS3的站点的配置········································535.2演示系统并抓取系统图形界面············································586、测试结果及存在的问题····················································656.1测试的结果·····························································656.2存在的问题·····························································667、参考文献································································661.在线考试系统的需求分析1.1硬件、软件环境说明1.1.1硬件环境说明在线考试系统的硬件环境是：CPU采用的是Inter（R）Core（TM）i3-2330MCPU@2.20GHz；硬盘容量：500GB；显示器的分辨率是1366×768。1.1.2软件环境说明：在线考试系统采用的是B/S架构，编译器为DreamweaverCS3，java的编译环境是JDK1.6.03。运行JSP页面的服务器是Tomcat服务器。Mysql数据库的驱动程序使用的是mysql-connector-java-5.1.0-bin.jar。1）DreamweaverCS3编译器的简要说明DreamweaverCS3是Adobe（奥多比）公司收购Macromedia公司后最新推出的CreativeSuite3设计套装中用于网页设计与制作的组件。作为全球最流行，最优秀的所见即所得的网页编辑器，Dreamweaver可以轻而易举地制作出跨操作系统平台，跨浏览器的充满动感的网页，是目前制作Web页站点,Web页和Web应用程序开发的理想工具。Dreamweaver，Fireworks，Flash被称为网页制作的“三剑客”，这三款工具相辅相成，是制作网页的最佳拍档之一。与其他网页编辑工具相比，Dreamweaver的新版DreamweaverCS3主要功能和具体应用方法，Dreamweaver的主要特点有：形式灵活Dreamweaver将“设计”和“代码”编译器集成在一起，既可以方便的进行源代码编辑，也可以使用鼠标方式添加和设置对象。可视化编辑环境Dreamweaver是一种所见即所得的网页编辑器，既有效的减少了代码编写的工作量，也确保所设计文档的专业性和兼容性。强大CSS功能CSS样式可以有效的控制网页对象的外观，美化网页界面，如文本字体，颜色，表单样式、图像风格等。Dreamweaver中有强大的CSS样式表编辑器，可以比较轻松的编辑CSS样式。站点管理功能完善Dreamweaver提供了强大的站点管理功能，可以安全，系统的维护和管理各种规模的网站。集成性高Dreamweaver与Fireworks，Flash，ShockWave具有良好的集成性，可以在这些Web创作工具之间自由的进行切换。媒体支持能力强在Dreamweaver文档中，可以灵活加入JAVA，Flash，Shockwave，ActiveX以及其他媒体元素，也可以对各种多媒体元素进行处理。扩展能力强Dreamweaver可以实现功能的扩展。利用Adobe公司免费提供的Dreamweaver插件，可以丰富Dreamweaver的媒体处理能力。DreamWeavercs3的前身Dreamweaver8