题库技术、Web技术、数据库技术实现基于Web的题库系统

中文摘要

本文主要研究试题库技术、Web技术、数据库技术，探索将这三种技术有机的结合，实现基于Web的题库系统。该系统能够和学校的校园网或其它基于Web的应用结合在一起，满足教师出题、学生在线做题和考试的需要。

本文对题库系统的背景、概念、理论和技术进行了概述，比较分析了其他各种试题库系统，并在此基础上提出了通用性、网络化的新特点，从而实现了此试题库管理系统。

研究了客户机/服务器模式、数据库系统、PHP等相关理论和技术，给出了一个基于Web的题库系统的实现方案。系统采用B/S模式，用户采用浏览器与系统实现交互。应用层由Web服务器和数据库组成。系统采用PHP作为主要开发语言，可实现试题录入，考卷自动生成、学生在线考试等功能。该系统由题库管理系统和在线考试子系统两部分组成。 关键词 B/S结构；题库系统；自动组卷

摘要

Abstract

This document is about to research examination question database technology, web technology, database technology and explore the combination of these three kinds of technology to achieve web-base examination database system. The system is able to integrate with the campus network or other web-base application to meet the requirement of make examination questions by teachers and the students online self-test.

This paper summarizes the examination question database system?s background, concept, theory and technology, comparatively analyses the existing examination question database system, and based on this proposes the new general and network characteristic, thus implements the system.

It makes research about client/server model, database system, PHP and other relate theories and technologies, gives a proposal to fulfill web-base examination question database system. This system adopts B/S mode, and the user accesses the system through a browser. The application layer is composed of web server and database. System users PHP as the main program language, and it can fulfill the functionality of online question input, automatic generation of the test papers, online examination etc. This system is composed of two parts: question database management subsystem and online test subsystem.

Keywords: B/S structure; examination question database system; automatic test paper combination

KeyWords: B/S structure; examination question database system; automatic test paper combination

摘要

目 录

中文摘要........................................................................................................................ 1 Abstract .......................................................................................................................... 2 目 录.............................................................................................................................. 3 第一章 引 言................................................................................................................ 2 1.1 研究背景及意义................................................................................................... 2 1.2 研究现状及趋势................................................................................................... 3 1.3 论文结构............................................................................................................... 5 第二章 系统分析.......................................................................................................... 6 2.1 可行性分析........................................................................................................... 6

2.1.1 技术分析..................................................................................................... 6 2.1.2 应用分析..................................................................................................... 6 2.2 系统需求分析....................................................................................................... 6

2.2.1 功能需求..................................................................................................... 7 2.2.2 用户需求..................................................................................................... 7 2.2.3 性能需求..................................................................................................... 7 2.3 本章总结............................................................................................................... 8 第三章 系统总体设计.................................................................................................. 9 3.1 系统的功能模块设计........................................................................................... 9

3.1.1 后台管理系统............................................................................................. 9 3.1.2 前台子系统............................................................................................... 10 3.2 系统的运行模式................................................................................................. 11

3.2.1 MVC架构特征 ........................................................................................ 12 3.2.2 题库系统结构........................................................................................... 13 3.3 系统的数据库设计............................................................................................. 13

3.3.1 数据库需求分析....................................................................................... 14 3.3.2 数据库安全............................................................................................... 14 3.3 本章总结............................................................................................................. 15 第四章 系统详细设计................................................................................................ 16 4.1 开发环境和开发工具......................................................................................... 16

4.1.1 开发环境搭建........................................................................................... 16

4.1.1.1 安装MySQL .................................................................................. 16 4.1.1.2 安装Apache ................................................................................... 17 4.1.1.3 安装PHP ........................................................................................ 17 4.1.1.4安装CodeIgniter ............................................................................... 17 4.1.2 主要开发工具........................................................................................... 18 4.2 系统数据库表结构设计..................................................................................... 19 4.3 系统主要模块设计............................................................................................. 23

4.3.1 系统前端实现........................................................................................... 23

4.3.1.1 首页................................................................................................. 23 4.3.1.2 用户注册与登陆............................................................................. 24 4.3.1.3 在线考试......................................................................................... 27

摘要

4.3.1.4 资料上传与下载............................................................................. 29 4.3.2 系统后端实现........................................................................................... 31

4.3.2.1 后端首页实现................................................................................. 31 4.3.2.2 登入登出......................................................................................... 32 4.3.2.3 试题管理......................................................................................... 33 4.3.2.4 试卷管理......................................................................................... 35 4.3.2.5 考卷管理......................................................................................... 38 4.3.2.6 上传管理......................................................................................... 40 4.3.2.7 科目管理和知识点管理................................................................. 41 4.3.2.7 用户和用户组管理......................................................................... 43

4.4 本章总结............................................................................................................. 46 第五章 系统测试........................................................................................................ 47 5.1 系统特色............................................................................................................. 47 5.2 系统测试............................................................................................................. 47

5.2.1 系统测试工具........................................................................................... 47 5.2.2 系统测试计划........................................................................................... 47 5.2.3 测试用例................................................................................................... 48

5.2.3.1 登陆模块测试................................................................................. 48 5.2.3.2 试题管理测试................................................................................. 48 5.2.3.3 试卷管理测试................................................................................. 48 5.2.3.4 在线考试测试................................................................................. 49 5.2.4 测试总结................................................................................................... 49 5.3 本章总结............................................................................................................. 49 第六章 结束语............................................................................................................ 50 致 谢............................................................................................................................ 52