In this Example we can Add and Update the Details of Employee using Servlet.
In this Example we can Add and Update the Details of Employee using Servlet.In this Example we can Add and Update the Details of Employee using Servlet. We create four file employee.jsp, viewdata.jsp, EmployeeAdd.java and viewdata.java. When a web page ("employee.jsp") run on browser then it will called to Servlet ("EmployeeAdd.java") and add the new Employee Record in the database and provide a link on browser, by this link user redirect to Servlet "viewdata". This Servlet retrieves the data and show on browser.
Step 1: Source code of employee.jsp to add and update the Employee records.
<%@page import="java.sql.*"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE> New Document </TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT=""> <META NAME="Keywords" CONTENT=""> <META NAME="Description" CONTENT=""> <style> .tdcls{ font-weight:bold; } A:visited {color: #00000;font-weight:bold; text-decoration: underline} A:link {color: #FFC0C0; text-decoration: none} A:active {color: #C0FFC0; text-decoration: none} A:hover { color: #FF0000; text-decoration: none} </style> </HEAD> <BODY> <br><br> <form name="frm" action="empsave" method="post"> <% String emp_id = ""; String first_name = ""; String last_name = ""; String request_status = ""; String pend_request_type=""; String pend_request_date=""; String pend_request_data=""; String readonly=""; String bttn_value="Add"; int pend_request_id = 0; if(request.getParameter("emp_id")!=null && request.getParameter("emp_id")!="") { emp_id= request.getParameter("emp_id").toString(); pend_request_id= Integer.parseInt (request.getParameter("pend_request_id").toString()); readonly = "readonly"; Connection conn = null; String url = "jdbc:mysql://localhost:3306/"; String dbName = "user_register"; String driver = "com.mysql.jdbc.Driver"; String userName = "root"; String password = "root"; bttn_value = "Update"; Statement st; try { Class.forName(driver).newInstance(); conn = DriverManager.getConnection (url+dbName,userName,password); System.out.println("Connected to the database"); String query1 = "SELECT * from pend_requests where emp_id='"+emp_id+"' and pend_request_id='"+pend_request_id+"'"; String query2 = "SELECT * from employee_details "+ "where eid='"+emp_id+"'"; st = conn.createStatement(); ResultSet rs1 = st.executeQuery(query1); while(rs1.next()) { request_status = rs1.getString(1); pend_request_type=rs1.getString(5); pend_request_date=rs1.getString(6); pend_request_data=rs1.getString(7); } ResultSet rs2 = st.executeQuery(query2); while(rs2.next()) { first_name = rs2.getString(2); last_name = rs2.getString(3); } } catch (Exception e) { e.printStackTrace(); } } %> <input type="hidden" name="pid" value="<%=pend_request_id%>"> <table width="350" align="center" border=0 bgcolor=#3EA99F> <tr><td colspan=2 align="center" class="tdcls"> Employee Details</td></tr> <tr> <td width="150px" class="tdcls">Employee Id</td> <td width="200px"> <input type="text" name="emp_id" value="<%=emp_id%>" <%=readonly%>></td></tr> <tr> <td class="tdcls">First Name</td> <td><input type="text" name="first_name" value="<%=first_name%>"></td> </tr><tr> <td class="tdcls">Last Name</td> <td><input type="text" name="last_name" value="<%=last_name%>"></td> </tr> <tr><td class="tdcls">Request Status</td> <td><select name="request_status"> <option value="open" <% if(request_status.equals("open"))out.println("selected"); %>>Open</option> <option value="pending" <% if(request_status.equals("pending"))out.println("selected"); %>>Pending</option> <option value="deferred" <% if(request_status.equals("deferred"))out.println("selected"); %>>Deferred</option> <option value="closed" <% if(request_status.equals("closed"))out.println("selected"); %>>Closed</option> </select> </td></tr> <tr> <td class="tdcls">Request Type</td> <td><select name="pend_request_type"> <option value="admin" <% if(pend_request_type.equals("admin"))out.println("selected"); %>>Admin</option> <option value="user" <% if(pend_request_type.equals("user"))out.println("selected"); %>>User</option> </select> </td></tr> <tr> <td class="tdcls">Date (yyyy-mm-dd)</td> <td> <input type="text" name="pend_request_date" value="<%=pend_request_date%>" <%=readonly%>> </td> </tr> <tr><td class="tdcls">Description</td> <td> <input type="text" name="pend_request_data" value="<%=pend_request_data%>"></td></tr> <tr> <td colspan=2 align="center"> <input type="submit" name="submit" value="<%=bttn_value%>"> </td></tr></table> <br><br> <% if(!(request.getParameter("emp_id")!=null && request.getParameter("emp_id")!="")) { %> <table width="100%" align="center"> <tr> <td align="center"><a href="viewdata"> Click here To show all records</a></td> </tr> </table> <% } %> </BODY> </HTML> |
Step 2:Source code of Servlet (EmployeeAdd.java) to add and update the data.
import java.io.*;
|
Step 3:Source code of Servlet (viewdata.java) to retrieve the data.
import java.io.*;
|
Step 4: Mapping the servlet (timer.java) in to web.xml file:
<?xml version="1.0" encoding="ISO-8859-1"?> <web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5"> <display-name>Welcome to Tomcat</display-name> <description> Welcome to Tomcat </description> <servlet> <servlet-name>viewData</servlet-name> <servlet-class>viewdata</servlet-class> </servlet> <servlet-mapping> <servlet-name>viewData</servlet-name> <url-pattern>/viewdata</url-pattern> </servlet-mapping> <servlet> <servlet-name>empSave</servlet-name> <servlet-class>EmployeeAdd</servlet-class> </servlet> <servlet-mapping> <servlet-name>empSave</servlet-name> <url-pattern>/empsave</url-pattern> </servlet-mapping> <servlet> <servlet-name>empUpdate</servlet-name> <servlet-class>EmpUpdate</servlet-class> </servlet> <servlet-mapping> <servlet-name>empUpdate</servlet-name> <url-pattern>/empupdate</url-pattern> </servlet-mapping> </web-app> |
Step 5: To create a web page (viewdata.jsp) to show all the records.
<%@page import="java.util.*"%> <html> <head> <title>Employee request form</title> <style> A:visited {color: #00000;font-weight:bold; text-decoration: underline} A:link {color: #FFC0C0; text-decoration: none} A:active {color: #C0FFC0; text-decoration: none} A:hover { color: #FF0000; text-decoration: none} .loginhead1{ text-align:left; padding-left:5px; } </style> </head> <body> <center> <table border="1" width="800px" cellspacing="0" cellpadding="0" bgcolor="bluelight"> <tr> <td width="10%" class="loginhead1" align="center"><b>Emp ID</b></td> <td width="19%" class="loginhead1" align="center"><b>Name</b></td> <td width="10%" class="loginhead1" align="center"><b>Request</b></td> <td width="14%" class="loginhead1" align="center"><b>Type</b></td> <td width="19%" class="loginhead1" align="center"><b> Request Date</b></td> <td width="20%" class="loginhead1" align="center"><b> Received Date</b></td> <td width="11%" class="loginhead1" align="center" height="25px"><b> Status</b></td> <td width="11%" class="loginhead1" align="center" height="25px"><b> Update</b></td> </tr> <% String ename=""; ArrayList arList=null; ArrayList AdminPendrequest = (ArrayList)session.getAttribute("arDataList"); //out.println(AdminPendrequest); out.println("<br>"); int count=0; if(AdminPendrequest!= null){ for(int i=0;i<AdminPendrequest.size();i++) { count++; arList = (ArrayList)AdminPendrequest.get(i); int pend_request_id = Integer.parseInt((arList.get(0).toString())); String emp_id =arList.get(1).toString(); String first_name = arList.get(2).toString(); String last_name = arList.get(3).toString(); String request_status = arList.get(4).toString(); String request_type = arList.get(5).toString(); String request_date = arList.get(6).toString(); String respond_date = arList.get(7).toString(); ename = first_name+ " " + last_name;%> <tr><form name="frm" method="post" action="employee.jsp"> <input type="hidden" name="emp_id" value="<%=emp_id%>"> <input type="hidden" name="pend_request_id" value="<%=pend_request_id%>"> <td width="10%" class="loginhead1" align="center"><%=emp_id%></td> <td width="19%" class="loginhead1" align="center"><%=ename%></td> <td width="10%" class="loginhead1" align="center"><%=request_status%></td> <td width="14%" class="loginhead1" align="center"><%=request_type%></td> <td width="19%" class="loginhead1" align="center"><%=request_date%></td> <td width="20%" class="loginhead1" align="center"><%=respond_date%></td> <td width="11%" class="loginhead1" align="center" height="25px"> <select name="request_status"> <% if(request_status.equals("open")) { %> <option value="pending">pending</option> <option value="deferred">Deferred</option> <option value="closed">Closed</option> <% } else if(request_status.equals("pending")) { %> <option value="deferred">Deferred</option> <option value="closed">Closed</option> <% } else if(request_status.equals("deferred")) {%> <option value="pending">Pending</option> <option value="closed">Closed</option> <%} else { %> <option value="closed">Closed</option> <% } %> </select> </td> <td width="19%" class="loginhead1" align="center"> <input type="submit" name="submit" value="Update"</td> <% %> </tr> </form> <% } } %> </table> <br> <br> <table> <tr><td align="center"> <a href="employee.jsp">Add More Employee</a></td></tr> </table> </center> </body> </html> |
Step 5: Start tomcat and type http://localhost:8080/updaterequest/employee.jsp
in on the browser and Click on Text Link "Click here To Show all records"
. Your browser should display all the records..
Successful Output of the program:
Download the full web application shows here.
Ads