Package edu.pdx.cs.joy.jdbc

Class DepartmentDAOImpl

java.lang.Object

edu.pdx.cs.joy.jdbc.DepartmentDAOImpl

All Implemented Interfaces:

DepartmentDAO

public class DepartmentDAOImpl
extends Object
implements DepartmentDAO

Data Access Object implementation for managing Department entities in the database. Demonstrates JDBC operations with auto-generated keys: CREATE, READ, UPDATE, DELETE.

Constructor Summary

Constructors

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

Method Summary

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

Methods inherited from class java.lang.Object

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

Constructor Details

DepartmentDAOImpl

public DepartmentDAOImpl(Connection connection)

Creates a new DepartmentDAOImpl 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 departments 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 departments 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(Department department)
          throws SQLException

Saves a department to the database. The department's ID will be automatically generated by the database.

Specified by:

save in interface DepartmentDAO

Parameters:

department - the department to save

Throws:

SQLException - if a database error occurs

findById

public Department findById(int id)
                    throws SQLException

Finds a department by its ID.

Specified by:

findById in interface DepartmentDAO

Parameters:

id - the ID to search for

Returns:

the department with the given ID, or null if not found

Throws:

SQLException - if a database error occurs

findByName

public Department findByName(String name)
                      throws SQLException

Finds a department by its name.

Specified by:

findByName in interface DepartmentDAO

Parameters:

name - the name to search for

Returns:

the department with the given name, or null if not found

Throws:

SQLException - if a database error occurs

findAll

public List<Department> findAll()
                         throws SQLException

Finds all departments in the database.

Specified by:

findAll in interface DepartmentDAO

Returns:

a list of all departments

Throws:

SQLException - if a database error occurs

update

public void update(Department department)
            throws SQLException

Updates an existing department in the database.

Specified by:

update in interface DepartmentDAO

Parameters:

department - the department to update

Throws:

SQLException - if a database error occurs

delete

public void delete(int id)
            throws SQLException

Deletes a department from the database by ID.

Specified by:

delete in interface DepartmentDAO

Parameters:

id - the ID of the department to delete

Throws:

SQLException - if a database error occurs