package sql;

import java.io.IOException;
import java.sql.*;
import java.util.logging.Logger;

public class SqlDriver {
      private Statement stmt;
      private ResultSet rs;
      private Logger log;
  public SqlDriver()
  {
	stmt = null;
	rs = null;
	log = Logger.getLogger("SqlDriver");

  }

  public Connection connect()
  {
  	  Connection con = null;
	  try
	  {
		  Class.forName("com.mysql.jdbc.Driver");
		  String url = "jdbc:mysql://localhost:3306/cooldatabase";
		  con = DriverManager.getConnection( url,"root", "*****");
	  }
    catch (ClassNotFoundException e) {
    	log.info("class not found");
		e.printStackTrace();
	} catch (SQLException e) {
	   log.info("SQL Exception");
	   e.printStackTrace();
	}
	 finally
	 {
		  return con;
	  }
    }
 public static void main(String args[])
  {
	System.out.println("hello\n");
	SqlDriver a = new SqlDriver();
	Connection conn = a.connect();
  }//end main
}