import java.io.IOException;
import java.io.PrintStream;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class deletesupportteam extends HttpServlet
{

    public deletesupportteam()
    {
    }

    public void init(ServletConfig servletconfig)
        throws ServletException
    {
        super.init(servletconfig);
        try
        {
            System.out.println("inside try");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:ecare","ecare","ecare");
//Class.forName("oracle.jdbc.driver.OracleDriver");
  //con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:project","ecare","ecare");
  st=con.createStatement();
            System.out.println("statement is created");
        }
        catch(Exception exception)
        {
            System.out.println(exception);
        }
    }

    public void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)
        throws ServletException, IOException
    {
        String s = "";
        String s1 = "";
        String s2 = "";
        String s3 = "";
        String s4 = "";
        String s5 = "";
        String s6 = "";
        String s7 = "";
        java.io.PrintWriter printwriter = httpservletresponse.getWriter();
        httpservletresponse.setContentType("text/html");
        String s8 = httpservletrequest.getParameter("s");
        System.out.println("Support team id is " + s8);
        String s9 = httpservletrequest.getParameter("m");
        System.out.println("Module code is " + s9);
        String s10 = httpservletrequest.getParameter("c");
        System.out.println("Category code is " + s10);
        String s11 = httpservletrequest.getParameter("n");
        System.out.println("Support team name is " + s11);
        System.out.println("before try");
        System.out.println("Code is " + s);
        System.out.println("Code is " + s1);
        System.out.println("Name is " + s2);
        System.out.println("status is " + s3);
        try
        {
            int i = st.executeUpdate("delete from supportteam where supportid='" + s8 + "'");
            System.out.println("deleted:" + i);
            httpservletresponse.sendRedirect("./categories");
        }
        catch(Exception exception)
        {
            System.out.println(exception);
        }
    }
Connection con;
Statement st;
    ResultSet rs;
}