C.V.
 
 

       10.4.12 Servlet opusr.java

       In cazul in care toate datele introduse au fost validate acest servlet creaza efectiv un cont nou pe baza lor si furnizeaza un buton pentru intoarcerea la cosul de alimente in scopul intrarii in procedura de autentificare. 

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 opusr 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();

  String cont=req.getParameter("Cont");
 
  if(cont==null || cont.equals("")){
    RequestDispatcher rd = req.getRequestDispatcher("usrlg"); 
    rd.forward(req,res);
  }
  else{//verifica contul
    Connection con = (Connection)ses.getAttribute("connexion");
  
    try{
       Statement stmt;
       ResultSet rs;
	 
       stmt = con.createStatement();
	  
       rs = stmt.executeQuery("select count(codf) from clienti where codf=\"" + cont + "\"");
       if(!rs.getString(1).equals("0")){//cont existent
         rs.close();stmt.close();
         RequestDispatcher rd = req.getRequestDispatcher("usrlg"); 
         rd.forward(req,res);
       }
       else{//cont nou
          rs.close();
          String update;
          update="insert into clienti values(\"" + 
          req.getParameter("Cont") + "\",\"" +
          req.getParameter("FirstPass") + "\",\"" +
          req.getParameter("LastName") + "\",\"" +
          req.getParameter("FirstName") + "\",\"" +
          req.getParameter("Title") + "\",\"" +
          req.getParameter("Company") + "\",\"" +
          req.getParameter("StreetAddress") + "\",\"" +
          req.getParameter("City") + "\",\"" +
          req.getParameter("MobPhone") + "\",\"" +
          req.getParameter("FixPhone") + "\",\"" +
          req.getParameter("Fax") + "\",\"" +
          req.getParameter("Email") + "\",\"" +	
          req.getParameter("BirthYear") + "-" +
          req.getParameter("BirthMonth") + "-" +
          req.getParameter("BirthDay") + "\",\"" +
          req.getParameter("CreditCardType") + "\",\"" +
          req.getParameter("CreditCardNumber") + "\",\"" +
          req.getParameter("ExpirationYear") + "-" +
          req.getParameter("ExpirationMonth") + "-" +
          req.getParameter("ExpirationDay") + "\",\"" +
          req.getParameter("Sex") + "\")";
	
          PrintWriter out=null; 
          try{
	 out = res.getWriter();
          }	
          catch(IOException e) {;}
  
         out.println("<html>");
         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("<head>");
         out.println("<title> Pagina realizata de servlet-ul alimb</title>");
         out.println("<SCRIPT language=JavaScript1.1 src=\"/adi/Scriptj.js\"></SCRIPT>");
         out.println("</head>");
        out.println("<body bgcolor=\"#fff0f0\" link=#ffffff vlink=#ffffff alink=#ffffff>");
        //        out.println(update + "<br>");

         if(req.getParameter("Sex").equals("M"))
	out.println("Domnule ");
         else
	out.println("Doamna ");
         out.println(req.getParameter("FirstName") + " " + req.getParameter("LastName") + 
                     	   " contul dvs:<br> Cont utilizator: \"" + req.getParameter("Cont") +
                           "\" Parola: \"" + req.getParameter("FirstPass"));
          if(stmt.executeUpdate(update)>0){ 
	 out.println("\"<br> a fost creat cu succes.<br> Reveniti la pagina cu comanda dvs.");
          String url1 = res.encodeURL("/adi/servlet/cosal");
          out.println("<form action=\"" + url1 + "\" method=\"post\" name=view>");			
          out.println("<input type=\"submit\" name=adcos value=\"Comanda\">");
          out.println("</form>");
         }
         else{
            out.println("\"<br> nu a fost creat; probleme cu actualizarea Bazei de Date. Va rugam 
                                reveniti.<br>");
           String url1 = res.encodeURL("/adi/servlet/usrlg");
           out.println("<form action=\"" + url1 + "\" method=\"post\" name=view>");			
           out.println("<input type=\"submit\" name=adcos value=\"Creare cont\">");
           out.println("</form>");
         }
         out.println("</body></html>");
         out.close();
      }  
      stmt.close();  
    }
    catch(SQLException h) {;}
  }	  
}
}



 
 
C.V.
 
Hosted by www.Geocities.ws

1