|
       10.4.10 Servlet comnd.java
       Acest servlet insereaza comanda clientului in baza de date si returneaza mesaj de succes sau insucces.
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.http.HttpSession;
import java.util.*;
import java.util.Date;
public class comnd 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 {
PrintWriter out=null;
try{
out = res.getWriter();
}
catch(IOException e) {;}
out.println("<body>");
res.setContentType("text/html");
HttpSession ses = req.getSession();
Connection con = (Connection)ses.getAttribute("connexion");
Hashtable Halcos = new Hashtable();
Halcos = (Hashtable)ses.getAttribute("cosal");
String cont = req.getParameter("cont");
String cercom = req.getParameter("cercom");
if(cercom==null) cercom="";
if(Halcos!=null && cont!=null){
if(req.getParameter("anul")!=null){
ses.removeAttribute("cosal");
out.println("Comanda anulata");
}
else{
Enumeration produse = Halcos.keys();
try {
Statement stmt;
stmt = con.createStatement();
Date now = new Date();
long codc = now.getTime();
String querry="insert into comenzi values(\"" + codc + "\",\""
+ cont + "\",\"" + cercom + "\",\"0\")";
if(stmt.executeUpdate(querry)>0){
while(produse.hasMoreElements()) {
String codp = (String)produse.nextElement();
prodcos pc = (prodcos)Halcos.get(codp);
querry="insert into alim_com values(\"" + codc + "\",\"" + codp +
"\",\"" + pc.getcant() + "\")";
stmt.executeUpdate(querry);
}
stmt.close();
out.println("Comanda dvs. a fost preluata");
}
else
out.println("Comanda nu a fost preluata");
}
catch(SQLException f) { out.println("An SQL Exception was thrown.");}
catch(Exception e) { e.printStackTrace(out); }
ses.removeAttribute("cosal");
}
}
else
out.println("Comanda nu a fost preluata");
out.println("</body>");
out.close();
}
}
|
|