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