文件列表:

project/ (0, 2023-12-01)
project/createPostgreDB.sh (111, 2023-12-01)
project/data/ (0, 2023-12-01)
project/data/bookings.csv (11144, 2023-12-01)
project/data/company.csv (92, 2023-12-01)
project/data/hotels.csv (847, 2023-12-01)
project/data/roomRepairRequests.csv (114, 2023-12-01)
project/data/roomRepairs.csv (237, 2023-12-01)
project/data/roomUpdatesLog.csv (1638, 2023-12-01)
project/data/rooms.csv (3090, 2023-12-01)
project/data/users.csv (2730, 2023-12-01)
project/java/ (0, 2023-12-01)
project/java/classes/ (0, 2023-12-01)
project/java/classes/Hotel.class (13885, 2023-12-01)
project/java/lib/ (0, 2023-12-01)
project/java/lib/pg73jdbc3.jar (183395, 2023-12-01)
project/java/scripts/ (0, 2023-12-01)
project/java/scripts/compile.sh (378, 2023-12-01)
project/java/src/ (0, 2023-12-01)
project/java/src/Hotel.class (13885, 2023-12-01)
project/java/src/Hotel.java (25922, 2023-12-01)
project/sql/ (0, 2023-12-01)
project/sql/scripts/ (0, 2023-12-01)
project/sql/scripts/create_db.sh (282, 2023-12-01)
project/sql/src/ (0, 2023-12-01)
project/sql/src/create_indexes.sql (0, 2023-12-01)
project/sql/src/create_tables.sql (4127, 2023-12-01)
project/sql/src/load_data.sql (1074, 2023-12-01)
project/startPostgreSQL.sh (421, 2023-12-01)
project/stopPostgreDB.sh (109, 2023-12-01)

# UCR-CS166-Final-Project This was my final project for my database class at UCR. The project had us implement the functions for this Java based interactive console for non-sql users. The theme of the database was an online hotel management system that has regular users and admin users. Database queries would be handled by PostgreSQL in the backend while the frontend interface was handled with Java. [The majority of my code can be found here below line 402.](https://github.com/ATranZone/UCR-CS166-Final-Project/blob/326999dc0ba5a5655dc777e19ad87afac9feb2d5/project/java/src/Hotel.java#L402C1-L402C1) ## viewHotels This function requests from the user their current latitude and longitude. These two attributes become converted into a double since they’re taken in as a string. We then query for a List of every hotel with their latitudes and longitudes. We then for loop to calculate the euclidean distance of every hotel in that generated List and check whether or not it is less than 30 and return the hotels that have a distance of less than 30. ## viewRooms We request a hotelID and a date from the user. We then query all available rooms for that hotel and that date. This also removes previously booked rooms from the query with the NOT IN keyword before the subquery that searches for booked rooms on the given date that the given hotelID. ## bookRooms: We request from the user their userID, hotelID, roomNumber and date. We then query whether or not the room is already booked on that date and if it is not then we continue to the next query to insert their booking. After booking their room, the room price is returned to the user. The user is also given prompts about whether or not their booking was successful and if it was successful, they are also given the price for that room. ## viewRecentBookingsfromCustomer: This function asks for the userID and queries for all the bookings under this userID and within the SELECT of the main query, we have a subquery that returns the price of the rooms that the user has booked. In the end, the user gets a result of their booking information along with the price of the room. ## updateRoomInfo: When prompted, we check whether the user is a manager. If they are, we ask for the room number, the price to update, and the image url to update. We then do an update query where we update the tuple that the given info matches in the Rooms table. We then do an INSERT into RoomUpdatesLog to add a tuple that tells us about the update that we performed. ## viewRecentUpdates: User is prompted for their manager info and hotelID. If they are confirmed as a manager, the 5 most recent room updates are returned from the given hotel of that manager in descending order by the updated date from RoomUpdatesLog. ## viewBookingHistoryofHotel: For this, we check if the managerUserID is valid with the hotelID. If they are a manager, they are asked if they want a specific date range. If they say yes, they enter the date and all the records of bookings from that date range are displayed. If they say no then every record of all bookings of that hotel are displayed.If the managerID does not match, an error message is displayed. ## viewRegularCustomers: This query asks the user for managerUserID and hotelID. The query searches for the customer that appears the most in the booking history of the given hotel. It returns the 5 most frequent matches in descending order. ## placeRoomRepairRequests: This query requests the user’s managerID and checks if it is valid. If the managerID exists then we continue and ask for all the required information to book a room repair. After that we insert all of the requested information into RoomRepairs and RoomRepairRequests. ## viewRoomRepairHistory: The user is prompted to enter their manager userID. If the manager userID is found matching a managerID we prompt them for their hotel ID. We then select from RoomRepairs the information about the room repairs for that hotel.

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：