com.codelanx.codelanxlib.data.types

Class SQLite

java.lang.Object

com.codelanx.codelanxlib.data.types.SQLite

All Implemented Interfaces:

DataType, SQLDataType, AutoCloseable

public class SQLite
extends Object
implements SQLDataType

Instantiable SQLite connector

Since:

0.1.0

Version:

0.1.0

Author:

1Rogue

Field Summary

Fields

Modifier and Type	Field and Description
protected Connection	con The Connection object
protected static byte	connections The number of connections in use by this data type

Constructor Summary

Constructors

Constructor and Description
SQLite()

Method Summary

Modifier and Type	Method and Description
boolean	checkTable(String tablename) Checks if a table exists within the set database
void	close() Closes the SQLite connection.
Connection	getConnection() Returns the Connection object for ease of use in exposing more internal API
Connection	open(File folder, String name) Opens a connection to the SQLite database.
Connection	open(org.bukkit.plugin.Plugin plugin) Opens a connection to the SQLite database.
Connection	open(org.bukkit.plugin.Plugin plugin, String name) Opens a connection to the SQLite database.

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.codelanx.codelanxlib.data.SQLDataType

commit, isAutoCommit, prepare, query, rollback, setAutoCommit, update

Field Detail

connections

protected static byte connections

The number of connections in use by this data type

con

protected Connection con

The Connection object

Constructor Detail

SQLite

public SQLite()

Method Detail

open

public Connection open(org.bukkit.plugin.Plugin plugin)
                throws SQLException

Opens a connection to the SQLite database. Make sure to call SQLite.close() after you are finished working with the database for your segment of your code.

Parameters:

plugin - The Plugin with the data folder to use

Returns:

The Connection object

Throws:

SQLException - If the connection fails to open

Since:

0.1.0

open

public Connection open(org.bukkit.plugin.Plugin plugin,
                       String name)
                throws SQLException

Opens a connection to the SQLite database. Make sure to call SQLite.close() after you are finished working with the database for your segment of your code.

Parameters:

plugin - The Plugin with the data folder to use

name - The name of the database file

Returns:

The Connection object

Throws:

SQLException - If the connection fails to open

Since:

0.1.0

open

public Connection open(File folder,
                       String name)
                throws SQLException

Opens a connection to the SQLite database. Make sure to call SQLite.close() after you are finished working with the database for your segment of your code.

Parameters:

folder - A File pointing to a data folder for the database

name - The name of the database file

Returns:

The Connection object

Throws:

SQLException - If the connection fails to open

Since:

0.1.0

checkTable

public boolean checkTable(String tablename)
                   throws SQLException

Checks if a table exists within the set database

Specified by:

checkTable in interface SQLDataType

Parameters:

tablename - Name of the table to check for

Returns:

true if exists, false otherwise

Throws:

SQLException - The query on the database fails

Since:

0.1.0

close

public void close()

Closes the SQLite connection. Must be open first.

Specified by:

close in interface SQLDataType

Specified by:

close in interface AutoCloseable

Since:

0.1.0

getConnection

public Connection getConnection()

Returns the Connection object for ease of use in exposing more internal API

Specified by:

getConnection in interface SQLDataType

Returns:

The Connection object in use by this SQLDataType

Since:

0.1.0