me.leoko.advancedban.manager

Class DatabaseManager

java.lang.Object

me.leoko.advancedban.manager.DatabaseManager

public class DatabaseManager
extends Object

The Database Manager is used to interact directly with the database is use.
Will automatically direct the requests to either MySQL or HSQLDB.

Looking to request Punishments from the Database? Use PunishmentManager.getPunishments(SQLQuery, Object...) or PunishmentManager.getPunishmentFromResultSet(ResultSet) for already parsed data.

Constructor Summary

Constructors

Constructor and Description
DatabaseManager()

Method Summary

Modifier and Type	Method and Description
ResultSet	executeResultStatement(SQLQuery sql, Object... parameters) Execute a sql statement.
void	executeStatement(SQLQuery sql, Object... parameters) Execute a sql statement without any results.
static DatabaseManager	get() Get the instance of the command manager
boolean	isConnectionValid(int timeout) Check whether there is a valid connection to the database.
boolean	isFailedMySQL() Check whether the connection to MySQL failed.
boolean	isUseMySQL() Check whether MySQL is actually used.
void	setup(boolean useMySQLServer) Initially connects to the database and sets up the required tables of they don't already exist.
void	shutdown() Shuts down the HSQLDB if used.

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseManager

public DatabaseManager()

Method Detail

get

public static DatabaseManager get()

Get the instance of the command manager

Returns:

the database manager instance

setup

public void setup(boolean useMySQLServer)

Initially connects to the database and sets up the required tables of they don't already exist.

Parameters:

useMySQLServer - whether to preferably use MySQL (uses HSQLDB as fallback)

shutdown

public void shutdown()

Shuts down the HSQLDB if used.

executeStatement

public void executeStatement(SQLQuery sql,
                             Object... parameters)

Execute a sql statement without any results.

Parameters:

sql - the sql statement

parameters - the parameters

executeResultStatement

public ResultSet executeResultStatement(SQLQuery sql,
                                        Object... parameters)

Execute a sql statement.

Parameters:

sql - the sql statement

parameters - the parameters

Returns:

the result set

isConnectionValid

public boolean isConnectionValid(int timeout)

Check whether there is a valid connection to the database.

Parameters:

timeout - the timeout for the check

Returns:

whether there is a valid connection

isFailedMySQL

public boolean isFailedMySQL()

Check whether the connection to MySQL failed.

Returns:

true if MySQL has been specified as the preferred Database and due to some error HSQLDB is used as the fallback database.

isUseMySQL

public boolean isUseMySQL()

Check whether MySQL is actually used.

Returns:

whether MySQL is used