学 士 学 位 论 文
基于微信小程序的图书馆预约系统
学院名称：
专业班级：
用户姓名：
学 号：
指导员工：
完成日期： 年 月 日
I
摘 要
近年来随着社会竞争压力的不断加剧，人们需要不断充实自己的学识来提升自己的
竞争力，对于在校的大学生而言需要利用在校期间实现考研考编的内容，职场的上班族
需要通过考取职业技能资格证书来实现升职加薪，各行各业的人们都在利用有限的时间
去提升和充实自己，因此图书馆成为了人们学习的提升的最佳场所。随着图书馆逐渐对
外开放，图书馆安境的环境和浓厚的学习氛围吸引了大量的人，但是图书馆的座位资源
是有限的，在考试旺季往往会出现一座难求的情况，图书馆排队和图书馆占座的情况时
常发生，这样既耽误了学习的时间也影响了学习的状态。为了帮助缓解图书馆内自习室
的接待压力，很多图书馆相继推出了在线服务平台，结合图书馆公告、图书馆座位使用
状态等信息帮助人们了解到当前图书馆的现状，从而节约大量的排队及等位时间，也可
以帮助优化管理学习计划提高学习效率。
考虑到用户使用的便捷性，此次图书馆预约系统的开发和设计主要基于微信小程序
端来实现，利用 Java 语言以及 Mysql 数据库实现数据的动态呈现，借助微信小程序用户
可以通过微信应用搜索对应的小程序名称，通过登录进入小程序平台后实现在线的图书
馆公告查询、自习室信息查看、自习室在线预约等内容，同时对于图书馆的管理人员可
以借助平台实现自习室信息的管理和维护，同时需要建立信用等级制度，对于没有按时
退出的用户采取扣分机制，信用等级低于 60 分的无法实现在线的预约，通过线上平台
的开通帮助进一步优化提升图书馆的精细化管理，也提高了人们的学习效率。
关键词：微信小程序，JAVA，Mysql 数据库，图书馆预约系统
II
Abstract
In recent years, with the increasing pressure of social competition, people need to constantly
enrich their knowledge to improve their competitiveness. For college students, they need to
use the content of the postgraduate entrance examination in school. Workers in the workplace
need to achieve promotion and salary increase by taking vocational skill qualification
certificates. People in all walks of life are using limited time to improve and enrich
themselves, Therefore, the library has become the best place for people to learn. With the
gradual opening of the library to the outside world, the safe environment and strong learning
atmosphere of the library have attracted a large number of people. However, the seating
resources of the library are limited. In the peak examination season, it is often difficult to find
a seat. The situation of the library queuing and the library occupying seats often occurs, which
not only delays the learning time but also affects the learning state. In order to help alleviate
the reception pressure of the study room in the library, many libraries have launched online
service platforms to help people understand the current situation of the library in combination
with library announcements, library seat use status and other information, thus saving a lot of
queuing and waiting time, and also helping to optimize the management of learning plans and
improve learning efficiency.
Considering the convenience of users, the development and design of the library
reservation system is mainly based on the WeChat applet. Java language and MySQL
database are used to realize the dynamic presentation of data. With the help of WeChat applet,
users can search the corresponding applet name through WeChat application. After logging
into the applet platform, online library announcement query, self-study room information
viewing At the same time, library managers can use the platform to manage and maintain the
information in the study room. At the same time, a credit rating system needs to be
established. For users who fail to exit on time, a point deduction mechanism is adopted. If the
credit rating is lower than 60, online reservations cannot be made. The opening of the online
platform helps further optimize and improve the refined management of the library, and also
improves people's learning efficiency.
Keywords: WeChat applet, JAVA, Mysql database, library reservation system
III
目 录
摘 要...................................................................................................................I
Abstract................................................................................................................II
目 录.................................................................................................................III
第一章 绪论........................................................................................................1
1.1 开发背景 ....................................................................................................................1
1.2 当前发展状况 .............................................................................................................1
1.3 研究的意义 .................................................................................................................2
1.4 开发工具及技术 .........................................................................................................2
1.4.1 微信小程序工具.....................................................................................................2
1.4.2 Mysql 数据库 ........................................................................................................2
1.4.3 Java 技术 ..............................................................................................................2
第二章 需求分析................................................................................................3
2.1 需求调研 .....................................................................................................................3
2.2 可行性分析 .................................................................................................................3
2.2.1 技术的可行性 ..........................................................................................................3
2.2.2 经济的可行性 ..........................................................................................................3
2.2.3 操作可行性 ..............................................................................................................4
2.3 用户用例图 .................................................................................................................4
2.3.1 管理员用例图 ..................................................................................................4
2.3.2 用户用例图 ......................................................................................................4
2.3.3 员工用例图 ......................................................................................................5
2.4 功能模块需求分析 .....................................................................................................5
第三章 数据库设计 ............................................................................................6
3.1 数据库的分析与设计 .................................................................................................6
3.1.1 数据库的概念结构设计...................................................................................6
IV
3.1.2 数据表的逻辑结构设计...................................................................................7
第四章 网站功能实现 ........................................................................................8
4.1 系统后台主页 ............................................................................................................8
4.2 自习室类别管理 .........................................................................................................8
4.3 自习室信息管理 .........................................................................................................9
4.4 会员信息管理 .............................................................................................................9
4.5 小程序首页界面 .......................................................................................................10
4.6 小程序预约界面 .......................................................................................................10
第五章 系统测试..............................................................................................11
5.1 系统测试的意义 ......................................................................................................11
5.3 系统测试的内容 ......................................................................................................11
5.4 系统测试结果 ...........................................................................................................11
总结....................................................................................................................12
致 谢..................................................................................................................13
参考文献............................................................................................................14
