<!--delete.jsp-->
<!--remove a row from the table named register -->


<%@ page import="java.sql.*" %>
<%
   String user = (String)session.getAttribute("user");
   String passwd = (String)session.getAttribute("passwd");

   Connection conn = null;
   try
   {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

      conn = DriverManager.getConnection("jdbc:odbc:orcl",user,passwd);

      String name = request.getParameter("name");

      Statement stmt = conn.createStatement();

      int rows = stmt.executeUpdate("DELETE FROM REGISTER WHERE NAME='"+name+"'");
      if (rows == 1)
          out.println("Deleted.");
      else
          out.println("Not deleted!");     
      stmt.close();
      conn.close();
 
   }  // end try
   catch(Exception e)
   {
	out.println(e);
   }

%>