《数据库原理与应用》题库系统的设计与实现

摘　　要
一般情况教师想出一份试卷，要么到庞大的题库里一道一道的把题找出来，或是从几本相关的书里把题一道一道挑出来。这样即费时又费力，而且很难保证试题的覆盖面和把握好试卷的难度。正是为了能够帮助教师轻松的出一份高质量的试卷而开发了本软件。为了达到预期的目标我们最终选择了Microsoft Office Word做为本软件的终端输出。本软件是在对现有控件的改进和VBA编程的研究的基础上开发的。本软件实现了以下主要功能：1.手动生成试卷；2.自动生成试卷；3.抽取现有试卷；4.用户管理；5.数据库管理。大量的测试表明本软件在Windows 98／me／2000／XP平台配合Office XP／2003 的环境下程序运行稳定且各项功能运行得都很正确，基本达到了预期的要求！！
结论：经过老师的实际试用本软件在界面上和功能上都有独到之处！！相信完全可以胜任出一份好的试卷任务。

Abstract
The general situation teacher thinks out a paper，reach huge exam pool each finds out the question, or shoulder the question together out from several relevant books. Time-consuming and also strenuous like this, and very difficult to guarantee coverage rate and paper degree of difficulty of examination question. Helping the teacher thinks out a higt quality paper is the destination of develop this Software. In the cause of this we select the terminal is Microsoft Office Word. This Software’s base of develop is improve on control in existence and study the VBA programing. These functions of this software are as follows: One. Manual create paper; Two. Auto create paper; Three. Select from existential papers; Four. User manage; Five. Database manage. The result of many test is that this software is runing steady and these funtions of it is runing right in the environment which make up of Windows 98／me／2000／XP and Office XP／2003, it is basic reach the requests.
 In all: the result of real test by teacher is that this software are unique in interface and function. We must believe it can complete creating a high quality paper.

 负责的功能模块
 设计试题生成功能，试题能分布整个教学内容
 设计试题的难易程度分析功能
 具有试题的答案生成功能
 数据库设计及维护
 程序的其它选项设置










目　　录

摘　　要 1
Abstract 2
前　　言 1
1 . 简述 2
1.1 开发工具简介 2
1.1.1 Delphi 7.0的特点 2
1.1.2 主要的控件及其属性简介 2
1.1.3 数据库连接方式选择 3
1.2 程序运行环境 4
2 . 需求分析 5
2.1 负责的功能模块 5
2.2 软件功能分析 5
3 . 设计阶段 8
3.1 概要设计 8
3.1.1 系统数据库设计 8
3.2 详细设计 12
3.2.1 程序流程图 12
3.2.2 窗体功能简介 14
4 . 软件实现 20
4.1 OOP简介 20
4.2 开发的关键技术 20
5 . 软件测试及其维护 24
5.1 系统测试平台简介 24
5.2 测试方法 24
5.3 系统维护 25
6 . 开发总结 26
参 考 文 献 27
致　　谢 28
译    文 29
原    文 33