------------------ Création de la BD: ------------------ CREATE SCHEMA PIZZA; CREATE TABLE PIZZA."STOCK" ( "STOCK_ID" INTEGER generated always as identity primary key, "PIZZA_ID" VARCHAR(10), "QUANTITE" numeric ); alter table PIZZA.stock add foreign key (pizza_id) references PIZZA.pizza; CREATE TABLE PIZZA."COMMANDE" ( "COMMANDE_ID" INTEGER generated always as identity primary key, "PIZZA_ID" VARCHAR(10), "QUANTITE" numeric, "TOTAL" numeric, "EMAIL" varchar(20) ); alter table PIZZA.commande add foreign key (pizza_id) references PIZZA.pizza; ---------------- StockFacade.java : ---------------- public void create(String pizzaId, int quantite) { String s = "insert into stock(pizza_id,quantite) "; s = s + "values ('" + pizzaId + "'," + quantite + ")"; em.createNativeQuery(s).executeUpdate(); } ---------------- StockFacadeLocal.java : ---------------- void create(String pizzaId, int quantite); ---------------- CommandeFacade.java : ---------------- public void create(String pizzaId, int quantite, int total, String email) { String s = "insert into commande(pizza_id,quantite,total,email) "; s = s + "values ('" + pizzaId + "'," + quantite + ","; s = s + total + ",'" + email + "')"; em.createNativeQuery(s).executeUpdate(); } ---------------- CommandeFacadeLocal.java : ---------------- void create(String pizzaId, int quantite, int total, String email); ---------------- AdminPizza.java : ---------------- out.println(""); out.println(""); out.println("Administration Pizza"); out.println(""); out.println(""); out.println("

Ajouter un nouveau type de pizza :

"); List lPizza = pizzaFacade.findAll(); for (Iterator it = lPizza.iterator(); it.hasNext();) { Pizza elem = (Pizza) it.next(); out.println("Type : " + elem.getPizzaId() + " "); out.println("Prix : " + elem.getPrix() + "
"); } String type=null; type=request.getParameter("type"); if (type!=null) { try { int prix=0; prix=new Integer(request.getParameter("prix")); int quantite=new Integer(request.getParameter("quantite")); out.println("On ajoute un type de pizza
"); Pizza e = new Pizza(); e.setPizzaId(type); e.setPrix(prix); pizzaFacade.create(e); stockFacade.create(type,quantite); response.sendRedirect("Admin_Pizza"); } catch (Exception ex) { ex.printStackTrace(); } out.println("Pizza sauvegardé"); } else { out.println("
"); out.println("Type:
"); out.println("Prix:
"); out.println("Quantité:
"); out.println("
"); out.println("
"); } out.println(""); out.println(""); ---------------- CommandePizza.java : ---------------- out.println(""); out.println(""); out.println("Commande Pizza"); out.println(""); out.println(""); List lStock = stockFacade.findAll(); for (Iterator it = lStock.iterator(); it.hasNext();) { Pizza elem = ((Stock) it.next()).getPizzaId(); out.println("Type : " + elem.getPizzaId() + " "); out.println("Prix : " + elem.getPrix() + "
"); } out.println("

Choisissez votre pizza :

"); String type=request.getParameter("type"); if (type!=null) { try { int quantite=new Integer(request.getParameter("quantite")); String email=new String(request.getParameter("email")); Pizza pizza = pizzaFacade.find(type); int total = quantite * pizza.getPrix(); out.println("On ajoute une commande dont le prix total est :"+total+"
"); commandeFacade.create(type, quantite, total, email); } catch (Exception ex) { ex.printStackTrace(); } out.println("Commande effectuée"); } else { out.println("
"); out.println("Type:
"); out.println("Quantité:
"); out.println("Email:
"); out.println("
"); out.println("
"); } out.println(""); out.println("");