import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class DeleteServlet extends HttpServlet {
/**Process the HTTP Get request*/
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException {
int recordAffected = 0;
try {
String id = request.getParameter("id");
String sql = "DELETE FROM Users WHERE Id=" + id;
Connection con =
DriverManager.getConnection("jdbc:odbc:JavaWeb");
Statement s = con.createStatement();
recordAffected = s.executeUpdate(sql);
s.close();
con.close();
}
catch (SQLException e) {
}
catch (Exception e) {
}
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("");
out.println("");
out.println("Deleting A Record");
out.println("");
out.println("");
out.println("");
if (recordAffected==1)
out.println("Record deleted.
");
else
out.println("Error deleting record.
");
out.println("Go back to the Search page");
}
}