Package com.JesacaLin.GrubGoblin_v13.daos

Class ReviewDAO

java.lang.Object

com.JesacaLin.GrubGoblin_v13.daos.ReviewDAO

@Component
public class ReviewDAO
extends Object

DAO class for managing Review entities in the database.

Constructor Summary

Constructors

Constructor	Description
ReviewDAO(DataSource dataSource)	Constructs a new ReviewDAO with the given DataSource.

Method Summary

Modifier and Type	Method	Description
Review	createReview(Review review, int dealId)	Creates a new Review.
int	deleteReviewById(int reviewId)	Deletes a Review by its ID.
List<Review>	getAllReviews()	Retrieves all Reviews.
List<Review>	getAllReviewsByDealId(int dealId)	Retrieves all Reviews for a specific deal.
Review	getReviewById(int reviewId)	Retrieves a Review by its ID.
Review	mapRowToReview(org.springframework.jdbc.support.rowset.SqlRowSet rowSet)	Maps a SqlRowSet to a Review.
Review	updateReview(int id, Review review)	Updates a Review.

Methods inherited from class java.lang.Object

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

Constructor Details

ReviewDAO

public ReviewDAO(DataSource dataSource)

Constructs a new ReviewDAO with the given DataSource.

Parameters:

dataSource - the DataSource to use for database access

Method Details

getReviewById

public Review getReviewById(int reviewId)

Retrieves a Review by its ID.

Parameters:

reviewId - the ID of the Review to retrieve

Returns:

the Review with the given ID, or null if no such Review exists

Throws:

DaoException - if a database access error occurs

getAllReviews

public List<Review> getAllReviews()

Retrieves all Reviews.

Returns:

a list of all Reviews

Throws:

DaoException - if a database access error occurs

createReview

public Review createReview(Review review,
 int dealId)

Creates a new Review.

Parameters:

review - the Review to create

dealId - the ID of the deal associated with the review

Returns:

the created Review

Throws:

DaoException - if a database access error occurs or if the Review data violates database constraints

updateReview

public Review updateReview(int id,
 Review review)

Updates a Review.

Parameters:

id - the ID of the Review to update

review - the Review data to update

Returns:

the updated Review

Throws:

DaoException - if a database access error occurs, if the Review data violates database constraints, or if no rows were affected by the update

deleteReviewById

public int deleteReviewById(int reviewId)

Deletes a Review by its ID.

Parameters:

reviewId - the ID of the Review to delete

Returns:

the number of rows affected by the delete

Throws:

DaoException - if a database access error occurs or if the Review data violates database constraints

getAllReviewsByDealId

public List<Review> getAllReviewsByDealId(int dealId)

Retrieves all Reviews for a specific deal.

Parameters:

dealId - the ID of the deal to retrieve Reviews for

Returns:

a list of all Reviews for the specified deal

Throws:

DaoException - if a database access error occurs

mapRowToReview

public Review mapRowToReview(org.springframework.jdbc.support.rowset.SqlRowSet rowSet)

Maps a SqlRowSet to a Review.

Parameters:

rowSet - the SqlRowSet to map

Returns:

the mapped Review