How to get JDBC Connection to MYSQL Database in Java?

Below code snippet shows you to get the JDBC connection in java for MYSQL DB. To get the JDBC connection you will need JDBC Driver Jar for MYSQL Database.

/****************************************************************************************
 * Created on 04-2011 Copyright(c) http://kodehelp.com All Rights Reserved.
 ****************************************************************************************/
package com.kodehelp.javasql;

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

/**
 * Created by http://kodehelp.com
 * Date: 4/29/11
 */
public class GetMySQLConnection {
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost/kodehelp";
        String username = "kodehelp";
        String password = "kodehelp";
        Class.forName(driver);
        Connection conn = DriverManager.getConnection(url, username, password);
    }
}

Please Post Your Comments & Reviews

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.