JavaFX 8 App - Pizza Shop with Code #9

This simple JavaFX Pizza Shop program allows the user to order a pizza and a drink. When a customer orders a pizza, the shop keeper usually asks what type of pizza (e.g. Hawaiian, Seafood or Vege), the number of pizza, and a size of pizza (e.g. small, medium or large) he or she wants. Then shop keeper will ask what type of drink (e.g. Coke or Sprite), the number of drink, and a size of drink (e.g. 500 ml or 1.25 Ltr.). When the customer could use coupons as a form of payment.

Source code for Pizza Shop Version 0.9: https://drive.google.com/file/d/1YbFO...

CREATE TABLE order_line (
order_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
pizza_type INT,
pizza_price NUMERIC(5,2),
pizza_quantity INT,
pizza_size INT,
drink_type INT,
drink_price NUMERIC(5,2),
drink_quantity INT,
drink_size INT,
coupon_amount NUMERIC(5,2),
PRIMARY KEY(order_id)
);

INSERT INTO order_line (pizza_type, pizza_price, pizza_quantity, pizza_size,
drink_type, drink_price, drink_quantity, drink_size,
coupon_amount)
VALUES (1, 5.59, 1, 0, 1, 3.59, 1, 0, 0.0);

INSERT INTO order_line (pizza_type, pizza_price, pizza_quantity, pizza_size,
drink_type, drink_price, drink_quantity, drink_size,
coupon_amount)
VALUES (3, 4.59, 2, 2, 2, 9.59, 2, 1, 2.0);

INSERT INTO order_line (pizza_type, pizza_price, pizza_quantity, pizza_size,
drink_type, drink_price, drink_quantity, drink_size,
coupon_amount)
VALUES (1, 5.59, 1, 0, 0, 0.0, 0, 0, 0.0);

SELECT * FROM order_line;

Pizza Shop Version 0.9
Can save order data to a database using Java Database Connectivity
Can read order data from a database

Pizza Shop Version 0.8
Added drinks using class inheritance
Can place an order with a pizza and a drink.

Pizza Shop Version 0.7
Added a missing quantity label
Added a checkbox for no coupon.
Rearranged layout

Pizza Shop Version 0.6
Can process an order using a JavaFX Bean property
Fixed pizza type logic errors
Added the reset button for the Sales Summary tab

Pizza Shop Version 0.5
Added discount coupons.
Fixed the reset button
Added double number to currency format

Pizza Shop Version 0.4
Can save data to a text file (e.g. sales.txt) using FileWriter and PrintWriter classes
Can read data from a text file (e.g. sales.txt) for calculations using File and Scanner classes
Can calculate the subtotal and the total

Pizza Shop Version 0.3
Removed all constructors so that it only uses a default constructor implicitly.
Added quantity as a property of Pizza class.
Changed to version 0.3.
Validated if a pizza type is not selected.

Pizza Shop Version 0.2
JavaFX provides a GUI to handle different user inputs, and a Pizza object is created in Java to process data, and then the output was send it to a TextArea object.

Pizza Shop Version 0.1
This simple JavaFX program allows the user to order a pizza. When a customer orders a pizza, the shop keeper usually asks what type of pizza (e.g. Vege, Hawaiian, or Seafood), the number of pizza, and a size of pizza (e.g. small, medium or large) he or she wants.
You are asked to develop a simple pizza ordering system using JavaFX and Java.
License free icons are available from https://icons8.com/.