me.armar.plugins.autorank.data
Class SQLDataStorage

java.lang.Object
  me.armar.plugins.autorank.data.SQLDataStorage

public class SQLDataStorage
extends java.lang.Object

Field Summary

private java.sql.Connection	conn
private java.lang.String	database
private java.lang.String	hostname
private java.lang.String	password
private java.lang.String	username

Constructor Summary

SQLDataStorage(java.lang.String hostname, java.lang.String username, java.lang.String password, java.lang.String database)
Create a new MySQL Connection

Method Summary

boolean	connect() Open a new MySQL connection
void	execute(java.lang.String sql) Execute a query.
java.sql.ResultSet	executeQuery(java.lang.String sql) Execute a query and returns a ResultSet.
boolean	isClosed() Returns state of MySQL connection

Methods inherited from class java.lang.Object

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

Field Detail

hostname

private java.lang.String hostname

username

private java.lang.String username

password

private java.lang.String password

database

private java.lang.String database

conn

private java.sql.Connection conn

Constructor Detail

SQLDataStorage

public SQLDataStorage(java.lang.String hostname,
                      java.lang.String username,
                      java.lang.String password,
                      java.lang.String database)

Create a new MySQL Connection

Parameters:

hostname - Hostname (Ex. 127.0.0.1:3306)

username - Username

password - Password

database - Database

Method Detail

execute

public void execute(java.lang.String sql)

Execute a query. Query cannot be null. This query doesn't return anything. (Good for updating tables)

Parameters:

sql - Query to execute

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)

Execute a query and returns a ResultSet. Query cannot be null.

Parameters:

sql - Query to execute

Returns:

ResultSet if successfully performed, null if an error occured.

connect

public boolean connect()

Open a new MySQL connection

Returns:

true if connection was successfully set up.

isClosed

public boolean isClosed()

Returns state of MySQL connection

Returns:

true if closed, false if open