Connect To MySQL With JDBC Driver

Here is an example to connect your JDBC code to MySQl database. You have to download mysql.jar for the JDBC driver class from here.

[code]
Class.forName("com.mysql.jdbc.Driver");
Connection conn = null;
conn = DriverManager.getConnection("jdbc:mysql://hostname:port/dbname","username", "password");
conn.close();
[/code]

 

[code lang=”java”]
package javabeat.net.db;

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

public class MySQLConnectionExample {
public static void main(String[] argv) {

try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
System.out.println("Problem in loading the MySQL Driver class!!!");
e.printStackTrace();
return;
}

Connection connection = null;

try {
//Get the connection object
connection = DriverManager
.getConnection("jdbc:mysql://<host>:3306/<dbname>","<username>", "<password>");

} catch (SQLException e) {
System.out.println("Problem in establishing connection!!");
e.printStackTrace();
return;
}

if (connection != null) {
System.out.println("Connection created successfully!!");
} else {
System.out.println("Problem in establishing connection!!");
}
}
}

[/code]

If you are not copying the mysql.jar file in the classpath, you will get the following error.

[code]
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:188)
at javabeat.net.db.MySQLConnectionExample.main(MySQLConnectionExample.java:11)
[/code]