C.V.
 
 

       10.5.26 Servlet malct.java

       Daca optiunea aleasa a fost operatia de modificare a unei subcategorii existente atunci acest servlet listeaza subcategoriile din categoria aleasa, impreuna cu butoane radio pentru selectia subcategoriei care se modifica. Utilizatorul poate sa se intoarca inapoi la pagina cu categorii sau sa ceara modificare subcategoriei alese.

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 malct 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");
	
    PrintWriter out = res.getWriter ();
    String url1 = res.encodeURL("/adi/servlet/medct"); 
    String url2 = res.encodeURL("/adi/servlet/categ"); 
		
    out.println("<html>");
    out.println("<head>");
    out.println("<title>Pagina realizata de servlet-ul malct</title>");
    out.println("<meta http-equiv=\"Pragma\" content=\"no-cache\">");
    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("</head>");
    out.println("<body>");

	
    out.println("<table  cellspacing=\"5\" width=\"750\">");
	
    out.println("<td width=750 align=center valign=middle>");
    out.println("<tr>");
    out.println("<form method=post action=" + url2 + ">");
    out.println("<td width=750 align=\"center\"><input type=submit value=Categorii><br><br></td>");
    out.println("</form></tr>");
    out.println("<form method=post action=" + url1 + ">");
    out.println("<tr>");
    out.println("<td width=750 align=\"center\"><input type=submit value=Modifica><br><hr></td>");
    out.println("</tr>");
    out.println("<tr><td width=750 align=center valign=middle>");
    out.println("<table width=750 cellspacing=7>"); 
    out.println("<td width=250></td><td width=400 valign=middle align=center>");		
	
    out.println("<table cellspacing=7 width=400>"); 
    out.println("<tr><th>Subcategorii<th> </tr>"); 
    try{	
	  
      String cat=(String)ses.getAttribute("cat");  
	  
      Statement stmt = con.createStatement(); 
      ResultSet rs; 
      rs = stmt.executeQuery("select * from subcat where c1=" + cat + " order by c2");	
     while(rs.next()){
       out.println("<tr><td width=330 align=center> " + rs.getString(2)+ ". " + rs.getString(3) + " 
                         </td>");
       out.println("<td valign=middle align=left width=20><input type=radio name=\"subcat\" value=" + 
                       rs.getString(2) +">");
       out.println("</td></tr>");
     }
     rs.close();stmt.close();
  }
  catch(SQLException e) {out.println("An SQL Exception was thrown.");}
	
  out.println("</table>"); 
  out.println("</td><td width=100></td>");		
  out.println("</table></td></tr>");
  out.println("<tr>");
  out.println("<td width=750 align=\"center\"><hr><br><input type=submit value=Modifica></td>");
  out.println("</tr>");
  out.println("</td></table></form>");	
  out.println("</body></html>");
  out.close();	
  }
}



 
 
C.V.
 
Hosted by www.Geocities.ws

1