PSE 2000 Group 4

jobmatch.data
Class AdressDO

jobmatch.data.AdressDO

public class AdressDO
implements Serializable

Data core class, used to set, retrieve the AdressDO information.

Since:
jobmatch
Version:
$Revision: 1.2 $
See Also:
Serialized Form

Field Summary
static jobmatch.data.RDBColumn City
           
static jobmatch.data.RDBColumn Country
           
static jobmatch.data.RDBColumn HouseNumber
           
protected static boolean isView
           
static jobmatch.data.RDBColumn PrimaryKey
           
static jobmatch.data.RDBColumn Street
           
static jobmatch.data.RDBTable table
          static final data members name the table and columns for this DO.
static jobmatch.data.RDBColumn ZIP
           
 
Constructor Summary
protected AdressDO()
          Protected constructor.
protected AdressDO(boolean is_view)
          Protected constructor.
protected AdressDO(jobmatch.data.ObjectId id)
          Protected constructor used by createExisting(ObjectId) above.
protected AdressDO(ResultSet rs)
          Protected constructor.
 
Method Summary
 void addCandidateDO(CandidateDO referrer)
          Add (set & commit) a CandidateDO object that refers to this DO.
 void addCandidateDO(CandidateDO referrer, jobmatch.data.DBTransaction tran)
          Add (set & commit) a CandidateDO object that refers to this DO.
 void addCompanyDO(CompanyDO referrer)
          Add (set & commit) a CompanyDO object that refers to this DO.
 void addCompanyDO(CompanyDO referrer, jobmatch.data.DBTransaction tran)
          Add (set & commit) a CompanyDO object that refers to this DO.
 void addEmployerDO(EmployerDO referrer)
          Add (set & commit) a EmployerDO object that refers to this DO.
 void addEmployerDO(EmployerDO referrer, jobmatch.data.DBTransaction tran)
          Add (set & commit) a EmployerDO object that refers to this DO.
 void addPersonDO(PersonDO referrer)
          Add (set & commit) a PersonDO object that refers to this DO.
 void addPersonDO(PersonDO referrer, jobmatch.data.DBTransaction tran)
          Add (set & commit) a PersonDO object that refers to this DO.
protected  void afterAnySet()
           
protected  void beforeAnyGet()
          The developer of a Business Object that derives from this class can override the methods: beforeAnyGet beforeAnySet afterAnySet to handle any general assertions or cleanup needed for get and set methods.
protected  void beforeAnySet()
           
 void commit()
          Inserts/Updates the DO into its table.
 void commit(jobmatch.data.DBTransaction dbt)
          Inserts/Updates the DO into its table.
static AdressDO createCopy(AdressDataStruct data)
          createCopy() Creates a DO that has no ObjectId but has a copy of an existing DO's data.
static AdressDO createCopy(AdressDO orig)
          createCopy() Creates a DO that has no ObjectId but has a copy of an existing DO's data.
static AdressDO createExisting(BigDecimal bd)
          createExisting( BigDecimal ) Factory method creates a AdressDO object by searching for it in the database using the passed BigDecimal value as the primary key.
protected static AdressDO createExisting(jobmatch.data.ObjectId id)
          createExisting( ObjectId ) Factory method creates a AdressDO object by searching for it in the database using the passed ObjectID value as the primary key.
protected static AdressDO createExisting(jobmatch.data.RDBColumnValue pk)
          createExisting( RDBColumnValue ) Factory method creates a AdressDO object by searching for it in the database using the passed AdressDO.PrimaryKey.
protected static AdressDO createExisting(jobmatch.data.RDBRow row)
          createExisting( RDBRow ) Factory method creates a AdressDO object by searching for it in the database using the AdressDO.PrimaryKey value in the passed RDBRow.
protected static AdressDO createExisting(ResultSet rs)
          createExisting( ResultSet ) Factory method used to create an instance of this class to represent a Data Object already existing in the database.
static AdressDO createExisting(String handle)
          The createExisting method is used to create a AdressDO from a string handle.
static AdressDO createVirgin()
          createVirgin() Creates a DO that has no ObjectId or data.
 void delete()
          Deletes the DO from its table.
 void delete(jobmatch.data.DBTransaction dbt)
          Deletes the DO from its table.
 CandidateDO getCandidateDO()
          Get the single CandidateDO object that refers to this DO.
 CandidateDO[] getCandidateDOArray()
          Get array of CandidateDO objects that refer to this DO.
 String getCity()
          Get City of the Adress
 CompanyDO getCompanyDO()
          Get the single CompanyDO object that refers to this DO.
 CompanyDO[] getCompanyDOArray()
          Get array of CompanyDO objects that refer to this DO.
 CountryDO getCountry()
          Get Country of the Adress
 PreparedStatement getDeleteStatement(jobmatch.data.DBConnection conn)
          Prepares the statement used to delete this object from the database.
 EmployerDO getEmployerDO()
          Get the single EmployerDO object that refers to this DO.
 EmployerDO[] getEmployerDOArray()
          Get array of EmployerDO objects that refer to this DO.
 String getHandle()
          The methods getHandle hasMatchingHandle are used by Presentation Objects that need to populate HTML select lists with Data Objects as options.
 String getHouseNumber()
          Get HouseNumber of the Adress
 IndustryDO[] getIndustryDOArray_via_Company()
          From the many-to-many relationship expressed by CompanyDO, get array of IndustryDO objects that indirectly refer to this DO.
 PreparedStatement getInsertStatement(jobmatch.data.DBConnection conn)
          Prepares the statement used to insert this object into the database.
 PersonDO getPersonDO()
          Get the single PersonDO object that refers to this DO.
 PersonDO[] getPersonDOArray()
          Get array of PersonDO objects that refer to this DO.
 String getStreet()
          Get Street of the Adress
protected  String getTableName()
          Return Adress as the name of the table in the database which contains AdressDO objects.
 PreparedStatement getUpdateStatement(jobmatch.data.DBConnection conn)
          Prepares the statement used to update this object in the database.
 String getZIP()
          Get ZIP of the Adress
 boolean hasMatchingHandle(String handle)
          hasMatchingHandle
 boolean isLoaded()
          isLoaded() Returns true if the data for this objects has been retrieved from the database.
 boolean isReadOnly()
          isReadOnly() Returns true if the data for this object has been marked read-only.
 void loadData()
          loadData() Load the fields for the DO from the database.
protected  void makeIdentical(AdressDO orig)
          makeIdentical() Assigns the DataStruct of an existing DO to this DO.
 void mapIndustry_via_CompanyDO(IndustryDO d)
          To the many-to-many relationship expressed by CompanyDO, add a IndustryDO object that indirectly refers to this DO.
 void mapIndustry_via_CompanyDO(IndustryDO d, jobmatch.data.DBTransaction tran)
          To the many-to-many relationship expressed by CompanyDO, add a IndustryDO object that indirectly refers to this DO.
protected  void modifyDO(jobmatch.data.DBTransaction dbt, boolean delete)
          Modifies the DO within its table.
protected  void okToCommit()
          A stub method for implementing pre-commit assertions for this AdressDO.
protected  void okToCommitCountry(CountryDO member)
          A stub method for implementing pre-commit assertions for the Country data member.
protected  void okToDelete()
          A stub method for implementing pre-delete assertions for this AdressDO.
protected  void okToDeleteCountry(CountryDO member)
          A stub method for implementing pre-delete assertions for the Country data member.
 void reload()
          reload() Causes the DO to refresh itself from the database the next time a set or get method is called.
 void removeCandidateDO(CandidateDO referrer)
          Remove (delete) a CandidateDO object that refers to this DO.
 void removeCandidateDO(CandidateDO referrer, jobmatch.data.DBTransaction tran)
          Remove (delete) a CandidateDO object that refers to this DO.
 void removeCompanyDO(CompanyDO referrer)
          Remove (delete) a CompanyDO object that refers to this DO.
 void removeCompanyDO(CompanyDO referrer, jobmatch.data.DBTransaction tran)
          Remove (delete) a CompanyDO object that refers to this DO.
 void removeEmployerDO(EmployerDO referrer)
          Remove (delete) a EmployerDO object that refers to this DO.
 void removeEmployerDO(EmployerDO referrer, jobmatch.data.DBTransaction tran)
          Remove (delete) a EmployerDO object that refers to this DO.
 void removePersonDO(PersonDO referrer)
          Remove (delete) a PersonDO object that refers to this DO.
 void removePersonDO(PersonDO referrer, jobmatch.data.DBTransaction tran)
          Remove (delete) a PersonDO object that refers to this DO.
 void setCity(String City)
          Set City of the Adress
 void setCountry(CountryDO Country)
          Set Country of the Adress
 void setHouseNumber(String HouseNumber)
          Set HouseNumber of the Adress
 void setStreet(String Street)
          Set Street of the Adress
 void setZIP(String ZIP)
          Set ZIP of the Adress
 String toString()
           
 String toString(int indentCount)
           
 void unmapIndustry_via_CompanyDO(IndustryDO d)
          From the many-to-many relationship expressed by CompanyDO, remove (delete) the IndustryDO object that indirectly refers to this DO.
 void unmapIndustry_via_CompanyDO(IndustryDO d, jobmatch.data.DBTransaction tran)
          From the many-to-many relationship expressed by CompanyDO, remove (delete) the IndustryDO object that indirectly refers to this DO.
 

Field Detail

table

public static final jobmatch.data.RDBTable table
static final data members name the table and columns for this DO. By using these members with an instance of the QueryBuilder class, an application can perform straight SQL queries while retaining compile-time checking of table and column usage. Example: List the Cities containing Persons named Bob: Using straight SQL with QueryBuilder: Pro: code runs faster because you create fewer objects Con: code is less clear Vector fields = new Vector(); fields.addElement( AddressDO.City ); QueryBuilder qb = new QueryBuilder( fields ); qb.addWhere( PersonDO.FirstName, "Bob" ); qb.addWhere( PersonDO.PrimaryKey, AddressDO.Person ); RDBRow row; while ( null != ( row = qb.getNextRow() ) ) { String city = row.get( AddressDO.City ).getString(); } Using Query/DO classes: Pro: code is (often) clearer Con: code runs slower because you create more objects PersonQuery pq = new PersonQuery(); pq.setQueryFirstName( "Bob" ); PersonDO[] bobs = pq.getDOArray(); for ( int i = 0; i < bobs.length; i++ ) { AddressQuery aq = new AddressQuery(); aq.setQueryPerson( bobs[i] ); AddressDO addr = aq.getNextDO(); String city = addr.getCity(); }

PrimaryKey

public static final jobmatch.data.RDBColumn PrimaryKey

isView

protected static final boolean isView

Street

public static final jobmatch.data.RDBColumn Street

HouseNumber

public static final jobmatch.data.RDBColumn HouseNumber

ZIP

public static final jobmatch.data.RDBColumn ZIP

City

public static final jobmatch.data.RDBColumn City

Country

public static final jobmatch.data.RDBColumn Country
Constructor Detail

AdressDO

protected AdressDO(boolean is_view)
            throws jobmatch.data.ObjectIdException,
                   jobmatch.data.DatabaseManagerException
Protected constructor. Only derived classes should call it.
Throws:
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.

AdressDO

protected AdressDO()
            throws jobmatch.data.ObjectIdException,
                   jobmatch.data.DatabaseManagerException
Protected constructor. Only derived classes should call it.
Throws:
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.

AdressDO

protected AdressDO(jobmatch.data.ObjectId id)
            throws SQLException,
                   jobmatch.data.ObjectIdException,
                   jobmatch.data.DataObjectException,
                   jobmatch.data.DatabaseManagerException
Protected constructor used by createExisting(ObjectId) above. Historical note (delete at will): Formerly, createExisting(ObjectId) invoked the no-args GenericDO ctor, which allocated a new ObjectId. Then, createExisting(ObjectId) would call setOId(id), discarding the newly allocated ObjectId; this resulted in an ObjectId "leak" (needless consumption of oid's.)
Parameters:
id - The ObjectId for the object.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
SQLException - Should never see this exception since GenericDO.ctor(ObjectId) never accesses the database.

AdressDO

protected AdressDO(ResultSet rs)
            throws SQLException,
                   jobmatch.data.ObjectIdException,
                   jobmatch.data.DataObjectException,
                   jobmatch.data.DatabaseManagerException
Protected constructor.
Parameters:
rs - Result set from which to obtain product data.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
SQLException - If the database rejects the SQL generated to retrieve data for this object, or if the table contains a bad foreign key, etc.
Method Detail

getTableName

protected String getTableName()
Return Adress as the name of the table in the database which contains AdressDO objects. This method overrides CoreDO.getTableName() and is used by CoreDO.executeUpdate() during error handling.
Returns:
the database table name
See Also:
CoreDO

isReadOnly

public boolean isReadOnly()
isReadOnly() Returns true if the data for this object has been marked read-only.

isLoaded

public boolean isLoaded()
isLoaded() Returns true if the data for this objects has been retrieved from the database.

loadData

public void loadData()
              throws SQLException,
                     jobmatch.data.ObjectIdException,
                     jobmatch.data.DataObjectException
loadData() Load the fields for the DO from the database.
Throws:
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DataObjectException - If the object is not found in the database.
SQLException - If the database rejects the SQL generated to retrieve data for this object, or if the table contains a bad foreign key, etc.

beforeAnyGet

protected void beforeAnyGet()
The developer of a Business Object that derives from this class can override the methods: beforeAnyGet beforeAnySet afterAnySet to handle any general assertions or cleanup needed for get and set methods.

beforeAnySet

protected void beforeAnySet()
                     throws Exception

afterAnySet

protected void afterAnySet()

createVirgin

public static AdressDO createVirgin()
                             throws jobmatch.data.DatabaseManagerException,
                                    jobmatch.data.ObjectIdException
createVirgin() Creates a DO that has no ObjectId or data. Such a DO is used to insert a new database entry after its data has been set.
Throws:
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.

createExisting

public static AdressDO createExisting(BigDecimal bd)
                               throws SQLException,
                                      jobmatch.data.ObjectIdException,
                                      jobmatch.data.DataObjectException,
                                      jobmatch.data.DatabaseManagerException
createExisting( BigDecimal ) Factory method creates a AdressDO object by searching for it in the database using the passed BigDecimal value as the primary key. Creates a DO that represents an existing entry in the database. Such a DO is used to examine and possibly update such an entry. createExisting() is called only from the code that retrieves an ObjectId from a ResultSet (database query result). createExisting() is protected because no other DO or BO should ever need to call it. FIX unfortunately the createExisting(BigDecimal) form *does* need to be public because it is called by the public ctors of other DOs. For example, AaaDO contains a ref to a BbbDO, so there is a method AaaDO.setBbb(BbbDO). In the ctor AaaDO(ResultSet), we have the call setBbb( BbbDO.createExisting( rs.getBigDecimal( "bbb", 0 ))); Since AaaDO is not in the same package as BbbDO, BbbDO.createExisting(BigDecimal) must be public, not protected. Java needs the C++ 'friend' idea.
Parameters:
bd - The BigDecimal representation of the ObjectId for the object.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
SQLException - If the database rejects the SQL generated to retrieve data for this object, or if the table contains a bad foreign key, etc.

createExisting

public static AdressDO createExisting(String handle)
The createExisting method is used to create a AdressDO from a string handle.

createExisting

protected static AdressDO createExisting(jobmatch.data.ObjectId id)
                                  throws SQLException,
                                         jobmatch.data.ObjectIdException,
                                         jobmatch.data.DataObjectException,
                                         jobmatch.data.DatabaseManagerException
createExisting( ObjectId ) Factory method creates a AdressDO object by searching for it in the database using the passed ObjectID value as the primary key.
Parameters:
id - The ObjectId for the object.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
SQLException - If the database rejects the SQL generated to retrieve data for this object, or if the table contains a bad foreign key, etc.

createExisting

protected static AdressDO createExisting(ResultSet rs)
                                  throws SQLException,
                                         jobmatch.data.ObjectIdException,
                                         jobmatch.data.DataObjectException,
                                         jobmatch.data.DatabaseManagerException
createExisting( ResultSet ) Factory method used to create an instance of this class to represent a Data Object already existing in the database.
Parameters:
rs - The ResultSet returned by the Query class for an existing Data Object stored in the database.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
SQLException - If the database rejects the SQL generated to retrieve data for this object, or if the table contains a bad foreign key, etc.

createExisting

protected static AdressDO createExisting(jobmatch.data.RDBRow row)
                                  throws SQLException,
                                         jobmatch.data.ObjectIdException,
                                         jobmatch.data.DataObjectException,
                                         jobmatch.data.DatabaseManagerException
createExisting( RDBRow ) Factory method creates a AdressDO object by searching for it in the database using the AdressDO.PrimaryKey value in the passed RDBRow.
Parameters:
RDBRow - A row returned by QueryBuilder.getNextRow().
Throws:
jobmatch.data.DataObjectException - If the RDBRow does not contain a AdressDO.PrimaryKey. If the object is not found in the database.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
SQLException - If the database rejects the SQL generated to retrieve data for this object, or if the table contains a bad foreign key, etc.

createExisting

protected static AdressDO createExisting(jobmatch.data.RDBColumnValue pk)
                                  throws SQLException,
                                         jobmatch.data.ObjectIdException,
                                         jobmatch.data.DataObjectException,
                                         jobmatch.data.DatabaseManagerException
createExisting( RDBColumnValue ) Factory method creates a AdressDO object by searching for it in the database using the passed AdressDO.PrimaryKey.
Parameters:
RDBColumnValue - a PrimaryKey column value from a row that was returned by QueryBuilder.getNextRow().
Throws:
jobmatch.data.DataObjectException - If the RDBColumnValue does not contain a AdressDO.PrimaryKey. If the object is not found in the database.
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.
SQLException - If the database rejects the SQL generated to retrieve data for this object, or if the table contains a bad foreign key, etc.

createCopy

public static AdressDO createCopy(AdressDataStruct data)
                           throws jobmatch.data.DatabaseManagerException,
                                  jobmatch.data.ObjectIdException
createCopy() Creates a DO that has no ObjectId but has a copy of an existing DO's data. Such a DO is used to insert a new database entry that is largely similar to an existing entry.
Parameters:
data - The data struct to copy values from.
Throws:
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.

createCopy

public static AdressDO createCopy(AdressDO orig)
                           throws jobmatch.data.DatabaseManagerException,
                                  jobmatch.data.ObjectIdException
createCopy() Creates a DO that has no ObjectId but has a copy of an existing DO's data. Such a DO is used to insert a new database entry that is largely similar to an existing entry.
Parameters:
orig - The original DO to copy.
Throws:
com.lutris.appserver.server.sql.ObjectIdException - If an object id can't be allocated for this object.
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.

reload

public void reload()
reload() Causes the DO to refresh itself from the database the next time a set or get method is called.

getHandle

public String getHandle()
                 throws jobmatch.data.DatabaseManagerException
The methods getHandle hasMatchingHandle are used by Presentation Objects that need to populate HTML select lists with Data Objects as options. The getHandle() method is used to set the value for each option, and the hasMatchingHandle() methods are used to lookup the Data Object when the selection has been made.
Returns:
id of this DO as a string If an object id can't be allocated for this object.
Throws:
jobmatch.data.DatabaseManagerException - If a connection to the database cannot be established, etc.

hasMatchingHandle

public boolean hasMatchingHandle(String handle)
hasMatchingHandle
Parameters:
handle - String version of DO id
Returns:
boolean True if the string version of the id of this DO matches passed handle
See Also:
getHandle

makeIdentical

protected void makeIdentical(AdressDO orig)
makeIdentical() Assigns the DataStruct of an existing DO to this DO. Does not duplicate data. Just assigns the reference.
Parameters:
orig - The original DO.

getStreet

public String getStreet()
                 throws jobmatch.data.DataObjectException
Get Street of the Adress
Returns:
Street of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

setStreet

public void setStreet(String Street)
               throws jobmatch.data.DataObjectException
Set Street of the Adress
Parameters:
Street - of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

getHouseNumber

public String getHouseNumber()
                      throws jobmatch.data.DataObjectException
Get HouseNumber of the Adress
Returns:
HouseNumber of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

setHouseNumber

public void setHouseNumber(String HouseNumber)
                    throws jobmatch.data.DataObjectException
Set HouseNumber of the Adress
Parameters:
HouseNumber - of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

getZIP

public String getZIP()
              throws jobmatch.data.DataObjectException
Get ZIP of the Adress
Returns:
ZIP of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

setZIP

public void setZIP(String ZIP)
            throws jobmatch.data.DataObjectException
Set ZIP of the Adress
Parameters:
ZIP - of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

getCity

public String getCity()
               throws jobmatch.data.DataObjectException
Get City of the Adress
Returns:
City of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

setCity

public void setCity(String City)
             throws jobmatch.data.DataObjectException
Set City of the Adress
Parameters:
City - of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

getCountry

public CountryDO getCountry()
                     throws jobmatch.data.DataObjectException
Get Country of the Adress
Returns:
Country of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

setCountry

public void setCountry(CountryDO Country)
                throws jobmatch.data.DataObjectException
Set Country of the Adress
Parameters:
Country - of the Adress
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

getInsertStatement

public PreparedStatement getInsertStatement(jobmatch.data.DBConnection conn)
                                     throws SQLException
Prepares the statement used to insert this object into the database.
Parameters:
conn - the database connection.
Returns:
the insert statement.
Throws:
SQLException - if an error occurs.

getUpdateStatement

public PreparedStatement getUpdateStatement(jobmatch.data.DBConnection conn)
                                     throws SQLException
Prepares the statement used to update this object in the database.
Parameters:
conn - the database connection
Returns:
the update statement.
Throws:
SQLException - if an error occurs.

getDeleteStatement

public PreparedStatement getDeleteStatement(jobmatch.data.DBConnection conn)
                                     throws SQLException
Prepares the statement used to delete this object from the database.
Parameters:
conn - the database connection
Returns:
the delete statement.
Throws:
SQLException - if an error occurs.

toString

public String toString()

toString

public String toString(int indentCount)

getCandidateDOArray

public CandidateDO[] getCandidateDOArray()
                                  throws jobmatch.data.DataObjectException,
                                         jobmatch.data.QueryException
Get array of CandidateDO objects that refer to this DO.
Returns:
array of CandidateDO objects.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.

getCandidateDO

public CandidateDO getCandidateDO()
                           throws jobmatch.data.DataObjectException,
                                  jobmatch.data.QueryException,
                                  jobmatch.data.NonUniqueQueryException
Get the single CandidateDO object that refers to this DO.
Returns:
CandidateDO object.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.
jobmatch.data.NonUniqueQueryException - If more than one CandidateDO object was found.

addCandidateDO

public void addCandidateDO(CandidateDO referrer)
                    throws SQLException,
                           jobmatch.data.DatabaseManagerException,
                           jobmatch.data.DataObjectException,
                           jobmatch.data.RefAssertionException,
                           jobmatch.data.DBRowUpdateException,
                           jobmatch.data.QueryException
Add (set & commit) a CandidateDO object that refers to this DO.
Parameters:
referrer - CandidateDO to be set to point to this DO and committed.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

addCandidateDO

public void addCandidateDO(CandidateDO referrer,
                           jobmatch.data.DBTransaction tran)
                    throws SQLException,
                           jobmatch.data.DatabaseManagerException,
                           jobmatch.data.DataObjectException,
                           jobmatch.data.RefAssertionException,
                           jobmatch.data.DBRowUpdateException,
                           jobmatch.data.QueryException
Add (set & commit) a CandidateDO object that refers to this DO.
Parameters:
referrer - CandidateDO to be set to point to this DO and committed.
tran - The transaction to be used for the commit. If null, a new transaction is created.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

removeCandidateDO

public void removeCandidateDO(CandidateDO referrer)
                       throws SQLException,
                              jobmatch.data.DatabaseManagerException,
                              jobmatch.data.DataObjectException,
                              jobmatch.data.RefAssertionException,
                              jobmatch.data.DBRowUpdateException,
                              jobmatch.data.QueryException
Remove (delete) a CandidateDO object that refers to this DO.
Parameters:
referrer - CandidateDO to be deleted.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

removeCandidateDO

public void removeCandidateDO(CandidateDO referrer,
                              jobmatch.data.DBTransaction tran)
                       throws SQLException,
                              jobmatch.data.DatabaseManagerException,
                              jobmatch.data.DataObjectException,
                              jobmatch.data.RefAssertionException,
                              jobmatch.data.DBRowUpdateException,
                              jobmatch.data.QueryException
Remove (delete) a CandidateDO object that refers to this DO.
Parameters:
referrer - CandidateDO to be deleted.
tran - The transaction to be used for the commit. If null, a new transaction is created.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

getCompanyDOArray

public CompanyDO[] getCompanyDOArray()
                              throws jobmatch.data.DataObjectException,
                                     jobmatch.data.QueryException
Get array of CompanyDO objects that refer to this DO.
Returns:
array of CompanyDO objects.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.

getCompanyDO

public CompanyDO getCompanyDO()
                       throws jobmatch.data.DataObjectException,
                              jobmatch.data.QueryException,
                              jobmatch.data.NonUniqueQueryException
Get the single CompanyDO object that refers to this DO.
Returns:
CompanyDO object.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.
jobmatch.data.NonUniqueQueryException - If more than one CompanyDO object was found.

addCompanyDO

public void addCompanyDO(CompanyDO referrer)
                  throws SQLException,
                         jobmatch.data.DatabaseManagerException,
                         jobmatch.data.DataObjectException,
                         jobmatch.data.RefAssertionException,
                         jobmatch.data.DBRowUpdateException,
                         jobmatch.data.QueryException
Add (set & commit) a CompanyDO object that refers to this DO.
Parameters:
referrer - CompanyDO to be set to point to this DO and committed.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

addCompanyDO

public void addCompanyDO(CompanyDO referrer,
                         jobmatch.data.DBTransaction tran)
                  throws SQLException,
                         jobmatch.data.DatabaseManagerException,
                         jobmatch.data.DataObjectException,
                         jobmatch.data.RefAssertionException,
                         jobmatch.data.DBRowUpdateException,
                         jobmatch.data.QueryException
Add (set & commit) a CompanyDO object that refers to this DO.
Parameters:
referrer - CompanyDO to be set to point to this DO and committed.
tran - The transaction to be used for the commit. If null, a new transaction is created.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

removeCompanyDO

public void removeCompanyDO(CompanyDO referrer)
                     throws SQLException,
                            jobmatch.data.DatabaseManagerException,
                            jobmatch.data.DataObjectException,
                            jobmatch.data.RefAssertionException,
                            jobmatch.data.DBRowUpdateException,
                            jobmatch.data.QueryException
Remove (delete) a CompanyDO object that refers to this DO.
Parameters:
referrer - CompanyDO to be deleted.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

removeCompanyDO

public void removeCompanyDO(CompanyDO referrer,
                            jobmatch.data.DBTransaction tran)
                     throws SQLException,
                            jobmatch.data.DatabaseManagerException,
                            jobmatch.data.DataObjectException,
                            jobmatch.data.RefAssertionException,
                            jobmatch.data.DBRowUpdateException,
                            jobmatch.data.QueryException
Remove (delete) a CompanyDO object that refers to this DO.
Parameters:
referrer - CompanyDO to be deleted.
tran - The transaction to be used for the commit. If null, a new transaction is created.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

getEmployerDOArray

public EmployerDO[] getEmployerDOArray()
                                throws jobmatch.data.DataObjectException,
                                       jobmatch.data.QueryException
Get array of EmployerDO objects that refer to this DO.
Returns:
array of EmployerDO objects.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.

getEmployerDO

public EmployerDO getEmployerDO()
                         throws jobmatch.data.DataObjectException,
                                jobmatch.data.QueryException,
                                jobmatch.data.NonUniqueQueryException
Get the single EmployerDO object that refers to this DO.
Returns:
EmployerDO object.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.
jobmatch.data.NonUniqueQueryException - If more than one EmployerDO object was found.

addEmployerDO

public void addEmployerDO(EmployerDO referrer)
                   throws SQLException,
                          jobmatch.data.DatabaseManagerException,
                          jobmatch.data.DataObjectException,
                          jobmatch.data.RefAssertionException,
                          jobmatch.data.DBRowUpdateException,
                          jobmatch.data.QueryException
Add (set & commit) a EmployerDO object that refers to this DO.
Parameters:
referrer - EmployerDO to be set to point to this DO and committed.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

addEmployerDO

public void addEmployerDO(EmployerDO referrer,
                          jobmatch.data.DBTransaction tran)
                   throws SQLException,
                          jobmatch.data.DatabaseManagerException,
                          jobmatch.data.DataObjectException,
                          jobmatch.data.RefAssertionException,
                          jobmatch.data.DBRowUpdateException,
                          jobmatch.data.QueryException
Add (set & commit) a EmployerDO object that refers to this DO.
Parameters:
referrer - EmployerDO to be set to point to this DO and committed.
tran - The transaction to be used for the commit. If null, a new transaction is created.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

removeEmployerDO

public void removeEmployerDO(EmployerDO referrer)
                      throws SQLException,
                             jobmatch.data.DatabaseManagerException,
                             jobmatch.data.DataObjectException,
                             jobmatch.data.RefAssertionException,
                             jobmatch.data.DBRowUpdateException,
                             jobmatch.data.QueryException
Remove (delete) a EmployerDO object that refers to this DO.
Parameters:
referrer - EmployerDO to be deleted.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

removeEmployerDO

public void removeEmployerDO(EmployerDO referrer,
                             jobmatch.data.DBTransaction tran)
                      throws SQLException,
                             jobmatch.data.DatabaseManagerException,
                             jobmatch.data.DataObjectException,
                             jobmatch.data.RefAssertionException,
                             jobmatch.data.DBRowUpdateException,
                             jobmatch.data.QueryException
Remove (delete) a EmployerDO object that refers to this DO.
Parameters:
referrer - EmployerDO to be deleted.
tran - The transaction to be used for the commit. If null, a new transaction is created.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

getPersonDOArray

public PersonDO[] getPersonDOArray()
                            throws jobmatch.data.DataObjectException,
                                   jobmatch.data.QueryException
Get array of PersonDO objects that refer to this DO.
Returns:
array of PersonDO objects.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.

getPersonDO

public PersonDO getPersonDO()
                     throws jobmatch.data.DataObjectException,
                            jobmatch.data.QueryException,
                            jobmatch.data.NonUniqueQueryException
Get the single PersonDO object that refers to this DO.
Returns:
PersonDO object.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.
jobmatch.data.NonUniqueQueryException - If more than one PersonDO object was found.

addPersonDO

public void addPersonDO(PersonDO referrer)
                 throws SQLException,
                        jobmatch.data.DatabaseManagerException,
                        jobmatch.data.DataObjectException,
                        jobmatch.data.RefAssertionException,
                        jobmatch.data.DBRowUpdateException,
                        jobmatch.data.QueryException
Add (set & commit) a PersonDO object that refers to this DO.
Parameters:
referrer - PersonDO to be set to point to this DO and committed.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

addPersonDO

public void addPersonDO(PersonDO referrer,
                        jobmatch.data.DBTransaction tran)
                 throws SQLException,
                        jobmatch.data.DatabaseManagerException,
                        jobmatch.data.DataObjectException,
                        jobmatch.data.RefAssertionException,
                        jobmatch.data.DBRowUpdateException,
                        jobmatch.data.QueryException
Add (set & commit) a PersonDO object that refers to this DO.
Parameters:
referrer - PersonDO to be set to point to this DO and committed.
tran - The transaction to be used for the commit. If null, a new transaction is created.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

removePersonDO

public void removePersonDO(PersonDO referrer)
                    throws SQLException,
                           jobmatch.data.DatabaseManagerException,
                           jobmatch.data.DataObjectException,
                           jobmatch.data.RefAssertionException,
                           jobmatch.data.DBRowUpdateException,
                           jobmatch.data.QueryException
Remove (delete) a PersonDO object that refers to this DO.
Parameters:
referrer - PersonDO to be deleted.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

removePersonDO

public void removePersonDO(PersonDO referrer,
                           jobmatch.data.DBTransaction tran)
                    throws SQLException,
                           jobmatch.data.DatabaseManagerException,
                           jobmatch.data.DataObjectException,
                           jobmatch.data.RefAssertionException,
                           jobmatch.data.DBRowUpdateException,
                           jobmatch.data.QueryException
Remove (delete) a PersonDO object that refers to this DO.
Parameters:
referrer - PersonDO to be deleted.
tran - The transaction to be used for the commit. If null, a new transaction is created.
Throws:
jobmatch.data.DatabaseManagerException - if could not create a transaction
SQLException - if any SQL errors occur.
jobmatch.data.DataObjectException - If object is not found in the database.

getIndustryDOArray_via_Company

public IndustryDO[] getIndustryDOArray_via_Company()
                                            throws jobmatch.data.DataObjectException
From the many-to-many relationship expressed by CompanyDO, get array of IndustryDO objects that indirectly refer to this DO.
Returns:
array of IndustryDO objects.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

mapIndustry_via_CompanyDO

public void mapIndustry_via_CompanyDO(IndustryDO d)
                               throws jobmatch.data.DataObjectException,
                                      jobmatch.data.DatabaseManagerException,
                                      jobmatch.data.RefAssertionException,
                                      SQLException,
                                      jobmatch.data.DBRowUpdateException,
                                      jobmatch.data.QueryException
To the many-to-many relationship expressed by CompanyDO, add a IndustryDO object that indirectly refers to this DO.
Parameters:
d - The IndustryDO to add to the CompanyDO mapping for this DO.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

mapIndustry_via_CompanyDO

public void mapIndustry_via_CompanyDO(IndustryDO d,
                                      jobmatch.data.DBTransaction tran)
                               throws jobmatch.data.DataObjectException,
                                      jobmatch.data.DatabaseManagerException,
                                      jobmatch.data.RefAssertionException,
                                      SQLException,
                                      jobmatch.data.DBRowUpdateException,
                                      jobmatch.data.QueryException
To the many-to-many relationship expressed by CompanyDO, add a IndustryDO object that indirectly refers to this DO.
Parameters:
b - The IndustryDO to add to the CompanyDO mapping for this DO.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.

unmapIndustry_via_CompanyDO

public void unmapIndustry_via_CompanyDO(IndustryDO d)
                                 throws jobmatch.data.DataObjectException,
                                        jobmatch.data.DatabaseManagerException,
                                        jobmatch.data.RefAssertionException,
                                        SQLException,
                                        jobmatch.data.DBRowUpdateException,
                                        jobmatch.data.QueryException
From the many-to-many relationship expressed by CompanyDO, remove (delete) the IndustryDO object that indirectly refers to this DO.
Parameters:
d - The IndustryDO to remove from the CompanyDO mapping for this DO.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.

unmapIndustry_via_CompanyDO

public void unmapIndustry_via_CompanyDO(IndustryDO d,
                                        jobmatch.data.DBTransaction tran)
                                 throws jobmatch.data.DataObjectException,
                                        jobmatch.data.DatabaseManagerException,
                                        jobmatch.data.RefAssertionException,
                                        SQLException,
                                        jobmatch.data.DBRowUpdateException,
                                        jobmatch.data.QueryException
From the many-to-many relationship expressed by CompanyDO, remove (delete) the IndustryDO object that indirectly refers to this DO.
Parameters:
b - The IndustryDO to remove from the CompanyDO mapping for this DO.
Throws:
jobmatch.data.DataObjectException - If the object is not found in the database.
jobmatch.data.QueryException - If an error occured while building the query before execution.

okToCommit

protected void okToCommit()
                   throws jobmatch.data.RefAssertionException
A stub method for implementing pre-commit assertions for this AdressDO. Implement this stub to throw an RefAssertionException for cases where this object is not valid for writing to the database.

okToDelete

protected void okToDelete()
                   throws jobmatch.data.RefAssertionException
A stub method for implementing pre-delete assertions for this AdressDO. Implement this stub to throw an RefAssertionException for cases where this object is not valid for deletion from the database.

commit

public void commit()
            throws SQLException,
                   jobmatch.data.DatabaseManagerException,
                   jobmatch.data.DataObjectException,
                   jobmatch.data.RefAssertionException,
                   jobmatch.data.DBRowUpdateException,
                   jobmatch.data.QueryException
Inserts/Updates the DO into its table.
Throws:
com.lutris.appserver.server.sql.DatabaseManagerException - if a Transaction can not be created.
jobmatch.data.RefAssertionException - thrown by okTo method.
SQLException - if any SQL errors occur.

commit

public void commit(jobmatch.data.DBTransaction dbt)
            throws SQLException,
                   jobmatch.data.DatabaseManagerException,
                   jobmatch.data.DataObjectException,
                   jobmatch.data.RefAssertionException,
                   jobmatch.data.DBRowUpdateException,
                   jobmatch.data.QueryException
Inserts/Updates the DO into its table. The transaction is likely provided by the commit() method of another DO which references this DO.
Parameters:
dbt - The transaction object to use for this operation.
Throws:
com.lutris.appserver.server.sql.DatabaseManagerException - if a Transaction can not be created.
com.lutris.appserver.server.sql.DBRowUpdateException - if a version error occurs.
jobmatch.data.RefAssertionException - thrown by okTo method.
SQLException - if any SQL errors occur.

delete

public void delete()
            throws SQLException,
                   jobmatch.data.DatabaseManagerException,
                   jobmatch.data.DataObjectException,
                   jobmatch.data.RefAssertionException,
                   jobmatch.data.DBRowUpdateException,
                   jobmatch.data.QueryException
Deletes the DO from its table.
Throws:
com.lutris.appserver.server.sql.DatabaseManagerException - if a Transaction can not be created.
jobmatch.data.RefAssertionException - thrown by okTo method.
SQLException - if any SQL errors occur.

delete

public void delete(jobmatch.data.DBTransaction dbt)
            throws SQLException,
                   jobmatch.data.DatabaseManagerException,
                   jobmatch.data.DataObjectException,
                   jobmatch.data.RefAssertionException,
                   jobmatch.data.DBRowUpdateException,
                   jobmatch.data.QueryException
Deletes the DO from its table. The transaction is likely provided by the delete() method of another DO which references this DO.
Parameters:
dbt - The transaction object to use for this operation.
Throws:
com.lutris.appserver.server.sql.DatabaseManagerException - if a Transaction can not be created.
com.lutris.appserver.server.sql.DBRowUpdateException - if a version error occurs.
jobmatch.data.RefAssertionException - thrown by okTo method.
SQLException - if any SQL errors occur.

okToCommitCountry

protected void okToCommitCountry(CountryDO member)
                          throws jobmatch.data.RefAssertionException
A stub method for implementing pre-commit assertions for the Country data member. Implement this stub to throw an RefAssertionException for cases where Country is not valid for writing to the database.

okToDeleteCountry

protected void okToDeleteCountry(CountryDO member)
                          throws jobmatch.data.RefAssertionException
A stub method for implementing pre-delete assertions for the Country data member. Implement this stub to throw an RefAssertionException for cases where Country is not valid for deletion from the database.

modifyDO

protected void modifyDO(jobmatch.data.DBTransaction dbt,
                        boolean delete)
                 throws SQLException,
                        jobmatch.data.DatabaseManagerException,
                        jobmatch.data.DataObjectException,
                        jobmatch.data.RefAssertionException,
                        jobmatch.data.DBRowUpdateException,
                        jobmatch.data.QueryException
Modifies the DO within its table. Performs recursive commit/delete on referenced DOs; all operations occur within a single transaction to allow rollback in the event of error. Only the creator of the transaction releases it.
Parameters:
dbt - The transaction object to use for this operation.
delete - True if doing a delete, otherwise doing insert/update.
Throws:
com.lutris.appserver.server.sql.DatabaseManagerException - if a Transaction can not be created.
com.lutris.appserver.server.sql.DBRowUpdateException - if a version error occurs.
jobmatch.data.RefAssertionException - thrown by okTo method.
SQLException - if any SQL errors occur.

PSE 2000 Group 4