Ebhor.com

JTable Pagination in Java JDBC and MySQL Database

September 22, 2023 by manish

Here we will see how to develop JTable Pagination in java. We will use JDBC prepared statement and MySQL Database. We used NetBeans IDE and Jdk 1.8 to develop this project. Our Project Structure is as below To develop this project we used Book Example. Project Development Steps are 1 Create Table in MySQL Database … Read more

html/jsp page response in ajax get method

September 22, 2023September 22, 2023 by manish

We want to get an entire page as ajax response by using jquery get method. Steps: 1) First create pages(FirstJsp.jsp and SecondJsp.jsp) 2) call jquery get method to get ajax response in one page(here FirstJsp.jsp to get SecondJsp.jsp) 3)Configure struts.xml file Lets start with page creating FirstJsp.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@taglib  uri="/struts-tags" prefix="s" %>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>First JSP Page</title>
        <script type='text/javascript' src="js/jquery.min.js"></script>
    </head>
    <body>

<h1>Get Html Page As Responser</h1>

        <s:submit id="fetch" value="fetch" />

<div id="content"></div>


        <script>
            $(document).ready(function() {
                $(document).on("click", "#fetch", function(f) {
                    f.preventDefault();
                    $.get("getContent", function(data) {
                        $("#content").html(data);
                    });
                });
            });
        </script>
    </body>
</html>

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<%@taglib uri="/struts-tags" prefix="s" %>

<!DOCTYPE html>

<html>

<head>

<title>First JSP Page</title>

</head>

<body>

<h1>Get Html Page As Responser</h1>

<s:submit id="fetch" value="fetch" />

$(document).ready(function() {

$(document).on("click", "#fetch", function(f) {

f.preventDefault();

$.get("getContent", function(data) {

$("#content").html(data);

});

</script>

</body>

</html>

SecondJsp.jsp

This is Second Jsp Page</h1>



<ol>

 	<li>Create jsp/html files</li>


 	<li>Call ajax method to get response</li>


 	<li>Set configuration file and respond with html/jsp file which you want to get on success</li>

</ol>

This is Second Jsp Page</h1>

<ol>

<li>Create jsp/html files</li>

<li>Call ajax method to get response</li>

<li>Set configuration file and respond with html/jsp file which you want to get on success</li>

</ol>

Struts.xml

 <package name="default" extends="struts-default">
        <action name="getContent">
            <result name="success">SecondJsp.jsp</result>
        </action>
    </package>

<result name="success">SecondJsp.jsp</result>

</action>

</package>

Output

how to return array, arraylist, object from a method in java

September 22, 2023September 22, 2023 by manish

In Java we can create methods to do specific work and many times we have to return results from java method. A java method can return any datatypes or object type from method. 1 Return primitive datatypes from method A Returning int long float double values from a java method A. Return a integer value … Read more

HTML Table rowspan and colspan

September 22, 2023September 22, 2023 by manish

HTML Table rowspan and colspan are useful to use multiple rows and columns. HTML ROW SPAN In HTML, the rowspan attribute is used to specify how many rows a table cell should span or cover vertically within an HTML table. It is an attribute that can be applied to <td> (table data) or <th> (table … Read more

Jtable in Java Swing Example defaulttablemodel cell color

September 22, 2023September 22, 2023 by manish

JTable in Java is a swing component, that is used to show data in a two-dimensional Grid. Here we will discuss JTable Java Swing Example with various parameters It is used to display and edit data in cell format in table How to create login form in java swing Constructors of JTable in Java Swing … Read more

Increment and decrement operators in Python (+=, -=)

September 22, 2023September 22, 2023 by manish

INCREMENT AND DECREMENT OPERATORS IN PYTHON If you’re acquainted with other programming languages like C, Java, or PHP, you’ll recognize that the ++ symbol represents two operators: the increment and decrement operators, respectively. The increment and decrement operators are not available in Python. This may seem strange, but in Python you would write + = … Read more

How to get multiple parameters in ServletContext

September 22, 2023September 22, 2023 by manish

index.html

        <title>Servlet Context Multiple Parameters</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    
    

<h1>Servlet Context Multiple Parameters</h1>

        <a href="get-servlet-context">Get Multiple  parameters in servlet context</a>

<title>Servlet Context Multiple Parameters</title>

<h1>Servlet Context Multiple Parameters</h1>

<a href="get-servlet-context">Get Multiple parameters in servlet context</a>

web.xml

<!--?xml version="1.0" encoding="UTF-8"?-->
<web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">
    <context-param>
        <param-name>SiteName</param-name>
        <param-value>Ebhor.com</param-value>
    </context-param>
    <context-param>
        <param-name>Description</param-name>
        <param-value>Provides free tutorials</param-value>
    </context-param>
    <servlet>
        <servlet-name>ServletContext</servlet-name>
        <servlet-class>ebhor.servlet.ServletContext</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>ServletContext</servlet-name>
        <url-pattern>/get-servlet-context</url-pattern>
    </servlet-mapping>
    <session-config>
        <session-timeout>
            30
        </session-timeout>
    </session-config>
</web-app>

<web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">

<context-param>

<param-name>SiteName</param-name>

<param-value>Ebhor.com</param-value>

</context-param>

<context-param>

<param-name>Description</param-name>

<param-value>Provides free tutorials</param-value>

</context-param>

<servlet-name>ServletContext</servlet-name>

<servlet-class>ebhor.servlet.ServletContext</servlet-class>

</servlet>

<servlet-mapping>

<servlet-name>ServletContext</servlet-name>

<url-pattern>/get-servlet-context</url-pattern>

</servlet-mapping>

<session-config>

<session-timeout>

</session-timeout>

</session-config>

</web-app>

ServletContext.java

package ebhor.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Enumeration;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class ServletContext extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html");
        Enumeration<string> params = getServletContext().getInitParameterNames();
        PrintWriter out = response.getWriter();
        out.println("
<h1>Getting multiple servlet context</h1>
");
        while (params.hasMoreElements()) {
            String name = params.nextElement();
            String value = getServletContext().getInitParameter(name);
            out.println("
<h2>" + name + ": " + value + "</h2>
");
        }

    }
}

</string>

package ebhor.servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.Enumeration;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class ServletContext extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

Enumeration<string> params = getServletContext().getInitParameterNames();

PrintWriter out = response.getWriter();

out.println("

<h1>Getting multiple servlet context</h1>

");

while (params.hasMoreElements()) {

String name = params.nextElement();

String value = getServletContext().getInitParameter(name);

out.println("

<h2>" + name + ": " + value + "</h2>

");

}

</string>

Results Read More How to access ServletContext parameters How to access ServletConfig initial parameter value

Gson parse json array with example

September 22, 2023September 22, 2023 by manish

Gson parses JSON array meaning to Parsing JSON array with Google Gson library. Follow these steps to read JSON Array To read jsonString as an array we use the following syntax Gson gson=new Gson(); ElementType [] refVar=gson.fromJson(jsonString,ElementType[].class); To read jsonString as List TypeToken is used to find the type of class List eList=(List)gson.fromJson(reader, new TypeToken(){}.getType()); … Read more

How to insert data in MySql Using JSP Servlet & JDBC

September 22, 2023September 22, 2023 by manish

Here we will insert data in MySQL using JSP Servlet and JDBC. Here We will fetch Data from the JSP page and pass it to Servlet then DAO which contains JDBC code to store data in the MySQL database. How To Get Data From Database To Servlet Jdbc JSP Technology used Steps for Data insertion … Read more

Employee Management System JSP Servlet Project

September 22, 2023September 22, 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>