|
|
10.4.9 Servlet plata.java
In situatia in care datele clientului sau confirmat (exista contul si parola furnizate) atunci acest servlet este chemat si el listeaza inca o data produsele din cosul de alimente, fara descriere, cu cantitatile alese, fara posibilitatea de a face modificari. In schimb clientul poate sa aleaga intre a anula comanda si a accepta comanda cosului de produse.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.http.HttpSession;
import java.util.*;
public class plata 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/comnd");
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("<META content=\"MSHTML 5.00.2614.3500\" name=GENERATOR>");
out.println("<head>");
out.println("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
out.println("<LINK href=\"/adi/tli.css\" rel=STYLESHEET type=text/css>");
out.println("<SCRIPT language=JavaScript1.1 src=\"/adi/Scriptj.js\"></SCRIPT>");
out.println("<title> Pagina realizata de servlet-ul cosal</title>");
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>");
temp=req.getParameter("cont");
if(temp==null) temp="";
out.println("<input type=\"hidden\" name=\"cont\" value=\"" + temp + "\">");
temp=req.getParameter("cercom");
if(temp==null) temp="";
out.println("<input type=\"hidden\" name=\"cercom\" value=\"" + temp + "\">");
out.println("<table cellspacing=\"5\" width=\"750\" align=left>"); //linii
try{
Statement stmt;
ResultSet rs;
stmt = con.createStatement();
String querry="select * from clienti where codf=\"" + req.getParameter("cont") + "\"";
rs = stmt.executeQuery(querry);
out.println("<tr><td>Comanda " + rs.getString(4) + " " + rs.getString(3) + "</td></tr>");
rs.close();stmt.close();
}
catch(SQLException h){;}
//1
out.println("<tr><td>");
out.println("<table cellspacing=\"5\" width=\"500\">"); //coloane
out.println("<tr><td width=50% align=\"left\">");
out.println("<input type=\"submit\" name=\"anul\" value=\"Anulare comanda\">");
out.println("</td><td width=50% align=right>");
out.println("<input type=\"submit\" name=\"acce\" value=\"Accept comanda\">");
out.println("</td></tr>");
out.println("</table>");
out.println("</tr></td>");
//2
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;
out.println("<tr><td width=650>");
out.println("<table width=\"650\" border=1 bordercolor=123456>");
out.println("<CAPTION ALIGN=CENTER VALIGN=TOP>Produse comandate</CAPTION>");
out.println("<TH>Denumire<TH>UM<TH>PretU<TH>Cant<TH>Valoare</TH>");
out.println("<font face=\"Arial\" color=\"#500000\" size=3>");
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.IntS()!=-1){
pc.setcant(valp.getS());
Halcos.put(codp,pc);
}
if(!pc.getcant().equals("0") && !pc.getcant().equals("")){
out.println("<tr>");
out.println("<td width=400 align=left>");
out.println("<b>" + rs.getString(2) + "</b>");
out.println("<td width=40 align=left >");
out.println("<b>" + rs.getString(4) + "</b>");
out.println("<td width=40 align=left >");
out.println("<b>" + rs.getString(3) + "</b>");
out.println("<td width=40 align=left >");
out.println("<b>" + pc.getcant() + "</b>");
out.println("<td width=100 align=left>");
val=Integer.parseInt(rs.getString(3))*Integer.parseInt(pc.getcant());
total=total+val;
out.println("<b>" + val + "</b>");
out.println("</tr>");
}
rs.close();
}
}//end while
stmt.close();
out.println("</table>");
out.println("<tr><td width=450 align=right>");
out.println("Total: <b>" + total + "</b></font></td></tr>");
out.println("</font>");
out.println("<tr><td width=450 align=left><hr width=450 color=\"#fdddbf\"
align=left></td></tr>");
out.println("<tr><td>");
out.println("<table cellspacing=\"5\" width=\"500\">"); //coloane
out.println("<tr><td width=50% align=\"left\">");
out.println("<input type=\"submit\" name=\"anul\" value=\"Anulare comanda\">");
out.println("</td><td width=50% align=right>");
out.println("<input type=\"submit\" name=\"acce\" value=\"Accept comanda\">");
out.println("</td></tr>");
out.println("</table>");
out.println("</tr></td>");
}
catch(SQLException f) { out.println("An SQL Exception was thrown.");}
catch(Exception e) { e.printStackTrace(out); }
}
out.println("</table>");
out.println("</form>");
out.println("</body></html>");
out.close();
}
}
|
|
