Utilities

Class DbInt

java.lang.Object

Utilities.DbInt

public class DbInt
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
static String	prefix

Constructor Summary

Constructors

Constructor and Description
DbInt()

Method Summary

Modifier and Type	Method and Description
static void	baselineDatabse(String database)
static Boolean	createDb(String DB) Creates a database with specified name
static void	createSetAndTables()
static void	deleteAllDB()
static void	deleteDb(String DB)
static Iterable<String>	getAllCustomerNames()
static Iterable<Customer>	getAllCustomers()
static String	getCategoryDate(String catName, String year)
static Connection	getConnection() Creates a Prepared statemtn from provided Parameters.
static Connection	getConnection(String Db)
static User	getCurrentUser()
static String	getCustInf(String yearL, Integer ID, String info, String defaultVal) Gets the specified Utilities.Customer info
static String	getCustInf(String yearL, int id, String info) Gets the specified Utilities.Customer info
static Version	getDatabaseVersion()
static ArrayList<String>	getDatabses()
static Version	getStoredProgramVersion(String Database)
static User	getUser(String year)
static String	getUserName()
static ArrayList<User>	getUsers()
static ArrayList<String>	getUserYears()
static ArrayList<String>	getYears()
static String	getYearsForUser(String uName)
static boolean	isAdmin()
static void	migrateDatabase(String database, String location)
static void	setPrefix(String newPrefix)
static boolean	testConnection()
static Boolean	verifyLogin(javafx.util.Pair<String,String> userPass)
static Boolean	verifyLoginAndUser(javafx.util.Pair<String,String> userPass)

Methods inherited from class java.lang.Object

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

Field Detail

prefix

public static String prefix

Constructor Detail

DbInt

public DbInt()

Method Detail

setPrefix

public static void setPrefix(String newPrefix)

getCustInf

public static String getCustInf(String yearL,
                                int id,
                                String info)

Gets the specified Utilities.Customer info

Parameters:

yearL - The year to search

info - The info to search for

Returns:

A string with the resulting data

getCustInf

public static String getCustInf(String yearL,
                                Integer ID,
                                String info,
                                String defaultVal)

Gets the specified Utilities.Customer info

Parameters:

yearL - The year to search

info - The info to search for

defaultVal - The default value to return if there is no data

Returns:

A string with the resulting data

getConnection

public static Connection getConnection(String Db)
                                throws SQLException

Throws:

SQLException

testConnection

public static boolean testConnection()

getConnection

public static Connection getConnection()
                                throws SQLException

Creates a Prepared statemtn from provided Parameters.

Returns:

the PreparedStatemtn that was created.

Throws:

SQLException

createDb

public static Boolean createDb(String DB)

Creates a database with specified name

Parameters:

DB - The name of the DB to create

deleteAllDB

public static void deleteAllDB()

createSetAndTables

public static void createSetAndTables()

getUsers

public static ArrayList<User> getUsers()
                                throws AccessException

Throws:

AccessException

deleteDb

public static void deleteDb(String DB)

getAllCustomerNames

public static Iterable<String> getAllCustomerNames()

getAllCustomers

public static Iterable<Customer> getAllCustomers()

getYearsForUser

public static String getYearsForUser(String uName)

getUserYears

public static ArrayList<String> getUserYears()

getYears

public static ArrayList<String> getYears()

getCategoryDate

public static String getCategoryDate(String catName,
                                     String year)

getUserName

public static String getUserName()

getUser

public static User getUser(String year)

getCurrentUser

public static User getCurrentUser()
                           throws SQLException

Throws:

SQLException

getDatabses

public static ArrayList<String> getDatabses()

migrateDatabase

public static void migrateDatabase(String database,
                                   String location)
                            throws AccessException

Throws:

AccessException

baselineDatabse

public static void baselineDatabse(String database)
                            throws AccessException

Throws:

AccessException

verifyLoginAndUser

public static Boolean verifyLoginAndUser(javafx.util.Pair<String,String> userPass)

verifyLogin

public static Boolean verifyLogin(javafx.util.Pair<String,String> userPass)

isAdmin

public static boolean isAdmin()

getDatabaseVersion

public static Version getDatabaseVersion()

getStoredProgramVersion

public static Version getStoredProgramVersion(String Database)