gyurix.mysql

Class MySQLDatabase

java.lang.Object

gyurix.mysql.MySQLDatabase

public class MySQLDatabase
extends java.lang.Object

Class representing a MySQL storage connection and containing the required methods and utils for executing MySQL queries

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	MySQLDatabase.MySQLBatch

Field Summary

Fields

Modifier and Type	Field and Description
static java.util.concurrent.ExecutorService	batchThread
java.lang.String	table

Constructor Summary

Constructors

Constructor and Description
MySQLDatabase()
MySQLDatabase(java.lang.String host, java.lang.String database, java.lang.String username, java.lang.String password)

Method Summary

Modifier and Type	Method and Description
void	batch(java.lang.Iterable<java.lang.String> commands)
void	batch(java.lang.Iterable<java.lang.String> commands, java.lang.Runnable r)
void	batchNoAsync(java.lang.Iterable<java.lang.String> commands)
void	close()
boolean	command(java.lang.String cmd)
boolean	command(java.lang.String cmd, java.lang.Object... args)
static java.lang.String	escape(java.lang.String in)
com.mysql.jdbc.Connection	getConnection()
boolean	openConnection()
java.sql.ResultSet	query(java.lang.String cmd)
java.sql.ResultSet	query(java.lang.String cmd, java.lang.Object... args)
int	update(java.lang.String cmd)
int	update(java.lang.String cmd, java.lang.Object... args)

Methods inherited from class java.lang.Object

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

Field Detail

batchThread

public static java.util.concurrent.ExecutorService batchThread

table

public java.lang.String table

Constructor Detail

MySQLDatabase

public MySQLDatabase()

MySQLDatabase

public MySQLDatabase(java.lang.String host,
                     java.lang.String database,
                     java.lang.String username,
                     java.lang.String password)

Parameters:

host - - The host of the MySQL server

database - - The name of the database

username - - The username to the MySQL server

password - - The password to the MySQL server

Method Detail

escape

public static java.lang.String escape(java.lang.String in)

batch

public void batch(java.lang.Iterable<java.lang.String> commands)

batch

public void batch(java.lang.Iterable<java.lang.String> commands,
                  java.lang.Runnable r)

batchNoAsync

public void batchNoAsync(java.lang.Iterable<java.lang.String> commands)

close

public void close()

command

public boolean command(java.lang.String cmd)

command

public boolean command(java.lang.String cmd,
                       java.lang.Object... args)

getConnection

public com.mysql.jdbc.Connection getConnection()

Returns:

- The Connection

openConnection

public boolean openConnection()

Returns:

True on successful connection otherwise false

query

public java.sql.ResultSet query(java.lang.String cmd)

query

public java.sql.ResultSet query(java.lang.String cmd,
                                java.lang.Object... args)

update

public int update(java.lang.String cmd)

update

public int update(java.lang.String cmd,
                  java.lang.Object... args)