connecting to a mysql db

[droidus]

I am trying to connect to a databse. here is my code so far:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Connect2 {

	public static void main(String args[]) {
		String dbtime;
		String dbUrl = "jdbc:mysql:/dbnumber.db.1and1.com/uploader";
		String dbClass = "com.mysql.jdbc.Driver";
		String query = "Select * FROM members";

		try {

			Class.forName("com.mysql.jdbc.Driver");
			Connection con = DriverManager.getConnection(dbUrl);
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(query);

			while (rs.next()) {
				dbtime = rs.getString(1);
				System.out.println(dbtime);
			} // end while

			con.close();
		} // end try

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

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

	} // end main

} // end class

i am getting this error:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at Connect2.main(Connect2.java:17)

I am familiar with connecting to mysql via php, but not java.

thanks in advance.

[JosAH]

That driver is most likely stored in a .jar file somewhere; add that .jar file to your classpath.

kind regards,

Jos

[RichersooN]

Check out my tutorial in youtube: "Lesson 8. Connecting Java to MySql ODBC easiest way"

[droidus]

I went through your tutorial online, and I get this error: Kamalian java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

(sorry, ignore the attached image)