JSP Maven Hibernate CRUD Example

🚀 Basic user registration and login system, user and products management web application using JSP, Servlet, Maven and Hibernate. This web application manages a colletion of users and products with the basic feature: list, insert, update and delete (CRUD operations - Create, Update, Read and Delete).

   

👨‍💻 Tech Stack

• Bootstrap 5
• Javascript, jQuery
• Java 11+
• Hibernate
• SQL - MySQL Workbench 8.0.27
• Maven

and more...

🪶 Features

• Customer registration
• Product registration
• User login
• Session treatment
• Shopping cart
• User profile and settings

🌍 Preparing Environment

Needs to be installed in your PC: Git, Node.js, Java JDK 11+. IDE to work with the code like Eclipse, IntelliJ, both with application server installed, Apache Tomcat 9 or other. MySQL Workbench or similar to manage database (important! case switch the tool to manage, it's necessary change the JDBC Driver).

Getting Started

# Clone repository or Download ZIP 
$ git clone <https://github.com/rubensdimasjr/jsp-maven-hibernate-crud>

Opening SQL script (MySQL Workbench)

1. File > Run SQL script > script.sql

Importing repository (Eclipse)

2. Open Eclipse IDE -> File > Import

   

3. Seach for Maven -> Select "Existing Maven Projects" -> Next > Root Directory, Browse...

4. Select repository until find > pom.xml > Open Folder

5. Finish.

Modifying Dao interface class and others

• Open src/main/java > package dao > Provedor.java

# Change for your connection credential
 String username = "root";
 String pwd = " ";

• Open src/main/java > hibernate.cfg.xml

# Change property hibernate connection
  <property name="hibernate.connection.username">root</property>  
  <property name="hibernate.connection.password"> </property>  

🗒 Note (important!)

• MySQL Workbench connection must not be closed while the application server(Apache TomCat or other) is running.
• MySQL Workbench(or other) version must be the same as the JDBC Driver(located pom.xml, Maven dependencies and hibernate.cfg.xml).
• Links that can help: (https://github.com/mysql/mysql-connector-j) (https://github.com/apache/tomcat)

---

🇦🇱 Autor

Feito por Rubens Matias 🚀 Entre em contato!