datastructure

Class SQLiteDB

java.lang.Object

datastructure.SQLiteDB

public class SQLiteDB
extends java.lang.Object

The class SQLiteDB implements interface to the database.
The used database is SQLite: http://www.sqlite.org/

Author:

Tomasz Bujlow (tbu@es.aau.dk)

Field Summary

Fields

Modifier and Type	Field and Description
(package private) com.almworks.sqlite4java.SQLiteConnection	con Connection to the database.
private static org.apache.log4j.Logger	log Used to log different events.
(package private) com.almworks.sqlite4java.SQLiteStatement	st Statement to be executed.

Constructor Summary

Constructors

Constructor and Description
SQLiteDB(java.lang.String databasePath) Constructs the object.

Method Summary

Methods

Modifier and Type	Method and Description
void	close() Closes connection to the database.
java.util.ArrayList<java.lang.Object[]>	executeQuery(java.lang.String str) Executes a SQL command and returns a result.
boolean	executeUpdate(java.lang.String str) Executes a SQL command without returning any result.

Methods inherited from class java.lang.Object

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

Field Detail

log

private static org.apache.log4j.Logger log

Used to log different events.

con

com.almworks.sqlite4java.SQLiteConnection con

Connection to the database.

st

com.almworks.sqlite4java.SQLiteStatement st

Statement to be executed.

Constructor Detail

SQLiteDB

public SQLiteDB(java.lang.String databasePath)
         throws java.lang.Exception

Constructs the object.

Parameters:

databasePath - path to the database file

Throws:

java.lang.Exception - when cannot open the database file

Method Detail

executeUpdate

public boolean executeUpdate(java.lang.String str)

Executes a SQL command without returning any result.

Parameters:

str - SQL command to be executed

Returns:

true if the SQL command was successfully executed, false otherwise

executeQuery

public java.util.ArrayList<java.lang.Object[]> executeQuery(java.lang.String str)

Executes a SQL command and returns a result.

Parameters:

str - SQL command to be executed

Returns:

list of rows. Each row is defined as array of Objects (columns), which must be casted to a specific data type.

close

public void close()

Closes connection to the database.