图书馆管理系统的设计与实现

ABSTRACT

With the rapid development of modern computer technology, the previous library management approach has failed to meet the requirements of the times, the use of computer information systems management book lending has become an inevitable trend in the development of modern library management. Library resources information makes daily teaching and research activities more extensive and convenient.

The traditional library management rely on manual, mainly by library management manual operations on efficiency, speed, and optional update information resources have been far from meeting the needs of today's teaching staff, the significance of this study lies in the use of existing computer technology to create a library management system to improve the efficiency and speed of library management information updates, and mine can choose the resources to deal with the library-related business more simple and easy to operate

Today, the increasing popularity of computers, the use of an effective management system to manage the books in the library, will be a lot of convenience. Ideological and theoretical basis of the specific characteristics of advanced information management systems and our library, we use B / S model design library management system, which caters to the current trends in software development, and significantly reduce maintenance and operating costs of the system-. This article describes the current situation and development trend of domestic and international library computer management information system, currently two main architectures (C / S and B / S) were analyzed and compared to a library / S's overall information management based on B proposal design of the system. In this article, the contents of a comprehensive analysis of library management, analysis and data modeling to arrive demand library management system, and ultimately with JSP development library information management system.

Keywords: library management；library management system； SQL server； database；management.

II

目 录

摘 要 ............................................................................................................................... I ABSTRACT ................................................................................................................. II 1 概述 ............................................................................................................................ 1

1.1开发背景 ............................................................................................................. 1 1.2开发意义 ............................................................................................................. 1 1.3主要完成内容 ..................................................................................................... 1

2 系统分析 ................................................................................................................... 3

2.1系统结构体系及模式介绍 ................................................................................. 3

2.1.1 C/S模式体系结构 ................................................................................... 3 2.1.2 B/S模式体系结构 ................................................................................... 4 2.1.3 C/S与B/S比较 ....................................................................................... 5 2.2需求分析 ............................................................................................................. 5

2.2.1功能需求 .................................................................................................. 5 2.2.2相关人员需求 .......................................................................................... 6

3 图书馆管理系统的设计与实现 ......................................................................... 8

3.1数据库概述 ......................................................................................................... 8 3.2系统总体结构 ..................................................................................................... 8 3.3创建数据库 ......................................................................................................... 8 3.4创建数据链表 ..................................................................................................... 9 3.5借阅者端子系统设计 ....................................................................................... 10 3.6管理员端子系统设计 ....................................................................................... 10

4 部分系统模块的设计与实现............................................................................ 12

4.1借阅人登录模块 ............................................................................................... 12 4.2书籍借阅模块 ................................................................................................... 13 4.3借阅者信息模块 ............................................................................................... 15

5 系统的应用分析及展望 ..................................................................................... 20 参考文献 ..................................................................................................................... 21 致谢 ............................................................................................................................... 22

III

1 概述

1.1开发背景

随着现代人们知识水平的提高，图书馆是日常生活中不可或缺的一部分。而图书馆拥有庞大的图书存数量和业务处理量，仅仅依靠传统的人工记账式管理方式管理图书馆是行不通的。因此图书管理系统的设计便十分必要，它成为信息提供给了学校或社会型图书馆的管理员，并且登记了馆内库存的详细情况以及对借书和了现代信息化建设不可缺少的组成部分。图书馆管理系统将所有借阅者的详细还书两大基本功能进行了合理的操作，由此可见，图书管理系统的设计是必然的。

1.2开发意义

该系统可以存储图书馆的图书信息、借阅者信息和图书借阅信息，相较于传统的管理方式来说这种管理方法更安全安全和高 效，并且在图书馆管理方面只需少数管理员即可操作系统，节省了大量人力输出，而图书管理系统还可以为借阅人提供充足的信息和快捷的查询手段，让其能够及时的查询到图书信息，更好地为读者服务。因此开发图书管理系统，是为了更好地适应现行图书管理工作的要求，提高图书馆管理工作的效率。

1.3主要完成内容

该系统主要需要完成以下功能：

1. 输入读者的基本信息：包括借阅证的编号、借阅者的姓名、借阅者的性别。 2. 查询和修改读者的基本信息：包括借阅者借书证编号、读者姓名、读者性别等。

3. 制定图书类别的标准、输入类别信息：包括类别编号、类别称。 4. 查询图书的类别信息、修改：包括类别名称、类别编号。

5. 输入书库书籍的存储信息：包括有书籍的类别、书籍的编号、作者的姓名、书籍的名称、出版社的名称、出版的日期和登记的日期等。

6. 查询和修改书库书籍的存储信息：包括书籍的编号、书籍的类别、作者的姓名、书籍的名称、出版社的名称、出版的日期和登记的日期等。 7. 输入借书信息：包括借阅者借阅证的编号、书籍的编号、借书的日期。

1

8. 查询和修改借书的信息：包括借阅证的编号、借阅者的编号、借阅者的姓名、书籍的编号、书籍的名称、借书的日期等。

9. 输入还书信息：包括借阅证的编号、书籍的编号、还书的日期。 10.查询和修改还书信息：包括还书借阅者借阅证的编号、借阅者的姓名、书籍的编号、书籍的名称、借书的日期、还书的日期等。

11.输入超期还书罚款：输入还书超出借阅期限的借阅者借书证号，书籍的编号和罚款的金额。

12.查询和删除超期还书罚款：包括借阅者借阅证的编号、借阅者的姓名、书籍的编号、书籍的名称，罚款的金额等

2