正文DOC格式共33頁(yè)

摘要： 數(shù)據(jù)庫(kù)技術(shù)是現(xiàn)代企業(yè)管理自動(dòng)化的重要而關(guān)鍵的環(huán)節(jié)，在日益信息化、辦公電腦化的今天發(fā)揮著越來(lái)越重要的地位。
本文介紹的學(xué)習(xí)成績(jī)查詢(xún)系統(tǒng)是計(jì)算機(jī)用于學(xué)校現(xiàn)代化管理，辦公自動(dòng)化和數(shù)據(jù)庫(kù)管理的系統(tǒng)。本文通過(guò)對(duì)學(xué)習(xí)成績(jī)查詢(xún)系統(tǒng)的分析與設(shè)計(jì)，介紹了該系統(tǒng)的設(shè)計(jì)方法和開(kāi)發(fā)的步驟及成果。
學(xué)習(xí)成績(jī)查詢(xún)系統(tǒng)是典型的信息管理系統(tǒng)(MIS),其開(kāi)發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前端應(yīng)用程序的開(kāi)發(fā)兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的庫(kù)。而對(duì)于后者則要求應(yīng)用程序功能完備,易使用等特點(diǎn)。本學(xué)生成績(jī)查詢(xún)系統(tǒng)前臺(tái)開(kāi)發(fā)工具選用了ASP,并結(jié)合HTML，后臺(tái)數(shù)據(jù)庫(kù)開(kāi)發(fā)采用Microsoft Access 2000。本文對(duì)學(xué)生成績(jī)查詢(xún)系統(tǒng)的開(kāi)發(fā)過(guò)程進(jìn)行了較為詳細(xì)的論述。對(duì)系統(tǒng)進(jìn)行了系統(tǒng)分析，明確了系統(tǒng)的可行行和客戶(hù)需求；對(duì)數(shù)據(jù)庫(kù)進(jìn)行了設(shè)計(jì)，論述了該系統(tǒng)數(shù)據(jù)庫(kù)的結(jié)構(gòu)和數(shù)據(jù)庫(kù)的完整性、安全性措施；根據(jù)模塊化原理，按照功能系統(tǒng)分為了二大功能模塊，并對(duì)各部分功能進(jìn)行了分析；采用結(jié)構(gòu)化設(shè)計(jì)的思想，最后對(duì)于本系統(tǒng)的測(cè)試和安裝進(jìn)行了分析。
關(guān)鍵詞：Acess 2000，ASP，HTML,數(shù)據(jù)庫(kù)。

Abstract: Database technique is link that the importance that the modern business enterprise manages the automation but key, at increasingly the information turn, transact the computerized developping the more and more important position today.
The introductive study in this text score search system is a system that calculator used for the school modernization manage, transacting the automation to manage with the database.This text passes the analysis to search the system to study score and design, introduced the design method of that system with step and results of the development.
Study score search system is development two aspects that typical information management system( MIS), its development includes primarily the backstage database establishes with support and the head applies the procedure.Establishes to rise to the former request the data consistency is strong with the complete, the database that data safety like.But request the latter very much the applied procedure function complete, easy usage etc. characteristics.This student the score search system stage development tool chose to use the Asp, combining combinative super text this marking language, backstage database development adoption Microsoft Access 2000.This text searches to student's score the process of development of the system proceeded the detailed treatise.Proceeded to the system the system analyze, clear and definite system can a line require with with the customer;Proceeded the design to the database, discuss the construction of the system's database with the complete, safety measure of the database;Turn the principle according to the mold piece, was divided into according to the function system two greatest functions mold piece, and proceeded the analysis to each parts of functions;Adoption the construction turns the thought of the design, finally test toward this system with installed to proceed the analysis.

Key words:Acess 2000, Asp, database.


目錄
摘要 1
Abstract 2
1．前 言 3
2．系統(tǒng)概述及開(kāi)發(fā)工具 4
2.1 項(xiàng)目的名稱(chēng) 4
2.2 系統(tǒng)開(kāi)發(fā)工具及運(yùn)行環(huán)境 4
2.2.1 Access 2000 簡(jiǎn)介 4
2.2.2 Asp 簡(jiǎn)介 4
3． 系統(tǒng)分析設(shè)計(jì) 5
3．1 需求分析 5
3．1．1 系統(tǒng)的功能需求 5
3．1．2 系統(tǒng)的性能需求 6
3．2 可行性分析 6
3．2．1技術(shù)可行性分析 6
3．2．2 經(jīng)濟(jì)可行性 6
3．2．3 操作可行性 6
3．3 系統(tǒng)的運(yùn)行需求 7
3．3．1 操作系統(tǒng) 7
3．3．2 Asp 服務(wù)器 7
3．4 系統(tǒng)的設(shè)計(jì)思想 7
4． 數(shù)據(jù)庫(kù)設(shè)計(jì) 9
4．1 數(shù)據(jù)庫(kù)的概念 9
4．1．1 數(shù)據(jù)庫(kù)的建立 9
4．1．2 數(shù)據(jù)庫(kù)之間的聯(lián)系 9
4．2數(shù)據(jù)通信接口 9
4．3 Database組件Ado 10
4．4 Asp訪問(wèn)數(shù)據(jù)庫(kù)的步驟 10
4．4．1定義數(shù)據(jù)源 10
4．4．2使用ADO組件查詢(xún)WEB數(shù)據(jù)庫(kù) 10
4．5 數(shù)據(jù)庫(kù)的設(shè)計(jì) 11
4．5．1 數(shù)據(jù)庫(kù)的完整性 11
5． 功能模塊設(shè)計(jì) 12
5．1 系統(tǒng)的總體功能 12
5．1．1 基本信息管理 12
5．1．2 按學(xué)生姓名查詢(xún) 13
5．1．3 按學(xué)號(hào)查詢(xún) 13
5．1．4 按畢業(yè)證號(hào)查詢(xún) 13
5．1．5 按學(xué)生證號(hào)查詢(xún) 14
5．1．6 按學(xué)院查詢(xún) 14
5．2 管理員登入窗口 14
5．2．1 管理員進(jìn)行維護(hù)的窗口 15
5．2．2 管理員進(jìn)行增加的窗口 16
5．2．3 管理員進(jìn)行修改的窗口 16
5．3功能模塊設(shè)計(jì) 17
5．3．1 系統(tǒng)化功能模塊 17
6． 詳細(xì)設(shè)計(jì) 19
6.1 程序設(shè)計(jì)思想 19
6.2 程序設(shè)計(jì)語(yǔ)言 19
6.3 學(xué)生學(xué)習(xí)成績(jī)查詢(xún)的設(shè)計(jì) 20
6．3．1 查詢(xún)模塊 20
6．3．2 學(xué)生姓名查詢(xún) 21
6．3．3 學(xué)號(hào)查詢(xún) 22
6．3．4 畢業(yè)證號(hào)查詢(xún) 22
6．3．5 學(xué)生證號(hào)查詢(xún) 22
6．3．6 學(xué)院查詢(xún) 22
6．3．7 管理員模塊 23
6．4數(shù)據(jù)庫(kù)設(shè)計(jì) 23
6．4．1學(xué)生總庫(kù)表 23
6．4．2 計(jì)算機(jī)學(xué)院學(xué)生庫(kù)表 23
6．4．3經(jīng)管學(xué)院學(xué)生庫(kù)表 24
6．4．4 社科學(xué)院學(xué)生庫(kù)表 24
6.5 程序的接口設(shè)計(jì) 25
6．5．1 設(shè)置數(shù)據(jù)庫(kù)的連接 25
6.6 程序主要代碼設(shè)計(jì) 26
6．6．1 信息錄入 26
6．6．2 信息查詢(xún) 26
6．6．3 信息修改 27
7．程序測(cè)試 28
7．1 軟件測(cè)試 28
8．謝 辭 29
參 考 文 獻(xiàn) 30