题 目：陕理工图书馆管理系统的设计
与实现
摘要
随着互联网技术的发发展，计算机技术广泛应用在人们的生活中，逐渐成
为日常工作、生活不可或缺的工具，高校各种管理系统层出不穷。高校作为学
习知识和技术的高等学府，信息技术更加的成熟，为高校图书馆借阅开发必要
的系统，能够有效的提升管理效率。一直以来，高校图书馆一直没有进行系统
化的管理，学生无法准确掌握高校图书馆图书状态，由此提出开发陕理工图书
馆管理系统，管理图书馆信息，学生可以在线查询书籍状态，进行借阅和座位
预约，节省时间，提高学习效率。
本文介绍了使用 Java 技术开发陕理工图书馆管理系统的设计与实现过程，
首先对实现该系统的技术进行分析，说明选择 Java 和 MySQL 数据库的必要性，
然后对陕理工图书馆管理系统的需求进行分析，并接着对系统进行设计，包括架
构设计、功能设计、数据库设计。最后进行了系统实现。针对系统用户权限问题
进行了设计，在前台界面为提升用户体验，使用 Jquery、Ajax、CSS 等技术进行
布局。陕理工图书馆管理系统上线后，反应良好，达到了所有的需求目的，完善
了高校图书馆教务工作，为高校发展具有一定的实际价值。
关键词 ：JAVA；MYSQL；借阅图书；座位预约；图书推荐
Abstract
With the development of Internet technology, computer technology is widely used
in people's life and has gradually become an indispensable tool for daily work and life.
Various management systems in Colleges and universities emerge one after another. As
an institution of higher learning to learn knowledge and technology, information
technology is more mature. Developing the necessary system for university library
borrowing can effectively improve the management efficiency. For a long time, the
university library has not carried out systematic management, and students can not
accurately grasp the book status of the university library. Therefore, it is proposed to
develop the Shaanxi science and technology library management system to manage the
library information. Students can query the book status online, borrow and reserve seats,
so as to save time and improve learning efficiency.
This paper introduces the design and implementation process of developing
Shaanxi science and technology library management system using Java technology.
Firstly, it analyzes the technology of realizing the system, explains the necessity of
selecting Java and MySQL database, then analyzes the requirements of Shaanxi science
and technology library management system, and then designs the system, including
architecture design, function design and database design. Finally, the system is
implemented. The system user authority is designed. In order to improve the user
experience, jQuery, AJAX, CSS and other technologies are used for layout in the
foreground interface. After the Shaanxi science and technology library management
system went online, it responded well, achieved all the needs and objectives, improved
the educational administration work of university library, and had a certain practical
value for the development of colleges and universities.
Key words: Java; Java; MYSQL;Borrow books; Seat reservation; Book
recommendation
目 录
摘要 ..........................................................................................................................................2
ABSTRACT .................................................................................................................................3
第 1 章 绪论..........................................................................................................................6
1.1 课题背景 .........................................................................................................................6
1.2 研究现状 ...............................................................................................................................6
1.3 研究意义 ...............................................................................................................................7
1.4 本文研究内容 .......................................................................................................................8
第 2 章 系统分析 ..................................................................................................................9
2.1 相关技术 .........................................................................................................................9
2.1.1 JAVA
技术
....................................................................................................................9
2.1.2 Web
开发技术
.............................................................................................................9
2.1.3 Mysql
数据库
..............................................................................................................9
2.1.4
系统框架
...............................................................................................................10
2.2 系统的需求分析 ...........................................................................................................11
2.3 系统用例分析 ...............................................................................................................11
2.3.1
会员用例分析
.......................................................................................................11
2.3.2
管理员用例分析
...................................................................................................12
第 3 章 系统设计 ................................................................................................................14
3.1 系统体系结构设计 .......................................................................................................14
3.2 系统功能模块设计 .......................................................................................................14
3.3 数据库设计 ...................................................................................................................15
3.3.1
数据库设计原则
...................................................................................................15
3.3.2
数据库逻辑设计
...................................................................................................15
3.3.3
数据库表结构设计
...............................................................................................16
3.4 程序流程图 ...................................................................................................................23
第 4 章 系统实现 ................................................................................................................26
4.1 前台实现 ............................................................................................................................26
4.1.1 网站首页
....................................................................................................................26
4.1.2 图书展示
.....................................................................................................................26
4.1.3 座位信息展示
.............................................................................................................27
4.1.4 网站公告信息
.............................................................................................................28
4.2.5 个人中心
.....................................................................................................................29
4.2 后台实现 ............................................................................................................................30
4.2.1 管理员登录
.................................................................................................................30
4.2.2 图书管理的实现
.........................................................................................................31
4.2.3 用户管理的实现
.........................................................................................................32
4.2.4 借阅管理的实现
.........................................................................................................34
第 5 章 系统测试 ................................................................................................................35
5.1 测试目的和原则 ...........................................................................................................35
5.2 功能测试 .......................................................................................................................35
5.3 测试结果及结论 ...........................................................................................................36
第 6 章 结论 ........................................................................................................................38
参考文献.................................................................................................................................39
致谢 ........................................................................................................................................41
