Using an SQLite database your program should be able to create, read, update, and delete room reservations.
Present the user with a menu at the beginning using the console or JOptionPane for example:
Choose a task
1. Add a reservation
2. View a reservation
3. List all reservations
4. Update a reservation
5. Cancel a reservation
What is your check-in date (YYYY-MM-DD)? 2013-08-02
How many nights will you be staying? 2
How many guests will be staying? 1
We have 1 palace room available at $250 per night. Your total price will be $500.
Type 'yes' to confirm your booking. yes.
Thank you, your reservation number is 2.
If all rooms are booked for a date you should not add a reservation.
You can stop the user from entering a date in the past or prevent them from
entering 0 guests or nights. You could split a party into multiple rooms if they will not fit in 1 room.
You can extend your program to add new rooms to the database. Be creative.
The program should loop until the user asks to quit.
If there are too many guests for an available room you should not add a reservation.