|
|
10.5.7 Servlet insed.java
Daca operatia solicitata de utilizator este cea de inserare atunci parametrii cererii sunt trimisi la servlet-ul inser. Acesta ii ofera utilizatorului posibilitatea de a se intoarce la alegerea unei subcategorii si a unei operatii sau sa valideze datele pe care le introduce. Utilizatorul poate completa simultan pana la 3 produse noi, carora le poate pune aceeasi imagine sau imagini diferite (upload). Suma in ko a dimensiunilor imaginilor luate in ansamblu nu trebuie sa depaseasca 15ko. Campurile care pot fi completate sunt: denumire, unitate de masura, pret unitar, explicatii, pozitie, si imaginea produsului. Numarul produsului in subcategorie precum si codul produsului, cheie primara in baza de date, se completeaza automat, prin program. Pozitia produsului in lista de produse din aceeasi subcategorie este implicit pusa de la 1 la 3, in ordinea celor trei inregistrari posibile. Pozitia 1, 2, sau 3 semnifica faptul ca la vizualizare produsul va fi in prima pagina vazuta de client, intre primele trei. Pentru a fi validata o introducere este necesar si obligatoriu ca sa fie completat campul "denumire". Dupa completarea datelor, utilizatorul, la apasarea butonului "validare", apeleaza servlet-ul iner.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 insed 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/inser");
String url2 = res.encodeURL("/adi/servlet/opert");
PrintWriter out = res.getWriter();
try {
int iRowCount;
String subcti=null, subctf=null;
Statement stmt;
ResultSet rs;
out.println("<html>");
out.println("<head>");
out.println("<title>Inserare: pagina realizata de servlet-ul insed" + "</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("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
out.println("<head>");
out.println("<title> Pagina realizata de servlet-ul alimb</title>");
out.println("<SCRIPT language=JavaScript1.1 src=\"/adi/Scriptj.js\"></SCRIPT>");
out.println("<SCRIPT>");
out.println("function validareCampuri(form)");
out.println("{ return (");
out.println(" checkStringLen(form.elements[\"ump1\"],sUmp,10,true) &&");
out.println(" checkInt(form.elements[\"pretp1\"],sPretm,true) &&");
out.println(" checkStringLen(form.elements[\"denp1\"],sDenp,255,true) &&");
out.println(" checkStringLen(form.elements[\"expl1\"],sExpl,255,true) &&");
out.println(" checkInt(form.elements[\"pozp1\"],sPozp,true) &&");
out.println(" checkStringLen(form.elements[\"ump2\"],sUmp,10,true) &&");
out.println(" checkInt(form.elements[\"pretp2\"],sPretm,true) &&");
out.println(" checkStringLen(form.elements[\"denp2\"],sDenp,255,true) &&");
out.println(" checkStringLen(form.elements[\"expl2\"],sExpl,255,true) &&");
out.println(" checkInt(form.elements[\"pozp2\"],sPozp,true) &&");
out.println(" checkStringLen(form.elements[\"ump3\"],sUmp,10,true) &&");
out.println(" checkInt(form.elements[\"pretp3\"],sPretm,true) &&");
out.println(" checkStringLen(form.elements[\"denp3\"],sDenp,255,true) &&");
out.println(" checkStringLen(form.elements[\"expl3\"],sExpl,255,true) &&");
out.println(" checkInt(form.elements[\"pozp3\"],sPozp,true))");
out.println("}");
out.println("</SCRIPT>");
out.println("</head>");
out.println("<body>");
subcti=(String)ses.getAttribute("subcat");
subctf=req.getParameter("subcat");
if(subctf!=null){
subcti=subctf;
ses.setAttribute("subcat",subcti);
}
stmt = con.createStatement();
rs = stmt.executeQuery("select c.den,count(a.no) from alimente a,subcat c where c.c2=" +
subcti + " and a.cat=" + subcti + " group by a.cat");
if(rs.getString(2)!=null){
iRowCount=Integer.parseInt(rs.getString(2));
out.println("<br><br> Subcategoria \"" + rs.getString(1)+
"\" are " + rs.getString(2) + " inregistrari. <br><br>");
}
else{
iRowCount=0;
out.println("<br><br> Nu exista inregistrari!<br><br>");
}
rs.close();stmt.close();
out.println(" Inserati produsele in ordinea crescatoare a pozitiei<br>");
out.println(" daca nu se specifica pozitia produsele se insereaza la sfarsit.<br>");
out.println("<table cellspacing=\"5\" width=\"100%\">");
out.println("<td width=60%> </td>");
out.println("<td width=40% align=\"rigth\">");
out.println("<form action=\"" + url2 + "\"method=\"post\">");
out.println("<input type=\"submit\" value=\"Categorii\">");
out.println("</form>");
out.println("</td>");
out.println("</table>");
out.println("<table cellspacing=2 bgcolor=eeeeee>");
out.println("<form action=\"" + url1 + "\" method=\"post\" ENCTYPE=\"multipart/form-data\">");
out.println("<tr><td width=40% align=\"left\">");
out.println("<input type=\"button\" value=\"Validare\" onclick=\"if (validareCampuri(this.form))
this.form.submit();\">");
out.println("</td></tr>");
out.println("<tr><td bgcolor=dddddd><hr></td></tr>");
for(int i=1;i<4;i++){
out.println("<tr><td valign=middle>Denumire : <br><input type=\"text\" name=denp" + i +
"size=100><br></td></tr>");
out.println("<tr><td><table>");
out.println("<tr><td valign=baseline width=170>");
out.println("Unitate de masura :<br><input type=\"text\" name=ump" + i + " size=10><br><br>");
out.println("Pret unitar :<br><input type=\"text\" name=pretp" + i + " size=10>");
out.println("</td><td width=20> </td>");
out.println("<td valign=middle width=300 align=left>");
out.println("Explicatii :<br><TEXTAREA name=expl" + i + " cols=51
rows=5></TEXTAREA> <br>");
out.println("</td></tr><td width=20% align=left>");
out.println("Pozitie :<br><input type=\"text\" name=pozp" + i + " value=" + i + " size=6>");
out.println("</td><td width=20> </td>");
out.println("<td align=left>");
out.println("Imagine :<br><input type=\"file\" name=imp" + i + " enctype=multipart/form-data
size=50 >");
out.println("</td></tr>");
out.println("</table></td></tr>");
out.println("<tr><td bgcolor=dddddd><hr></td></tr>");
}
out.println("<tr><td width=40% align=\"left\">");
out.println("<input type=\"button\" value=\"Validare\" onclick=\"if (validareCampuri(this.form))
this.form.submit();\">");
out.println("</td></tr>");
out.println("</form>");
out.println("</table>");
out.println("</form>");
out.println("<table cellspacing=\"5\" width=\"100%\">");
out.println("<td width=60%> </td>");
out.println("<td width=40% align=\"rigth\">");
out.println("<form action=\"" + url2 + "\"method=\"post\">");
out.println("<input type=\"submit\" value=\"Categorii\">");
out.println("</form>");
out.println("</td>");
out.println("</table>");
out.println("</body></html>");
}
catch(SQLException e) {
out.println("An SQL Exception was thrown.");
}
out.close();
}
}
|
|
