------------------
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("");
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("");
out.println("");