Here is a simple example to demonstrate how to connect MySQL database with JDBC driver in Java.

Go get a MySQL JDBC driver first,MySQL JDBC Driver Download Here

Java JDBC connection example

Class.forName("com.mysql.jdbc.Driver");
Connection connection = null;
connection = DriverManager.getConnection(
"jdbc:mysql://hostname:port/dbname","username", "password");
connection.close();
package com.mkyong.common;
 
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
 
public class a {
 
   public static void main(String[] argv) {
 
	System.out.println("-------- MySQL JDBC Connection Testing ------------");
 
	try {
 
		Class.forName("com.mysql.jdbc.Driver");
 
	} catch (ClassNotFoundException e) {
		System.out.println("Where is your MySQL JDBC Driver? Include in your library path!");
		e.printStackTrace();
		return;
	}
 
	System.out.println("MySQL JDBC Driver Registered!");
	Connection connection = null;
 
	try {       
		connection = 
			DriverManager.getConnection("jdbc:mysql://localhost:3306/mkyongcom","root", "password");
 
	} catch (SQLException e) {
		System.out.println("Connection Failed! Check output console");
		e.printStackTrace();
		return;
	}
 
 
	if (connection != null){
		System.out.println("You made it, take control your database now!");
	}else{
		System.out.println("Failed to make connection!");
	}
  }
}

How to run it?

Assume JDBCExample is store in c:\test folder, together with mysql JDBC driver

C:\test>java -cp c:\test\mysql-connector-java-5.1.8-bin.jar;c:\test JDBCExample
-------- MySQL JDBC Connection Testing ------------
MySQL JDBC Driver Registered!
You made it, take control your database now!
 
C:\test>
This article was posted in Java category.