CRUD operations in Employee management using Spring, jQuery, Ajax, JSTL, JDBC, MySQL, Maven and developed using Eclipse IDE

In this example  we are seeing how to develop CRUD (Create, Read, Update and Delete) operation application using technologies Java, spring, JSP, JSTL, JDBC, MySQL, Ajax, jQuery and Maven. Application is developed using eclipse IDE. In this example all operations are performed on Employee basic properties like employee number, first name, last name and department name. Application main aim is adding employee details to DB using user interface, and performing multiple operations like update, viewing and deleting.

Below, find the Test cases and flow of the application.

Create Employee Query:

CREATE TABLE `employee` (

  `EMP_NO` int(11) DEFAULT NULL,

  `FIRST_NAME` varchar(30) DEFAULT NULL,

  `LAST_NAME` varchar(30) DEFAULT NULL,

  `DEPT_NAME` varchar(30) DEFAULT NULL

);

Insert Employee Query:

insert into employee values(1,'Gurugubelli','G','Technology');

insert into employee values(2,'Gurugubelli','Tech','Developer');

insert into employee values(3,'Employee','E','Dept 1');

Project Structure:

Required dependencies(Java libraries) :

pom.xml

EmployeeController.java
EmployeeService.java
EmployeeServiceImpl.java
EmployeeDao.java
EmployeeDaoImpl.java
GurugubelliUtil.java
Employee.java
home.jsp
menu.jsp
addEmployee.jsp
listOfEmployee.jsp
updateEmployee.jsp
deleteEmployee.jsp