Module eus.ehu.hotelreservation

Package eus.ehu.hotelreservation.dataAccess

Class DataAccess

java.lang.Object

eus.ehu.hotelreservation.dataAccess.DataAccess

public class DataAccess
extends Object

Data-access layer built on Hibernate / JPA with an embedded H2 database.

Manages the EntityManager lifecycle and exposes CRUD operations for the domain entities (Hotel, Room, Reservation, WaitingListEntry, etc.). Supports an initialize mode that drops and recreates the schema with test data on startup.

See Also:

• Config

Field Summary

Fields

Modifier and Type	Field	Description
protected jakarta.persistence.EntityManager	db
protected jakarta.persistence.EntityManagerFactory	emf

Constructor Summary

Constructors

Constructor	Description
DataAccess()

Method Summary

Modifier and Type	Method	Description
void	close()	Closes the EntityManager and releases database resources.
List<AvailableRoomModel>	getAvailableRooms(String hotelName, LocalDate startDate, LocalDate endDate)	Returns available room types (not specific rooms) for a hotel and date range.
Customer	getCustomer(String nationalId)	Looks up a customer by national ID.
List<Hotel>	getHotels()	Retrieves all hotels from the database.
void	initializeDB()	Initializes the database schema and populates it with sample data.
void	joinWaitingList(String hotelName, String roomTypeStr, LocalDate startDate, LocalDate endDate, Customer customer)	Adds a customer to the waiting list for a room type at a hotel.
void	open()	Opens a connection to the database using the configuration defined in hibernate.cfg.xml and config.properties.
void	open(boolean initializeMode)
void	reserveRoom(AvailableRoomModel room, LocalDate startDate, LocalDate endDate, Customer customer)	Reserves a room of the given type at the given hotel for the date range.
void	reset()

Methods inherited from class java.lang.Object

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

Field Details

db

protected jakarta.persistence.EntityManager db

emf

protected jakarta.persistence.EntityManagerFactory emf

Constructor Details

DataAccess

public DataAccess()

Method Details

open

public void open()

Opens a connection to the database using the configuration defined in hibernate.cfg.xml and config.properties.

Equivalent to calling open(boolean) with false.

open

public void open(boolean initializeMode)

reset

public void reset()

close

public void close()

Closes the EntityManager and releases database resources.

initializeDB

public void initializeDB()

Initializes the database schema and populates it with sample data.

This method is intended to be called once at application startup when db.openmode=initialize in config.properties. It creates room types, hotels, rooms, rates and test customers inside a single JPA transaction.

See Also:

• generateTestingData()

getHotels

public List<Hotel> getHotels()

Retrieves all hotels from the database.

Returns:

a list of all Hotel entities

getCustomer

public Customer getCustomer(String nationalId)

Looks up a customer by national ID.

Parameters:

nationalId - the customer's national identity document number

Returns:

the matching Customer, or null if not found

getAvailableRooms

public List<AvailableRoomModel> getAvailableRooms(String hotelName,
 LocalDate startDate,
 LocalDate endDate)

Returns available room types (not specific rooms) for a hotel and date range. Only room types that have at least one available room for ALL days in the range are returned. For each available room type, it calculates the total price across all days (considering different rates on different dates).

reserveRoom

public void reserveRoom(AvailableRoomModel room,
 LocalDate startDate,
 LocalDate endDate,
 Customer customer)

Reserves a room of the given type at the given hotel for the date range. The customer pays 20% upfront via credit card.

joinWaitingList

public void joinWaitingList(String hotelName,
 String roomTypeStr,
 LocalDate startDate,
 LocalDate endDate,
 Customer customer)

Adds a customer to the waiting list for a room type at a hotel.