As part of my sofware engineering bootcamp, I had to create a programme for the fiction food delivery company "FoodQuick". It allows a user to place an order at a restaurant, then checks if there are nearby drivers and matches the order with the driver with the lowest load. It also prints an invoice to a .txt file for the customer, and updates the database with the customer info and the new driver load.
Stack used: Java - SQL Server
These were the detailed requirements for the capstone project:
- It reads a text file with a list of drivers who are in different cities and carry different loads of deliveries.
- It lets customers place orders, via console input.
- The customer enters their own details and the restaurant contact details.
- The customer enters their menu choices, quantities, and any special instructions. All restaurants have the same default menu.
- If there is a driver nearby that restaurant, the driver with the lowest load is assigned to pick up the order.
- An invoice is printed to invoice.txt for the customer. The invoice shows the driver name, menu choices, bill total, and contact info.
- The FoodQuick administrator can print a list of all customers by location or alphabetically.
- The programe connects to a SQL Server database.
- The list of drivers is now stored in the database instead of .txt file.
- The customer enters their own details, which creates a new entry in the customers table of the database.
- Instead of entering the restaurant info, the customer selects one from the databse. All restaurants still have the same default menu.
- The invoice and list of customers are still printed to .txt files, but they pull the data directly from the database.
- The FoodQuick administrator can retrieve a list of all incomplete orders, search an order by customer name or order number, and update a customer's details in the database.
To run Version 2 of this programme, you will need SQL Server, Microsoft JDBC Driver, JDE and JRE 15. You will need to create a database in SQL Server based on the db_export excel file and adapt the database connections in the code to that database. To run Version 1 of this programme, you can download and run the Docker image from https://hub.docker.com/repository/docker/timigun/food_quick.
The main method in the Main class runs the programme. It has several operations commented out, including adding a customer, placing an order, updating a customer, getting the list of customers, getting a list of all incomplete orders, or searching an order. You can simply uncomment the operations you would like to run.
Big thanks to my coding mentor Dayle at HyperionDev for helpful advice along the way.