mySQL Recipe Program

Command line arguments

<ipaddress> <dbname> <drivername> <dbadminName> <dbadminPassword>

Example

"mySQL IP" "RECIPEDB" "com.mysql.jdbc.Driver" "ADMIN" "PASSWORD"

Main Menu

• Cupboard
  • Show Cupboard - Displays grocery items in current user's cupboard
  • Add Ingredient - Adds an ingredient from a list to the current user's cupboard
  • Delete Ingredient - Deletes and ingredient from the current user's cupboard
• Cart
  • Show Cart - Displays items in the user's cart
  • Show Current Recipes - Displays current user's recipes
  • Rate Recipe - Rates a user's recipe
  • Add Recipe To Cart - Adds a reicpe to the cart
  • Build Shopping Cart Cart - Builds a shopping cart
• Manage Recipes
  • Show All Recipes - Displays all recipes in the database
  • Add Recipe To Global Recipes - Adds a recipe to the database
  • Delete Recipe - Deletes a recipe from the database
• Manage Queries
  • Rating Query - Queries recipes based on a minimal rating
  • Times Cooked Query - Displays recipes based on the times cooked by a user
• Manage Users
  • Select User - Change between Users in the mySQL Database

Cupboard Menu Example

Cart Menu Example

Manage Recipes Example

Manage Queries Example