|
|
10.5.11 Servlet mdpro.java
La fel ca la operatia de inserare este necesara editarea modificarilor. Acesta ii ofera utilizatorului posibilitatea de a se intoarce la alegerea unei subcategori si a unei operatii sau sa valideze datele pe care le introduce. Utilizatorul poate modifica inclusiv imaginea de produsului, de o dimensiune mai mica de 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. Pentru a fi validata o introducere este necesar si obligatoriu ca sa fie completat campul "denumire", sa nu fie sters din greseala. Dupa modificarea datelor, utilizatorul, la apasarea butonului "validare", apeleaza servlet-ul execm.java pentru executia modificarii.
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 mdpro 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/modif");
String url2 = res.encodeURL("/adi/servlet/execm");
String url3 = res.encodeURL("/adi/servlet/opert");
try {
Statement stmt;
ResultSet rs;
String subcti=null;
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title> Pagina realizata cu servlet-ul mdpro" + "</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("<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[\"ump\"],sUmp,10,true) &&");
out.println(" checkInt(form.elements[\"pretp\"],sPretm,true) &&");
out.println(" checkStringLen(form.elements[\"denp\"],sDenp,255,true) &&");
out.println(" checkStringLen(form.elements[\"expl\"],sExpl,255,true) &&");
out.println(" checkInt(form.elements[\"pozp\"],sPozp,true))");
out.println("}");
out.println("</SCRIPT>");
out.println("</head>");
out.println("<body>");
//subcategoria
subcti=(String)ses.getAttribute("subcat");
//denumirea categoriei
stmt = con.createStatement();
rs = stmt.executeQuery("select den from subcat where c2=" + subcti);
out.println("<table cellspacing=\"5\" width=\"100%\">");
out.println("<td width=40% align=\"left\" valign=middle>");
if(rs.getString(1)!=null){
out.println("<br><br> Subcategoria <a href=\"" +
url1 + "\">\"" + rs.getString(1) + "\"</a> <br><br>");
}
out.println("</td>");
out.println("<td width=20%> </td>");
out.println("<td width=40% align=\"rigth\" valign=middle>");
out.println("<form action=\"" + url3 + "\"method=\"post\">");
out.println("<input type=\"submit\" value=\"Categorii\">");
out.println("</form>");
out.println("</td>");
out.println("</table>");
rs.close();stmt.close();
//produsul care se modifica
String sprod=req.getParameter("sprod");
if(sprod!=null){
//componentele inregistrarii
String codp = sprod.substring(0,sprod.indexOf(198));
sprod=sprod.substring(sprod.indexOf(198) +1 ,sprod.length());
String denp = sprod.substring(0,sprod.indexOf(198));
sprod=sprod.substring(sprod.indexOf(198) +1 ,sprod.length());
String pret = sprod.substring(0,sprod.indexOf(198));
sprod=sprod.substring(sprod.indexOf(198) +1 ,sprod.length());
String ump = sprod.substring(0,sprod.indexOf(198));
//se sare stocul
sprod=sprod.substring(sprod.indexOf(198) +1 ,sprod.length());
sprod=sprod.substring(sprod.indexOf(198) +1 ,sprod.length());
String cat = sprod.substring(0,sprod.indexOf(198));
sprod=sprod.substring(sprod.indexOf(198) +1 ,sprod.length());
String expl = sprod.substring(0,sprod.indexOf(198));
sprod=sprod.substring(sprod.indexOf(198) +1 ,sprod.length());
String no = sprod.substring(0,sprod.indexOf(198));
sprod=sprod.substring(sprod.indexOf(198) +1 ,sprod.length());
String type = sprod;
//out.println("<br>" + codp + " " + denp + " " + pret + "<br>"
//+ ump + " " + cat + " " + expl + " " + no + " " + type + " " + con);
out.println("<table cellspacing=2 bgcolor=eeeeee>");
out.println("<form action=\"" + url2 + "\" 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("<input type=\"hidden\" name=codp value=\"" + codp + "\">");
out.println("<input type=\"hidden\" name=no value=\"" + no + "\">");
out.println("<input type=\"hidden\" name=type value=\"" + type + "\">");
out.println("</td></tr>");
out.println("<tr><td bgcolor=dddddd><hr></td></tr>");
out.println("<tr><td valign=middle>Denumire : <br><input type=\"text\" name=denp value=\""
+ denp + "\" 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 value=\"" + ump +
"\"size=10><br><br>");
out.println("Pret unitar :<br><input type=\"text\" name=pretp value=\"" + pret + "\" 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 cols=51 rows=5>" + expl +
"</TEXTAREA> <br>");
out.println("</td></tr><td width=20% align=left>");
out.println("Pozitie :<br><input type=\"text\" name=pozp value=\"" + no + "\" size=6>");
out.println("</td><td width=20> </td>");
out.println("<td align=left>");
out.println("Imagine :<br><input type=\"file\" name=imp enctype=multipart/form-data size=50 >");
out.println(" <font size=1>lasati nemodificat daca pastrati
imaginea</font></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>");
}
else{
out.println("<br><br> Nu ati ales un produs<br><br>");
}
out.close();
}
catch(SQLException e) {;}
}
}
|
|
