SQLAccess

SQLAccess
========

This is a simple Java 8 library that facilitates SQLite access for any Java program

API
========
The SQLAccess class is the entry point of this library.

It has 2 constructors: SQLAccess (File) and SQLAccess (String)

Both of these constructors will attempt to create a file if it does not already exist, and will initialize the instance to use this particular file

The SQLAccess does not lock the database unless it is actively writing to it at this very time. However, you should still not have multiple SQLAccess instances for a single file simultaneously since write operation will fail if the file is locked.

From an SQLAccess instance, you can use multiple methods to interact with the database. Here are the main ones:

boolean CreateTable (SQLTable) : Creates a table (if it does not exist) using the SQLTable instance provided. Returns if it succeded

boolean DeleteTable (String) : Deletes the table if it exists. Returns if it succeeded

boolean AddFieldToTable (String, SQLField) : Adds a new field to the table. Return if it succeeded. Please note that you cannot add special fields (IE. primary keys and auto increment)

public boolean RenameTable (String, String) : Renames a table. Returns if it succeeded.

boolean ExecuteSQLOperation (String) : Executes a DELETE, UPDATE or INSERT operation on the database. Returns if an entry was successfully altered.

ResultSet ExecuteSQLQuery (String) : Executes a SELECT operation on the database. Returns the ResultSet of that operation. Make sure to close it when you are finished with it


boolean EntryExist (String, SQLField, Object) : Returns if a particular entry exists. Parameters, in order:

- The table name
- The SQLField representing the primary key
- The value of the primary key to search for

Returns if an entry was found

void close(void) : closes the database connection. You should always do this before disbanding an SQLAccess instance

Integration
========

Simply import
org.spectralmemories.sqlaccess.* to use the library

You must also extract this library into your final jar file

Bugs and inquiries
========

If you encounter a bug or have any question, simply post it in the discussion tab of this page