- 1 -
图书馆书库管理系统
摘要
毕业设计（论文）是考核应考者综合运用所学基础理论和专业技能，独立分析和
解决实际问题的能力。计算机应用专业培养从事计算机软件和硬件设计，开发和应用的
高层次人才,检测考生是否阅读了必要的中外文献，能否运用科技合理的定性和定量分
析，来设计和实现设计系统。
图书馆书库管理系统主要是完成图书管理员对图书的管理（增加新书，删除旧书，
并修改等的图书编辑）；图书管理员对读者借还书的统计（图书的在库数目和还日期的
统计）和管理；读者和管理员对图书信息和读者信息的查询；当查到所需信息时，打印
出相应的信息报表等工作。
在图书馆书库管理系统的设计与实现过程中，我深深体会到此次毕业设计的重要
性------它是我走上工作岗位前的一次重要的练习，更深刻体会到理论联系实践的重要
性和必要性。同时,我也感受到 JAVA 和 SQL SERVER 2000 的功能之强大，事件处理的灵
活性和高效性。但我掌握和应用的还不是很熟练，应多加实践和练习，在以后的工作中，
我将不断的学习和充实自己，力争成为一个高水平的程序员。
关键字：Java Swing； SQL Server 2000；图书馆管理；图书馆
图书馆书库管理系统
- 2 -
Management System of Books
ABSTRACT
Graduation project examines students for the abilities of synthetically using professional
knowledge, analyzing and solving practical problems. The computer Applying major aims to
train high-level technical personnel on designing, developing and applying about hardware
and software. It also examines whether or not the students have read necessary Chinese or
foreign references, and whether or not they can reasonably analyze ,design and achieve the
system .
The Administrative System of Books’ has three functions, they are: books managed by
books managers (adding new books, deleting old books , modifying book records and so
on ),managing and counting readers’ borrowing and returning by books managers, searching
for books information and readers information by both books managers and readers. When the
needed information is searched, you can print it.
In the process of designing and achieving this system, I deeply know the importance of
the graduation project, it’s only a practice before we go to work. I also know the importance
and necessity of integrating theory with practice. Both JAVA and SQL SERVER 2000 have
very strong functions, flexible and efficient. But I don’t know and apply them well, I will take
more practice and learn more to handle them very skillfully, to be a qualified and high-level
programmer.
Keywords:Java Swing； SQL Server 2000；Management System of Books；Library
- 3 -
目录
第一章 绪论 ....................................................................................................................................................5
第二章 用户需求说明书 ................................................................................................................................6
2.1 文档的介绍 .......................................................................................................................................6
2.1.1 文档的目的 ...........................................................................................................................6
2.1.2 文档的范围 ...........................................................................................................................6
2.1.3 读者对象 ...............................................................................................................................6
2.2 产品介绍 ...........................................................................................................................................6
2.3 产品面向的用户群体 .......................................................................................................................7
2.4 产品应当遵循的标准和规范。 .......................................................................................................7
2.5 产品的功能性需求 ...........................................................................................................................7
2.5.1 功能性需求分类 ...................................................................................................................7
2.5.2 特点 ......................................................................................................................................7
2.6 产品的非功能性需求 .......................................................................................................................8
2.6.1 用户界面需求 .......................................................................................................................8
2.6.2 软硬环境要求 .......................................................................................................................8
2.6.3 产品质量需求 .......................................................................................................................8
第三章 体系结构设计 ....................................................................................................................................9
3.1 介绍文档 ...........................................................................................................................................9
3.1.1 文档目的 ...............................................................................................................................9
3.1.2 文档范围 ...............................................................................................................................9
3.1.3 读者对象 ...............................................................................................................................9
3.2 系统概述 ...........................................................................................................................................9
3.3 设计约束 .........................................................................................................................................10
3.4 设计策略 .........................................................................................................................................10
3.5 系统总体结构 .................................................................................................................................11
3.6 子系统的结构功能 .........................................................................................................................12
3.7 开发环境的配置 .............................................................................................................................19
3.8 运行环境的配置 .............................................................................................................................19
第四章 数据库设计 ......................................................................................................................................20
4.1 文档介绍 .........................................................................................................................................20
4.1.1 文档目的 .............................................................................................................................20
4.1.2 文档范围 .............................................................................................................................20
4.1.3 读者对象 .............................................................................................................................20
4.2 数据库环境说明 .............................................................................................................................20
4.3 数据库的命名规则 .........................................................................................................................21
4.4 逻辑设计 .........................................................................................................................................22
4.5 物理设计 .........................................................................................................................................22
4.5.1 表总汇 .................................................................................................................................22
4.5.2 领书订单表 .........................................................................................................................23
4.5.3 借书记录表 .........................................................................................................................23
4.5.4 书籍信息表 .........................................................................................................................23
4.5.5 会员表 .................................................................................................................................24
图书馆书库管理系统
- 4 -
4.5.6 书籍记录表 .........................................................................................................................24
4.6 安全性设计 .....................................................................................................................................24
4.6.1 防止用户直接操作数据库的方法 .....................................................................................25
4.6.2 角色与权限 .........................................................................................................................25
4.7 数据库管理与维护说明 .................................................................................................................25
第五章 用户界面设计 ..................................................................................................................................26
5.1 文档介绍 .........................................................................................................................................26
5.1.1 文档目的 .............................................................................................................................26
5.1.2 文档范围 .............................................................................................................................26
5.1.3 读者对象 .............................................................................................................................26
5.2 应当遵循的界面设计规范 .............................................................................................................26
5.3 界面的图形 .....................................................................................................................................26
5.4 主界面 .............................................................................................................................................27
5.5 采购管理系统界面 .......................................................................................................................27
5.6 流通系统界面 .................................................................................................................................28
5.7 查询系统界面 .................................................................................................................................28
5.8 编目系统界面 .................................................................................................................................29
第六章 模块设计 ..........................................................................................................................................30
6.1 文档介绍 .........................................................................................................................................30
6.1.1 文档目的 .............................................................................................................................30
6.1.2 文档范围 .............................................................................................................................30
6.1.3 读者对象 .............................................................................................................................30
6.2 模块命名规则 .................................................................................................................................30
6.3 模块总汇 .........................................................................................................................................30
6.3.1 模块总汇表 .........................................................................................................................30
6.3.2 模块关系图 .........................................................................................................................31
6.4 模块设计 .........................................................................................................................................32
6.4.1 采购管理系统的模块设计 .................................................................................................32
6.4.2 流通管理系统的模块设计 .................................................................................................32
6.4.3 查询系统的模块设计 .........................................................................................................33
6.4.4 编目系统的模块设计 .........................................................................................................34
第七章 软件测试 ..........................................................................................................................................35
7.1 软件测试的目标 .............................................................................................................................35
7．2 软件测试准则 ...............................................................................................................................35
7．3 测试方法 .......................................................................................................................................35
7．4 测试步骤 .......................................................................................................................................35
7.5 接口测试用 .....................................................................................................................................35
第八章 结论 ..................................................................................................................................................37
致谢 ................................................................................................................................................................38
参考文献 ........................................................................................................................................................39
附录Ａ 安装说明 ........................................................................................................................................40
附录 A ............................................................................................................................................................41
- 5 -
第一章 绪论
信息化校园建设是高等学校建设的重要部分，是一项基础性、长期性和经常性的工
作，其建设水平是高校整体办学水平、学校形象和地位的重要标志。信息技术的发展可
谓日新月异，然而它在教育教学上的应用却比较滞后。近几年，各校的校园信息化建设
都在如火如荼地进行着，“校园信息化管理”被提的很多，但就目前全国高校的总体情
况来看，大多仍处于试验性阶段，我们仍然在摸索怎样才能更有效地让这些信息技术手
段为教育教学服务。大学相对中小学而言，拥有更多更专业的人才，掌握着更多的技术
和信息，有更活跃的思维，理应在这条路上走在前端。如何将信息化技术引入到现代实
验室管理中来，已是摆在我们每一个面前的课题。
作为在图书馆信息化管理方面的探索，我们选择了“图书馆信息系统”的开发作为
自己的毕业设计课题。通过这篇毕业论文，我将对这段时间的设计开发工作做一回顾。
该系统基本满足了用户（学校）在图书管理方面的需求，用户界面友好。系统对用户数
据有效地实现了信息电子化处理，从而降低了人工劳动并增加的信息的准确性。
