Ebhor.com

How to Include CSS in HTML- Types of CSS Inline External Internal

May 28, 2023May 28, 2023 by manish

CSS (Cascading Style Sheets) is a fundamental component of web design that enhances the visual appeal and aesthetics of websites. There are various types of CSS that developers can utilize to style their web pages. Each type has its own syntax, usage, and advantages. In this article, we will explore the three primary types of … Read more

Static keyword in Java with uses and Examples

May 27, 2023May 27, 2023 by manish

Static keyword can be used with Variables Methods Blocks Static inner class lets see them one by one Static Variables in Java Static variable can be create by adding static keyword in front of variable. below count is static variable. A static variable is shared among all objects of class. Each class have their own … Read more

error: error:0308010c:digital envelope routines::unsupported

May 22, 2023May 22, 2023 by manish

The error “error: error:0308010c:digital envelope routines::unsupported” typically occurs when you are trying to access an HTTPS website using the Python requests library and the SSL certificate of the website is not supported by the SSL library of your Python installation. Here are the step-by-step details to resolve this issue: Step 1: Check your Python version … Read more

How to find String length in java string method

May 21, 2023 by manish

Get String length with String length() method To find String length in java there is a method length(). This method is used to get the length of the string. The signature of length method is:

public int length()

1	public int length()

The length method returns the length of the string. it counts the number of Unicode in string. str.length java … Read more

1 billion in rupees: Billion to Lakhs Crores Million

May 21, 2023 by manish

If we talk about the Indian currency i.e. Rupees, then 1 billion is equal to 10000 lacs. 1 billion is equal to 10000000000 which is a natural number. The number 1000000001 comes after 1 billion and the number 999999999 comes before it. To describe in quantities in Math, the concept of place value is used. … Read more

What Is 7/8 As A Percentage?

May 21, 2023May 21, 2023 by manish

7/8 As A Percentage is 87.5 % Percent and fractions are the two terms that we generally use in comparing quantities. A fraction is represented as a numerical value that is defined as a part of a whole while percent, a relative value tells you how much of the whole you have and it is … Read more

ITI full form | ITI Course Trades Institutes and Job

May 21, 2023May 21, 2023 by manish

ITI Full form is Industrial Training Institute ITI is especially a 2-year technical course. This course is useful to those people who are in need of work and want to learn valuable skills. The various disciplines can be Fitter, Linesman, Welder, etc. The minimum eligibility criterion for ITI is grade 10. It can be done … Read more

Function Overriding in C++ with Example

May 21, 2023May 21, 2023 by manish

Function Overriding in C++ Programming Language is one of the important concept in C++. Function Overloading is used to achieve run time polymorphism What is Function Overriding in C++? When two classes are in the inheritance hierarchy. The parent class function is re-defined in the child class with the same method signature. The re-defined function … Read more

How to get client IP address in java Struts2

May 21, 2023May 21, 2023 by manish

When users submit a form along with form data we can get the IP address of the client. Let’s see one simple program to demonstrate this request.getHeader(“X-FORWARDED-FOR”); is used to get the address of client in java/jsp/struts and in spring.

   public class Post extends ActionSupport{
           public String execute(){
              HttpServletRequest request = ServletActionContext.getRequest();
              String ipAdd = request.getHeader("X-FORWARDED-FOR");
              if (ipAdd == null) {
                  ipAdd = request.getRemoteAddr();
              }
                System.out.pritln("Ip address of requested client is "+ipAdd); 
               return SUCCESS;
           }
        }

public class Post extends ActionSupport{

public String execute(){

HttpServletRequest request = ServletActionContext.getRequest();

String ipAdd = request.getHeader("X-FORWARDED-FOR");

if (ipAdd == null) {

ipAdd = request.getRemoteAddr();

}

System.out.pritln("Ip address of requested client is "+ipAdd);

return SUCCESS;

}

Employee Management System Project JSP Servlet

May 20, 2023May 20, 2023 by manish

org. comp.model Employee Model – Employee.java

package org.comp.model;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Objects;

public class Employee implements Serializable {

	private static final long serialVersionUID = 1L;
	private Long id;
	private String name;
	private String department;
	private String designation;
	private BigDecimal salary;

	public Employee() {

	}

	public Employee(Long id, String name, String department, String designation, BigDecimal salary) {
		super();
		this.id = id;
		this.name = name;
		this.department = department;
		this.designation = designation;
		this.salary = salary;
	}

	@Override
	public String toString() {
		return "Employee [id=" + id + ", name=" + name + ", department=" + department + ", designation=" + designation
				+ ", salary=" + salary + "]";
	}

	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getDepartment() {
		return department;
	}

	public void setDepartment(String department) {
		this.department = department;
	}

	public String getDesignation() {
		return designation;
	}

	public void setDesignation(String designation) {
		this.designation = designation;
	}

	public BigDecimal getSalary() {
		return salary;
	}

	public void setSalary(BigDecimal salary) {
		this.salary = salary;
	}

	public static long getSerialversionuid() {
		return serialVersionUID;
	}

}

package org.comp.model;

import java.io.Serializable;

import java.math.BigDecimal;

import java.util.Objects;

public class Employee implements Serializable {

private static final long serialVersionUID = 1L;

private Long id;

private String name;

private String department;

private String designation;

private BigDecimal salary;

public Employee() {

}

public Employee(Long id, String name, String department, String designation, BigDecimal salary) {

super();

this.id = id;

this.name = name;

this.department = department;

this.designation = designation;

this.salary = salary;

}

@Override

public String toString() {

return "Employee [id=" + id + ", name=" + name + ", department=" + department + ", designation=" + designation

+ ", salary=" + salary + "]";

}

public Long getId() {

return id;

}

public void setId(Long id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getDepartment() {

return department;

}

public void setDepartment(String department) {

this.department = department;

}

public String getDesignation() {

return designation;

}

public void setDesignation(String designation) {

this.designation = designation;

}

public BigDecimal getSalary() {

return salary;

}

public void setSalary(BigDecimal salary) {

this.salary = salary;

}

public static long getSerialversionuid() {

return serialVersionUID;

}

Employee Controller Servlet added org.comp.controller package is used for controller AddEmployee.Java

package org.comp.controller;
import java.io.IOException;
import java.math.BigDecimal;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.comp.dao.EmployeeDAO;
import org.comp.model.Employee;
@WebServlet("/add-employee")
public class AddEmployee extends HttpServlet {
	private static final long serialVersionUID = 1L;
	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String name = request.getParameter("name");
		String department = request.getParameter("department");
		String designation = request.getParameter("designation");
		String salary = request.getParameter("salary");
		Employee e = new Employee();
		e.setName(name);
		e.setDepartment(department);
		e.setDesignation(designation);
		e.setSalary(new BigDecimal(salary));
		System.out.println(e);
		EmployeeDAO dao = new EmployeeDAO();
		dao.insert(e);
		List<Employee> employeeList = dao.fetchAll();
		request.setAttribute("employeeList", employeeList);
		int employeeCount = dao.count();
		request.setAttribute("employeeCount", employeeCount);
		RequestDispatcher rd = request.getRequestDispatcher("/ListEmployees.jsp");
		rd.forward(request, response);
	}
}

package org.comp.controller;

import java.io.IOException;

import java.math.BigDecimal;

import java.util.List;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.comp.dao.EmployeeDAO;

import org.comp.model.Employee;

@WebServlet("/add-employee")

public class AddEmployee extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String name = request.getParameter("name");

String department = request.getParameter("department");

String designation = request.getParameter("designation");

String salary = request.getParameter("salary");

Employee e = new Employee();

e.setName(name);

e.setDepartment(department);

e.setDesignation(designation);

e.setSalary(new BigDecimal(salary));

System.out.println(e);

EmployeeDAO dao = new EmployeeDAO();

dao.insert(e);

List<Employee> employeeList = dao.fetchAll();

request.setAttribute("employeeList", employeeList);

int employeeCount = dao.count();

request.setAttribute("employeeCount", employeeCount);

RequestDispatcher rd = request.getRequestDispatcher("/ListEmployees.jsp");

rd.forward(request, response);

}

FetchEmployee.java

package org.comp.controller;

import java.io.IOException;
import java.math.BigDecimal;
import java.util.List;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.comp.dao.EmployeeDAO;
import org.comp.model.Employee;

@WebServlet("/update")
public class FetchEmployee extends HttpServlet {
	private static final long serialVersionUID = 1L;

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		Long id=Long.valueOf( request.getParameter("id"));
		EmployeeDAO dao = new EmployeeDAO();
		Employee employee = dao.fetch(id);
		System.out.println(employee);
		request.setAttribute("employee", employee);
		RequestDispatcher rd = request.getRequestDispatcher("/UpdateEmployee.jsp");
		rd.forward(request, response);
	}

}

package org.comp.controller;

import java.io.IOException;

import java.math.BigDecimal;

import java.util.List;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.comp.dao.EmployeeDAO;

import org.comp.model.Employee;

@WebServlet("/update")

public class FetchEmployee extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

Long id=Long.valueOf( request.getParameter("id"));

EmployeeDAO dao = new EmployeeDAO();

Employee employee = dao.fetch(id);

System.out.println(employee);

request.setAttribute("employee", employee);

RequestDispatcher rd = request.getRequestDispatcher("/UpdateEmployee.jsp");

rd.forward(request, response);

}

UpdateEmployee.java

package org.comp.controller;
import java.io.IOException;
import java.math.BigDecimal;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.comp.dao.EmployeeDAO;
import org.comp.model.Employee;
@WebServlet("/update-employee")
public class UpdateEmployee extends HttpServlet {
	private static final long serialVersionUID = 1L;
	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		Long id = Long.valueOf(request.getParameter("id"));
		String name = request.getParameter("name");
		String department = request.getParameter("department");
		String designation = request.getParameter("designation");
		String salary = request.getParameter("salary");
		Employee e = new Employee();
		e.setId(id);
		e.setName(name);
		e.setDepartment(department);
		e.setDesignation(designation);
		e.setSalary(new BigDecimal(salary));
		System.out.println(e);
		EmployeeDAO dao = new EmployeeDAO();
		dao.update(e);
		List<Employee> employeeList = dao.fetchAll();
		request.setAttribute("employeeList", employeeList);
		int employeeCount = dao.count();
		request.setAttribute("employeeCount", employeeCount);
		RequestDispatcher rd = request.getRequestDispatcher("/ListEmployees.jsp");
		rd.forward(request, response);
	}
}

package org.comp.controller;

import java.io.IOException;

import java.math.BigDecimal;

import java.util.List;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.comp.dao.EmployeeDAO;

import org.comp.model.Employee;

@WebServlet("/update-employee")

public class UpdateEmployee extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

Long id = Long.valueOf(request.getParameter("id"));

String name = request.getParameter("name");

String department = request.getParameter("department");

String designation = request.getParameter("designation");

String salary = request.getParameter("salary");

Employee e = new Employee();

e.setId(id);

e.setName(name);

e.setDepartment(department);

e.setDesignation(designation);

e.setSalary(new BigDecimal(salary));

System.out.println(e);

EmployeeDAO dao = new EmployeeDAO();

dao.update(e);

List<Employee> employeeList = dao.fetchAll();

request.setAttribute("employeeList", employeeList);

int employeeCount = dao.count();

request.setAttribute("employeeCount", employeeCount);

RequestDispatcher rd = request.getRequestDispatcher("/ListEmployees.jsp");

rd.forward(request, response);

}

showEmployee.java

package org.comp.controller;                                                                                
                                                                                                            
import java.io.IOException;                                                                                 
import java.math.BigDecimal;                                                                                
import java.util.List;                                                                                      
                                                                                                            
import javax.servlet.RequestDispatcher;                                                                     
import javax.servlet.ServletException;                                                                      
import javax.servlet.annotation.WebServlet;                                                                 
import javax.servlet.http.HttpServlet;                                                                      
import javax.servlet.http.HttpServletRequest;                                                               
import javax.servlet.http.HttpServletResponse;                                                              
                                                                                                            
import org.comp.dao.EmployeeDAO;                                                                            
import org.comp.model.Employee;                                                                             
                                                                                                            
@WebServlet("/show-employee")                                                                               
public class ShowEmployee extends HttpServlet {                                                             
	private static final long serialVersionUID = 1L;                                                        
                                                                                                            
	protected void doGet(HttpServletRequest request, HttpServletResponse response)                          
			throws ServletException, IOException {                                                          
		EmployeeDAO dao = new EmployeeDAO();                                                                
		List<Employee> employeeList = dao.fetchAll();                                                       
		int employeeCount = dao.count();                                                                    
		request.setAttribute("employeeList", employeeList);                                                 
		request.setAttribute("employeeCount", employeeCount);                                               
		RequestDispatcher rd = request.getRequestDispatcher("/ListEmployees.jsp");                          
		rd.forward(request, response);                                                                      
	}                                                                                                       
                                                                                                            
}

package org.comp.controller;

import java.io.IOException;

import java.math.BigDecimal;

import java.util.List;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.comp.dao.EmployeeDAO;

import org.comp.model.Employee;

@WebServlet("/show-employee")

public class ShowEmployee extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

EmployeeDAO dao = new EmployeeDAO();

List<Employee> employeeList = dao.fetchAll();

int employeeCount = dao.count();

request.setAttribute("employeeList", employeeList);

request.setAttribute("employeeCount", employeeCount);

RequestDispatcher rd = request.getRequestDispatcher("/ListEmployees.jsp");

rd.forward(request, response);

}

DeleteEmployee.java

package org.comp.controller;
import java.io.IOException;
import java.math.BigDecimal;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.comp.dao.EmployeeDAO;
import org.comp.model.Employee;
@WebServlet("/delete")
public class DeleteEmployee extends HttpServlet {
	private static final long serialVersionUID = 1L;
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		Long id =Long.valueOf(request.getParameter("id"));
		EmployeeDAO dao = new EmployeeDAO();
		int st = dao.delete(id);
		List<Employee> employeeList = dao.fetchAll();
		request.setAttribute("employeeList", employeeList);
		RequestDispatcher rd = request.getRequestDispatcher("/ListEmployees.jsp");
		rd.forward(request, response);
	}
}

package org.comp.controller;

import java.io.IOException;

import java.math.BigDecimal;

import java.util.List;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.comp.dao.EmployeeDAO;

import org.comp.model.Employee;

@WebServlet("/delete")

public class DeleteEmployee extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

Long id =Long.valueOf(request.getParameter("id"));

EmployeeDAO dao = new EmployeeDAO();

int st = dao.delete(id);

List<Employee> employeeList = dao.fetchAll();

request.setAttribute("employeeList", employeeList);

RequestDispatcher rd = request.getRequestDispatcher("/ListEmployees.jsp");

rd.forward(request, response);

}

Data Access Object ConnectionFactory.java

package org.comp.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectionFactory {

	public static Connection getConnection() {
		Connection c = null;
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			c = DriverManager.getConnection("jdbc:mysql://localhost:3306/sspu",
					"sspu_userx25", "MV7GG5TV2312");
		} catch (ClassNotFoundException e) {
			System.out.println("ClassNotFoundException " + e);
		} catch (SQLException e) {
			System.out.println("SQLException " + e);
		}
		return c;
	}
}

package org.comp.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class ConnectionFactory {

public static Connection getConnection() {

Connection c = null;

try {

Class.forName("com.mysql.cj.jdbc.Driver");

c = DriverManager.getConnection("jdbc:mysql://localhost:3306/sspu",

"sspu_userx25", "MV7GG5TV2312");

} catch (ClassNotFoundException e) {

System.out.println("ClassNotFoundException " + e);

} catch (SQLException e) {

System.out.println("SQLException " + e);

}

return c;

}

EmployeeDAO.java

package org.comp.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.comp.model.Employee;
public class EmployeeDAO {
	Connection con = null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	int st;// status
	public int insert(Employee employee) {
		con = ConnectionFactory.getConnection();
		try {
			String query = "insert into employee(name,department,designation,salary) " + "values(?,?,?,?)";
			ps = con.prepareStatement(query);
			ps.setString(1, employee.getName());
			ps.setString(2, employee.getDepartment());
			ps.setString(3, employee.getDesignation());
			ps.setBigDecimal(4, employee.getSalary());
			st = ps.executeUpdate();
			System.out.println("inserted employee " + st);
		} catch (Exception e) {
			st = -2;
			e.printStackTrace();
		} finally {
			try {
				con.close();
			} catch (SQLException ex) {
				ex.printStackTrace();
			}
		}
		return st;
	}
	public int update(Employee employee) {
		con = ConnectionFactory.getConnection();
		try {
			String query = "update employee set name=?,department=?,designation=?,salary=? where id=?";
			ps = con.prepareStatement(query);
			ps.setString(1, employee.getName());
			ps.setString(2, employee.getDepartment());
			ps.setString(3, employee.getDesignation());
			ps.setBigDecimal(4, employee.getSalary());
			ps.setLong(5, employee.getId());
			st = ps.executeUpdate();
			System.out.println("Updated employee " + st);
		} catch (Exception e) {
			st = -2;
			e.printStackTrace();
		} finally {
			try {
				con.close();
			} catch (SQLException ex) {
				ex.printStackTrace();
			}
		}
		return st;
	}
	public List<Employee> fetchAll() {
		List<Employee> employeeList = new ArrayList<Employee>();
		con = ConnectionFactory.getConnection();
		try {
			String query = "select * from employee order by name";
			ps = con.prepareStatement(query);
			rs = ps.executeQuery();
			while (rs.next()) {
				Employee employee = new Employee();
				employee.setId(rs.getLong("id"));
				employee.setName(rs.getString("name"));
				employee.setDepartment(rs.getString("department"));
				employee.setDesignation(rs.getString("designation"));
				employee.setSalary(rs.getBigDecimal("salary"));
				employeeList.add(employee);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				con.close();
			} catch (SQLException ex) {
				ex.printStackTrace();
			}
		}
		return employeeList;
	}
	public Employee fetch(long id) {
		Employee employee = null;
		con = ConnectionFactory.getConnection();
		try {
			String query = "select * from employee where id=?";
			ps = con.prepareStatement(query);
			ps.setLong(1, id);
			rs = ps.executeQuery();
			while (rs.next()) {
				employee = new Employee();
				employee.setId(rs.getLong("id"));
				employee.setName(rs.getString("name"));
				employee.setDepartment(rs.getString("department"));
				employee.setDesignation(rs.getString("designation"));
				employee.setSalary(rs.getBigDecimal("salary"));
				System.out.println(employee);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				con.close();
			} catch (SQLException ex) {
				ex.printStackTrace();
			}
		}
		return employee;
	}
	public int delete(Long id) {
		con = ConnectionFactory.getConnection();
		try {
			String query = "delete from employee where id=?";
			ps = con.prepareStatement(query);
			ps.setLong(1, id);
			st = ps.executeUpdate();
			System.out.println("Deleted employee " + st);
		} catch (Exception e) {
			st = -2;
			e.printStackTrace();
		} finally {
			try {
				con.close();
			} catch (SQLException ex) {
				ex.printStackTrace();
			}
		}
		return st;
	}
	public int count() {
		int count = 0;
		con = ConnectionFactory.getConnection();
		try {
			String query = "select count(*) from employee";
			ps = con.prepareStatement(query);
			ResultSet rs = ps.executeQuery();
			while (rs.next()) {
				count = rs.getInt(1);
			}
			System.out.println("Total employees " + count);
		} catch (Exception e) {
			st = -2;
			e.printStackTrace();
		} finally {
			try {
				con.close();
			} catch (SQLException ex) {
				ex.printStackTrace();
			}
		}
		return count;
	}
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

package org.comp.dao;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import org.comp.model.Employee;

public class EmployeeDAO {

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

int st;// status

public int insert(Employee employee) {

con = ConnectionFactory.getConnection();

try {

String query = "insert into employee(name,department,designation,salary) " + "values(?,?,?,?)";

ps = con.prepareStatement(query);

ps.setString(1, employee.getName());

ps.setString(2, employee.getDepartment());

ps.setString(3, employee.getDesignation());

ps.setBigDecimal(4, employee.getSalary());

st = ps.executeUpdate();

System.out.println("inserted employee " + st);

} catch (Exception e) {

st = -2;

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return st;

}

public int update(Employee employee) {

con = ConnectionFactory.getConnection();

try {

String query = "update employee set name=?,department=?,designation=?,salary=? where id=?";

ps = con.prepareStatement(query);

ps.setString(1, employee.getName());

ps.setString(2, employee.getDepartment());

ps.setString(3, employee.getDesignation());

ps.setBigDecimal(4, employee.getSalary());

ps.setLong(5, employee.getId());

st = ps.executeUpdate();

System.out.println("Updated employee " + st);

} catch (Exception e) {

st = -2;

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return st;

}

public List<Employee> fetchAll() {

List<Employee> employeeList = new ArrayList<Employee>();

con = ConnectionFactory.getConnection();

try {

String query = "select * from employee order by name";

ps = con.prepareStatement(query);

rs = ps.executeQuery();

while (rs.next()) {

Employee employee = new Employee();

employee.setId(rs.getLong("id"));

employee.setName(rs.getString("name"));

employee.setDepartment(rs.getString("department"));

employee.setDesignation(rs.getString("designation"));

employee.setSalary(rs.getBigDecimal("salary"));

employeeList.add(employee);

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return employeeList;

}

public Employee fetch(long id) {

Employee employee = null;

con = ConnectionFactory.getConnection();

try {

String query = "select * from employee where id=?";

ps = con.prepareStatement(query);

ps.setLong(1, id);

rs = ps.executeQuery();

while (rs.next()) {

employee = new Employee();

employee.setId(rs.getLong("id"));

employee.setName(rs.getString("name"));

employee.setDepartment(rs.getString("department"));

employee.setDesignation(rs.getString("designation"));

employee.setSalary(rs.getBigDecimal("salary"));

System.out.println(employee);

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return employee;

}

public int delete(Long id) {

con = ConnectionFactory.getConnection();

try {

String query = "delete from employee where id=?";

ps = con.prepareStatement(query);

ps.setLong(1, id);

st = ps.executeUpdate();

System.out.println("Deleted employee " + st);

} catch (Exception e) {

st = -2;

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return st;

}

public int count() {

int count = 0;

con = ConnectionFactory.getConnection();

try {

String query = "select count(*) from employee";

ps = con.prepareStatement(query);

ResultSet rs = ps.executeQuery();

while (rs.next()) {

count = rs.getInt(1);

}

System.out.println("Total employees " + count);

} catch (Exception e) {

st = -2;

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException ex) {

ex.printStackTrace();

}

return count;

}

HTML Pages ListEmployees.jsp

<%@page import="org.comp.model.Employee"%>
<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Employee List</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link
	href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css"
	rel="stylesheet">
<script
	src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"></script>
</head>
<body class="container-fluid">
	<div class="row">
		<jsp:include page="menu.jsp" />
	</div>
	<div class="row">
		<div class="col-2"></div>
		<div class="col-8">
			<h2>List of Employees ${employeeCount}</h2>
			<small></small><a href="AddEmployee.jsp">Add Employee</a></small>
			<table class="table table-bordered">
				<thead>
					<tr>
						<th>#</th>
						<th>Name</th>
						<th>Department</th>
						<th>Designation</th>
						<th>Salary</th>
						<th>Update</th>
						<th>Delete</th>
					</tr>
				</thead>
				<tbody>
					<c:forEach items="${employeeList}" var="employee" varStatus="loop">
						<tr>
							<td>${loop.index+1}</td>
							<td>${employee.name}</td>
							<td>${employee.department}</td>
							<td>${employee.designation}</td>
							<td>${employee.salary}</td>
							<td><a href="update?id=${employee.id}">Update</a></td>
							<td><a href="delete?id=${employee.id}">Delete</a></td>
						</tr>
					</c:forEach>
				</tbody>
			</table>
		</div>
		<div class="col-2"></div>
	</div>
	<div class="row">
		<jsp:include page="footer.jsp"></jsp:include>
	</div>
</body>
</html>

<%@page import="org.comp.model.Employee"%>

<%@page import="java.util.ArrayList"%>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE html>

<html>

<head>

<title>Employee List</title>

<link

href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css"

rel="stylesheet">

<script

src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>

</head>

<jsp:include page="menu.jsp" />

</div>

<h2>List of Employees ${employeeCount}</h2>

<small></small><a href="AddEmployee.jsp">Add Employee</a></small>

<thead>

<tr>

<th>Department</th>

<th>Designation</th>

<th>Salary</th>

<th>Update</th>

<th>Delete</th>

</tr>

</thead>

<tbody>

<c:forEach items="${employeeList}" var="employee" varStatus="loop">

<tr>

<td>${loop.index+1}</td>

<td>${employee.name}</td>

<td>${employee.department}</td>

<td>${employee.designation}</td>

<td>${employee.salary}</td>

<td><a href="update?id=${employee.id}">Update</a></td>

<td><a href="delete?id=${employee.id}">Delete</a></td>

</tr>

</c:forEach>

</tbody>

</table>

</div>

</div>

<jsp:include page="footer.jsp"></jsp:include>

</div>

</body>

</html>

AddEmployee.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link
	href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css"
	rel="stylesheet">
<script
	src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"></script>
</head>
<body class="container-fluid">
	<div class="row">
		<jsp:include page="menu.jsp" />
	</div>
	<div class="row">
		<div class="col-2"></div>
		<div class="col-8">
			<h2>Add New Employee</h2>
			<form id="add-employee" action="add-employee" method="post">
				<div class="mb-3 mt-3">
					<label for="name">Name</label> <input type="text"
						class="form-control" id="name" placeholder="Name" name="name"
						required>
				</div>
				<div class="mb-3">
					<label for="department">Department</label> <input type="text"
						class="form-control" id="department"
						placeholder="Enter Department" name="department" required />
				</div>
				<div class="mb-3 mt-3">
					<label for="designation">Designation</label> <input type="text"
						class="form-control" id="designation"
						placeholder="Enter Designation" name="designation" required />
				</div>
				<div class="mb-3">
					<label for="salary">Salary</label> <input type="number"
						class="form-control" id="salary" placeholder="Enter Salary"
						name="salary" required />
				</div>
				<button type="submit" class="btn btn-primary">Add Employee</button>
			</form>
		</div>
		<div class="col-2"></div>
	</div>
	<div class="row">
		<jsp:include page="footer.jsp" />
	</div>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html>

<html>

<head>

<title>Insert title here</title>

<link

href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css"

rel="stylesheet">

<script

src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>

</head>

<jsp:include page="menu.jsp" />

</div>

<h2>Add New Employee</h2>

<label for="name">Name</label> <input type="text"

class="form-control" id="name" placeholder="Name" name="name"

required>

</div>

<label for="department">Department</label> <input type="text"

class="form-control" id="department"

placeholder="Enter Department" name="department" required />

</div>

<label for="designation">Designation</label> <input type="text"

class="form-control" id="designation"

placeholder="Enter Designation" name="designation" required />

</div>

<label for="salary">Salary</label> <input type="number"

class="form-control" id="salary" placeholder="Enter Salary"

name="salary" required />

</div>

<button type="submit" class="btn btn-primary">Add Employee</button>

</form>

</div>

</div>

<jsp:include page="footer.jsp" />

</div>

</body>

</html>

UpdateEmployee.jsp

<%@page import="org.comp.model.Employee"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link
	href="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/css/bootstrap.min.css"
	rel="stylesheet">
<script
	src="https://cdn.jsdelivr.net/npm/bootstrap@5.2.3/dist/js/bootstrap.bundle.min.js"></script>
</head>
<body class="container-fluid">
	<div class="row">
		<jsp:include page="menu.jsp" />
	</div>
	<div class="row">
		<div class="col-2"></div>
		<div class="col-8">
			<h2>Update Employee</h2>
			<form id="update-employee" action="update-employee" method="post">
				<div class="mb-3 mt-3">
					<label for="name">Name</label> <input type="text"
						class="form-control" id="name" placeholder="Name" name="name"
						value="${employee.name}" required /> <input type="hidden"
						name="id" value="${employee.id}" />
				</div>
				<div class="mb-3">
					<label for="department">Department</label> <input type="text"
						class="form-control" id="department"
						placeholder="Enter Department" name="department"
						value="${employee.department}" required />
				</div>
				<div class="mb-3 mt-3">
					<label for="designation">Designation</label> <input type="text"
						class="form-control" id="designation"
						placeholder="Enter Designation" name="designation"
						value="${employee.designation}" required />
				</div>
				<div class="mb-3">
					<label for="salary">Salary</label> <input type="number"
						class="form-control" id="salary" placeholder="Enter Salary"
						name="salary" value=${employee.salary } required />
				</div>
				<button type="submit" class="btn btn-primary">Update
					Employee</button>
			</form>
		</div>
		<div class="col-2"></div>
	</div>
	<div class="row">
		<jsp:include page="footer.jsp" />
	</div>
</body>
</html>

<%@page import="org.comp.model.Employee"%>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

pageEncoding="ISO-8859-1"%>

<!DOCTYPE html>

<html>

<head>

<title>Insert title here</title>

<link

href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css"

rel="stylesheet">

<script

src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>

</head>

<jsp:include page="menu.jsp" />

</div>

<h2>Update Employee</h2>

<label for="name">Name</label> <input type="text"

class="form-control" id="name" placeholder="Name" name="name"

value="${employee.name}" required /> <input type="hidden"

name="id" value="${employee.id}" />

</div>

<label for="department">Department</label> <input type="text"

class="form-control" id="department"

placeholder="Enter Department" name="department"

value="${employee.department}" required />

</div>

<label for="designation">Designation</label> <input type="text"

class="form-control" id="designation"

placeholder="Enter Designation" name="designation"

value="${employee.designation}" required />

</div>

<label for="salary">Salary</label> <input type="number"

class="form-control" id="salary" placeholder="Enter Salary"

name="salary" value=${employee.salary } required />

</div>

<button type="submit" class="btn btn-primary">Update

Employee</button>

</form>

</div>

</div>

<jsp:include page="footer.jsp" />

</div>

</body>

</html>

menu.jsp

<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
	<div class="container-fluid">
		<a class="navbar-brand" href="#">Employee Management</a>
		<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavDarkDropdown" aria-controls="navbarNavDarkDropdown" aria-expanded="false" aria-label="Toggle navigation">
			<span class="navbar-toggler-icon"></span>
		</button>
		<div class="collapse navbar-collapse" id="navbarNavDarkDropdown">
			<ul class="navbar-nav me-auto mb-2 mb-lg-0">
				<li class="nav-item"><a class="nav-link active" aria-current="page" href="/EmployeeManagement">Home</a></li>
				<li class="nav-item"><a class="nav-link active" aria-current="page" href="/EmployeeManagement">Show</a></li>
				<li class="nav-item"><a class="nav-link active" aria-current="page" href="AddEmployee.jsp">Add</a></li>
			</ul>
		</div>
	</div>
</nav>

<a class="navbar-brand" href="#">Employee Management</a>

</button>

</ul>

</div>

</nav>

footer.jsp

<div class="container">
	<footer class="py-3 my-4">
		<ul class="nav justify-content-center border-bottom pb-3 mb-3">
			<li class="nav-item"><a href="#" class="nav-link px-2 text-muted">Home</a></li>
			<li class="nav-item"><a href="#" class="nav-link px-2 text-muted">Features</a></li>
			<li class="nav-item"><a href="#" class="nav-link px-2 text-muted">About</a></li>
			<li class="nav-item"><a href="#" class="nav-link px-2 text-muted">Contact</a></li>
			<li class="nav-item"><a href="#" class="nav-link px-2 text-muted">FAQ's</a></li>
		</ul>
		<p class="text-center text-muted">© 2021 Company, Inc</p>
	</footer>
</div>

<li class="nav-item"><a href="#" class="nav-link px-2 text-muted">Features</a></li>

<li class="nav-item"><a href="#" class="nav-link px-2 text-muted">About</a></li>

<li class="nav-item"><a href="#" class="nav-link px-2 text-muted">Contact</a></li>

</ul>

</footer>

</div>