Package Database

Class ContactDataAccessObject

java.lang.Object

Database.ContactDataAccessObject

public class ContactDataAccessObject
extends Object

Class representing all the methods to query the contacts table

Constructor Summary

Constructors

Constructor	Description
ContactDataAccessObject()

Method Summary

Modifier and Type	Method	Description
static void	addContact(Contact _contact)	This function adds a contact record
static void	deleteContactByContactID(int _contactId)	This function deletes a contact record
static void	deleteContactByDivisionID(int _email)	This function deletes a contact record
static javafx.collections.ObservableList<Contact>	getAllContacts()	This function queries a list of contacts
static Contact	getContactByContactID(int _contactId)	This function queries a contact
static javafx.collections.ObservableList<Contact>	getContactByEmail(int _email)	This function queries a list of contacts
static void	updateContact(Contact _contact)	This function update a contact record

Methods inherited from class java.lang.Object

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

Constructor Details

ContactDataAccessObject

public ContactDataAccessObject()

Method Details

getContactByContactID

public static Contact getContactByContactID(int _contactId)
                                     throws SQLException

This function queries a contact

Parameters:

_contactId - the contactID int value

Returns:

the Contact object

Throws:

SQLException

getAllContacts

public static javafx.collections.ObservableList<Contact> getAllContacts()
                                                                 throws SQLException

This function queries a list of contacts

Returns:

[ObservableList] of Contact objects

Throws:

SQLException

getContactByEmail

public static javafx.collections.ObservableList<Contact> getContactByEmail(int _email)
                                                                    throws SQLException

This function queries a list of contacts

Parameters:

_email - the email string value

Returns:

[ObservableList] of Contact objects

Throws:

SQLException

deleteContactByContactID

public static void deleteContactByContactID(int _contactId)
                                     throws SQLException

This function deletes a contact record

Parameters:

_contactId - the contactID int value

Throws:

SQLException

deleteContactByDivisionID

public static void deleteContactByDivisionID(int _email)
                                      throws SQLException

This function deletes a contact record

Parameters:

_email - the email string value

Throws:

SQLException

addContact

public static void addContact(Contact _contact)

This function adds a contact record

Parameters:

_contact - the Contact object

updateContact

public static void updateContact(Contact _contact)

This function update a contact record

Parameters:

_contact - the Contact object