Package edu.pdx.cs.joy.jdbc

Class AcademicTermDAOImpl

java.lang.Object

edu.pdx.cs.joy.jdbc.AcademicTermDAOImpl

All Implemented Interfaces:

AcademicTermDAO

public class AcademicTermDAOImpl
extends Object
implements AcademicTermDAO

Data Access Object implementation for managing AcademicTerm entities in the database. Demonstrates JDBC operations with date fields: CREATE, READ, UPDATE, DELETE.

Constructor Summary

Constructors

Constructor	Description
AcademicTermDAOImpl(Connection connection)	Creates a new AcademicTermDAOImpl with the specified database connection.

Method Summary

Modifier and Type	Method	Description
static void	createTable(Connection connection)	Creates the academic_terms table in the database if it does not already exist.
void	delete(int id)	Deletes an academic term from the database by ID.
static void	dropTable(Connection connection)	Drops the academic_terms table from the database if it exists.
List<AcademicTerm>	findAll()	Finds all academic terms in the database.
AcademicTerm	findById(int id)	Finds an academic term by its ID.
AcademicTerm	findByName(String name)	Finds an academic term by its name.
void	save(AcademicTerm term)	Saves an academic term to the database.
void	update(AcademicTerm term)	Updates an existing academic term in the database.

Methods inherited from class java.lang.Object

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

Constructor Details

AcademicTermDAOImpl

public AcademicTermDAOImpl(Connection connection)

Creates a new AcademicTermDAOImpl with the specified database connection.

Parameters:

connection - the database connection to use

Method Details

dropTable

public static void dropTable(Connection connection)
                      throws SQLException

Drops the academic_terms 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 academic_terms table in the database if it does not already exist.

Parameters:

connection - the database connection to use

Throws:

SQLException - if a database error occurs

save

public void save(AcademicTerm term)
          throws SQLException

Saves an academic term to the database. The term's ID will be automatically generated by the database and set on the object.

Specified by:

save in interface AcademicTermDAO

Parameters:

term - the academic term to save

Throws:

SQLException - if a database error occurs

findById

public AcademicTerm findById(int id)
                      throws SQLException

Finds an academic term by its ID.

Specified by:

findById in interface AcademicTermDAO

Parameters:

id - the ID to search for

Returns:

the academic term with the given ID, or null if not found

Throws:

SQLException - if a database error occurs

findByName

public AcademicTerm findByName(String name)
                        throws SQLException

Finds an academic term by its name.

Specified by:

findByName in interface AcademicTermDAO

Parameters:

name - the name to search for

Returns:

the academic term with the given name, or null if not found

Throws:

SQLException - if a database error occurs

findAll

public List<AcademicTerm> findAll()
                           throws SQLException

Finds all academic terms in the database.

Specified by:

findAll in interface AcademicTermDAO

Returns:

a list of all academic terms

Throws:

SQLException - if a database error occurs

update

public void update(AcademicTerm term)
            throws SQLException

Updates an existing academic term in the database. Uses the term's ID to identify which record to update.

Specified by:

update in interface AcademicTermDAO

Parameters:

term - the academic term to update

Throws:

SQLException - if a database error occurs

delete

public void delete(int id)
            throws SQLException

Deletes an academic term from the database by ID.

Specified by:

delete in interface AcademicTermDAO

Parameters:

id - the ID of the academic term to delete

Throws:

SQLException - if a database error occurs