JINGGANGSHAN UNIVERSITY本科毕业论文（设计）题目基于JSP的学校图书馆管理系统的设计与实现学院电子与信息工程学院专业软件工程班级 2008 级软件工程本(1)班姓名学号 80914029指导教师起讫时间 2012.1—2012.5摘要二十一世纪是信息的社会，信息作为社会最主要的资源，将成为战略资源引起人们广泛的关注。

如何获取信息？图书是我们最好的获取信息的方式，但由于图书馆图书收藏量大大增加，使传统的图书管理员的工作日益繁重起来。

迫使人们起用新的管理方法来管理图书，如何把图书管理员从繁重的工作中解脱出来呢？图书馆管理系统是学校管理机制中的重要组成部分，通过对图书馆管理系统的运行管理机制进行调查研究，开发了此图书馆系统。

本系统中实现了学校图书管理事务中的常用基本问题以及相关统计工作。

本系统中包含6个功能模块：读书借阅，读者管理，图书管理，系统查询，系统设置和更改口令。

本系统使用jsp进行网页界面的设计，使用MVC设计模式，采用了开源框架Struts，它采用了当今软件设计的最新技术，具有开发效率高、设计灵活、生成的软件界面友好美观等特点。

本系统中通过JDBC驱动和数据库进行无缝连接，后端的数据库是MySQL，也是一个开源的数据库系统，该数据库具有较高的完整性，一致性和安全性。

关键词：图书馆管理MySQL JSP StrutsAbstract21 centuries is resources that information that society，social most in conduct and actions in information，will become the strategy resources cause the extensive concern in people.How to obtain the information?Books is work that the way that we obtain the information bestly，but collect and keep to have great capacity the big increment because of the library books，make traditional books' managing person increasingly heavy to get up.Forcing people rises to manage the books with the new management method，howing to set free out the books the managing person from the heavy work?The management system of the library takes an important role in the administration of school organization. I desigen the system after the thorough investigations about the library management system’s mechanism. This system contains with six functional modules: book borrowing，reader management，booksmanagement ，system query，system setting，and change the password.The system is contrived with Java Server Pages Techonolege as well as Struts，the software design mode of MVC with open source framework techonolege，which makes this system have the advantages of efficiently designed with beauteous and friendly interface . This system use jdbc driver to connect the mysql database server，which is also an open source database system for its users. The batabase was desigend with highly integrity，security，and consistency.Keyword: Library Management MySQL JSP Struts目录第1章绪论.................................................................................................................. - 1 -1.1.1图书管理的现状..................................................................................... - 1 -1.1.2现有图书馆管理系统现状..................................................................... - 2 -1.2 选题的目的及意义.......................................................................................... - 3 -1.3 课题研究的主要内容...................................................................................... - 3 - 第2章系统开发工具及相关技术.............................................................................. - 4 -2.1 JSP技术........................................................................................................... - 4 -2.2 JDBC.................................................................................................................. - 4 -2.3 Servlet............................................................................................................ - 5 -2.4 MySQL................................................................................................................ - 5 -2.5 TOMCAT.............................................................................................................. - 5 -2.6 MyEclipse........................................................................................................ - 5 -2.7 B/S结构........................................................................................................... - 6 -2.8 本章总结.......................................................................................................... - 6 - 第3章系统需求分析.................................................................................................. - 7 -3.1 可行性分析...................................................................................................... - 7 -3.1.1技术可行性............................................................................................. - 7 -3.1.2经济可行性............................................................................................. - 7 -3.2 系统实现的目标.............................................................................................. - 8 -3.3系统功能分析................................................................................................... - 8 -3.4系统流程图分析............................................................................................... - 8 -3.5 开发及运行的环境.......................................................................................... - 9 -3.5.1硬件环境................................................................................................. - 9 -3.5.2软件环境................................................................................................. - 9 -3.6设计模式分析................................................................................................. - 10 - 第4章系统设计........................................................................................................ - 11 -4.1 系统功能设计:.............................................................................................. - 11 -4.1.1总体功能设计....................................................................................... - 11 -4.1.2“图书借还”模块设计........................................................................ - 12 -4.1.3“读者管理”模块设计........................................................................ - 12 -4.1.4“图书管理”模块设计........................................................................ - 13 -4.1.5“系统查询”模块设计........................................................................ - 13 -4.1.6“系统设置”模块设计........................................................................ - 14 -4.1.7“更改口令”模块设计........................................................................ - 14 -4.1.8 其他功能设计...................................................................................... - 14 -4.2 系统数据库设计............................................................................................ - 14 -4.2.1数据总体结构设计............................................................................... - 14 -4.2.2图书信息表结构设计........................................................................... - 16 -4.2.3图书类型信息表结构设计................................................................... - 16 -4.2.4 读者信息表结构设计.......................................................................... - 17 -4.2.5读者类型信息表结构设计................................................................... - 17 -4.2.6图书借阅信息表结构设计................................................................... - 18 -4.2.7图书归还信息表结构设计................................................................... - 18 -4.2.8管理员信息表结构设计....................................................................... - 18 -4.2.9图书馆信息表结构设计....................................................................... - 19 -4.2.10书架信息表结构设计......................................................................... - 19 -4.2.11出版社信息表结构设计 ..................................................................... - 20 -4.2.12权限信息表结构设计......................................................................... - 20 - 第5章系统实现........................................................................................................ - 21 -5.1数据库操作类的实现..................................................................................... - 21 -5.2登录模块实现................................................................................................. - 23 -5.3图书馆主界面模块的实现............................................................................. - 24 -5.4图书借还功能模块的实现............................................................................. - 26 -5.5读者管理功能模块的实现............................................................................. - 30 -5.6图书管理功能模块的实现............................................................................. - 34 -5.7系统查询功能模块的实现............................................................................. - 39 -5.8系统管理功能模块的实现............................................................................. - 43 - 第六章软件测试........................................................................................................ - 48 -6.1 软件测试的方法与步骤................................................................................ - 48 -6.2 测试用例设计与测试用例的运行过程及测试结果分析............................ - 49 -6.2.1模块测试..................................................................................................... - 49 -6.2.2集成测试..................................................................................................... - 50 -6.2.3 验收测试.................................................................................................... - 51 -6.3 评价................................................................................................................ - 51 - 第七章总结................................................................................................................ - 52 - 致谢........................................................................................................................ - 53 - 参考文献........................................................................................................................ - 54 -第1章绪论随着计算机技术的发展以及计算机网络的逐渐普及，Internet 英特网成为人们查找信息的重要场所。