C.V.

 
 

       10.5.19 Servlet stcom.java

       Servlet-ul acesta schimba starea comenzii punand-o intr-una din grupele: "Noi", "Vazute", "In curs", "Realizate", "Anulate". Apeleaza apoi servlet-ul comen.java.


import java.io.*;
import java.util.*;
import java.util.Date;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.http.*;
import javax.servlet.http.HttpSession;
public class stcom 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 subcti=null;
  //subcategoria
  subcti=(String)ses.getAttribute("subcat");
  try {   
    Statement stmt; 
    String querry;
    stmt = con.createStatement();
    querry="update comenzi set tip=\"" + req.getParameter("tipc") + 
	       "\" where codc=\"" + req.getParameter("sctip") + "\"";
    /** PrintWriter out=null;out = res.getWriter();out.println("
" + querry + "");**/ stmt.executeUpdate(querry); stmt.close(); } catch(SQLException e) {;} catch(Exception e) {;} RequestDispatcher rd = req.getRequestDispatcher("comen"); rd.forward(req,res); } }



 
 
C.V.
 
Hosted by www.Geocities.ws

1