Package Database

Class DivisionDataAccessObject

java.lang.Object

Database.DivisionDataAccessObject

public class DivisionDataAccessObject
extends Object

Class representing all the methods to query the country table

Constructor Summary

Constructors

Constructor	Description
DivisionDataAccessObject()

Method Summary

Modifier and Type	Method	Description
static javafx.collections.ObservableList<FirstLevelDivision>	getAllDivisions()
static FirstLevelDivision	getDivisionByDivisionID(int divisionId)
static javafx.collections.ObservableList<FirstLevelDivision>	getDivisionsByCountryID(int countryId)

Methods inherited from class java.lang.Object

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

Constructor Details

DivisionDataAccessObject

public DivisionDataAccessObject()

Method Details

getDivisionByDivisionID

public static FirstLevelDivision getDivisionByDivisionID(int divisionId)
                                                  throws SQLException

Parameters:

divisionId - the divisionID int value

Returns:

the FirstLevelDivision object

Throws:

SQLException

getAllDivisions

public static javafx.collections.ObservableList<FirstLevelDivision> getAllDivisions()
                                                                             throws SQLException

Returns:

[ObservableList] of FirstLevelDivision objects

Throws:

SQLException

getDivisionsByCountryID

public static javafx.collections.ObservableList<FirstLevelDivision> getDivisionsByCountryID(int countryId)
                                                                                     throws SQLException

Parameters:

countryId - the countryId int value

Returns:

the FirstLevelDivision object

Throws:

SQLException