Java Servlet Programing Laungage

Java Servlet Projects

Servlet Project 3

Java Servlet :Deleting data from table by name
Previous Home Next

This example shows you how to delete the data from the database table by providing the unique name using the JDBC and servlet.

index.html

<html>
	<head>
	 <title>Delete Data from database by Name </title>
	</head>
	<body>
	 <form action="del" method="get">
	 UserName<input type="text" name="txtName"><br>
	 <input type="submit" value="delete"><br>
	 </form>
	 </body>
</html>

 

web.xml

<web-app>
	<servlet>
	 <servlet-name>s1</servlet-name>
	 <servlet-class>Delete</servlet-class>
	</servlet>
	<servlet-mapping>
	 <servlet-name>s1</servlet-name>
	 <url-pattern>del</url-pattern>
	</servlet-mapping>
</web-app>

Delete.java

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class Delete extends HttpServlet
{
  public void doGet(HttpServletRequest request,
	HttpServletResponse response)throws 
	     ServletException,IOException
  {
   response.setContentType("text/html");
   PrintWriter out=response.getWriter();
   String name=request.getParameter("txtName");
   try
   {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection con=DriverManager.getConnection
		("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");	
    PreparedStatement stmt=con.prepareStatement("delete from emp where name=?");
    stmt.setString(1, name);
	int i=stmt.executeUpdate();
    if(i!=0)
    out.println("<b>You are successfully deleted</b>");
    con.close();
    }
    catch(Exception e)
   {
    out.println("<b> failed</b>"); 
    out.println("<b>Error:</b>" +e);
   }
 }
}

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback:
Previous Home Next