<%@page import="java.sql.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%
String fullName = request.getParameter("fullName");
String phone = request.getParameter("phone");
String address = request.getParameter("address");
String pizzaSize = request.getParameter("pizzaSize");
String creditNumber = request.getParameter("creditNumber");
String expiry_Year = request.getParameter("expiry_Year");
String expiry_Month = request.getParameter("expiry_Month");
String cvv = request.getParameter("cvv");
String sql = String.format("INSERT INTO pizza_Customer (fullName, phone, creditNumber) VALUES('%s')",fullName , phone, creditNumber);
//  Driver settings
Class.forName("com.mysql.jdbc.Driver");
//  Connection settings
String host = "jdbc:mysql://localhost:3306/customer";
Connection con = DriverManager.getConnection(host,"root","1234");
if(con != null)
{
//  SQL Statment
Statement stm = con.createStatement();
//  Run Query
stm.executeUpdate(sql);
//  Close connection
con.close();
//  Inform user
out.write("Thank you for adding ");
}
else
{
out.write("There was a problem connecting to the data base");
}
%>