|
|
10.5.27 Servlet medct.java
Dupa ce a ales subcategoria pe care vrea s-o modifice utilizatorul are la dispozitie o casuta de editare pentru a face modificarea dorita. Deasemenea el poate reveni la pagina de categorii.
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 medct 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 cat = req.getParameter("cat");
if(cat==null)
cat=(String)ses.getAttribute("cat");
String subcat = req.getParameter("subcat");
if(subcat=null){ RequestDispatcher rd = req.getRequestDispatcher("malct"); rd.forward(req,res);}
else{
String url1 = res.encodeURL("/adi/servlet/msbct");
String url2 = res.encodeURL("/adi/servlet/categ");
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
out.println("<head>");
out.println("<title>Inserare: pagina realizata de servlet-ul medct" + "</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 validareSubct(form)");
out.println("{ return (checkString(form.elements[\"subcatden\"],sSubct,true))}");
out.println("</SCRIPT>");
out.println("</head>");
out.println("<body>");
out.println("<table cellspacing=\"5\" width=\"100%\">");
out.println("<td width=30%> </td>");
out.println("<td width=40% align=\"center\" valign=center>");
out.println("<form action=\"" + url2 + "\"method=\"post\">");
out.println("<input type=\"submit\" value=Categorii>");
out.println("</form>");
out.println("<br><br><br>");
out.println("<form action=\"" + url1 + "\"method=\"post\">");
out.println("<input type=\"button\" value=Validare onclick=\"if (validareSubct(this.form))
this.form.submit();\">");
out.println("<br><br><br>");
try{
Statement stmt = con.createStatement();
ResultSet rs;
String querry;
querry="select den from categ where cod=" + cat;
rs = stmt.executeQuery(querry);
out.println("In categoria <b>" + rs.getString(1) + "</b><br>");
rs.close();
querry="select den from subcat where c2=" + subcat;
rs = stmt.executeQuery(querry);
out.println("<input type=\"hidden\" name=subcatno value=\"" + subcat +"\">");
out.println("<input type=\"text\" name=subcatden value=\"" + rs.getString(1) +"\">");
rs.close();stmt.close();
}
catch(SQLException e) {out.println("An SQL Exception was thrown.");}
out.println("</form>");
out.println("</td>");
out.println("<td width=30%> </td>");
out.println("</table>");
out.println("</body></html>");
out.close();
}
}
}
|
|
