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 msbct 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 subcatno = req.getParameter("subcatno");
    String subcatden = req.getParameter("subcatden");
    String querry="update subcat set den=\"" + subcatden + "\" where c2=" + subcatno;
    Statement stmt  = con.createStatement(); 
    stmt.executeUpdate(querry);
    stmt.close();
  }
  catch(SQLException e) {;}
  catch(Exception e) {;}
   
  RequestDispatcher rd = req.getRequestDispatcher("malct"); 
  rd.forward(req,res);	
}
}