OrderSubmission



For the simple database structure below, use the following definitions for each data field in each table as well as the java model
Table/Field name
Database field type
Java Model field type
Products table
ProductId
INTEGER
java.lang.Integer
Description
VARCHAR
java.lang.String
Price
DECIMAL
java.math.BigDecimal
LineItems table
 OrderID
INTEGER
java.lang.Integer
ProductId
INTEGER
java.lang.Integer
Quantity
INTEGER
java.lang.Integer
TotalPrice
DECIMAL
java.math.BigDecimal
Orders table
OrderId
INTEGER
java.lang.Integer
FirstName
VARCHAR
java.lang.String
LastName
VARCHAR
java.lang.String
Address
VARCHAR
java.lang.String
City
VARCHAR
java.lang.String
State
VARCHAR
java.lang.String
SubmissionDate
DATE
java.sql.Date
For the database data submission:
Add 5 entries to the products table using sql statements not a web page)
Create the following web application using Struts2
Name it OrderSubmission
Create a Welcome page that has links to the below actions required except number 5.
Create an action to submit an order (create an order) with:
An Order input page with the customer information(first name, last name, address, city, state)
Items – at least 2 items per order. The User can choose a product and quantity from a drop down list on the Order input page.  There is an Add button to add a new order item.
The result of the order is a view, with the customer information and a table to show the items bought and will allow the user to update the order created.
Create an action to retrieve (one order, by an order id)  – It is not search
An input page with a text field for the order Id that the user provides, and a Submit button.
The result of the action will be the detail page of the order, with the list of items in a table.
The above page in point 4.b will be dynamically created, not a static page. The User will be able to update both the order information and the line items within the order by clicking on an Update button. 
Create the action to take care of point 4.c 
  
Requirements
– use MVC architecture
– Struts2, jsp view pages
– web.xml and struts.xml as configuration files
– Field validation – use xml validation (Framework Validator) – check for data types, empty fields, and show appropriate error messages.
– MySQL  database
– Use pooling to connect to a MySQL database
– GlassFish 4.0  Server
– Eclipse Luna