Package com.plotsquared.core.database

Class SQLite

java.lang.Object

com.plotsquared.core.database.Database

com.plotsquared.core.database.SQLite

public class SQLite
extends Database

Connects to and uses a SQLite database.

Constructor Summary

Constructors

Constructor	Description
SQLite(File dbLocation)	Creates a new SQLite instance

Method Summary

Modifier and Type	Method	Description
boolean	checkConnection()	Checks if a connection is open with the database.
boolean	closeConnection()	Closes the connection with the database.
Connection	forceConnection()
Connection	getConnection()	Gets the connection with the database.
Connection	openConnection()	Opens a connection with the database.
ResultSet	querySQL(String query)	Executes a SQL Query.
int	updateSQL(String query)	Executes an Update SQL Query.

Methods inherited from class java.lang.Object

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

Constructor Details

SQLite

public SQLite(File dbLocation)

Creates a new SQLite instance

Parameters:

dbLocation - Location of the Database (Must end in .db)

Method Details

openConnection

public Connection openConnection()
                          throws SQLException,
ClassNotFoundException

Description copied from class: Database

Opens a connection with the database.

Specified by:

openConnection in class Database

Returns:

Opened connection

Throws:

SQLException - if the connection can not be opened

ClassNotFoundException - if the driver cannot be found

checkConnection

public boolean checkConnection()
                        throws SQLException

Description copied from class: Database

Checks if a connection is open with the database.

Specified by:

checkConnection in class Database

Returns:

true if the connection is open

Throws:

SQLException - if the connection cannot be checked

getConnection

public Connection getConnection()

Description copied from class: Database

Gets the connection with the database.

Specified by:

getConnection in class Database

Returns:

Connection with the database, null if none

closeConnection

public boolean closeConnection()
                        throws SQLException

Description copied from class: Database

Closes the connection with the database.

Specified by:

closeConnection in class Database

Returns:

true if successful

Throws:

SQLException - if the connection cannot be closed

querySQL

public ResultSet querySQL(String query)
                   throws SQLException,
ClassNotFoundException

Description copied from class: Database

Executes a SQL Query. If the connection is closed, it will be opened.

Specified by:

querySQL in class Database

Parameters:

query - Query to be run

Returns:

the results of the query

Throws:

SQLException - If the query cannot be executed

ClassNotFoundException - If the driver cannot be found; see Database.openConnection()

updateSQL

public int updateSQL(String query)
              throws SQLException,
ClassNotFoundException

Description copied from class: Database

Executes an Update SQL Query. See Statement.executeUpdate(String). If the connection is closed, it will be opened.

Specified by:

updateSQL in class Database

Parameters:

query - Query to be run

Returns:

Result Code, see Statement.executeUpdate(String)

Throws:

SQLException - If the query cannot be executed

ClassNotFoundException - If the driver cannot be found; see Database.openConnection()

forceConnection

public Connection forceConnection()
                           throws SQLException,
ClassNotFoundException

Specified by:

forceConnection in class Database

Throws:

SQLException

ClassNotFoundException