This article isVideo version, please be informed that

Project introduction

Project source: gitee.com/GaoHuaiYu/l…

This sharing is also a lot of library management system, suitable for beginners.

This system is based on JSP+Servlet+C3P0+Mysql. Involve less technology, easy to understand, suitable for JavaWeb beginners to learn to use.

Difficulty level: Easy

Technology stack

The editor

The Eclipse Version: 2019-12 (4.14.0)

The front-end technology

Basis: HTML + CSS + JavaScript

Framework: the BootStrap + JQuery

The back-end technology

Jsp+Servlet

Database: mysql 5.7.27 (personal test use)

Connection pool: C3P0

JDBC tool: Apache Commons DbUtils

JDK version: 1.8.0_181 (for personal testing)

Tomcat version: 8.5.34

Run locally

Preparing the Eclipse Environment

1. The eclipse new JDK

2. New tomcat eclipse

Import the project

1. Download the zip file and decompress it or install Git and run the clone command

https://gitee.com/GaoHuaiYu/library_management_system.git
Copy the code

2. Use Eclipse to open the project and configure JDK, Tomcat, and the required JAR packages. The jar packages that the project depends on are in the WebContent/WEB-INF/lib folder.

3. Open Navicat For Mysql and run dzy. SQL.

4. Modify the database content in c3P0-config. XML.

5. Release to tomcat, specific access link to see the tomcat configuration, if not modify the http://localhost:8080/myworkplus/ for the login page. The system has three permissions: system administrator, librarian and reader. System administrator initial account: admin System administrator initial password: 123 Librarian initial account: GHY Librarian initial password: 123 User initial account: fg User initial password: 123

Pay attention to

  • This project does not declare the use version of mysql, JDK and Tomcat. The above version numbers are used for personal testing.
  • Modify the database content in c3P0-config. XML.

Project screenshots

The statement

  • This project is collected from Gitee. I just explain the use of technology, attention points and start-up methods to help everyone learn and communicate.
  • If the project cannot be downloaded through gitee address or cannot run normally, please send me a private message and I will provide free assistance.

Recommended reading

  • JSP+Servlet+JDBC+DBCP2 to achieve online book buying system
  • JSP+Servlet+JDBC implementation shine online book city
  • JSP+Servlet+JDBC cloud auto repair background management system
  • JSP+Servlet+JDBC implementation of student information management system
  • JSP+Servlet+C3P0+Mysql implementation of YCU movies website

Welcome to follow my public account “Zhang Youlu”, the first time to push original technical articles.