Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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>");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement