.jar file not working

I need some help and hope I am in the right place.

I made a Java database app in a GUI. The app runs fine with no errors, and does what I want it to do. When I make the app into a .jar the app starts up but does not input data into the MySQL table. Here is the code.
I even took out the System.out.println(); and tryed again with making the .jar file still does not work.

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.File;
import java.io.FileWriter;
import java.io.BufferedWriter;
import java.io.IOException;
import java.sql.*;

public class ContactP extends JPanel
{
  private JLabel Fn, Ln, Add, Ct, St, Zp, Hp, Cp, Em;
  private JTextField Fn1, Ln1, Add1, Ct1, Zp1, Hp1, Cp1, Em1;
  private JButton b1;
  private JComboBox cb;

String Fn2, Ln2, Add2, Ct2, St2, Zp2, Hp2, Cp2, Em2; 
  String Fn3, Ln3, Add3, Ct3, St3, Zp3, Hp3, Cp3, Em3;

public ContactP()
  {
    this.setBackground(Color.LIGHT_GRAY);
    Fn = new JLabel("First Name:");
    Ln = new JLabel("Last Name:");
    Add = new JLabel("Address:");
    Ct = new JLabel("City:");
    St = new JLabel("State:");
    Zp = new JLabel("Zip Code:");
    Hp = new JLabel("Home Phone:");
    Cp = new JLabel("Cell Phone:");
    Em = new JLabel("Email:");
    SqlOP = new JLabel(" ");

Fn1 = new JTextField(10);
    Ln1 = new JTextField(10);
    Add1 = new JTextField(15);
    Ct1 = new JTextField(10);
    String[] states = {"__", "AL", "AK", "AZ", "AR", "CA", "CO", "CT", "DE", "FL", "GA", "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "NV", "NH", "NJ", "NM", "NY", "NC",  "ND", "OH", "OK", "OR", "PA", "RI", "SC", "SD", "TN", "TX", "UT", "VT", "VA", "WV", "WI", "WY" };
    cb = new JComboBox(states);
    Zp1 = new JTextField(6);
    Hp1 = new JTextField(8);
    Cp1 = new JTextField(8);
    Em1 = new JTextField(15);

b1 = new JButton("Submit");
    ButtonListener listener = new ButtonListener();
    b1.addActionListener(listener);

setLayout(new GridBagLayout());
    GridBagConstraints gbc = new GridBagConstraints();
    gbc.insets = new Insets(5, 5, 5, 5);
    gbc.anchor = GridBagConstraints.WEST;

gbc.gridx = 0;
    gbc.gridy = 0;
    add(Fn, gbc);
    gbc.gridx = 1;
    gbc.gridy = 0;
    add(Fn1, gbc);
    gbc.gridx = 2;
    gbc.gridy = 0;
    add(Ln, gbc);
    gbc.gridx = 3;
    gbc.gridy = 0;
    add(Ln1, gbc);

gbc.gridx = 0;
    gbc.gridy = 1;
    add(Add, gbc);
    gbc.gridx = 1;
    gbc.gridy = 1;
    add(Add1, gbc);
    gbc.gridx = 2;
    gbc.gridy = 1;
    add(Ct, gbc);
    gbc.gridx = 3;
    gbc.gridy = 1;
    add(Ct1, gbc);
 
    gbc.gridx = 0;
    gbc.gridy = 2;
    add(St, gbc); 
    gbc.gridx = 1;
    gbc.gridy = 2;
    add(cb, gbc);
    gbc.gridx = 2;
    gbc.gridy = 2;
    add(Zp, gbc);
    gbc.gridx = 3;
    gbc.gridy = 2;
    add(Zp1, gbc);

gbc.gridx = 0;
    gbc.gridy = 3;
    add(Hp, gbc);
    gbc.gridx = 1;
    gbc.gridy = 3;
    add(Hp1, gbc);
    gbc.gridx = 2;
    gbc.gridy = 3;
    add(Cp, gbc);
    gbc.gridx = 3;
    gbc.gridy = 3;
    add(Cp1, gbc);

gbc.gridx = 0; 
    gbc.gridy = 4;
    add(Em, gbc);
    gbc.gridx = 1;
    gbc.gridy = 4;
    add(Em1, gbc);

gbc.gridx = 3;
    gbc.gridy = 5;
    add(b1, gbc);
  }

private class ButtonListener implements ActionListener
  {
   public void actionPerformed (ActionEvent event)
   {     
     Fn2 = "n/a";
     Ln2 = "n/a";
     Add2 = "n/a";
     Ct2 = "n/a";
     St2 = "n/a";
     Zp2 = "n/a";
     Hp2 = "n/a";
     Cp2 = "n/a";
     Em2 = "n/a";

if(event.getSource() == b1)
     Fn2 = Fn1.getText();
     Ln2 = Ln1.getText();
     Add2 = Add1.getText();
     Ct2 = Ct1.getText();
     St2 = (String)cb.getSelectedItem();
     Zp2 = Zp1.getText();
     Hp2 = Hp1.getText();
     Cp2 = Cp1.getText();
     Em2 = Em1.getText();

try 
      {
       String data = "insert into contact";
       String data1 = "(F_Name, L_Name, Address, City, State, Zip, H_Phone, C_Phone, email)";
       String data2 = "values";
       String data3 = "('" + Fn2 + "', '" + Ln2 + "', '" + Add2 + "', '" + Ct2 + "', '" + St2 + "', '" + Zp2 + "', '" + Hp2 + "', '" + Cp2 + "', '" + Em2 + "');";

File file = new File("AddressBook.txt");

if(!file.exists())
       {
       file.createNewFile();
       }

FileWriter fileWritter = new FileWriter(file.getName(), true);
       BufferedWriter bufferWritter = new BufferedWriter(fileWritter);
       bufferWritter.newLine();
       bufferWritter.write(data);
       bufferWritter.newLine();
       bufferWritter.write(data1);
       bufferWritter.newLine();
       bufferWritter.write(data2);
       bufferWritter.newLine();
       bufferWritter.write(data3);
       bufferWritter.newLine();
       bufferWritter.close();
      }

catch(IOException e)
      {
       e.printStackTrace();
      }

System.out.println("Inserting values in Mysql database table!");
      Connection con = null;
      String url = "jdbc:mysql://localhost/ContactList";  
      String user = "root";
      String pw = "marty95";  
      String driver = "com.mysql.jdbc.Driver";

try
      {  
        Class.forName(driver);  
        con = DriverManager.getConnection(url, user, pw);
 
        try
        {
          Statement st = con.createStatement();
          String insert = "insert into contact "
              + "(F_Name, L_Name, Address, City, State, Zip, H_Phone, C_Phone, Email) "
              + "values"
              + "(' " + Fn2 + " ',"
              + "' " + Ln2 + " ',"
              + "' " + Add2 + " ',"
              + "' " + Ct2 + " ',"
              + "' " + St2 + " ',"
              + "' " + Zp2 + " ',"
              + "' " + Hp2 + " ',"
              + "' " + Cp2 + " ',"
              + "' " + Em2 + " ')";
            
          int val = st.executeUpdate(insert);  
          System.out.println("1 row affected");  
        }

catch (SQLException s)
        {  
          System.out.println("SQL statement is not executed!");
        }
      }

catch (Exception e)
      {
         e.printStackTrace();
      }
      
      Fn1.setText(null);
      Ln1.setText(null);
      Add1.setText(null);
      Ct1.setText(null);
      cb.setSelectedItem("__");
      Zp1.setText(null);
      Hp1.setText(null);
      Cp1.setText(null);
      Em1.setText(null);
   }
  }
}

Please read this. You appear to have posted lots of code with long lines in, so people can’t read it, but chances are none of that code is relevant to the question.
Please show us how you are trying to create the .jar, and the complete contents of the manifest file.

Ok,
Sorry that the code was so long here is the SQL part of the code. It is with in the ButtonListener method of the class.

System.out.println("Inserting values in Mysql database table!");
      Connection con = null;
      String url = "jdbc:mysql://localhost/ContactList";  
      String user = "root";
      String pw = "marty95";  
      String driver = "com.mysql.jdbc.Driver";

try
      {  
        Class.forName(driver);  
        con = DriverManager.getConnection(url, user, pw);
 
        try
        {
          Statement st = con.createStatement();
          String insert = "insert into contact "
              + "(F_Name, L_Name, Address, City, State, Zip, H_Phone, C_Phone, Email) "
              + "values"
              + "(' " + Fn2 + " ',"
              + "' " + Ln2 + " ',"
              + "' " + Add2 + " ',"
              + "' " + Ct2 + " ',"
              + "' " + St2 + " ',"
              + "' " + Zp2 + " ',"
              + "' " + Hp2 + " ',"
              + "' " + Cp2 + " ',"
              + "' " + Em2 + " ')";
            
          int val = st.executeUpdate(insert);  
          System.out.println("1 row affected");  
        }

catch (SQLException s)
        {  
          System.out.println("SQL statement is not executed!");
        }

As for making the .jar file what I did was,
1. Made a MyManifest.txt file and in that i wrote Main-Class: Contact then pressed enter twice saved the file named MyManifest. Contact is the main class of my app.
2. in CMD i wrote jar cfm JarFileName.jar MyManifest.txt Contact.class ContactFrame.class ContactP$1.class ContactP$ButtonListener.class ContactP.class

The jar file works, the app runs. But as for sending data to the SQL table that does not work.
It only sends data to the SQL table if I run the app in CMD.

And how are you adding the connector to JDBC to your classpath?

I downloaded a driver from mysql.com/products/connector, unziped it, added the drivers .jar file to the class path variable. c:\mysql\mysql-connector-java-5.0.4-bin.jar
in the class file i have

import java.sql*.;

and in the ButtonLinstener method i have

System.out.println("Inserting values in Mysql database table!");
Connection con = null;
String url = "jdbc:mysql://localhost/ContactList";
String user = "root";
String pw = "marty95";
String driver = "com.mysql.jdbc.Driver";

To repeat: how are you adding that connector to your classpath?

I am not sure what you are asking.

added the drivers .jar file to the class path variable. c:\mysql\mysql-connector-java-5.0.4-bin.jar

Did you use the -cp option when you started the jar file, or is the classpath in the manifest file? I think it is better in the manifest file. If you don’t supply a classpath, the app can’t find the jar with the connector in.

Ok im a little lost here? What do you mean -cp? As for the Manifest.txt file, I opened note pad inside that I wrote

Main-Class: Contact

Saved that as MyManifest.txt to the folder where the app files are.

Contatc is the main of the app.
the files are
Contact.java
ContactFrame.java
ContactP.java

The class files are.
Contact.class
ContactFrame.class
ContactP$1.class
ContactP$ButtonListener.class
ContactP.class

Then in CMD I wrote

jar cfm JarFileName.jar MyManifest.txt Contact.class ContactFrame.class ContactP$1.class ContactP$Buttonlistener.class ContactP.class

You need to supply a classpath which includes the location of the connector classes. If you go through the Java tutorials section, you find it in the section about adding other classes to the classpath.