Package edu.pdx.cs.joy.jdbc

Interface AcademicTermDAO

All Known Implementing Classes:
AcademicTermDAOImpl
public interface AcademicTermDAO
Data Access Object interface for managing AcademicTerm entities in the database.

  • Method Details

    • save

      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.
      Parameters:
      term - the academic term to save
      Throws:
      SQLException - if a database error occurs

    • findById

      AcademicTerm findById(int id) throws SQLException
      Finds an academic term by its ID.
      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

      AcademicTerm findByName(String name) throws SQLException
      Finds an academic term by its name.
      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

      List<AcademicTerm> findAll() throws SQLException
      Finds all academic terms in the database.
      Returns:
      a list of all academic terms
      Throws:
      SQLException - if a database error occurs

    • update

      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.
      Parameters:
      term - the academic term to update
      Throws:
      SQLException - if a database error occurs

    • delete

      void delete(int id) throws SQLException
      Deletes an academic term from the database by ID.
      Parameters:
      id - the ID of the academic term to delete
      Throws:
      SQLException - if a database error occurs