|
|
10.4.7 Servlet cosal.java
Dupa ce si-a umplut cosul de alimente clientul va apasa pe butonul-imagine "cos alimente" pentru a intra in procedura de achizitie. Acest servlet listeaza produsele existente in cosul de alimente, adaugand in dreapta fiecarui produs o casuta text, editabila, pentru specificarea cantitatii. Pentru a se scoate un produs din cos este suficient sa se puna cantitatea acestuia pe valoarea 0. In coltul din stanga sus este un buton pentru actualizarea modificarilor facute, fie pentru modificarile cantitatiilor, fie pentru a se lista si produsele adaugate recent. In partea dreapta a ferestrei servlet-ul cosal.java furnizeaza clientului doua casute text pentru a-si introduce datele personale (nume cont si parola) si o casuta text in care acesta poate sa introduca cerinte pentru comanda pe care o realizeaza. Daca clientul este pentru prima data navigator al magazinului sau nu si-a introdus inca datele personale si, deci, nu are inca un cont, atunci el este trimis catre servlet-ul usrlg, prin link-ul "client nou".
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.http.HttpSession;
import java.util.*;
public class cosal 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 {
PrintWriter out=null;
try{
out = res.getWriter();
}
catch(IOException e) {;}
res.setContentType("text/html");
HttpSession ses = req.getSession();
Connection con = (Connection)ses.getAttribute("connexion");
//Pastrarea contextului folosind tehnica URL
String url1 = res.encodeURL("/adi/servlet/opcos");
String temp;
out.println("<html>");
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("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
out.println("<head>");
out.println("<title> Pagina realizata de servlet-ul cosal</title>");
out.println("<SCRIPT language=JavaScript1.1 src=\"/adi/Scriptj.js\"></SCRIPT>");
out.println("</head>");
out.println("<body bgcolor=\"#fff0f0\" link=#ffffff vlink=#ffffff alink=#ffffff>");
Hashtable Halcos = new Hashtable();
Halcos = (Hashtable)ses.getAttribute("cosal");
out.println("<form action=\"" + url1 + "\" method=\"post\" name=view>");
out.println("<table cellspacing=\"5\" width=\"750\" align=left>");
out.println("<tr><td width=\"550\" >");
out.println("<table cellspacing=\"5\" width=\"550\" align=left>");
out.println("<tr><td>");
out.println("<table cellspacing=\"5\" width=\"500\">");
out.println("<tr><td width=50% align=\"left\">");
out.println("<input type=\"submit\" name=\"modif\" value=\"Actualizare\">");
out.println("</td><td width=50% align=right>");
out.println(" ");
out.println("</td></tr>");
out.println("</table>");
out.println("</tr></td>");
out.println("<tr><td width=450 align=left><hr width=450 color=\"#fdddbf\" align=left></td></tr>");
if(Halcos!=null){
Enumeration produse = Halcos.keys();
try {
Statement stmt;
ResultSet rs=null;
stmt = con.createStatement();
int total=0;
int val=0;
while(produse.hasMoreElements()) {
String codp = (String)produse.nextElement();
prodcos pc = (prodcos)Halcos.get(codp);
rs = stmt.executeQuery("select * from alimente where codp="
+ codp + " and cat=" + pc.getcat());
if(rs.getString(1)!=null){
stoi valp = new stoi(req.getParameter(codp));
if(valp.getS()!=null && valp.getS().length()<5 && valp.IntS()!=-1){
pc.setcant(valp.getS());
Halcos.put(codp,pc);
}
if(!pc.getcant().equals("0") && !pc.getcant().equals("")){
out.println("<tr><td width=500>");
out.println("<table cellspacing=\"5\" width=\"500\">");
out.println("<tr>");
out.println("<td width=300 align=left >");
out.println("<font face=\"Arial\" color=\"#500000\" size=3><b>" + rs.getString(2) +
"</b></font>");
if(rs.getString(7)!=null && !rs.getString(7).equals("")){
out.println("<br>");
out.println("<font face=\"Arial\" color=\"#904040\" size=3>" + rs.getString(7) + "</font>");
}
out.println("<font face=\"Arial\" color=\"#903000\" size=3><br>Pret ");
out.println("<b>" + rs.getString(3) + "</b> pe <b>" + rs.getString(4) + "</b></font>");
out.println("</td>");
out.println("<td width=100 align=center valign=middle>");
out.println("<font face=\"Arial\" color=\"#903000\" size=1>");
out.println("Cantitate: <input type=\"text\" size=9 name=\"" + codp + "\" value=\"" +
pc.getcant() + "\">");
out.println("</font></td>");
out.println("<td width=100 align=center valign=middle>");
out.println("<font face=\"Arial\" color=\"#903000\" size=1>");
out.println("valoare: ");
out.println("</font>");
val=Integer.parseInt(rs.getString(3))*Integer.parseInt(pc.getcant());
total=total+val;
out.println("<font face=\"Arial\" color=\"#903000\" size=2>");
out.println("<b>" + val + "</b>");
out.println("</font></td>");
out.println("<td></td>");
out.println("</tr></table>");
out.println("</td></tr>");
out.println("<tr><td width=450 align=left><hr width=450 color=\"#fdddbf\"
align=left></td></tr>");
}
}
rs.close();
}
stmt.close();
out.println("<tr><td width=450 align=right>");
out.println("<font face=\"Arial\" color=\"#903000\" size=2>");
out.println("Total: <b>" + total + "</b></font></td></tr>");
out.println("<tr><td>");
out.println("<table cellspacing=\"5\" width=\"500\">");
out.println("<tr><td width=50% align=\"left\">");
out.println("<input type=\"submit\" name=\"modif\" value=\"Actualizare\">");
out.println("</td><td width=50% align=right>");
out.println(" ");
out.println("</td></tr>");
out.println("</table>");
out.println("</td></tr>");
}
catch(SQLException f) { out.println("An SQL Exception was thrown.");}
catch(Exception e) { e.printStackTrace(out); }
}
out.println("</table>");
out.println("</td>");
out.println("<td width=200 bgcolor=efefef valign=top align=left>");
out.println("<a href=\"" + url1 + "?unou=unou\">Client nou</a><br><hr><br>");
out.println("<input type=\"submit\" name=plata value=Comanda><br>");
out.println("<font face=\"Arial\" color=\"#103050\" size=3>");
out.println("Cont:<br>");
temp=req.getParameter("cont");
if(temp==null) temp="";
out.println("<input type=\"text\" name=cont size=20 value=\"" + temp + "\"><br>");
out.println("Parola:<br>");
out.println("<input type=\"password\" name=pass size=20 ><br><br>");
out.println("</font>");
out.println("Cerinte comanda:<br>");
temp=req.getParameter("cercom");
if(temp==null) temp="";
out.println("<TEXTAREA cols=30 name=cercom rows=4 >" + temp + "</TEXTAREA>");
out.println("</td>");
out.println("</tr>");
out.println("</table>");
out.println("</form>");
out.println("</body></html>");
out.close();
}
}
|
|
