public DirectedMovies delete(DirectedMovies directedMovie) throws SQLException {
String deleteDirectedMovie = "DELETE FROM DirectedMovies WHERE DirectedMovieId=?;";
Connection connection = null;
PreparedStatement deleteStmt = null;
try {
connection = connectionManager.getConnection();
deleteStmt = connection.prepareStatement(deleteDirectedMovie);
deleteStmt.setInt(1, directedMovie.getDirectedMovieId());
deleteStmt.executeUpdate();
return null;
} catch (SQLException e) {
e.printStackTrace();
throw e;
} finally {
if (connection != null) {
connection.close();
}
if (deleteStmt != null) {
deleteStmt.close();
}
}
}
