摘要
圖書管理系統(tǒng)是典型的信息管理系統(tǒng)(MIS),其開發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前端應(yīng)用程序的開發(fā)兩個(gè)方面。因此本人結(jié)合開入式圖書館的要求，對(duì)access、Delphi應(yīng)用程序設(shè)計(jì)，Delphi數(shù)據(jù)庫(kù)技術(shù)進(jìn)行了較深入的學(xué)習(xí)和應(yīng)用，主要完成對(duì)圖書管理系統(tǒng)的需求分析、功能模塊劃分、數(shù)據(jù)庫(kù)模式分析，并由此設(shè)計(jì)了數(shù)據(jù)庫(kù)結(jié)構(gòu)和應(yīng)用程序。系統(tǒng)運(yùn)行結(jié)果證明，此系統(tǒng)所設(shè)計(jì)的圖書管理系統(tǒng)可以滿足借閱者、圖書館工作人員和高級(jí)管理員三方面的需要。
系統(tǒng)進(jìn)行了具體的程序設(shè)計(jì)，具體劃分了三類用戶的操作權(quán)限，設(shè)計(jì)了了三個(gè)操作界面。實(shí)現(xiàn)了數(shù)據(jù)庫(kù)表的瀏覽，記錄的添加、刪除和修改，報(bào)表的生成，實(shí)現(xiàn)了多數(shù)據(jù)庫(kù)表的連接操作，實(shí)現(xiàn)了多條件查詢和模糊查詢，并靈活實(shí)現(xiàn)了對(duì)不可更新查詢結(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開始語(yǔ)4
2.2開發(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ù)控制類DataControl6
4.2.3數(shù)據(jù)訪問(wèn)類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)圖書管理界面17
6.4圖書入庫(kù)界面18
6.5讀者管理界面19
6.6借閱管理界面20
6.7查詢圖書、讀者、借閱基本信息21
7.結(jié)論22
8.致謝23
9.參考文獻(xiàn)24
10.附錄25