logbook.storage.db
Class JFlightLogDbController

java.lang.Object
  logbook.storage.db.JFlightLogDbController

public class JFlightLogDbController
extends java.lang.Object

Central point for data base operations(connecting, creating, updating, querying, shutting down, etc.

Method Summary

static void	cleanDb() Deletes all data from the logbook table
static void	connectToDb(java.lang.String db_file_name_prefix) Connects to the database
static void	deleteAllRecsFromDb() Deletes all logbook records from the database
static void	deleteDbRec(LogBookRecord rec) Deletes a single logbook record from the database
static void	insertDbRec(LogBookRecord rec) Inserts the provided logbookrecord into the database
static void	insertWholeEntireLogBook(LogBook logBook) Inserts a whole entire logbook into the database :) It does this by looping through all the LogBookRecord's
static java.sql.ResultSet	query(java.lang.String expression) use for SQL command SELECT NOTE: RIF REMOVED THE SYNCHRONIZED MODIFIER!! READY FOR THE LIGHTNING SPEED!
static void	shutdown() Shuts down the database in a clean manner
static void	update(java.lang.String expression) use for SQL commands CREATE, DROP, INSERT and UPDATE NOTE: RIF REMOVED THE 'SYNCRONIZED' MODIFIER! (READY FOR THE LIGHTNING SPEED!)
static void	updateDbRec(LogBookRecord rec) Updates the provided record in the database

Methods inherited from class java.lang.Object

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

Method Detail

connectToDb

public static void connectToDb(java.lang.String db_file_name_prefix)

Connects to the database

cleanDb

public static void cleanDb()
                    throws java.lang.Exception

Deletes all data from the logbook table

Throws:

java.lang.Exception

shutdown

public static void shutdown()
                     throws java.sql.SQLException

Shuts down the database in a clean manner

Throws:

java.sql.SQLException

query

public static java.sql.ResultSet query(java.lang.String expression)
                                throws java.sql.SQLException

use for SQL command SELECT NOTE: RIF REMOVED THE SYNCHRONIZED MODIFIER!! READY FOR THE LIGHTNING SPEED!

Throws:

java.sql.SQLException

update

public static void update(java.lang.String expression)
                   throws java.sql.SQLException

use for SQL commands CREATE, DROP, INSERT and UPDATE NOTE: RIF REMOVED THE 'SYNCRONIZED' MODIFIER! (READY FOR THE LIGHTNING SPEED!)

Throws:

java.sql.SQLException

insertWholeEntireLogBook

public static void insertWholeEntireLogBook(LogBook logBook)

Inserts a whole entire logbook into the database :) It does this by looping through all the LogBookRecord's

insertDbRec

public static void insertDbRec(LogBookRecord rec)

Inserts the provided logbookrecord into the database

updateDbRec

public static void updateDbRec(LogBookRecord rec)

Updates the provided record in the database

deleteDbRec

public static void deleteDbRec(LogBookRecord rec)

Deletes a single logbook record from the database

deleteAllRecsFromDb

public static void deleteAllRecsFromDb()

Deletes all logbook records from the database