How To - Create a Database Connection Class in Java (MySQL)

This was created when i was doing a project and was creating lot of database connections and i final spend my time to create a proper class to be used by other class of my projects. special attention was given to the variable creation. so that same could be used all over the project and to make standardized the code as possible. also to reduce the amount of memory used.

You can use the methods in this class to execute or get a resultset just insert the SQL query in a String format

Warning- this class returns a resultset this could lead to memory leak so better to close connection which are created.

Download Source Code

	//This class is able to be used in any project or with another class to connect with MySQL database.
	//Author -Dinushka95@yahoo.com
	//11/12/2016
	package MainSystem;
	import com.mysql.jdbc.Connection;
	import java.sql.DriverManager;
	import java.sql.PreparedStatement;
	import java.sql.ResultSet;
	import java.sql.SQLException;
	import java.util.logging.Level;
	import java.util.logging.Logger;
	public class AutoDB_Connect {
	//Thses varriables are the main varriables ued in this and other class that's why
	//it is public and Static because i wanted it to be in globle level
	public static Connection DB_connection =null;
	public static PreparedStatement DB_PreparedStatement =null;
	public static ResultSet DB_ResultSet =null;
	//Default Contructor will use above valuse
	private static String DB_Host= "jdbc:mysql://localhost:3306/garmentsystem";
	private static String username="YOUR USERNAME";
	private static String password="YOUR PASSWORD";
	//Default Contructor
	public AutoDB_Connect() {
	}
	// this constructor can be used to change your connection settings
	public AutoDB_Connect(String Database_URL,int Port,String DatabaseName,String Username,String Password) {
	DB_Host="jdbc:mysql://"+Database_URL+":"+Port+"/"+DatabaseName+"";
	username=Username;
	password=Password;
	}
	// used to start a connection with the above selected settings
	public void connect()
	{
	try
	{
	Class.forName("com.mysql.jdbc.Driver");
	DB_connection=(Connection) DriverManager.getConnection(DB_Host,username,password);
	System.out.println("Succesfully connected to "+DB_Host);
	}
	catch(Exception e)
	{
	System.out.println(e);
	}
	}
	// Close the DB connection
	public void close()
	{
	try {
	DB_connection.close();
	} catch (SQLException ex) {
	Logger.getLogger(AutoDB_Connect.class.getName()).log(Level.SEVERE, null, ex);
	}
	}
	// this method is used to excute SQL queryies without a return value
	// this method will return a boolen value if it is sucessfull and a message in the console
	public boolean execute(String SQL_String){
	DB_ResultSet =null;
	//System.out.println(SQL_String);
	try {
	DB_PreparedStatement =DB_connection.prepareStatement(SQL_String);
	DB_PreparedStatement.execute();
	System.out.println("***Successfull***Excuted "+SQL_String);
	return true;
	} catch (SQLException ex) {
	System.out.println("***Fail***Excuted "+SQL_String);
	Logger.getLogger(AutoDB_Connect.class.getName()).log(Level.SEVERE, null, ex);
	return false;
	}
	}
	// this method is used to excute SQL queryies with a return value
	// this method will return a Resultset if it is sucessfull Or NULL value if it fails and a message in the console
	public ResultSet executeQuery(String SQL_String)
	{
	DB_ResultSet =null;
	System.out.println(SQL_String);
	try {
	DB_PreparedStatement =DB_connection.prepareStatement(SQL_String);
	DB_ResultSet=DB_PreparedStatement.executeQuery();
	System.out.println("***Successfull***Excuted "+SQL_String);
	return DB_ResultSet;
	} catch (SQLException ex) {
	System.out.println("***Fail***Excuted "+SQL_String);
	Logger.getLogger(AutoDB_Connect.class.getName()).log(Level.SEVERE, null, ex);
	return null;
	}
	}
	}

view raw AutoDB_Connect.java hosted with ❤ by GitHub