import java.io.*;
import java.util.*;
import java.util.Date;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.http.*;
import javax.servlet.http.HttpSession;

public class stsct extends HttpServlet{  
public void doPost(HttpServletRequest req, HttpServletResponse res)
  throws ServletException, IOException {
  doGet(req,res);
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
  throws ServletException, IOException {
res.setContentType("text/html");
  HttpSession ses = req.getSession();
  Connection con=(Connection) ses.getAttribute("connexion");
  try {   
    //se sterge subcategoria   
    String subcat = req.getParameter("subcat");
    Statement stmt  = con.createStatement(); 
    ResultSet rs; 
     rs = stmt.executeQuery("select count(codp)from alimente where cat=" + subcat);
     if(rs.getString(1).equals("0")){
       rs.close();
       stmt.executeUpdate("delete from subcat where c2=" + subcat);
     }
     else
        rs.close();
      stmt.close();
  }
  catch(SQLException e) {;}
  catch(Exception e) {;}
  RequestDispatcher rd = req.getRequestDispatcher("stect"); 
  rd.forward(req,res);	
}
}