<%@ page import="java.sql.*" %>
<%
  // String url = "jdbc:odbc:productDSN";
  String filename = "c:/product.mdb"; 
  String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; 
  database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end 

  String username = "";
  String password = "";
  Connection conn = null;
  String classPath = "sun.jdbc.odbc.JdbcOdbcDriver";

  try
  {
    Class.forName( classPath );
    conn = DriverManager.getConnection( database, username, password );
  }
  catch (Exception e)
  {
    out.println(e.toString());
  }

  Statement stm = null;
  stm = conn.createStatement();

  String id = request.getParameter("id");
  String name = request.getParameter("name");
  String model = request.getParameter("model");
  double price;
  int manufacturerID;
  String query;

  try
  {
    price = Double.parseDouble( request.getParameter("price") );
  }
  catch (Exception e)
  {
    price = 0.0;
  }

  try
  {
    manufacturerID = Integer.parseInt( request.getParameter("manufacturerID") );
  }
  catch (Exception e)
  {
    manufacturerID = 0;
  }

  query = "INSERT INTO product VALUES('" + id + "', '" + name + "', '" + model + "', '" 
	+ price + "', '" + manufacturerID + "')";
  out.println(query);

  try
  {
    stm.executeUpdate(query);
    out.println("Update Successful");
  }
  catch (Exception e)
  {
    out.println("Update unsuccessful");
  }

  stm.close();
  conn.close();
%>