**Small Pizza Shop Example:
An ERD & DDL plus tips are on the zipped file!
****_WHAT I NEED DONE!
_**Document it in Javadoc style!
* Write a Java API for the pizza ordering system as an extended Connection class.
* This API should include methods for:
· Making a pizza order and cancelling an existing order
· Adding or removing pizzas from an order
· Changing the name or address on an order
· Adding or removing a kind of pizza
· Changing the price of a pizza
· Changing the ingredients in a pizza
· Adding or removing a type of ingredient
· Listing unfilled orders
* Then augment and implement the above Pizza interface using JDBC and Oracle with the additional functionality:
· Keep track of the order state. One of Ordered, ReadyForDelivery, BeingDelivered, Delivered, Refused, Cancelled. Make sure that the state changes are legal.
· Timestamp each time the order changes state.
· Add a method to report; * The orders which took more than ‘X’ minutes from order time to delivery or refusal time.
· Write a test application in the form of a simple GUI that allows for each method to be tested.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4) The code for the GUI to be written in Java and all code written to be documented in Javadoc style.
## Platform
Windows and work on Oracle 8i obviously and the gui to work on the j2sdk1.4.0_01(the latested version in other words)