Untitled

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.sql.*;

public class AddPizza extends HttpServlet{
    public void doPost(HttpServletRequest request,
              HttpServletResponse response)
    throws ServletException, IOException {

    Connection conn =null; // Create connection object

    String database = "whalleys"; // Name of database
    String user = "whalleys"; //
    String password = "crasmael";
    String url = "jdbc:mysql://mudfoot.doc.stu.mmu.ac.uk/" + database;

    String docType =
        "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 "+
        "Transitional//EN\">\n";

    response.setContentType("text/html");
    PrintWriter out = response.getWriter();
    out.println(docType);

    try{
        Class.forName("com.mysql.jdbc.Driver").newInstance();
    } catch(Exception e) {
        System.err.println(e);
    }

    // connecting to database
    try{
        conn = DriverManager.getConnection(url, user, password);

    }
    catch(SQLException se) {
        System.err.println(se);
    }
    // Create select statement and execute it
    // get form data
    String name = request.getParameter("name");
    String toppings = request.getParameter("toppings");
    String price = request.getParameter("price");


    try{
        String updateSQL = "insert into pizzas (name, toppings, price) values ('" + name + "', '" + toppings + "', " + price + ") ";

/*this is an update query where we insert values into an existing table, look at mysqlcrpizzas.sql for an idea*/

        System.err.println("DEBUG: Query: " + updateSQL);
        Statement stmt = conn.createStatement();
        int rows = stmt.executeUpdate(updateSQL);

            conn.close();
    } catch(SQLException se) {
        System.err.println(se);
    }


    out.println("<html><body><h1>Database updated</h1></body></html>");

    }
}