【正文】 。 經(jīng)過測試，該系統(tǒng)運(yùn)行良好，操作簡單，實(shí)用可行。實(shí)現(xiàn)了 試題錄入 和 試題查詢 等主要功能。 本文主 要介紹了該系統(tǒng)的背景、目的和意義，給出了系統(tǒng)的需求分析、總體方案 和總體設(shè)計(jì)，還有本系統(tǒng)運(yùn)行的工作環(huán)境以及所使用的開發(fā)工具，包括 ASP、 access 等軟件。本課題的研究實(shí)現(xiàn)了 對試題庫的錄入管理功能， 能使試卷管理工作更科學(xué)更高效。 《數(shù)據(jù)庫原理》試題庫錄入系統(tǒng) A test questions library input system for Database principle 總計(jì) 畢業(yè)設(shè)計(jì)（論文） 52 頁 表 格 3 個(gè) 插 圖 17 幅 I 摘 要 隨著計(jì)算機(jī)技術(shù)的發(fā)展和學(xué)校教學(xué)手段 的提高，計(jì)算機(jī)逐漸成為人們生活與學(xué)習(xí)的工具。由于考試作為評估各個(gè)學(xué)校教學(xué)質(zhì)量和學(xué)生能力的重要手段，建 立試題庫并且實(shí)施有效的管理便成了老師迫切希望解決的問題。本系統(tǒng)采用 ASP 等技術(shù)對 試題庫管理系統(tǒng) 的設(shè)計(jì)進(jìn)行了研究開發(fā)。采用 ADO 數(shù)據(jù)庫訪問技術(shù)對數(shù)據(jù)庫進(jìn)行連接和訪問。 本系統(tǒng)采用 ASP 作為開發(fā)平臺(tái)，以 access2021 作為后臺(tái)數(shù)據(jù)庫 ，整個(gè)系統(tǒng)層次結(jié)構(gòu)清晰 。 關(guān)鍵詞： Dreamweaver 試題庫 站點(diǎn)設(shè)計(jì) ASP Access II Abstract With the development of puter technology and the improvement of teaching standards, then puters increasingly bee convenient tools for life and studying. Because the examination is an important way to evaluate the quality of teaching ad students’ ability in all schools, then how to build and manage the test questions library bee an important thing for university teachers. The research objective in this paper is to realize the function of input management on the test questions library, which can make examination papers management more scientific and more efficient. The ASP technique is used to design and develop this test questions library management system. The background, purpose and significance of this system are first introduced in this paper, and then the needs analysis, general scheme and overall design of the system are also presented. Moreover, it introduces the running environment and the developing tools, such as ASP, Access and so on. This system adopts twolayer architecture. The ADO technique is used to connect and access the database. Two main functions of this software are realized as follows: test questions input and test questions query. The system uses ASP as a development platform, and uses the Access2021 to be the backend database. The entire system structure is simple and easy to understand. By testing, this system goes well, it is simple and effective, which can be put into practice. Key Words: Dreamweaver 。 The website design 。 Access III 目 錄 摘 要 ...................................................................................................................... I Abstract ................................................................................................................. II 第一章 緒論 ........................................................................................................ 1 試題庫錄入系統(tǒng)開發(fā)的背景 ......................................................................................... 1 試題庫錄入系統(tǒng)開發(fā)的目的和意義 ............................................................................. 1 試題庫錄入系統(tǒng)的研究現(xiàn)狀與發(fā)展 ............................................................................. 1 國外試題庫研究現(xiàn)狀 ......................................................................................... 2 國內(nèi)試題庫研究現(xiàn)狀 ......................................................................................... 2 試題庫錄入系統(tǒng)的發(fā)展趨勢 ............................................................................. 2 《數(shù)據(jù)庫原理》試題庫錄入系統(tǒng)研究的主要內(nèi)容 ..................................................... 3 《數(shù)據(jù)庫原理》試題庫錄入系統(tǒng)開發(fā)工具的選擇 ..................................................... 3 ASP 簡介 ........................................................................................................... 3 ACCESS 簡介 ................................................................................................... 5 小結(jié) ................................................................................................................................. 6 第二章 《數(shù)據(jù)庫原理》試題庫錄入系統(tǒng)設(shè)計(jì) ................................................. 7 系統(tǒng)需要分析 ................................................................................................................. 7 數(shù)據(jù)庫需求分析 ............................................................................................................. 8 信息需求 ............................................................................................................. 8 處理需求 ............................................................................................................. 8 數(shù)據(jù)庫設(shè)計(jì)原則 ............................................................................................................. 9 界面設(shè)計(jì) ......................................................................................................................... 9 小結(jié) ................................................................................................................................. 9 第三章 《數(shù)據(jù)庫原理》試題庫錄入系統(tǒng)實(shí)現(xiàn) ............................................... 10 數(shù)據(jù)庫設(shè)計(jì) ................................................................................................................... 10 管理員數(shù)據(jù)庫設(shè)計(jì) ........................................................................................... 10 普通用戶信息數(shù)據(jù)庫設(shè)計(jì) ............................................................................... 10 《數(shù)據(jù)庫原理》試題數(shù)據(jù)庫設(shè)計(jì) ................................................................... 11 IV 《數(shù)據(jù)庫原理》試題數(shù)據(jù)庫連接 ..................................................................... 11 用戶 登錄 功能 .............................................................................................................. 13 用戶管理功能 ............................................................................................................... 16 試題題目管理功能 ...................................................................................................... 18 試題查詢功能 .................................................................................