摘要
圖書(shū)管理系統(tǒng)是典型的信息管理系統(tǒng)(MIS),其開(kāi)發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前端應(yīng)用程序的開(kāi)發(fā)兩個(gè)方面。因此本人結(jié)合開(kāi)入式圖書(shū)館的要求，對(duì)access、Delphi應(yīng)用程序設(shè)計(jì)，Delphi數(shù)據(jù)庫(kù)技術(shù)進(jìn)行了較深入的學(xué)習(xí)和應(yīng)用，主要完成對(duì)圖書(shū)管理系統(tǒng)的需求分析、功能模塊劃分、數(shù)據(jù)庫(kù)模式分析，并由此設(shè)計(jì)了數(shù)據(jù)庫(kù)結(jié)構(gòu)和應(yīng)用程序。系統(tǒng)運(yùn)行結(jié)果證明，此系統(tǒng)所設(shè)計(jì)的圖書(shū)管理系統(tǒng)可以滿足借閱者、圖書(shū)館工作人員和高級(jí)管理員三方面的需要。
系統(tǒng)進(jìn)行了具體的程序設(shè)計(jì)，具體劃分了三類(lèi)用戶的操作權(quán)限，設(shè)計(jì)了了三個(gè)操作界面。實(shí)現(xiàn)了數(shù)據(jù)庫(kù)表的瀏覽，記錄的添加、刪除和修改，報(bào)表的生成，實(shí)現(xiàn)了多數(shù)據(jù)庫(kù)表的連接操作，實(shí)現(xiàn)了多條件查詢(xún)和模糊查詢(xún)，并靈活實(shí)現(xiàn)了對(duì)不可更新查詢(xún)結(jié)果集的更新操作，實(shí)現(xiàn)了主從表操作，實(shí)現(xiàn)了密碼維護(hù)功能，最后，系統(tǒng)還可以導(dǎo)入數(shù)據(jù)庫(kù)以對(duì)任意同結(jié)構(gòu)的數(shù)據(jù)庫(kù)進(jìn)行操作。設(shè)計(jì)充分利用Delphi 6、MS SQL Server2000數(shù)據(jù)庫(kù)技術(shù)的強(qiáng)大力量，提高了編程效率和可靠性。
關(guān)鍵字
數(shù)據(jù)庫(kù)，Delphi 7，數(shù)據(jù)庫(kù)組件，數(shù)據(jù)庫(kù)管理

Abstract
The book management system is the typical information management system( MIS), it mainly develop the establishment and maintenances and head application procedures of include the backstage databases develop two aspects.So oneself combine to open into the request of the type library, apply the program design to the access, Delphi, the Delphi database technique carried on the more thorough study and applications, mainly completing the need analysis, the function mold piece that manages the system to the book to divide the line, the database mode analysis, and designed the database structure and the application procedures from here.The system circulates the result certificate, the book that this text design management the system can satisfy to borrow to read, staff member and deluxe managing persons of library three demands of the aspects.
Key word
Database, Delphi 7, the database module, the database management

目錄
摘要1
Abstract2
1.引言3
2.前言4
2.1開(kāi)始語(yǔ)4
2.2開(kāi)發(fā)工具4
2.3工作要點(diǎn)4
3.瀀湥鍣聞介4
3.1數(shù)據(jù)庫(kù)的發(fā)展4
3.1.1數(shù)據(jù)庫(kù)階段的特點(diǎn)4
3.2數(shù)據(jù)庫(kù)理論基礎(chǔ)5
3.2.1數(shù)據(jù)庫(kù)模型5
3.2.2數(shù)據(jù)庫(kù)體系結(jié)構(gòu)5
3.2.3數(shù)據(jù)的獨(dú)立性5
3.2.4范式6
4.瀀湥鍣^發(fā)軟件6
4.1 Delphi 7.0 簡(jiǎn)介6
4.2 Delphi 7.0 控件6
4.2.1 ADO數(shù)據(jù)訪問(wèn)組件6
4.2.2數(shù)據(jù)控制類(lèi)DataControl6
4.2.3數(shù)據(jù)訪問(wèn)類(lèi)DataAccess6
4.2.4 SQL語(yǔ)言在Delphi中的應(yīng)用7
4.3Access 簡(jiǎn)介7
5.系統(tǒng)總體設(shè)計(jì)8
5.1系統(tǒng)需求分析8
5.2系統(tǒng)概要設(shè)計(jì)11
6.系統(tǒng)應(yīng)用程序設(shè)計(jì)16
6.1程序系統(tǒng)結(jié)構(gòu)16
6.2系統(tǒng)主界面17
6.3系統(tǒng)圖書(shū)管理界面17
6.4圖書(shū)入庫(kù)界面18
6.5讀者管理界面19
6.6借閱管理界面20
6.7查詢(xún)圖書(shū)、讀者、借閱基本信息21
7.結(jié)論22
8.致謝23
9.參考文獻(xiàn)24
10.附錄25