Reservation System

Tools: Java, JDBM, MySQL

GitHub: https://github.com/apervmm/booking

Team members:
Israel Banez
Almas Perneshev
Adrian Nguyen

Note:
The database is under user anguy714.
The database holds tables lab7_rooms and lab7_reservations.

How to compile:
javac InnReservations.java
java -cp mysql-connector-java-8.0.16.jar [InnReservations | InnReservations.java]

Set Environment Variables (Windows):
setx HP_JDBC_URL "jdbc:mysql://db.labthreesixfive.com/anguy714?autoReconnect=true&useSSL=false"
setx HP_JDBC_USER "anguy714"
setx HP_JDBC_PW " "

Set Environment Varables (Mac):
export HP_JDBC_URL="jdbc:mysql://db.labthreesixfive.com/anguy714?autoReconnect=true&useSSL=false"
export HP_JDBC_USER=anguy714
export HP_JDBC_PW=

Overall Code Status:
We have an implmentation for all 6 FRS methods.

FR1 Notes - We change the day range from 180 to 360, because the current date would not reach the dates of the data.
FR2 Notes -
The deficiencies of FRS 2 are that it requires users to input correct date format.
It also lacks the 5 recommondations behavior when there is no available rooms.
FR3 Notes -
It lacks the ability to check for time conflictsc