Library reservation management system based on JSP + SSM + MySQL

Project brief

Project source: https://gitee.com/gepanjiang/LibrarySeats

Because there is no database file and watermark in the original gitee warehouse, I modify it and upload it to the personal gitee warehouse again.
https://gitee.com/coderzcr/LibrarySeats

The system is based onJSP+SSM+MysqlThe library reservation management system is realized. The main functions include: user management, menu management, role management, authority management, student management, teacher management, class management, library reading room management, student credit management, reservation seat management, post comment management, violation statistics, reservation seat statistics, etc. when adding students and teachers, they will automatically register in the user table, and the scheduled task will generate seats regularly The credit rating can be set in the classification of reading room. Students can’t reserve the corresponding reading room seats when their credit rating is lower than the corresponding value after being deducted.

Difficulty level: medium

Technology stack

editor

Eclipse Version: 2020-03 (4.15.0)

front-end technology

Basic: HTML + CSS + JavaScript

Framework: jQuery + easyUI

back-end technology

Spring+SpringMVC+mybatis

Template engine: JSP

Database: MySQL 5.7.27 (for personal test)

JDK version: 1.8.0_ 251 (for personal testing)

Tomcat version: 8.5.34 (for personal test)

Local operation

Eclipse environment preparation

1. Add JDK to eclipse

2. New Tomcat in eclipse

Import project

If you have doubts, please check the video version.

1. Download zip, unzip or install git, then execute clone command.

git clone https://gitee.com/coderzcr/LibrarySeats.git

2. Use eclipse to import project, configure JDK, Tomcat and required jar package.
The jar package on which the project dependsWebContent/WEB-INF/libFolder.

3. Open Navicat for MySQL and create dB_ library_ Seats database, and runWebContent/sql/db_library_seats.sql。

4. Modificationconfig.propertiesDatabase related content in.

5. Publish to tomcat, see the Tomcat configuration for the specific access link, if not modified, then http://localhost : 8080 / libraryseats / is the login page.

Administrator account: admin administrator password: admin

be careful

• The project does not declare the version of MySQL, JDK and tomcat, and the above version numbers are personal test versions.
• be carefulmodify config.propertiesDatabase related content in.

Project screenshot

statement

• This project is collected in GitHub, I just explain the use of technology, attention points and start-up methods to help you learn and communicate.
• If you can’t download the project through the gitee address or it doesn’t work normally, please send me a private letter and I will help you free of charge.

Recommended reading

• Jsp + servlet + jdbc + dbcp2 to realize online book purchasing system
• Shine online bookstore based on JSP + servlet + jdbc
• Jsp + servlet + jdbc implementation of cloud auto repair background management system
• Student information management system based on JSP + servlet + jdbc
• Ycu Movies Movie Website Based on JSP + servlet + c3p0 + MySQL
• Library management system based on JSP + servlet + c3p0 + MySQL

---

This article has been included in personal GitHub warehouse https://github.com/coderzcr/JavaWeb-Project-Source-Share Welcome star.