Java Servlet Programing Laungage

Java Servlet Projects

Servlet Project 3

adplus-dvertising
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);
   }
 }
}
Previous Home Next