微信小程序的图书馆预约系统设计与实现

摘 要
近年来随着社会竞争压力的不断加剧，人们需要不断充实自己的学识来提升自己的竞争力，对于在校的大学生而言需要利用在校期间实现考研考编的内容，职场的上班族需要通过考取职业技能资格证书来实现升职加薪，各行各业的人们都在利用有限的时间去提升和充实自己，因此图书馆成为了人们学习的提升的最佳场所。随着图书馆逐渐对外开放，图书馆安境的环境和浓厚的学习氛围吸引了大量的人，但是图书馆的座位资源是有限的，在考试旺季往往会出现一座难求的情况，图书馆排队和图书馆占座的情况时常发生，这样既耽误了学习的时间也影响了学习的状态。为了帮助缓解图书馆内自习室的接待压力，很多图书馆相继推出了在线服务平台，结合图书馆公告、图书馆座位使用状态等信息帮助人们了解到当前图书馆的现状，从而节约大量的排队及等位时间，也可以帮助优化管理学习计划提高学习效率。
考虑到用户使用的便捷性，此次图书馆预约系统的开发和设计主要基于微信小程序端来实现，利用Java语言以及Mysql数据库实现数据的动态呈现，借助微信小程序用户可以通过微信应用搜索对应的小程序名称，通过登录进入小程序平台后实现在线的图书馆公告查询、自习室信息查看、自习室在线预约等内容，同时对于图书馆的管理人员可以借助平台实现自习室信息的管理和维护，同时需要建立信用等级制度，对于没有按时退出的用户采取扣分机制，信用等级低于60分的无法实现在线的预约，通过线上平台的开通帮助进一步优化提升图书馆的精细化管理，也提高了人们的学习效率。

关键词：微信小程序，JAVA，Mysql数据库，图书馆预约系统；

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

目 录
摘 要 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
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