me.mrCookieSlime.CSCoreLibPlugin.database

Class MySQLDatabase

java.lang.Object

me.mrCookieSlime.CSCoreLibPlugin.database.MySQLDatabase

All Implemented Interfaces:

Database

public class MySQLDatabase
extends java.lang.Object
implements Database

Constructor Summary

Constructors

Constructor and Description
MySQLDatabase(org.bukkit.plugin.Plugin plugin)

Method Summary

Modifier and Type	Method and Description
void	closeConnection()
static void	closeResources(java.sql.ResultSet set, java.sql.PreparedStatement statement)
void	createTable(java.lang.String table, java.lang.String primary_key, java.lang.String... parameters)
java.lang.String	formatTableName(java.lang.String name)
java.sql.Connection	getConnection()
java.lang.String	getIP()
java.sql.ResultSet	getResults(java.lang.String query)
boolean	isConnected()
java.sql.ResultSet	selectFromTable(java.lang.String table)
java.sql.ResultSet	selectFromTable(java.lang.String table, java.util.Map<java.lang.String,java.lang.String> requirements)
java.sql.ResultSet	selectFromTable(java.lang.String table, java.lang.String[] columns)
java.sql.ResultSet	selectFromTable(java.lang.String table, java.lang.String[] columns, java.util.Map<java.lang.String,java.lang.String> requirements)
void	update(java.lang.String query)

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLDatabase

public MySQLDatabase(org.bukkit.plugin.Plugin plugin)

Method Detail

getConnection

public java.sql.Connection getConnection()

Specified by:

getConnection in interface Database

getIP

public java.lang.String getIP()

Specified by:

getIP in interface Database

isConnected

public boolean isConnected()

Specified by:

isConnected in interface Database

closeResources

public static void closeResources(java.sql.ResultSet set,
                                  java.sql.PreparedStatement statement)

closeConnection

public void closeConnection()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

update

public void update(java.lang.String query)

formatTableName

public java.lang.String formatTableName(java.lang.String name)

getResults

public java.sql.ResultSet getResults(java.lang.String query)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

selectFromTable

public java.sql.ResultSet selectFromTable(java.lang.String table)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

selectFromTable

public java.sql.ResultSet selectFromTable(java.lang.String table,
                                          java.lang.String[] columns)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

selectFromTable

public java.sql.ResultSet selectFromTable(java.lang.String table,
                                          java.lang.String[] columns,
                                          java.util.Map<java.lang.String,java.lang.String> requirements)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

selectFromTable

public java.sql.ResultSet selectFromTable(java.lang.String table,
                                          java.util.Map<java.lang.String,java.lang.String> requirements)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

createTable

public void createTable(java.lang.String table,
                        java.lang.String primary_key,
                        java.lang.String... parameters)