info.dyndns.thetaco.bullion.api

Class Database

java.lang.Object

info.dyndns.thetaco.bullion.api.Database

public class Database
extends java.lang.Object

If you want your extension of BullionEconomy to use BE's database, use this class. Just be sure to add your own tables and don't edit the stuff BullionEconomy creates by default unless that is your plugin's purpose (of course). Be sure to use the server name if it is necessary for your plugin.

Author:

activates

Constructor Summary

Constructors

Constructor and Description
Database()

Method Summary

Methods

Modifier and Type	Method and Description
void	closeConnection(java.sql.Connection con) This method is designed to be used instead of con.close() because there are certain instances where the connection shouldn't be closed.
java.sql.ResultSet	executeQuery(java.lang.String sql) A method for retrieving information from the database manually without having to mess with the raw connection.
boolean	executeUpdate(java.lang.String sql) An alternative to creating a raw connection yourself.
java.sql.Connection	getRawConnection() For advanced users only! A raw connection to the SQL database for BullionEconomy.
boolean	usingMySQL() Will determine if MySQL is being used or SQLlite is being used.

Methods inherited from class java.lang.Object

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

Constructor Detail

Database

public Database()

Method Detail

getRawConnection

public java.sql.Connection getRawConnection()

For advanced users only! A raw connection to the SQL database for BullionEconomy. If you call this method, Store it in a variable, then use that variable with the closeConnection() method that is also inside of this class. If you don't, newer connections might hang. Do not try to close the connection manually.

Returns:

The raw connection to the database

closeConnection

public void closeConnection(java.sql.Connection con)

This method is designed to be used instead of con.close() because there are certain instances where the connection shouldn't be closed. Don't close the connection yourself, use this method instead.

Parameters:

con -

usingMySQL

public boolean usingMySQL()

Will determine if MySQL is being used or SQLlite is being used.

Returns:

Will return true if MySQL is being used; false if it is using SQLlite

executeUpdate

public boolean executeUpdate(java.lang.String sql)

An alternative to creating a raw connection yourself. Just use this method to update the database. If you are looking to retrieve information from the database, use the executeQuery() method

Parameters:

sql - The SQL you wish to run on BullionEconomy's database

Returns:

Will return true if the update was successful, false if it was not

executeQuery

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

A method for retrieving information from the database manually without having to mess with the raw connection. If you are looking to update the databases information, use the executeUpdate() method.

Parameters:

sql - The SQL you wish to run on BullionEconomy's database

Returns:

Will return the ResultSet you want. If there was an error, it will return null