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

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開始語4
2.2開發(fā)工具4
2.3工作要點(diǎn)4
3.瀀湥鍣聞介4
3.1數(shù)據(jù)庫的發(fā)展4
3.1.1數(shù)據(jù)庫階段的特點(diǎn)4
3.2數(shù)據(jù)庫理論基礎(chǔ)5
3.2.1數(shù)據(jù)庫模型5
3.2.2數(shù)據(jù)庫體系結(jié)構(gòu)5
3.2.3數(shù)據(jù)的獨(dú)立性5
3.2.4范式6
4.瀀湥鍣^發(fā)軟件6
4.1 Delphi 7.0 簡介6
4.2 Delphi 7.0 控件6
4.2.1 ADO數(shù)據(jù)訪問組件6
4.2.2數(shù)據(jù)控制類DataControl6
4.2.3數(shù)據(jù)訪問類DataAccess6
4.2.4 SQL語言在Delphi中的應(yīng)用7
4.3Access 簡介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圖書入庫界面18
6.5讀者管理界面19
6.6借閱管理界面20
6.7查詢圖書、讀者、借閱基本信息21
7.結(jié)論22
8.致謝23
9.參考文獻(xiàn)24
10.附錄25