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 insct 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 extrage categoria si subcategoria   
    String cat = (String)ses.getAttribute("cat");
    String subcat = req.getParameter("subcat");
    Statement stmt  = con.createStatement(); 
    ResultSet rs; 
    rs = stmt.executeQuery("select count(c2)+1 from subcat");
    stmt.executeUpdate("insert into subcat values(" + cat + "," + rs.getString(1) + ",\"" + subcat + "\")");
    rs.close();stmt.close();
  }
  catch(SQLException e) {;}
  catch(Exception e) {;}
   
  RequestDispatcher rd = req.getRequestDispatcher("edcat"); 
  rd.forward(req,res);	
}
}