ABOS.Derby

Class DbInt

java.lang.Object

ABOS.Derby.DbInt

public class DbInt
extends Object

Field Summary

Fields

Modifier and Type	Field and Description
static String	DbLoc
static Connection	pCon

Constructor Summary

Constructors

Constructor and Description
DbInt()

Method Summary

Modifier and Type	Method and Description
static Boolean	createDb(String DB) Creates a database with specified name
static void	createSetAndTables()
static void	deleteDb(String DB)
static Iterable<String>	getAllCustomers()
static String	getCategoryDate(String catName, String year)
static String	getCustInf(String yearL, String name, String info) Gets the specified Utilities.Customer info
static String	getCustInf(String yearL, String name, String info, String defaultVal) Gets the specified Utilities.Customer info
static PreparedStatement	getPrep(String Db, String Command) Creates a Prepared statemtn from provided Parameters.
static Iterable<String>	getYears()

Methods inherited from class java.lang.Object

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

Field Detail

pCon

public static Connection pCon

DbLoc

public static String DbLoc

Constructor Detail

DbInt

public DbInt()

Method Detail

getCustInf

public static String getCustInf(String yearL,
                                String name,
                                String info)

Gets the specified Utilities.Customer info

Parameters:

yearL - The year to search

name - The customer name

info - The info to search for

Returns:

A string with the resulting data

getCustInf

public static String getCustInf(String yearL,
                                String name,
                                String info,
                                String defaultVal)

Gets the specified Utilities.Customer info

Parameters:

yearL - The year to search

name - The customer name

info - The info to search for

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

Returns:

A string with the resulting data

getPrep

public static PreparedStatement getPrep(String Db,
                                        String Command)
                                 throws SQLException

Creates a Prepared statemtn from provided Parameters.

Parameters:

Db - The database to create the statement for

Command - The Base command for the statement

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

createSetAndTables

public static void createSetAndTables()

deleteDb

public static void deleteDb(String DB)

getAllCustomers

public static Iterable<String> getAllCustomers()

getYears

public static Iterable<String> getYears()

getCategoryDate

public static String getCategoryDate(String catName,
                                     String year)