Design and implementation of library management system based on WeChat applet (paper + program design source code + database file)

Abstract 4
Abstract 6
1 Foreword 7
1.1 The purpose and significance of this design 7
1.2 Overview of domestic and foreign development 7
1.3 The main content of this design 8
2 Related technology introduction and system environment development conditions 9
2.1 Related technology introduction 9
2.2 System environment development conditions 10
3 System requirements analysis and design 11
3.1 Feasibility analysis 11
3.2 Requirements analysis 12
3.2.1 System overview 12
3.2.2 Functional requirements 13
3.2.3 Non-functional requirements 14
3.2.4 Flow chart design 14
3.2.5 System ER Figure Design 16
3.3 Database Design 16
3.3.1 Principles of Database Design 16
3.3.2 Design of Database Table 17
4 Realization of System Function Module 18
4.1 Realization of Front-end Page Function 19
4.1.1 Realization of Landing Page 19
4.1.2 Realization of Book Page 21
4.1.3 The realization of the seat page 21
4.2 The realization of the back-end page function 22
4.2.1 The realization of the landing page 22
4.2.2 The realization of the user management page 24
4.2.3 The realization of the book classification management page 25
4.2.4 The realization of the book management page Implementation 26
4.2.5 Implementation of the seat management page 27

4.3 Log Function Module 29
4.4 Installation and Deployment 30
5 System Test 31
5.1 Purpose and Significance of System Debugging 31
5.2 Function Test Cases 32
6 Summary 33
References: 34
Acknowledgements 35
Abstract
In today’s society, the Internet has begun to become the mainstream of the times. With the vigorous development of 4G and 5G technologies, people's lives are increasingly dependent on network technology. Internet mobile services have also emerged at the historic moment. Its emergence has rapidly redefined the way people obtain information and services, relying on mobile phones to cross regions and dates, and help people in the most efficient way. At the same time, as one of the main practice places of mobile service technology, the library is also an indispensable existence for universities. A large number of students come to borrow books and conduct self-study every day, in order to help students and administrators improve efficiency and reduce students’ There is a conflict between book borrowing and seat occupancy, so the Internet mobile service and library are combined to create a library management system based on WeChat applets.
WeChat Mini Program is the most popular, convenient and cutting-edge mobile service method. The development of WeChat Mini Program uses WeChat developer tools to design and develop library management Mini Programs, and realizes book borrowing management, message management, and book management. Library seat management, reservation occupancy and other functions help students effectively reduce the time for selecting and borrowing books, and can provide immediate feedback to the library. When library seats and resources need to be occupied, it is also better to reduce Seat resources are wasted and the time of premature seat occupation is saved.

Keywords: WeChat applet; university library; user needs

The design and implementation of library management system based on WeChat program
Abstract
In today's society, the Internet has begun to become the mainstream of the times, with the rapid development of 4G, 5G and other technologies, people's lives are more and more dependent on network technology. Internet mobile services have also emerged, and their emergence has rapidly redefined the way people access information and services, relying on mobile phones alone to help people across regions and dates in the most efficient way. At the same time, as one of the main practical places of mobile service technology, library is also an indispensable existence of the university, every day a large number of students come to borrow books and self-study, in order to help students and administrators improve efficiency, reduce students because of book lending and seating and conflicts,so the Internet mobile services and libraries combined to produce a library management system based on WeChat small programs.
WeChat small program is the most popular, convenient and cutting-edge mobile service, WeChat small program development using WeChat developer tools, design and development of library management small program, and realize the book lending management, message management, library seat management, reservation seating and other functions, to help students effectively reduce the time to select and borrow books, and can provide immediate feedback on the library, when the need to occupy the library seat and resources, but also better reduce the waste of space, and save time on early seating...

Key words: WeChat mini-program; University libraries; User requirements


Table of Contents 1 Preface
1.1 The purpose and significance of this design
In the torrent of the Renaissance, the philosopher Francis Bacon once said: "Books are ships of thought that sail in the waves of the times. They carefully transport precious goods to generations. One generation." The library is a fleet of wisdom, carrying the wisdom of generations of wise men, traveling through the torrent of time, and gifting precious goods to the next generation. As early as 3000 AD, the ancestors of wisdom realized the importance of knowledge that needs to be passed on. They carved their own thinking about life on the clay board, and the younger generations carefully collected the books in the Mesopotamian plains. In this place, the world’s first library appeared. It has survived the polishing of time and the erosion of war, with a full body of stories depicting the colorful past from the ancient and beautiful kingdom to us today. . Nowadays, every city and every university has built large and small libraries to continue the inheritance of wisdom, and they will also set sail with our thoughts and thoughts to the other side of the future.
With the continuous development of the Internet, the number of Internet users in my country who use mobile phones to access the Internet accounts for 99.3% of the total number of Internet users [1]. After the rapid popularization of modern smart phones, the way people communicate and read has gradually changed. On January 21, 2011, WeChat turned out to be popularized rapidly in just a few years, completely changing people’s lives and entering thousands of people. Wanjia, it seems that overnight, people across the country began to use WeChat to communicate, and soon six years later, on January 9, 2017, the first batch of much-anticipated WeChat applets were officially launched in a low-key manner, which is also for the future of light applications. Popularization has taken the first step. The WeChat Mini Program is backed by the huge traffic portal of WeChat and the resource support plan released in 2019. So far, the daily activity has exceeded 330 million [2].
In many universities across the country, due to the lack of dedicated student study rooms, and because students have many tasks on weekdays, they cannot concentrate on studying in the dormitory. Therefore, many students choose to go to the library for self-study. Therefore, university libraries are faced with "more people and fewer seats." "The embarrassing management problem has also caused many students to occupy their seats. In order to occupy the seats, they even had to line up at the library gate at 5 o'clock in the morning. However, because they could not rest well in the evening, they had to get up early to get a seat. Instead, he slept on his stomach on the table.
At the same time, awkward problems have also arisen in the borrowing of books. Because they cannot see the composition of the books in the library and the borrowing situation, students often face the situation that they can't find the book or the book is borrowed by others and run in vain. It wasted students' time and also reduced their desire to borrow books. Many excellent books accumulated in the library but no one knew or borrowed them.
Therefore, designing a convenient and lightweight application based on WeChat applets to help university libraries solve such problems is my purpose and focus this time.
1.2 Overview of Development at Home and Abroad The
WeChat Mini Program is an application that can be used without downloading and installing. It truly realizes a tool that users can open and use only by scanning or searching [3].
The usage rate of WeChat and WeChat Mini Programs abroad is not high. The users are mainly concentrated in Southeast Asia and overseas Chinese. For light applications such as WeChat Mini Programs, it is still a blue ocean.
In China, WeChat has completely occupied the mainstream market share. Currently, iPhone version, Android version, Windows Phone version, Blackberry version, S60V3 and V5 versions have been released [4]. According to the survey, self-employed and individual subjects can register 5 WeChat Mini Programs, and the development cost of WeChat Mini Programs is lower than that of the software, and the development threshold is low. With the help of reliable WeChat data backends, the data resources required for the development of Mini Programs are safe. Efficient. As of the end of 2019, the number of WeChat Mini Programs in my country has reached 3 million, and the future development prospects are promising [5]. On the premise that WeChat itself is already a universal application, the epidemic has also made WeChat applets such as health codes in various places gradually become a daily necessity. Nowadays, no matter where people go, they need to scan through WeChat to register and show QR codes to record travel routes and contact people through the Internet. This not only ensures safety but also greatly reduces the difficulty of finding people who have been in close contact with confirmed patients.
Now many applications have added WeChat applet versions with the same functions, such as takeaway software such as Meituan and Ele.me or Didi taxi-hailing software. Even the software for star fans has also developed a WeChat applet version. Because light applications such as WeChat applets can be used directly without downloading, it helps to free the increasingly bloated mobile phone from the various kinds of software now available.
The WeChat applet has also played an important role in medical care. Now many hospitals are gradually increasing their safety awareness and promoting contactless registration appointments. By scanning the QR code to enter the WeChat applet of the local hospital, you can complete the appointment registration and information at home. Filling in not only ensures safety, reduces the workload of the hospital, but also facilitates patients. There is no need to wait in a long line or go to the hospital to find that the doctor is not at work.
At present, some domestic academic libraries provide services to a wide range of readers and users through the WeChat public platform, such as the Peking University Library, the Renmin University Library of China, and the Shanghai Normal University Library [6]. In addition to library management in colleges and universities, WeChat Mini Programs also play an important role. Students usually rely on Mini Programs for querying curriculum, examination dates, and scores. After nearly two years of development, new programs have been established in China. WeChat applet development environment and developer ecology.
1.3 The main content of the
design This article designed a WeChat applet about the library management system. The main goal is to realize the inquiry and reservation of library books through the applet, and students can make relevant suggestions to the library on the public message board. You can make reservations for self-study desks and chairs in the library on the Internet to save students’ invalid seat grab time and display occupied seats, and reserve seats for students during meal breaks within a certain period of time.
This paper conducts research and analysis based on the characteristics of the software. The main content: first introduces the background of the project development and the significance of the research; second, it introduces the theoretical knowledge of the relevant technologies used in the project development process and the introduction of the development environment; three It is necessary to analyze the system development and provide the corresponding theoretical basis for the system design link. The fourth is to realize the main links and prerequisites of the system development. The main modules of the project system are analyzed and designed in detail to lay the foundation for the subsequent concrete realization. The fifth is to briefly introduce the test cases, so that after successfully completing the development of the program, through these tests, we can quickly and effectively find out the shortcomings of the system and modify and improve them in time.

2 Related technology introduction and system environment development conditions
2.1 Related technology introduction
WeChat developer tool is a developer tool specially designed by Tencent for WeChat applets. It is not only lightweight and convenient, but also not very demanding on the computer. Therefore, the corresponding development can be completed on a general computer. In the process of system debugging and testing, you can complete the system test link without downloading third-party plug-ins, which can be completed through a developed debug debugger.
The system is accessed based on a browser, adopts the springboot integrated rapid development framework, the front end uses the vue method, based on the es5 syntax, and the development tool IntelliJ IDEA 2020.1.1 x64. Because the development tool is embedded with the Tomcat service operation mechanism, it can be No need to download Tomcat server separately.
As an object-oriented development language, Java not only absorbs the various advantages of many languages, but also its entire ecology is the best openness among all languages. In learning, you can find many similar functional codes for later Refer to learning, like the current asp.net development language to a large extent imitates the thinking of java. If you learn java programming and master another language, you will learn very quickly because of its simplicity and structure-oriented It reduces the complexity of code management, makes the programming process clearer, and the logic decoupling is more hierarchical.
As a project version management software, Maven can better manage the use of jar packages. There was no Maven management tool before, and many versions of jar packages need to be downloaded online. Sometimes the incompatibility between versions affects the use of the system. Play, sometimes different bugs appear, after using the Mavern project, this difficult problem can be eliminated very well.
MySQL is an open source relational database. Because it is open source, there is no copyright dispute. Now many companies are using MySQL as database storage. Not only its storage rate is relatively fast, but it can also be used for secondary development. Customize a database that is more suitable for the company.
The bottom layer of Vue's syntax implements the principle of two-way data binding. When re-detailing or releasing the project, there is no need to restart the project. The implementation of the code function module can be reflected on the browser to achieve fast response. Some compilable languages ​​need to load a lot of plug-ins before they can be started.
Spring encapsulates a lot of java class library files. During the development process, you don’t need to write too many complicated class files. You only need to quote the spring framework to complete the needs of rapid development. Therefore, the logic code of Java programming becomes more complicated. Clear, the decoupling between the various layers is also relatively strong, the reusability has also been well played, making the development difficulty easier and easier, its main two features are dependency injection, interface-oriented thinking; (AOP) Aspects of thinking;
IntelliJ IDE and eclipse comparison, these two are Java programming language development tools, and the difference, IDEA and third-party plug-in market access more, development efficiency and intelligent prompts are smarter than eclipse, in terms of environment IDEA is also faster in configuration generation, and the interface design is also relatively clean and simple.
HBuilder is a development technology based on H5 grammar such as HTML, js, css, etc., which makes it easy for developers to learn. The data binding involved is based on Vue grammar, and it is faster than traditional jquery in development efficiency. Of course, HBuilder also retains With support for jquery, the two grammars can be combined with the needs of the project and can be mixed development. The development tool itself is written by java, so it has good compatibility with native project plug-ins.

2.2 System environment development conditions
The system adopts the B/S architecture, the front-end framework is developed with WeChat developer tools, and the background data is realized using MYSQL
serial number. Software environment version remarks
1 windows operating system 10
2 database MYSQL 8.0
3 programming development tool software IDEA 2020.2
4 WeChat Developer tool 1.05

3 System requirements analysis and design
As the software development process in the early stage, the project needs to be analyzed. First of all, we must understand what the business does and what functions it implements, and subdivide the use background of each functional module in the functional module. In this way, in software development, the defects of the architecture design will not reproduce the underlying data structure of the secondary design. In addition, there are some non-functional special details, such as database performance, security considerations, and network speed reflection time. They are all used as constraints for demand analysis, and they are also targets that need to be analyzed at runtime after the project is developed.

3.1 Feasibility analysis The feasibility analysis of
the system is essential in the process of system development. The feasibility study is to evaluate whether the problem can be solved and to solve it with the least time and the least cost. In order to achieve the above goals, the advantages and disadvantages of the methods to solve these problems must be considered, and the economic benefits brought by the development of these systems must also be considered. Here we can use technical feasibility, operational feasibility, and economic feasibility to conduct a feasibility study of our system.

3.1.1 Technicality: The system designed in this project mainly adopts layui front-end development, the back-end uses java language and springboot integrated development framework, uses mysql database, according to one's own major, combined with online access to case lists and library materials, development and realization There is no big problem.
3.1.2 Economics: To develop a mature software, it takes a long process. Here, the design to the software requirements analysis, planning, development personnel, testing links, and debugging process all require capital and manpower input. And the development of this set of software can be learned through online open source source code and related materials. The hardware and computer use are all used by oneself, so the development cost can be ignored.
3.1.3 Operability: The functions designed by this system mainly include login module, student management module, teacher management module, course management module, classroom management module. The relevant knowledge of these functional modules are commonly used functions that are usually designed. It is achievable in operation.

3.2 Demand analysis
By understanding the needs of users, we can know that simple-to-operate systems are more likely to be favored by users, and can manage information accurately and completely. After the small program book management platform analyzes the requirements accordingly, it comes to the conclusion that the system is mainly divided into two roles: administrators and ordinary users.
The administrator module is mainly used for data update management. The functions are divided into user management, book classification, book management, seat management, and message information management. The
ordinary user module can mainly register and log in to the system, as well as the book borrowing function, the message reply function, and the seat Query and other functions.

3.2.1 General overview of
the system The project management system is mainly based on the B/S design model. The functions of the system design include: user management, book classification, book management, seat management, and message information. The system structure is shown in

Insert picture description here


Figure 3-1 : Figure 3-1 Structure Diagram

3.2.2 Functional requirements
This system is designed to use modern computer network technology to integrate traditional information propaganda methods, and to complete it in accordance with the practical process. At the same time, the service was improved, and a WeChat book management system platform was initially designed to facilitate related business operations. In order to make the system play a greater role in various management and realize computerized and efficient management, the development target function requirements are now introduced as follows:
(1) Administrator login module The
administrator has the right to manage the applet library system, However, all registration and the use of permissions need to be authorized by the administrator. After the administrator enters the home page, he can authorize employees for related functions, such as: book borrowing management, message reply management, seat management, and user management.
(2) User management module Manage the
registered users.
(3) The book borrowing management module is
mainly used to record the status of book borrowing. The administrator can perform operations on books and shelves, as well as operations on book management.
(4) The seat management module is
mainly for the inquiry of the library seat situation, which is convenient for college students to make the reservation of the library seat in advance. The administrator can add, modify, and delete the seat information.
3.2.3 Non-functional requirements
The system is not only To meet functional requirements, you also need to meet invisible non-functional requirements, such as system compatibility, user interface integrity, and web page access fluency. The main points are summarized as follows:
Category requirements describe
compatibility and support multiple browsers access.
The interface website is overall beautiful, with coordinated elements.
Security access control is not attacked, preventing SQL injection.
3.2.4 Flow chart design
The workflow of the ordinary user system is: After logging in to the system through the WeChat library management system, ordinary users can inquire about book borrowing and subscribe to related books. In the book seat management, they can inquire about the remaining seats in the library and leave a message on the mini program. ,Suggestions. The following is the overall flow chart design as

Insert picture description here


shown in Figure 3-2: Figure 3-2 The overall flow chart design

Login management flow chart: The login management function is the management entrance of the system, and of course it is also the highest level of system protection. If there is no good security prevention and control mechanism, the system will be vulnerable to attacks; for this, the following are the main considerations when designing Aspects. The following are as follows: 1. Verify that the user name and password are recorded in the database table; 2. Verify that the user name and password input is legal, especially SQL injection to prevent intrusion into the system and tampering with permissions; 3. When the user logs in to the system, it will be provided for each user A seesionID has an expiration time of 30 minutes. If the user does not use the system for a long time, the system will automatically jump to the login page after 30 minutes. The following is a part of the flow chart design, as follows:

Insert picture description here


3.2.5 System ER diagram design

Insert picture description here


3.3 Database design
3.3.1 Principles of database design
When creating a table, the primary key of the table should be as few as possible, and when establishing a foreign key relationship between the table and the table To minimize the complexity of database queries and CRUD operations as much as possible; system recovery operations, in the design of database files, consider that if the table is damaged, it can be quickly recovered in a short period of time, reducing costs. In the process of database system development, the following characteristics generally need to be met: less field redundancy, that is, when designing table fields, try to reduce unnecessary and redundant fields, and when setting table parameter types, reasonably control the length of parameter fields ; Confidentiality and security should be strong, do not set system keywords in the table to prevent SQL injection attacks; the management between tables should be rationalized, try to reduce more than three management table queries, and reduce SQL queries Decrease in system performance.

3.3.2 The design of the database table
User table (user_name): user number, user name, user password, name, telephone, mailbox

Insert picture description here


Insert picture description here


Insert picture description here


4 system function module realization

Part of the interface diagram is as follows:

Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Design and implementation of library management system based on WeChat applet (paper + program design source code + database file): Click to download >>>