|
|
10.5.18 Servlet comcl.java
Acet servlet afiseaza comanda aleasa. In primul rand utilizatorul poate sa schimbe starea comenzii. Sunt listate datele comenzii(codc, data, cerinte), datele clientului complete, lista de produse din comanda.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.http.HttpSession;
import java.util.*;
public class comcl 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/stcom");
String temp;
out.println("<html>");
out.println("<head>");
out.println("<title> Pagina realizata de servlet-ul cosal</title>");
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("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
out.println("<LINK href=\"/adi/tli.css\" rel=STYLESHEET type=text/css>");
out.println("</head>");
out.println("<body bgcolor=\"#fff0f0\" link=#ffffff vlink=#ffffff alink=#ffffff>");
out.println("<form action=\"" + url1 + "\" method=\"post\" name=view>");
temp=req.getParameter("an"); if(temp==null) temp="";
out.println("<input type=\"hidden\" name=\"an\" value=\"" + temp + "\">");
temp=req.getParameter("luna"); if(temp==null) temp="";
out.println("<input type=\"hidden\" name=\"luna\" value=\"" + temp + "\">");
temp=req.getParameter("zi"); if(temp==null) temp="";
out.println("<input type=\"hidden\" name=\"zi\" value=\"" + temp + "\">");
temp=req.getParameter("tip"); if(temp==null) temp="";
out.println("<input type=\"hidden\" name=\"tip\" value=\"" + temp + "\">");
out.println("<table cellspacing=\"5\" width=\"750\" align=left>"); //linii
try{
Statement stmt;
ResultSet rs;
stmt = con.createStatement();
String querry, tip, codf, codc;
codc=req.getParameter("comnd");
querry = "select *,FROM_UNIXTIME(substring(codc,1,length(codc)-3),\"%Y-%c-%e
%H:%i:%S\")"
+ "from comenzi where codc=" + codc;
rs = stmt.executeQuery(querry);
out.println("<tr><td>Comanda: " + codc + " Data: " + rs.getString(5) +
"<br>Cerinta: " + rs.getString(3) + "</td></tr>");
tip=rs.getString(4);
out.println("<tr><td width=450 align=left><hr width=450 color=\"#fdddbf\"
align=left></td></tr>");
out.println("<tr><td width=550 align=\"center\" valign=middle>");
out.println("<table cellspacing=\"5\" width=\"550\">");
out.println("<td align=\"center\" valign=middle width=110>");
out.println("<font color=ff00f size=3 face=Arial>");
out.println(" Noi ");
if(tip.equals("0"))
out.println("<input type=\"radio\" name=tipc value=0 checked>");
else
out.println("<input type=\"radio\" name=tipc value=0 >");
out.println("<td align=\"left\" valign=middle width=110>");
out.println("<font color=7f228f size=3 face=Arial>");
out.println(" Vazute ");
if(tip.equals("1"))
out.println("<input type=\"radio\" name=tipc value=1 checked>");
else
out.println("<input type=\"radio\" name=tipc value=1 >");
out.println("<td align=\"left\" valign=middle width=110>");
out.println("<font color=0000ff size=3 face=Arial>");
out.println(" In curs ");
if(tip.equals("2"))
out.println("<input type=\"radio\" name=tipc value=2 checked>");
else
out.println("<input type=\"radio\" name=tipc value=2 >");
out.println("<td align=\"left\" valign=middle width=110>");
out.println("<font color=ff0000 size=3 face=Arial>");
out.println(" Realizate ");
if(tip.equals("3"))
out.println("<input type=\"radio\" name=tipc value=3 checked>");
else
out.println("<input type=\"radio\" name=tipc value=3 >");
out.println("<td align=\"left\" valign=middle width=110>");
out.println("<font color=00ff00 size=3 face=Arial>");
out.println(" Anulate ");
if(tip.equals("4"))
out.println("<input type=\"radio\" name=tipc value=4 checked>");
else
out.println("<input type=\"radio\" name=tipc value=4 >");
out.println("</table>");
out.println("</td></tr>");
out.println("<tr><td align=\"center\" valign=middle width=550>");
out.println("<input type=\"hidden\" name=sctip value=\"" + codc + "\">");
out.println("<input type=\"submit\" name=go value=\"Schimba stare\">");
out.println("</td></tr>");
out.println("</form>");
out.println("<tr><td width=450 align=left><hr width=450 color=\"#fdddbf\" align=left></td></tr>");
codf=rs.getString(2);
rs.close();
querry = "select * from clienti where codf=\"" + codf + "\"";
//out.println("<tr><td>" + querry + "</td></tr>");
rs = stmt.executeQuery(querry);
out.println("<tr><td>Cont: " +codf + " Nume: " + rs.getString(3) +
" Prenume: " + rs.getString(4) + " Nascut: " + rs.getString(13) +
" Sex: " + rs.getString(17) + "<br> Ocupatie: " + rs.getString(5) +
" Firma: " + rs.getString(6) + " Adresa: " + rs.getString(7) +
" Oras: " + rs.getString(8) + "<br> Telmob: " + rs.getString(9) +
" Telfix: " + rs.getString(10) + " Fax: " + rs.getString(11) +
" E-mail: " + rs.getString(12) + "<br> Tip c.c.: " + rs.getString(14) +
" Numar c.c.:" + rs.getString(15) + "Expira la: " + rs.getString(16) +
" </td></tr>");
rs.close();
out.println("<tr><td width=450 align=left><hr width=450 color=\"#fdddbf\" align=left></td></tr>");
out.println("<tr><td width=750>");
out.println("<table width=\"750\" 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>");
querry = "select ac.*,a.* from alim_com ac, alimente a where ac.codc=" + codc +
" and a.codp=ac.codp" ;
//out.println("<tr><td width=400 align=left><b>"+querry+"</b></tr>");
rs = stmt.executeQuery(querry);
int total=0;
while(rs.next()) {
String codp = rs.getString(2);
int cant = Integer.parseInt(rs.getString(3));
int val;
out.println("<tr>");
out.println("<td width=400 align=left>");
out.println("<b>" + rs.getString(5) + "</b>");
out.println("<td width=110 align=right >");
out.println("<b>" + rs.getString(7) + "</b>");
out.println("<td width=90 align=right >");
out.println("<b>" + rs.getString(6) + "</b>");
out.println("<td width=40 align=right >");
out.println("<b>" + cant + "</b>");
out.println("<td width=90 align=right>");
val=Integer.parseInt(rs.getString(6))*cant;
total=total+val;
out.println("<b>" + val + "</b>");
out.println("</tr>");
}//end while
rs.close();stmt.close();
out.println("</table>");
out.println("</td></tr>");
out.println("<tr><td width=450 align=right>");
out.println("Total: <b>" + total + "</b></font></td></tr>");
out.println("</font>");
}
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();
}
}
|
|
