Web App for Deli Order

Tech Stack:

J2EE, JSP, Servlet, JSTL, JDBC, MySQL

Design Pattern:

MVC, DAO

Main Function:

Administer: Login, Add/delete dish, Update dish, Manage orders.
Customer: Choose dish, Add order, Delete order, See order.

MVC Design Architecture

Servlet and Filter	JSP, SQL scripts, CSS and XML

To be done:

• Create Order Class

  • order id
  • customer name
  • phone number
  • email
  • dish name
  • dish id
  • pickup time
  • pickup address
  • dish price
  • payment way
  • is paid or not
  • is picked or not
  • note

• Create Dish Class

  • dish id (each dish has unique id, even after deleted)
  • dish name
  • price

• Administer Login Page

• Administer Authentication (Webfilter and Servlet)

• Create MySQL database for dish and order

• Design basic customer page:
  

  • choose dishes
  • choose pick time, place and payment
  • fill in name, email, cell
  • add note

• Design basic administer page:
  

  • show all orders (order by isPaid, isPicked and customer name)
  • show all dishes
  • add / delete dish
  • update dish info
  • update state of order (isPicked, isPaid)

• Handle cookies for customer information

  • store cookie in OrderControllerServlet (Tomcat doesn't allow " " in cookie)
  • read cookie in welcome.jsp