Adam Burda

so I made a ClassPath C:\Program Files (x86)\Java\jre7\lib\mysql-connector-java-5.1.34-bin.jar
then re compiled my app then ran it now I get an error could not find or load main class

There is no ClassPath in windows 7 only path.

Hi all,

I do not understand what I am doing wrong. I'm trying to set the path to the J connector.
Then run a java app to check connection. I get JDBC driver not found
I have the mysql-connector-java-5.1.34-bin.jar placed in C:\Program Files (x86)\Java\jre7\lib folder.
So the path would be C:\Program Files (x86)\Java\jre7\lib\mysql-connector-java-5.1.34-bin.jar
and then in Windows 7 path variables edit, it looks like
......;C:\Program Files (x86)\Java\jdk1.7.0_71\bin;C:\Program Files (x86)\Java\jre7\lib\mysql-connector-java-5.1.34-bin.jar

java version = 7
jdk1.7.0_71
MySQL version = 5.6
MySQL Workbench 6.2 CE

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

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

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";

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.

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); } } }

If you look at code line 170, you will see where it has to do with JDBC. It will not load, keep getting errors.

Ok sorry about the code. I was only showing the inner class here is the whole code.

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.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Timestamp; import java.sql.Statement; public class ContactP extends JPanel { public JLabel Fn, Ln, Add, Ct, St, Zp, Hp, Cp, Em; public JTextField Fn1, Ln1, Add1, Ct1, Zp1, Hp1, Cp1, Em1; public JButton b1; public JComboBox cb; public String Fn3, Ln3, Add3, Ct3, St3, Zp3, Hp3, Cp3, Em3; public String Fn2, Ln2, Add2, Ct2, St2, Zp2, Hp2, Cp2, Em2; 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:"); 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); } public class ContactSql { public ContactSql()throws Exception { Fn3 = Fn2; Ln3 = Ln2; Add3 = Add2; Ct3 = Ct2; St3 = St2; Zp3 = Zp2; Hp3 = Hp2; Cp3 = Cp2; Em3 = Em2; Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sqlQuery = "SELECT *" + "from contact"; ResultSet rs = stmt.executeQuery(sqlQuery); try { rs.moveToInsertRow(); rs.updateString("F_Name", Fn3); rs.updateString("L_Name", Ln3); rs.updateString("Address", Add3); rs.updateString("City", Ct3); rs.updateString("State", St3); rs.updateString("Zip", Zp3); rs.updateString("Home_P", Hp3); rs.updateString("Cell_P", Cp3); rs.updateString("Email", Em3); rs.insertRow(); } catch(Exception e) { System.exit(0); } } static Connection conn; static Statement st; static { try { // Step 1: Load the JDBC driver. Class.forName("com.mysql.jdbc.Driver"); System.out.println("Driver Loaded."); // Step 2: Establish the connection to the database. String url = "jdbc:mysql://localhost/contacts"; String user = "root"; String pw = "marty95"; conn = DriverManager.getConnection(url, user, pw); System.out.println("Got Connection."); st = conn.createStatement(); } catch (Exception e) { System.err.println("Got an exception! "); e.printStackTrace(); System.exit(0); } } } 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 address_book"; 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(); } 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); } } }

If you look at the code the static errors are there
line 42
line 44
line 46

So how do i go about fixing it. I tryed to make it as its own class file, and instantiate the class in a nother class.
But i keep getting throw or catch errors. When the class already has the throw and catch exception.

Hi all hope you can help.
I am getting three errors for a inner class. Here is the class.
public class ContactSql { public ContactSql()throws Exception { Fn3 = Fn2; Ln3 = Ln2; Add3 = Add2; Ct3 = Ct2; St3 = St2; Zp3 = Zp2; Hp3 = Hp2; Cp3 = Cp2; Em3 = Em2; Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); String sqlQuery = "SELECT *" + "from contact"; ResultSet rs = stmt.executeQuery(sqlQuery); try { rs.moveToInsertRow(); rs.updateString("F_Name", Fn3); rs.updateString("L_Name", Ln3); rs.updateString("Address", Add3); rs.updateString("City", Ct3); rs.updateString("State", St3); rs.updateString("Zip", Zp3); rs.updateString("Home_P", Hp3); rs.updateString("Cell_P", Cp3); rs.updateString("Email", Em3); rs.insertRow(); } catch(Exception e) { System.exit(0); } } static Connection conn; static Statement st; static { try { // Step 1: Load the JDBC driver. Class.forName("com.mysql.jdbc.Driver"); System.out.println("Driver Loaded."); // Step 2: Establish the connection to the database. String url = "jdbc:mysql://localhost/contacts"; String user = "root"; String pw = "marty95"; conn = DriverManager.getConnection(url, user, pw); System.out.println("Got Connection."); st = conn.createStatement(); } catch (Exception e) { System.err.println("Got an exception! "); e.printStackTrace(); System.exit(0); } } }

.\ContactP.java:162: error: Illegal static declaration in inner class ContactP.ContactSql
static Connection conn;

modifier 'static' is only allowed in constant variable declarations
.\ContactP.java:164: error: Illegal static declaration in inner class ContactP.ContactSql
static Statement st;

modifier 'static' is only allowed in constant variable declarations
.\ContactP.java:166: error: Illegal static declaration in inner class ContactP.ContactSql
static {

modifier 'static' is only allowed in constant variable declarations

Thank you. I feel like DUH....

Need help. This should be simple, but i can not seem to get it.
I want to take a double like 0.01 and then times it by 2 for each output.
like this....
0.01
0.02
0.04
0.08
0.16
Do i use a loop of if, else?

Thank you.

Thank you. It works now.