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.
Class.forName("com.mysql.jdbc.Driver"); Connection conn = null; conn = DriverManager.getConnection("jdbc:mysql://hostname:port/dbname","username", "password"); conn.close();
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!!"); } } }
If you are not copying the mysql.jar file in the classpath, you will get the following error.
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)