Package id.luckynetwork.lyrams.lyralibs.core.database.mysql

Class MySQL

java.lang.Object

id.luckynetwork.lyrams.lyralibs.core.database.mysql.MySQL

public class MySQL
extends Object

Constructor Summary

Constructors

Constructor	Description
MySQL(String host, String port, String database, String username, String password, boolean useSSL)
MySQL(String host, String port, String database, String username, String password, boolean useSSL, boolean useHikari)

Method Summary

Modifier and Type	Method	Description
void	connect()	It connects to the database
void	disconnect()	If the connection is open, close it.
void	executeQuery(String sql)	"Execute the given SQL query, and call the given callback function with the results."
Connection	getConnection()
boolean	isConnected()	If the connection is not null, and it's not closed, and it's valid, then it's connected
Results	results(String sql)	"Execute the given SQL statement and return the results."

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

MySQL

public MySQL(String host,
 String port,
 String database,
 String username,
 String password,
 boolean useSSL,
 boolean useHikari)

MySQL

public MySQL(String host,
 String port,
 String database,
 String username,
 String password,
 boolean useSSL)

Method Details

connect

public void connect()
             throws SQLException

It connects to the database

Throws:

SQLException

disconnect

public void disconnect()
                throws SQLException

If the connection is open, close it.

Throws:

SQLException

getConnection

public Connection getConnection()
                         throws SQLException

Throws:

SQLException

isConnected

public boolean isConnected()

If the connection is not null, and it's not closed, and it's valid, then it's connected

Returns:

A boolean value.

executeQuery

public void executeQuery(String sql)
                  throws SQLException

"Execute the given SQL query, and call the given callback function with the results."

The first line of the function creates a new Query object, passing in the SQL query and the callback function. The second line calls to execute() function on the Query object

Parameters:

sql - The SQL query to execute.

Throws:

SQLException

results

public Results results(String sql)
                throws SQLException

"Execute the given SQL statement and return the results."

The first thing we do is create a new Query object. We pass in the SQL statement and the database connection

Parameters:

sql - The SQL query to execute.

Returns:

A new Query object is being returned.

Throws:

SQLException