毕 业 设 计 （ L 文 ）
题 目：图书馆管理系统
学生姓名
学 号
指导教师
所在学院
专业名称
班 级
摘 要
随着信息技术和网络技术的飞速发展，人类已进入全新信息化时代，传统管理技术
已无法高效，便捷地管理信息。为了迎合时代需求，优化管理效率，各种各样的管理系
统应运而生，各行各业相继进入信息管理时代，图书馆管理系统就是信息时代变革中的
产物之一。
任何系统都要遵循系统设计的基本流程，本系统也不例外，同样需要经过市场进行
调研，论文需求进行分析，概要设计，系统详细设计，测试和编码等步骤，设计并实现
了图书馆管理系统。系统选用 B/S 模式，应用 Python 技术， MySQL 为后台数据库。系
统主要包括首页，个人中心，用户管理，图书馆管理，图书信息管理，图书类型管理，
借阅信息管理，归还信息管理，续借信息管理，罚金信息管理，留言板管理，系统管理
等功能模块。
本文首先介绍了图书馆管理的技术发展背景与发展现状，然后遵循软件常规开发流
程，首先针对系统选取适用的语言和开发平台，根据需求分析制定模块并设计数据库结
构，再根据系统总体功能模块的设计绘制系统的功能模块图，流程图以及 E/R 图。然后，
设计框架并根据设计的框架编写代码以实现系统的各个功能模块。最后，对初步完成的
系统进行测试，对功能、单元和性能进行测试。测试结果表明，该系统能够实现所需的
功能，运行状况尚可并无明显缺点。
关键词：图书馆管理；Python 技术；MySQL 数据库
Abstract
With the rapid development of information technology and network technology, human
beings have entered a new information age, traditional management technology has been
unable to efficiently and conveniently manage information. In order to meet the needs of The
Times, optimize the management efficiency, a variety of management systems emerged, all
walks of life have entered the information management era, library management system is one
of the products in the information era change.
Any system must follow the basic process of system design, this system is no exception,
also need to go through market research, paper demand analysis, outline design, system
detailed design, testing and coding steps, design and implementation of the library
management system. The system uses B/S mode, using Python technology, MySQL as the
background database. The system mainly includes home page, personal center, user
management, library management, book information management, book type management,
borrowing information management, return information management, renewal information
management, fine information management, message board management, system
management and other functional modules.
This article first introduces the technical development background and current situation
of the development of library management, and then follow the routine software development
process, first of all, in view of the system and the selection of suitable language development
platform, based on demand analysis module and database structure design, and then based on
the system's overall function module design rendering system function module chart, flow
chart and the E/R diagram. Then, design the framework and write code according to the
designed framework to achieve each functional module of the system. Finally, the
preliminarily completed system is tested for functionality, unit and performance. The test
results show that the system can achieve the required functions, and the running condition is
fair and there is no obvious defect.
Key words: Library management; Python technology; The MySQL database
目录
1 绪论..............................................................................................................................1
1.1 课题背景..............................................................................................................1
1.2 课题研究现状......................................................................................................1
1.3 初步设计方法与实施方案..................................................................................2
1.4 本文研究内容......................................................................................................2
2 系统开发环境.........................................................................................................................4
2.1 PYTHON 简介 .....................................................................................................4
2.2MyEclipse 环境配置 .............................................................................................4
2.3 B/S 结构简介........................................................................................................4
2.4MySQL 数据库 .....................................................................................................5
2.5 DJANGO 框架......................................................................................................5
3 系统分析.................................................................................................................................6
3.1 系统可行性分析..................................................................................................6
3.1.1 经济可行性...............................................................................................6
3.1.2 技术可行性...............................................................................................6
3.1.3 运行可行性...............................................................................................6
3.2 系统现状分析......................................................................................................6
3.3 功能需求分析......................................................................................................7
3.4 系统设计规则与运行环境..................................................................................8
3.5 系统流程分析.......................................................................................................8
3.5.1 操作流程....................................................................................................8
3.5.2 添加信息流程............................................................................................9
3.5.3 删除信息流程..........................................................................................10
4 系统设计...............................................................................................................................11
4.1 系统设计主要功能............................................................................................11
4.2 数据库设计........................................................................................................11
4.2.1 数据库设计规范.....................................................................................11
4.2.2 E/R 图 ......................................................................................................11
4.2.3 数据表.....................................................................................................12
5 系统实现...............................................................................................................................21
5.1 系统功能模块.....................................................................................................21
5.2 后台功能模块.....................................................................................................23
5.2.1 管理员功能模块.....................................................................................23
5.2.2 用户功能模块.......................................................................................26
6 系统测试...............................................................................................................................29
6.1 功能测试............................................................................................................29
6.2 可用性测试........................................................................................................29
6.3 性能测试............................................................................................................30
6.4 测试结果分析....................................................................................................30
结 论.........................................................................................................................................31
参考文献...................................................................................................................................32
致 谢..............................................................................................................................33
