I'm having trouble interpreting what Sun is trying to say.
I have this: It must allow the user to search the data for all records.... One can interpret this as to have a button that will populate your JTable with all the data in the database (which might not be so efficient...).
I implemented the 48 hours rule - so when clicking on the search button only the rooms that have the start date within 48 hours will be retrieved from the DB. Do you think it's OK?
2 text fields (one for hotel name, one for location)
if you leave both fields empty and click the search-button, all valid (not deleted) records are shown in the JTable
no implementation of the 48 hours rule
If the database grows and grows, this approach is indeed not that efficient: a lot of redundant records will be loaded into your table. I used a record cache, so if the database is really huge I'll ran into memory problems. I addressed that in my choices.txt and one of the solutions I suggested was implementing the 48 hours rule (only loading the records in cache with an available night within 48 hours).
So I think you'll be fine with your implementation/approach, certainly if you mention something about it in your decision document.