library_manage_system

1. Project introduction

Project Introduction

The library system completed using jsp, layui, and mysql includes user book borrowing, librarian, and system administrator interfaces, with complete functions.

The development tool is eclipse, where mysql is 5.7 (mysql8 is also OK)

Demo address : http://library.mingyuefusu.top

The latest code is stored in the code cloud: https://gitee.com/mingyuefusu/tushuguanlixitong

（谢谢手下留情）

User account password: 1805010219 1234

Librarian account password: root 1234

System administrator account password: admin admin

If you encounter problems that cannot be solved or need to set up relevant documents in the course, please add Q group 1021590105

Project details

This book management system is generally divided into front-end page display and back-end management.

The front desk page (i.e. the homepage of the book management system of this book) realizes three main functions: display of announcements, book query, and message suggestions. There is a function of viewing readers' rules. Teachers and students can see the latest announcement information released by library managers, and can query books they are interested in and view comments. After logging in, users can also have functions such as personal information modification, personal borrowing information query, and personal violation information query. They can also leave messages and suggestions to school library managers.

The backend page integrates the functions required in library management and is divided into library managers and system managers. The work of managers is usually completed in the backend. The front desk is for teachers and students to display. The corresponding backend is for school library managers, and the backend pages are encrypted. If you log in normally, you cannot enter the backend management page. The functions of the backend library managers include: borrowing books, returning books, displaying and searching for borrowing records, displaying and searching for book return records, and adding and retrieving announcements; the functions of the backend system administrators include: adding and deleting and retrieving books, adding and retrieving books classification, adding and retrieving to borrow certificates, displaying and searching for borrowing information, adding and retrieving to borrow rules, adding and retrieving to librarians, displaying line charts for the number of recent borrowed books, and outputting the Excel table of these table data.

Contains three major modules: user, librarian, and system administrator

1. User module

1. View announcements: You can see the announcement information released by the librarian.
2. Book view: paging display, you can see the book overview, and you can fuzzy query through book number, book name, author, storage location, and book description
3. Personal violation information (after login): Personal historical violation information and inquiry
4. Library readers leave a message (after login): Suggestions for the library, or reviews of books
5. View borrowing rules: Different rules have different borrowing limit quantity, limited time, and overdue fees.
6. Personal information (after login): Viewing personal information and modifying the login password
7. Personal borrowing information (after login): paging and querying personal borrowing records

2. Librarian module

1. Borrowing and returning books: Help users borrow books, and determine whether the symbol does not meet the borrowing rules, and when returning books, determine whether there is an expiration date. If the expiration date is exceeded, the expiration date is output and the expiration date is returned.
2. Borrowing reports: paging displays all borrowing records, can query and output results to Excel announcement management: can add editing and delete announcements
3. Return report: The page displays all unrepaid books, and can be fuzzy inquired through conditions such as borrowing certificate number, book number, borrowing date, deadline and other conditions.
4. Modification of personal information: modify personal information, password, etc.

3. System Administrator Module

1. Book management: paging, adding new books, setting various information about books, editing and deleting, searching through number, title, author, description, etc., output the results to excel, and you can view who has borrowed the book.
2. Classification management: pagination display, add, delete and modify books, and easy to read and organize book classification
3. Borrowing certificate management: paging displays all borrowing certificates, adds, deletes, modify and checks the user's borrowing certificate, and view all borrowing records of the borrowing certificate.
4. Borrowing rules management: It can display, edit and delete all borrowing rules. The borrowing rules will determine what library books can be borrowed from the library certificate, how many books can be borrowed, how long can it be borrowed, and the daily expenses exceeding the deadline.
5. Borrowing information query: The page displays that if the query can be queryed for a condition that has not been returned for an expiration date, the fuzzy query will be conducted based on the number, borrowing certificate number, book number, borrowing date, etc., and the output result will be to excel, etc. The system administrator can only query it, and cannot add, delete and modify borrowing information. This operation is operated by the librarian.
6. Librarian management: add, delete and modify the librarian, but cannot modify the original account
7. Book borrowing statistics: The number of books borrowed in the library for the past 30 days is intuitively displayed through the line chart.

sql table

There are ten database tables, book tables, book borrowing record tables, message tables, system administrator tables, borrowing certificate tables, library administrator tables, book classification tables, library tables, borrowing rules tables, announcement tables

• Book list

  • Number, name, author, library stored, classification number, storage location, whether to lend, book description

• Book Borrowing Record Table

  • Number, loan certificate number, book number, loan date, restricted date, return date, description of violation, handler number

• Message form

  • Number, loan certificate number, message content, message date

• System Administrator Table

  • Account number, password

• Borrowing certificate form

  • Number, password, borrower name, rule number, status (lost, available)

• Librarian Table

  • Number, name, account, password, email

• Book classification table

  • Number, classification name, classification description

• Library Table

  • Number, library name, description

• Rule table

  • Numbering, limiting the number of borrowings, limiting the number of borrowing days, daily expenses for book expiration

• Announcement form

  • Number, title, announcement content, release date

2. Deployment

Import the library.sql file into the mysql database , and you need to modify the following two database connection-related attributes (database account password, database table name)

3. Project demonstration

user

Book Query

Other omissions

Librarian

System Administrator