Package edu.pdx.cs.joy.family

Class MarriageDAOImpl

java.lang.Object

edu.pdx.cs.joy.family.MarriageDAOImpl

All Implemented Interfaces:

MarriageDAO

public class MarriageDAOImpl
extends Object
implements MarriageDAO

Data Access Object implementation for managing Marriage entities in the database.

Constructor Summary

Constructors

Constructor	Description
MarriageDAOImpl(Connection connection, Map<Integer,Person> personCache)	Creates a new MarriageDAOImpl with the specified database connection.

Method Summary

Modifier and Type	Method	Description
static void	createTable(Connection connection)	Creates the marriages table in the database.
void	delete(int husbandId, int wifeId)	Deletes a marriage from the database.
static void	dropTable(Connection connection)	Drops the marriages table from the database if it exists.
List<Marriage>	findAll()	Finds all marriages in the database.
List<Marriage>	findByPersonId(int personId)	Finds all marriages for a specific person ID.
void	save(Marriage marriage)	Saves a marriage to the database.

Methods inherited from class java.lang.Object

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

Constructor Details

MarriageDAOImpl

public MarriageDAOImpl(Connection connection,
 Map<Integer,Person> personCache)

Creates a new MarriageDAOImpl with the specified database connection.

Parameters:

connection - the database connection to use

personCache - a cache of persons to resolve marriage partners

Method Details

dropTable

public static void dropTable(Connection connection)
                      throws SQLException

Drops the marriages table from the database if it exists.

Parameters:

connection - the database connection to use

Throws:

SQLException - if a database error occurs

createTable

public static void createTable(Connection connection)
                        throws SQLException

Creates the marriages table in the database.

Parameters:

connection - the database connection to use

Throws:

SQLException - if a database error occurs

save

public void save(Marriage marriage)
          throws SQLException

Saves a marriage to the database.

Specified by:

save in interface MarriageDAO

Parameters:

marriage - the marriage to save

Throws:

SQLException - if a database error occurs

findByPersonId

public List<Marriage> findByPersonId(int personId)
                              throws SQLException

Finds all marriages for a specific person ID.

Specified by:

findByPersonId in interface MarriageDAO

Parameters:

personId - the person ID

Returns:

a list of marriages involving the person

Throws:

SQLException - if a database error occurs

findAll

public List<Marriage> findAll()
                       throws SQLException

Finds all marriages in the database.

Specified by:

findAll in interface MarriageDAO

Returns:

a list of all marriages

Throws:

SQLException - if a database error occurs

delete

public void delete(int husbandId,
 int wifeId)
            throws SQLException

Deletes a marriage from the database.

Specified by:

delete in interface MarriageDAO

Parameters:

husbandId - the husband's ID

wifeId - the wife's ID

Throws:

SQLException - if a database error occurs