摘   要

 

图书管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。

因此本人结合开入式图书馆的要求，对MS SQL Server2000数据库管理系统、SQL语言原理、Visual Basic 应用程序设计，Visual Basic 数据库(Access)技术进行了较深入的学习和应用，主要完成对图书管理系统的需求分析、功能模块划分、数据库模式分析，并由此设计了数据库结构和应用程序。系统运行结果证明，本文所设计的图书管理系统可以满足借阅者、图书馆工作人员和高级管理员三方面的需要。

设计充分利用Visual Basic  6、MS SQL Server2000数据库技术的强大力量，提高了编程效率和可靠性。

关键词：数据库   access  Visual Basic6.0  图书管理   窗体

Summary : The books administrative system is typical informations managements ~s systems(MIS), it develops main two respects of development including setting-up and maintenance and front application program of backstage supporter's database . Demand to set up the consistency of the data and integrality the storehouse of strong , data with good security to the former. Require to the latter that the function of the application program is complete , apt characteristic of using etc. . So combine and make the request of the entering type library in person, to MS SQL Server2000 data base management system, SQL language principle , Visual Basic use and design program, Visual Basic database technology has carried on the deeper study and application, finish demand analysis , function module dividing , database mode analysis to the books administrative system mainly, and has designed structure of the database and application program from this. The systematic operation result is proved, the books administrative system designed of this text can meet the needs of three respects of persons who borrow , library staff member and senior administrator . Design and fully utilize Visual Basic 6 , strong strength of MS SQL Server2000 database technology , has improved programming efficiency and dependability .