I摘要在人类文化的传承与发展中,书籍的作用功不可没,正如高尔基所言,书籍是人类进步的阶梯,随着知识的爆炸,读者日益增多,图书馆的出现满足了人们对知识的渴望,研究怎样高效的管理图书将是一个十分有意义的课题。通过对图书馆管理系统的运行管理机制进行调查研究,开发了此图书馆管理系统。本系统中实现了图书管理事务中的常用基本问题以及相关统计工作。本系统中包含9个功能模块:首页展示、系统设置、读者管理、图书管理、图书借还、系统查询、更改口令,读者模块、退出系统。我主要负责图书管理、读者管理、读者模块。本系统使用jsp进行网页界面的设计,使用MVC设计模式,它采用了当今软件设计的最新技术,具有开发效率高、设计灵活、生成的软件界面友好美观等特点。本系统中通过JDBC驱动和数据库进行无缝连接,后端的数据库SQLServer2008具有较高的完整性、一致性和安全性。关键词:图书馆管理SQLServer2008JSPServletIIAbstractOntheinheritanceanddevelopmentofhumancultureinthebookgoestotherole,asGorkysaid,booksarealadderofhumanprogress,withtheexplosionofknowledge,increasingreaders,librariesappearedsatisfiedthepeople'sdesireforknowledgeonhowefficientmanagementbookisaveryinterestingsubject.Byundertakingstudiesonoperationandmanagementmechanismoflibrarymanagementsystem,developedthislibrarymanagementsystem.Implementinglibrarymanagementsystemcommonlyusedinbasicandrelatedstatistics.Thissystemcontains9modules:Homeshowmanagement,librarymanagement,systemsettings,reader,bookborrowingandreturningsystemquery,changepassword,readermodules,exitthesystem.Iwasresponsibleforlibrarymanagement,usermanagement,usermodule.ThissystemusingJSPforWebinterfacedesign,usingtheMVCdesignpattern,itusestoday'ssoftwarehasbeendesignedwiththelatesttechnology,havehighdevelopmentefficiency,designflexibility,builduserfriendlyappearanceandothercharacteristicsofthesoftware.ThisseamlessconnectivitythroughadatabaseandJDBCdriverinyoursystem,theback-enddatabaseSQLServer2008havehighintegrity,consistency,andsecurity.Keywords:librarymanagementSQLServer2008JSPServletIII目录第1章绪论...........................................................................................................................11.1课题现状分析...........................................................................................................11.1.1图书管理的现状...........................................................................................11.1.2现有图书馆管理系统现状...........................................................................21.2选题的目的及意义..................................................................................................21.3课题研究的主要内容..............................................................................................3第2章系统开发工具及相关技术.......................................................................................42.1JSP技术....................................................................................................................42.2jsp开发相关技术.....................................................................................................42.3B/S结构....................................................................................................................5第3章系统分析...................................................................................................................73.1可行性分析..............................................................................................................73.2系统实现的目标......................................................................................................73.3系统功能分析..........................................................................................................73.4开发及运行的环......................................................................................................83.5设计模式分析..........................................................................................................8第4章系统设计...................................................................................................................94.1系统功能设计..........................................................................................................94.1.1总体功能设计...............................................................................................94.1.2系统设置模块设计.......................................................................................94.1.3读者管理模块设计.....................................................................................104.1.4图书管理模块设计.....................................................................................104.1.5图书借还模块设计.....................................................................................114.1.6系统查询模块设计.....................................................................................114.1.7读者模块设计.............................................................................................114.1.8更改口令模块设计.....................................................................................124.2系统数据库设计....................................................................................................124.2.1数据总体结构设计.....................................................................................124.2.2图书信息表结构设计.................................................................................134.2.3图书馆信息表结构设计.............................................................................144.2.4读者信息表结构设计.................................................................................15第5章界面设计.................................................................................