图书馆作为一种信息资源的集散地，图书和用户借阅资料繁多，包含很多的信息数据的管理，现今，有很多的图书馆都是初步开始使用，甚至尚未使用计算机进行信息管理。图书馆若采取手工方式对图书资料和图书借阅情况进行人工管理，由于资料繁多，手工处理的工作量大，整体管理效率低下，也不方便读者对图书资料的查阅。为了提高日常的图书管理效率，本文针对通常的图书管理流程，以C/S模式设计了一个图书管理系统，可满足大多数中小型的图书管理要求。

本文首先探讨了SQL语言接口和Delphi软件开发工具的技术特点以及结合SQL 和Delphi的数据库访问方法，在此基础上，利用Delphi 7 和 Access 2002实现了一个通用的图书管理系统。在本文的后半部分，给出了该系统的整个系统分析、设计以及实现的过程，包括需求分析、功能模块的分析与设计、数据模式的分析与设计，最后是系统的Delphi实现。

系统的运行结果表明，所设计的图书管理系统可以满足读者，图书馆工作人员，系统管理员三者的共同需求。

 

关键词：图书管理系统，Delphi 数据库应用，SQL语言

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Since volumes of book management activities have to take place daily in library, it will be a hard work and be low efficiency if only manual operations are adopted in the management. To upgrade their management efficiency, people would like to develop various Book Management Systems to help their daily work. In this paper a book management system built in Client/Server model is designed, which can meet requirements of most library management for its integration of general library transaction management processes.

SQL database access interface and Delphi RAD tool as well as the combination of the two are firstly discussed in the paper. In the latter part of the paper, the whole design of a general Book Management System built with Delphi 7 and Access 2002 is presented, including the system’s requirement analysis, function modules design, data model design and its Delphi implementation.

The running of the system proves that it could meet the common usage for various kinds of users including readers, library staffs and system administrators.

 

Keyword: Book Management System, Delphi database application, SQL language