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
}
}