|
       10.5.24 Servlet stect.java
       Daca s-a selectat operatia de stergere acest servlet fuenizeaza o lista cu subcategoriile din categoria selectata, asociindu-le un buton radio pentru selectia subcategoriei care se va sterge. Nu se pot sterge subcategorii care contin inca produse. Pentru a le sterge mai intai trebuie sterse produsele din subcategorie. Utilizatorul poate sa aleaga optiunea de stergere sau sa se intoarca din nou la pagina cu categorii.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.http.*;
import javax.servlet.http.HttpSession;
import java.util.*;
public class stect 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");
PrintWriter out = res.getWriter ();
String url1 = res.encodeURL("/adi/servlet/stsct");
String url2 = res.encodeURL("/adi/servlet/categ");
out.println("<html>");
out.println("<head>");
out.println("<title>Pagina realizata de servlet-ul stect</title>");
out.println("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">");
out.println("<META content=\"text/html; charset=windows-1252\" http-equiv=Content-Type>");
out.println("<LINK href=\"/adi/tli.css\" rel=STYLESHEET type=text/css>");
out.println("<META content=\"MSHTML 5.00.2614.3500\" name=GENERATOR>");
out.println("</head>");
out.println("<body>");
out.println("<font size = 1 ><b><blink> ! </blink></b>Pentru a se sterge o subcategorie ea nu
terbuie sa contina produse</font>");
out.println("<table cellspacing=\"5\" width=\"750\">");
out.println("<td width=750 align=center valign=middle>");
out.println("<tr>");
out.println("<form method=post action=" + url2 + ">");
out.println("<td width=750 align=\"center\"><input type=submit value=Categorii><br><br></td>");
out.println("</form></tr>");
out.println("<form method=post action=" + url1 + ">");
out.println("<tr>");
out.println("<td width=750 align=\"center\"><input type=submit value=Sterge><br><hr></td>");
out.println("</tr>");
out.println("<tr><td width=750 align=center valign=middle>");
out.println("<table width=750 cellspacing=7>");
out.println("<td width=250></td><td width=350 valign=middle align=center>");
out.println("<table cellspacing=7 width=350>");
out.println("<tr><th>Subcategorii<th> <th>prod.</tr>");
try{
String cat=(String)ses.getAttribute("cat");
Statement stmt = con.createStatement();
Statement stmt2 = con.createStatement();
ResultSet rs;
rs = stmt.executeQuery("select * from subcat where c1=" + cat + " order by c2");
while(rs.next()){
ResultSet rs2 = stmt2.executeQuery("select count(codp) from alimente where cat=" +
rs.getString(2));
out.println("<tr><td width=330 align=center> " + rs.getString(2)+ ". " + rs.getString(3) + "
</td>");
out.println("<td valign=middle align=left><input type=radio name=\"subcat\" value="+
rs.getString(2) + "></td>");
out.println("<td valign=middle align=right width=20>" + rs2.getString(1));
out.println("</td></tr>");
rs2.close();
}
rs.close();stmt.close();stmt2.close();
}
catch(SQLException e) {out.println("An SQL Exception was thrown.");}
out.println("</table>");
out.println("</td><td width=150></td>");
out.println("</table></td></tr>");
out.println("<tr>");
out.println("<td width=750 align=\"center\"><hr><br><input type=submit value=Sterge></td>");
out.println("</tr>");
out.println("</td></table></form>");
out.println("</body></html>");
out.close();
}
}
|
|