import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class ConnectionManager {
 
    // Connection data -- START
 
    static final String driver   = "com.mysql.jdbc.my_driver_version";
    static final String dbserver = "mysql.server.name";
    static final String dbport   = "mysql.database.port";
    static final String dbname   = "mysql.database.name";
    static final String dbuser   = "mysql.database.username";
    static final String dbpass   = "mysql.database.password";
 
    // Connection data -- END
 
    /**
     * Opens a connection to the database
     *
     * @return Returns a Connection object
     */
    public static Connection getConnection(){
 
        Connection con = null;
 
        try {
 
            Class.forName(driver).newInstance();
            String conString = "jdbc:mysql://"+dbserver+":"+dbport+"/"+dbname;
            con = DriverManager.getConnection(conString,dbuser, dbpass);
 
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
 
        return con;
    }
 
    public static void close(Object object){
 
        if (object != null){
 
            try {
 
                if (object instanceof Connection)
                    ((Connection)object).close();
 
                else if (object instanceof Statement)
                    ((Statement)object).close();
 
                else if (object instanceof PreparedStatement)
                    ((PreparedStatement)object).close();
 
                else if (object instanceof ResultSet)
                    ((ResultSet)object).close();
 
            } catch (SQLException e) {
                e.printStackTrace();
            } finally {
                object = null;
            }
        }
    }
}