摘 要
本系统是经过实际的需求分析,采用PowerBuilder 9.0作为开发工具而开发出来的单机版和网络版相结合的图书馆信息管理系统。结合图书馆的要求,对浏览器/服务器知识、ADO通用编程接口、ASP知识、VBScript语言、SQL语言原理、PowerBuilder应用程序设计,SQL Server 2000数据库技术进行了较深入的学习和应用。主要完成对图书馆信息管理系统的需求分析、功能模块划分、数据库模式分析,并由此设计了数据库结构和应用程序。系统实现了图书和期刊的借阅、归还、挂失、查询和订购等功能。设计充分利用PowerBuilder 9.0、SQL Server 2000数据库技术的强大力量,提高了编程效率和可靠性。系统经过运行测试,取得了令人满意的效果。
关键字:图书馆管理系统,数据库,SQL语言原理, ADO通用编程接口
Abstract
This system is library management system which is united by the single-computer library management system and the network library management system and developed by PowerBuilder 9.0 according to the actual demand.Unifying the request of the library,I have thoroughly study and apply the knowlege about browser/server, ADO general programming connection,knowledge about ASP, VBScript language, the principle of SQL languag,PowerBuilder application programming and SQL Server 2000 database technologies.The library management system mainly completes the system demand analysis, the division of the function module and the database pattern analysis, and from this I designed the database structure and the application procedure. The system has realized the management function of book and magazine,for example,borrow,return, loss,inquiry,order and so on.The design fully uses PowerBuilder 9.0 which enhances the programming efficiency and reliability and SQL Server 2000 database technologies. The system has obtained the satisfying effect after the movement test.
Key words:library management system,database,the principle of SQL language,ADO general programming connection