Core Java| JSP| Servlets| XML| EJB| JEE5| Web Services| J2ME| Glossary| Questions?

 

 

 

 

 

 

 

 

 

 

 

 

 

Search Tutorials
Latest Questions
Comments
 
Check if parameter exists in servlet request 
 

In this Example we can Add and Update the Details of Employee using Servlet.

 

Update Employee Records

                         

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.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;
import java.text.*;

public class EmployeeAdd extends HttpServlet{ 
 
   public void doPost(HttpServletRequest request, HttpServletResponse response)
                                   throws ServletException,IOException{
    response.setContentType("text/html");
    PrintWriter out = response.getWriter();

     System.out.println("MySQL Connect Example.");
    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";

   
  String emp_id = request.getParameter("emp_id"); 
  String first_name = request.getParameter("first_name");
  String last_name = request.getParameter("last_name");
  String request_status = request.getParameter("request_status");
  String pend_request_date = request.getParameter("pend_request_date");
  String pend_request_type = request.getParameter("pend_request_type");
  String pend_request_data = request.getParameter("pend_request_data");
  int pend_request_id =  Integer.parseInt(request.getParameter("pid"));
  String bttn_value = request.getParameter("submit");
  String ardate[] = pend_request_date.split("-");

   if(ardate.length!=3)
     {
        response.sendRedirect("employee.jsp");
     }
  
  Statement st;
  
    try {

    java.util.Date date = new java.util.Date();
      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url+dbName,userName,password);
      System.out.println("Connected to the database");
    int j=0;
    int i=0;
    if(bttn_value.equals("Add"))
    {
    String query_1 = "insert into employee_details set eid='"+emp_id+"',first_name='"+first_name+"',
last_name='"+last_name+"'";
    out.println("query_1 " + query_1);
       out.println("<br>");
        st = conn.createStatement();
     i = st.executeUpdate(query_1);
       out.println("<br>");
out.println("i " + i);
      String query_2 =
 "insert into pend_requests set pend_request_status='"+request_status+"',
emp_id='"+emp_id+"',pend_request_type='"+pend_request_type+"',pend_request_date='"+pend_request_date+"',
pend_request_data='"+pend_request_data+"'";
        out.println("query_2 " + query_2);
         out.println("<br>");
        st = conn.createStatement();
     j = st.executeUpdate(query_2);
     response.sendRedirect("viewdata");
    }
    else if(bttn_value.equals("Update"))
    {
       java.util.Date now = new java.util.Date();
      String DATE_FORMAT = "yyyy-MM-dd hh:mm:ss";
       SimpleDateFormat sdf = new SimpleDateFormat(DATE_FORMAT);
 
  
    String strDateNew = sdf.format(now) ;
      
              String query_1 = 
"update  employee_details set first_name='"+first_name+"',last_name='"+last_name+"' 
where eid='"+emp_id+"'";
    out.println("query_1 " + query_1);
       out.println("<br>");
        st = conn.createStatement();
     i = st.executeUpdate(query_1);
       out.println("<br>");
out.println("i " + i);
      String query_2 = 
"update pend_requests set pend_request_status='"+request_status+"',
emp_id='"+emp_id+"',pend_request_type='"+pend_request_type+"',pend_request_date='"+pend_request_date+"',
pend_request_data='"+pend_request_data+"',respond_date='"+strDateNew+"'
 where pend_request_id="+pend_request_id+" and emp_id='"+emp_id+"'";
        out.println("query_2 " + query_2);
         out.println("<br>");
        st = conn.createStatement();
     j = st.executeUpdate(query_2);
     response.sendRedirect("viewdata");
    }
    
    

    
     
  //  pw.println(query);
    conn.close();
      System.out.println("Disconnected from database");
    } catch (Exception e) {
       response.sendRedirect("viewdata");
      e.printStackTrace();
    }
  }
}


Step 3:Source code of Servlet (viewdata.java) to retrieve the data.
 

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;

public class viewdata extends HttpServlet{ 
 
   public void doGet(HttpServletRequest request, HttpServletResponse response)
                                   throws ServletException,IOException{
    response.setContentType("text/html");
    PrintWriter pw = response.getWriter();

     System.out.println("MySQL Connect Example.");
    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";
  String respond_date="";
  Statement st;
  ArrayList arData=null;
  ArrayList arDataList=new ArrayList();
   HttpSession session=request.getSession(true);
    try {
      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url+dbName,userName,password);
      System.out.println("Connected to the database");
    String query = 
"SELECT p1.pend_request_id,p1.emp_id,p1.pend_request_type,p1.pend_request_date,
p1.pend_request_status,p1.pend_request_data,p2.first_name,p2.last_name,
p1.respond_date FROM pend_requests p1,employee_details p2 where p1.emp_id=p2.eid";
   
        st = conn.createStatement();
  
    ResultSet rs = st.executeQuery(query);
    
    while(rs.next())
    {
       arData=new  ArrayList();
      System.out.println(rs.getString(9));
       pw.println(rs.getString(9));
       if(rs.getString(9)==null)
      {
          respond_date = "Not Responding";
      }
      else
      {
        respond_date = rs.getString(9);
      }
      arData.add(rs.getInt(1));
      arData.add(rs.getString(2));
      arData.add(rs.getString(7));
      arData.add(rs.getString(8));
      arData.add(rs.getString(5));
      arData.add(rs.getString(3));
      arData.add(rs.getString(4));
      arData.add(respond_date);
    
        arDataList.add(arData);
    }
  
     pw.println("query4 " + query);
    pw.println("<br>");

     session.setAttribute("arDataList",arDataList);
pw.println("arData " + arData);
pw.println("<br>");
pw.println("arDataList " + arDataList);
pw.println("<br>");
pw.println("session "+ session.getAttribute("arDataList"));
pw.println("<br>");
     response.sendRedirect("viewdata.jsp");

    
     
  //  pw.println(query);
    conn.close();
      System.out.println("Disconnected from database");
    } catch (Exception e) {
    response.sendRedirect("viewdata.jsp");
      e.printStackTrace();
    }
  }
}


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.

 

Download the application

 

                         

» View all related tutorials
Related Tags: c ide orm table data form io make type column field name columns change this id nsis war tab row

Leave your comment:

Name:

Email:

URL:

Title:

Comments:

Enter Code:
Audio Version
Reload Image
 

Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted.

No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.
Add This Tutorial To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Training Courses
Tell A Friend
Your Friend Name
Software Solutions
Least Viewed
Most Rated
Recently Viewed
Search Tutorials

 

 
 

Home | JSP | EJB | JDBC | Java Servlets | WAP  | Free JSP Hosting  | Search Engine | News Archive | Jboss 3.0 tutorial | Free Linux CD's | Forum | Blogs

About Us | Advertising On RoseIndia.net  | Site Map

India News

Indian Software Development Company | iPhone Development Company in India | Flex Development Company in India | Java Training Delhi | Java Training at Noida |

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2008. All rights reserved.