Spring and Spring Boot Learning
This repository contains code for hotel management done during my linkedIn online training.
The schema contains three table
| Room Table |
- |
| ROOM_ID |
(AUTO_INCREMENT) PRIMARY KEY |
| NAME VARCHAR(16) |
NOT NULL |
| ROOM_NUMBER |
CHAR(2), NOT NULL, UNIQUE |
| BED_INFO |
CHAR(2), NOT NULL |
| Guest Table |
- |
| GUEST_ID |
(AUTO_INCREMENT) PRIMARY KEY |
| FIRST_NAME |
VARCHAR(64) |
| LAST_NAME |
VARCHAR(64) |
| EMAIL_ADDRESS |
VARCHAR(64) |
| ADDRESS |
VARCHAR(64) |
| COUNTRY |
VARCHAR(32) |
| STATE |
VARCHAR(12) |
| PHONE_NUMBER |
VARCHAR(24) |
| Reservation Table |
- |
| RESERVATION_ID |
(AUTO_INCREMENT) PRIMARY KEY |
| ROOM_ID |
BIGINT NOT NULL |
| GUEST_ID |
BIGINT NOT NULL |
| RES_DATE |
DATE |
- Get Reservation Details by date (return all if no reservation on particular date)
- Get Guest List in ascending order of last name
- Get room details in ascending order of room number
- Get list of all reservations in json
- Home Page (localhost:8080)
- Rooms Page (localhost:8080/rooms)
- Guests Page (localhost:8080/guests)
- Reservations API (localhost:8080/api/reservations?date=2020-01-01)
