摘 要
在以信息技术为核心的时代，任何管理工作都离不开信息技术的帮助。如今的图书为了满足人们日益增长的精神文化需求，图书的种类和数量成倍的增加，图书的借阅工作日益频繁。因此，这就需要一个行之有效的图书管理系统来帮助图书馆工作人员更加方便、准确的管理图书的借阅工作。本系统的主要任务就是对图书、读者、借阅信息、查询进行统一管理，满足各类用户的需求。该系统的主要研究内容包括前台应用程序的开发以及后台数据库的建立和管理，对于前者要求应用程序功能的完备、易用。对于后者则要求建立数据的一致性和完整性。基于上述考虑，本系统是基于JAVA语言进行开发的，本系统利用Eclipse作为前端的应用开发工具，利用SQL Server 2005作为后台的数据库，通过对管理系统模块的研究，提出构造图书信息管理系统的方法，结合其它图书管理业务方面的常识，建立相关数据模型，利用面向对象开发工具对其进行设计与开发，使系统有良好的性能和较高的处理效率。
关键词：图书管理系统；数据库；面向对象
I
Abstract
In the era of information technology as the core, any management work rely heavily on information technology to help. Now, in order to satisfy the library spirit culture of people growing demand, the amount and type of books and books have multiplied the uses of the borrowing work increasingly frequent. Therefore, it needs to be an effective books management system management system to help the people who work in libraries is more convenient and accurate management work of the library borrowing. The system's main task is to readers, borrowing books, information query, unified management, and satisfy the needs of the users. This system includes main research and development foreground application of backstage supporter's database for the establishment and management of the application requirements, complete functions, easy-to-use, etc. For the latter requires establishing consistency and integrality of data based on the consideration, this system is based on a JAVA language development, this system using the Eclipse as front application development tool that uses SQL Server 2005 as a background, based on the database management system structure, puts forward the module of the library management information system, and by using the method of knowledge, combined with other books management business sense, establish relevant data model, using object-oriented development tool to design and development, make the system has good performance and high efficiency.
Key words: The books management system management system；Database；Object-oriented
II
目 录
摘要 ··········································································································· I Abstract ···································································································· II
第1章 绪论 ····························································································· 1
1.1 课题背景 ························································································ 1 1.2 国内外现状 ····················································································· 1 1.3 本系统的主要研究内容 ······································································ 1 1.4 本系统的主要特点 ············································································ 2 第2章 需求分析 ······················································································· 3
2.1 需求分析 ························································································ 3 2.2 系统目标 ························································································ 3 2.3 系统设计 ························································································ 3 2.3.1 系统的功能结构 ·········································································· 4 2.3.2 系统的执行流程图 ······································································· 5 第3章 系统的数据库设计 ··········································································· 6
3.1 数据库分析 ····················································································· 6 3.2 数据库需求分析 ··············································································· 7 3.3 数据库概念结构设计 ········································································· 7 3.3.1 图书信息实体·············································································· 8 3.3.2 读者信息实体·············································································· 8 3.3.3 图书借阅信息实体 ······································································· 8 3.3.4 图书分类实体·············································································· 9 3.3.5 图书订购实体·············································································· 9 3.3.6 操作员信息实体 ·········································································· 9 3.3.7 库存信息实体············································································· 10 3.4 数据库逻辑结构设计 ········································································ 10 第4章 系统的详细设计与测试 ···································································· 13
4.1 公共模块设计 ················································································· 13 4.1.1 数据库的链接及操作类的编写 ······················································· 13 4.1.2 MenuActions类的编写 ································································· 13 4.1.3 限制文本框长度类的编写 ····························································· 14
III
4.1.4 描述组合框索引与内容类的编写 ···················································· 15 4.1.5 在JLable上添加图片类的编写 ······················································· 15 4.2 主窗口的设计 ················································································· 15 4.2.1 主窗体概述 ················································································ 15 4.2.2 主窗体技术分析 ········································································· 16 4.2.3 主窗体的实现过程 ······································································ 17 4.3 系统登录模块设计 ··········································································· 17 4.3.1 系统登录模块概述 ······································································ 17 4.3.2 系统登录模块技术分析 ································································ 18 4.3.3 登陆模块实现过程 ······································································ 18 4.4 图书信息管理模块设计 ····································································· 19 4.4.1 图书信息管理模块概述 ································································ 19 4.4.2 图书信息管理模块技术分析 ·························································· 21 4.4.3 图书信息管理模块实现过程 ·························································· 21 4.4.4 单元测试 ··················································································· 22 4.5 图书借阅、归还模块设计 ·································································· 22 4.5.1 图书借阅、归还模块概述 ····························································· 22 4.5.2 图书借阅、归还模块技术分析 ······················································· 24 4.5.3 图书借阅、归还模块的实现过程 ···················································· 24 4.5.4 单元测试 ··················································································· 25 4.6 图书查询模块设计 ··········································································· 26 4.6.1 图书查询模块概述 ······································································ 26 4.6.2 图书查询模块技术分析 ································································ 26 4.6.3 图书查询模块实现过程 ································································ 27 4.7 格式化的文本框 ·············································································· 27 4.7.1 使用JFormattedTextField限制整数输入 ············································ 28 4.7.2 使用JFormattedTextField限制日期输入 ············································ 28 结论 ········································································································· 29 参考文献 ·································································································· 30 附录 ········································································································· 31 致谢 ········································································································· 41
IV