java connect to sql db code example

Example: java sql connection example

import java.sql.*;

class MySQLConnection{

public static final String DBNAME = "name_of_the_database";  // Like "testDB"

/** JDBC driver name and database URL */
public static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";

/** Gives access to all Databases */
static final String ALL_DBS_URL = "jdbc:mysql://localhost/?allowPublicKeyRetrieval=true&autoReconnect=true&useSSL=false";

/** Gives access to a given DB */
static final String GIVEN_DB_URL = "jdbc:mysql://localhost/"+DBNAME+"?allowPublicKeyRetrieval=true&autoReconnect=true&useSSL=false";

// Below are the USERNAME and PASSWORD used in mysql
public static final String USER = "myUserName";
public static final String PASS = "myGoodPassWord";

/** A variable for connecting to MySQL Server */
public static Connection conn = null;

/** A variable for Preparing Statements */
public static PreparedStatement ps = null;

public static void main(String[] args) 
			throws ClassNotFoundException, SQLException {
		// Register JDBC driver
		Class.forName(JDBC_DRIVER);
		
		// Open a connection with MySQL server
		System.out.println("Connecting to all Databases path...");
		conn = DriverManager.getConnection(ALL_DBS_URL, USER, PASS);
		System.out.println("Connected to all Databases!");
		
		// Test if there is the db in MySQL Server
		// if not then create one
		System.out.println("Testing if "+DBNAME+" exists...");
		ps = conn.prepareStatement("CREATE DATABASE IF NOT EXISTS "+DBNAME+";");
		ps.executeUpdate();
		// Now db exists for sure!
		
		// Open a connection with given DB
		System.out.println("Connecting to "+DBNAME+" path...");
		conn = DriverManager.getConnection(GIVEN_DB_URL, USER, PASS);
		System.out.println("Connected to "+DBNAME+"!");
  		
  		// then you can do all sort of queries that you want to do
}
}