Servlet CRUD

In this tutorial you will learn about the Servlet CRUD and its application with practical example.

Servlet CRUD

CRUD (Create,Read,Update,Delete) is the most important part of any application or project. In this article we will learn about CRUD. Let’s get understand it by an example.

Example :-

Before doing coding part we need to create database and table for the storage, in this example I have used mysql which is in phpmyadmin of Xampp. Check below image for table structure.

image001

Here test is database name and emp_management is the table name.

Let’s start coding part. First we need to create project for this, index.html file will be auto created. Check below code for that and also other classes.

Note: Don’t forget to add MySQL JDBC Driver in your project like below image.
image003

index.html

Emp.java

This is our java bean class, from here we will set and get the data.2. Emp.java : This is our java bean class, from here we will set and get the data.

EmpDBHandler.java

This is very important part of this project, from here we will handle our all queries of database, database connection also be here. Check below code.

AddServlet.java

From this class we will add employee which will inserted to database. Check below code.

Recommended:-  Servlet HttpSession

ViewEmpServlet.java

It will show employees list in the form of table which are added by you, from here you can also delete and update user details. Check below code.

DeleteEmpServlet.java

When you run this project you will find an option in “View Employee” screen that is delete, which will redirect to DeleteEmpServlet.java class and delete the entry from table. Check below code.

Recommended:-  Servlet RequestDispatcher

UpdateEmpServlet.java

This is the class from where you can update the details of employee, You will get the form here which will be filled by previous entries of employee, when you edit and submit the details , it will redirect to the UpdateEmpServlet2.java class, which will update the data in the table. Check below code for this class.

UpdateEmpServlet2.java

As I explained above that this servlet will be used for update the employee details in the table, check below code for this class.

Output:-

So we are done with coding now check one by one screenshots of this project.

Index2.html

image005

After Adding Employee

image007

Database screenshot after adding employee.

image009

 

View Employee screenshot.

image011

Update Screenshot : On Update screeshot.

image013

After update and add one more employee.

image015

Delete: Post deletion result will be like below image

image017

After insertion of multiple records.

image019

So we are done with this project, link of this project is below. You can simply download this project by below link. Here we can see there are many records in table so in next article we will make them in pagination. In short we will divide our data in pages. Check Next article for this.

Download Complete Code

In this tutorial we have learn about the Servlet CRUD and its application with practical example. I hope you will like this tutorial.