I摘要本文主要介绍图书借阅管理系统的开发过程,其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立数据一致性好、完整性强、安全性强的数据库,而对于后者则要求应用程序功能完备,界面友好等。在系统设计上,首先对图书借阅管理系统的现状及其重要性进行分析,提出实现图书借阅管理的必要性及系统的可行性。在短时间内建立系统应用原型,再对其进行需求迭代,不断修正和改进,直到形成用户满意的可行系统。系统实现的主要功能有查询、图书管理、用户管理、借书、还书、超期罚款等。图书借阅管理系统属于典型的管理信息系统(MIS)。前端采用C#语言开发程序,后台使用SQLServer2005数据库管理系统,系统的操作具有方便、快捷、准确、安全等特点。关键字:图书借阅管理系统;MIS;C#语言;SQLServerIIAbstractThispaperintroducesthebooklendingmanagementsystemdevelopmentprocess,itsdevelopmentincludestheestablishmentandmaintenanceofback-enddatabaseandfront-endapplicationdevelopmentaspects.Theestablishmentofthedatabaserequirementsfordataconsistencyisgood,strongintegrity,strongsafety,forthelatterapplication'srequirementsarefullyfunctional,user-friendlyandsoon.Thedesignsofthesystem,firstlendinglibrarymanagementsystemforanalysisofthestatusandimportanceofproposedmanagementrealizetheneedforborrowingbooksandsystemfeasibility.Theestablishmentofaprototypesystemapplicationinashorttime,thendemandforthemiterative,constantlyrevisedandimprovedcustomersatisfactionuntiltheformationofaviablesystem.Themainfunctionsofsystemimplementationarequeries,thebooksmanagement,usermanagement,borrowingbooks,returnsthebook,overduefines.Booklendingmanagementsystemisatypicalmanagementinformationsystem(MIS).Front-endwasdevelopedwithC#languagedevelopmentprogram,thebackgroundusingSQLServer2005databasemanagementsystem,thesystem'soperationisconvenient,fast,accurate,safeandsoon.Keywords:booklendingmanagementsystem;MIS;C#language;SQLServerI目录引言........................................................................................................................................11基础知识..............................................................................................................................21.1.NET简介..................................................................................................................21.2VisualC#.NET简介..................................................................................................21.3SQLServer2005数据库管理系统介绍...................................................................32系统分析..............................................................................................................................52.1开发背景及意义........................................................................................................52.2可行性研究................................................................................................................52.3功能需求....................................................................................................................62.3.1用例分析..........................................................................................................62.3.3实体关系设计..................................................................................................92.3.3行为描述........................................................................................................112.4环境需求..................................................................................................................122.4.1硬件环境........................................................................................................122.4.2软件环境........................................................................................................133系统设计............................................................................................................................143.1软件设计的原则......................................................................................................143.2系统功能模块图......................................................................................................143.3数据库设计..............................................................................................................163.3.1数据库概念设计............................................................................................163.3.2数据库逻辑设计............................................................................................163.4人机界面设计..........................................................................................................183.4.1人机界面设计指南........................................................................................183.4.2用户界面设计................................................................................................203.5系统详细设计..........................................................................................................213.5.1图书查询PAD图...........................................................................................223.5.2借书PAD图...................................................................................................233.5.3还书PAD图...................................................................................................23II4系统实现............................................................................................................................254.1语言选择原因..........................................................................................................254.2软件开发环境....