title: Jquery Form Data Insert MySQL Database
body: <p>I am trying to write to a MySql Database using an HTML form, with Jquery I can't get the servlet to write to the database. I don't see anything obvious that Im doing wrong.  Here is the code for the servlet and the code for the HTML file.</p>
  
  <p>Servlet:</p>
  
  <pre><code>package com.david.servlets;
  import java.io.IOException;
  import java.sql.Connection;
  import java.sql.PreparedStatement;
  import java.sql.SQLException;
  import java.util.Hashtable;
  import javax.naming.Context;
  import javax.naming.InitialContext;
  import javax.naming.NamingException;
  import javax.servlet.ServletException;
  import javax.servlet.http.HttpServlet;
  import javax.servlet.http.HttpServletRequest;
  import javax.servlet.http.HttpServletResponse;
  import javax.sql.DataSource;
  
  
  /**
   * Servlet implementation class myForm
   */
  public class myForm extends HttpServlet {
  
      /**
       * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
       */
      protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  
      }
  
      public void doPost(HttpServletRequest request, HttpServletResponse response)
          throws ServletException, IOException
          {
                //Get parameters
              String id = request.getParameter("ID");
              String fname = request.getParameter("FirstName");
              String lname = request.getParameter("LastName");
  
  
              //Get Connection
              try {
                  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              } catch (ClassNotFoundException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
              }
              System.out.println("Found a driver");
              Connection dbConnect = null;
              try {
                  dbConnect = getConnection("localhost", 7001);
              } catch (SQLException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
              } catch (NamingException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
              }
  
  
              System.out.println("Made a connection");
  
  
                  //Create Query
              String query = "INSERT INTO test.customer (ID, FirstName, LastName) " + 
                      "VALUES (" + id + ", " + fname + ", " + lname + ")";
              PreparedStatement dbStatement = null;
              try {
                  dbStatement = dbConnect.prepareStatement(query);
              } catch (SQLException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
              }
              //Execute Query
              try {
                  dbStatement.executeUpdate(query);
              } catch (SQLException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
              }
  
              //close connection
              try {
                  dbStatement.close();
              } catch (SQLException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
              }
              try {
                  dbConnect.close();
              } catch (SQLException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
              }
  
          }
  
  
  
  
  
  public Connection getConnection(String server, int port)
          throws SQLException, NamingException {
      Context ctx = null;
      Hashtable ht = new Hashtable();
      ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory");
      ht.put(Context.PROVIDER_URL, "t3://"+server+":"+port);
      ctx = new InitialContext(ht);
      DataSource ds = (javax.sql.DataSource) ctx.lookup ("localmysql");
      Connection conn =  ds.getConnection();
      //conn.setAutoCommit( true );
      return conn;
  }    
  
  
  
  
  
  }
  </code></pre>
  
  <p>HTML: </p>
  
  <pre><code>&lt;html&gt;
  &lt;head&gt;
  &lt;title&gt;myForm&lt;/title&gt;
  &lt;script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.js" type="text/javascript"&gt;&lt;/script&gt;
  &lt;script type="text/javascript"&gt;
  
      $("#submit").click(function () {
          Var ID = $("#ID").val();
          Var FirstName = $("#FirstName").val();
          Var LastName = $("#LastName").val();
          $.post("myForm", $("form").serialize(), insertCallback);
      });
  
      function insertCallback(result) {
          if (result == "success") {
              alert("Record added!");
          } else {
              alert("Could not add Record!");
          }
      }
  
  &lt;/script&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;form action="myForm" method="POST"&gt;
  ID: &lt;input type="number" name="ID"&gt;
  FirstName: &lt;input type="text" name="FirstName"&gt; &lt;br&gt;
  LastName: &lt;input type="text" name="LastName"&gt;  &lt;br&gt;
  &lt;input type="button" value="submit"&gt;
  &lt;/form&gt;
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>