|
|
10.5.20 Servlet categ.java
Acest servlet este apelat de utilizatorii cu rol de administrator sau de vanzator. El listeaza toate categoriile si permite alegerea unei singure, la un moment dat, prin folosirea de butoane radio. Utilizatorul trebuie deasemenea sa aleaga o operatie: stergere, modificare sau adaugare. In cazul in care utilizatorul are rol de administrator atunci el se poate intoarce la pagina generata de servlet-ul admin.java.
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 categ 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 url = res.encodeURL("/adi/servlet/opcat");
out.println("<html>");
out.println("<head>");
out.println("<title>Pagina realizata de servlet-ul categ</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>");
String name = (String)ses.getAttribute("username");
out.println("<b>" + name.toUpperCase() + "<br></b>");
out.println("<form method=post action=" + url + ">");
out.println("<table cellspacing=\"5\" width=\"750\">");
out.println("<td width=750 align=center valign=middle>");
String rol =(String)ses.getAttribute("rol");
if(rol!=null && rol.equals("1")){
out.println("<tr><td align=left width=750>");
out.println("<input type=\"submit\" name=admin value=\"Administrare\"></br>");
out.println("</td></tr>");
}
out.println("<tr><td align=center width=750>");
out.println("<input type=submit value=Intrare><hr><b>Alegeti operatia: <br></b>");
out.println("Inserare <input type=radio name=op value=ins >");
out.println(" Modificare <input type=radio name=op value=mod >");
out.println(" Stergere <input type=radio name=op value=ste ><br>");
out.println("</td></tr>");
out.println("<tr>");
out.println("<td width=750 valign=middle align=\"center\"><b>Alegeti categoria:</b></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=750 valign=middle align=center>");
out.println("<table cellspacing=7 width=750>");
try{
Statement stmt = con.createStatement();
ResultSet rs;
rs = stmt.executeQuery("select * from categ order by cod");
while(rs.next()){
out.println("<tr><td width=200 align=center></td>");
out.println("<td width=400 align=center>" + rs.getString(1)+ ". " + rs.getString(2) + "</td>");
out.println("<td valign=middle width=50 align=left><input type=radio name=\"cat\" value="+
rs.getString(1) + ">" );
out.println("<td width=150 align=center></td>");
out.println("</td></tr>");
}
rs.close();stmt.close();
}
catch(SQLException e) {out.println("An SQL Exception was thrown.");}
out.println("</table>");
out.println("</table>");
out.println("</td></tr>");
out.println("<tr>");
out.println("<td width=750 align=\"center\"><hr><br><input type=submit value=Intrare></td>");
out.println("</tr></td>");
out.println("</td></table></form>");
out.println("</body></html>");
out.close();
}
}
|
|
