|
|
10.5.22 Servlet edcat.java
Pentru a se introduce noi subcategorii intr-o categorie existenta este apelat acest servlet. El genereaza o casuta de editare in care se trece denumirea subcategoriei care se creaza, si doua butoane, unul pentru validare si celalalt pentru revenire a la pagina cu 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 edcat 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 url1 = res.encodeURL("/adi/servlet/insct");
String url2 = res.encodeURL("/adi/servlet/categ");
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>Inserare: pagina realizata de servlet-ul edcat" + "</title>");
out.println("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
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 validareCat(form)");
out.println("{return (checkString(form.elements[\"subcat\"],sSubct))}");
out.println("</SCRIPT>");
out.println("</head>");
out.println("<body>");
out.println("<table cellspacing=\"5\" width=\"700\">");
out.println("<td width=200> </td>");
out.println("<td width=400 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 (validareCat(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();stmt.close();
}
catch(SQLException e) {out.println("An SQL Exception was thrown.");}
out.println("<input type=\"text\" name=subcat>");
out.println("</form>");
out.println("</td>");
out.println("<td width=200> </td>");
out.println("</table>");
out.println("</body></html>");
out.close();
}
}
|
|
