| I have created a Cart.jsp page in which all the products with the total amount and no_of_items are showing now I want you to create a OrderPlaced table in which the Schema is this
|
| - OrderID (int, Primary Key, Not null)
|
| - Product ID (int, Foreign Key, Not null)
|
| - ProductName(varchar(50), Not Null)
|
| - Customer ID (int, Foreign Key, Not null)
|
| - CustomerName(varchar(50), Not Null)
|
| - no_of_items (int, Not null)
|
| - Total Amount (int, Not null)
|
|
|
| So please make a OrderConfirmed.jsp page in which the funcationality to add the products into the OrderPlaced table will be shown after clicking the Order Placed button on
|
| Cart.jsp file. I have already made a Orderplaced.jsp in which it is showing Download invoice and go to Home page so when download invoice is clicked it's doing the jsPDF work.
|
| now, the jsPDF values are hardcoded just do one thing fetch the details from OrderPlaced table and and those entries in Invoice refering the Orderplaced,jsp table for the format required.
|
|
|
| Please, write down which pages or codes you need! for my queries to be executed.
|