|
|
10.5.16 Servlet comen.java
Acest servlet listeaza comenzile realizate de catre clienti pentru o anumita zi. La inceput, cand nu este selectata ziua, utilizatorul are la dispozitie trei casute de editare pentru a specifica anul, luna si ziua comenzilor pe care doreste sa le vada. El mai poate sa aleaga deasemenea tipul\starea comenzzilor care vor fi afisate. Comenzile pot fi in una din urmatoarele grupe: "Noi", "Vazute", "In curs", "Realizate", "Anulate". Comenziile sunt listate incepand cu campul codc, care este in acelasi timp buton de selectie al comenzii. Urmeaza contul utilizatorului, cerintele de realizare in limita a treizeci de caractere si timpul la care a fost efectuata comanda de catre client.
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.*;
import java.util.Date;
public class comen 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");
String url1 = res.encodeURL("/adi/servlet/opcom");
String temp;
String an;
String luna;
String zi;
String tip;
boolean vb=true;
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
out.println("<head>");
out.println("<title> Pagina realizata cu servlet-ul comen" + "</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("<LINK href=\"/adi/tli.css\" rel=STYLESHEET type=text/css>");
out.println("<META content=\"MSHTML 5.00.2614.3500\" name=GENERATOR>");
out.println("<SCRIPT language=JavaScript1.1 src=\"/adi/Scriptj.js\"></SCRIPT>");
out.println("<script>");
out.println("function validateInfo(form)");
out.println("{ return (");
out.println("checkDate(form.elements[\"an\"],form.elements[\"luna\"],
form.elements[\"zi\"],sDateComenzi)");
out.println(" )");
out.println("}");
out.println("</script>");
out.println("</head>");
out.println("<body>");
String name = (String)ses.getAttribute("username");
out.println("<Center>" + name.toUpperCase() + "<br></Center>");
out.println("<form action=\"" + url1 + "\"method=\"post\">");
out.println("<table cellspacing=\"5\" width=\"700\">");
String rol =(String)ses.getAttribute("rol");
if(rol!=null && rol.equals("1")){
out.println("<tr><td width=550 align=\"left\" valign=middle>");
out.println("<input type=\"submit\" name=admin value=\"Administrare\">");
out.println("</td><tr>");
}
out.println("<tr>");
out.println("<td width=550 align=\"center\" valign=middle>");
an=req.getParameter("an");
if(an==null){an="";vb=false;}
out.println("An: <input type=\"text\" name=an size=4 value=" + an + "> ");
luna=req.getParameter("luna");
if(luna==null){luna=""; vb=false;}
out.println("Luna: <input type=\"text\" name=luna size=2 value=" + luna + "> ");
zi=req.getParameter("zi");
if(zi==null){zi="";vb=false;}
out.println("Zi: <input type=\"text\" name=zi size=2 value=" + zi + "> ");
tip=req.getParameter("tip");
if(tip==null){tip="";}
out.println("</tr><tr>");
out.println("<td width=650 align=\"center\" valign=middle>");
out.println("<table cellspacing=\"5\" width=\"550\">");
out.println("<td align=\"left\" valign=middle>");
out.println("<font color=ff00f size=3 face=Arial>");
out.println(" Noi ");
if(tip.equals("0"))
out.println("<input type=\"radio\" name=tip value=0 checked>");
else
out.println("<input type=\"radio\" name=tip value=0 >");
out.println("<td align=\"left\" valign=middle>");
out.println("<font color=7f228f size=3 face=Arial>");
out.println(" Vazute ");
if(tip.equals("1"))
out.println("<input type=\"radio\" name=tip value=1 checked>");
else
out.println("<input type=\"radio\" name=tip value=1 >");
out.println("<td align=\"left\" valign=middle>");
out.println("<font color=0000ff size=3 face=Arial>");
out.println(" In curs ");
if(tip.equals("2"))
out.println("<input type=\"radio\" name=tip value=2 checked>");
else
out.println("<input type=\"radio\" name=tip value=2 >");
out.println("<td align=\"left\" valign=middle>");
out.println("<font color=ff0000 size=3 face=Arial>");
out.println(" Realizate ");
if(tip.equals("3"))
out.println("<input type=\"radio\" name=tip value=3 checked>");
else
out.println("<input type=\"radio\" name=tip value=3 >");
out.println("<td align=\"left\" valign=middle>");
out.println("<font color=00ff00 size=3 face=Arial>");
out.println(" Anulate ");
if(tip.equals("4"))
out.println("<input type=\"radio\" name=tip value=4 checked>");
else
out.println("<input type=\"radio\" name=tip value=4 >");
out.println("<td align=\"left\" valign=middle>");
out.println(" Toate ");
out.println("<input type=\"radio\" name=tip value=\"\">");
out.println("</table></tr><tr>");
out.println("<td width=550 align=\"center\" valign=middle>");
out.println("<INPUT name=cauta type=button value=Cauta onclick=\" if(validateInfo(this.form))
this.form.submit();\">");
out.println("</td></tr>");
out.println("</table>");
out.println("<table border=1 width=\"700\" bordercolor=333222>");
out.println("<th>Cod<th>Cont<th>Cerinte<th>h:m:s");
if(vb==true){
try {
Statement stmt;
ResultSet rs;
String querry;
stmt=con.createStatement();
if(an.substring(0,1).equals("0")) an=an.substring(1,an.length());
if(luna.substring(0,1).equals("0")) luna=luna.substring(1,luna.length());
if(zi.substring(0,1).equals("0")) zi=zi.substring(1,zi.length());
temp=tip;
if(!temp.equals(""))
temp=" and tip=" + tip;
querry = "select *, FROM_UNIXTIME(substring(codc,1,length(codc)-3),\"%H:%i:%S\")"
+ "from comenzi where " + "\"" + an + "-" + luna + "-" + zi + "\""
+ "=FROM_UNIXTIME(substring(codc,1,length(codc)-3),\"%Y-%c-%e\")" + temp;
//out.println(querry);
rs = stmt.executeQuery(querry);
while(rs.next()){
out.println("<tr>");
temp="00ffff";
if(rs.getString(4).equals("0"))
temp="ff00ff";
if(rs.getString(4).equals("1"))
temp="7f228f";
if(rs.getString(4).equals("2"))
temp="0000ff";
if(rs.getString(4).equals("3"))
temp="ff0000";
if(rs.getString(4).equals("4"))
temp="00ff00";
out.println("<td width=50 align=\"center\" valign=middle>");
out.println("<font color=" + temp +" size=3 face=Arial>");
out.println("<input type=submit name=comnd value=\"" + rs.getString(1) + "\">");
out.println("<td width=130 align=\"center\" valign=middle>");
out.println("<font color=" + temp +" size=3 face=Arial>");
out.println(rs.getString(2));
out.println("<td width=200 align=\"left\" valign=middle>");
out.println("<font color=" + temp +" size=3 face=Arial>");
querry=rs.getString(3); querry=querry.replace('\n',' ');
querry=querry.replace('\r',' ');querry=querry.replace('\t',' ');
if(querry.length()>30)
out.println(querry.substring(0,30) );
else
out.println(querry);
out.println(" ");
out.println("<td width=100 align=\"left\" valign=middle>");
out.println("<font color=" + temp +" size=3 face=Arial>");
out.println(rs.getString(5));
out.println("</font>");
out.println("</tr>");
}
}
catch(SQLException e) {;}
}
out.println("</table>");
out.println("</form>");
out.println("</body></html>");
out.close();
}
}
|
|
