winston-dsouza/online-food-ordering-system

Online Food Ordering And Order Retrieval System

Online Food Ordering System

The Online Food Ordering System(Foody) is a desktop app. It has a food ordering app for a customer and a separate app for order retrieval system for Restaurant.

Features

• Authentication system guarding the app core.
• Customers can browse the menu, Add/remove items to cart, track the order and can make payment online.
• Customers can update password and can change the delivery address.
• Data stored in a MySQL database
• Friendly user interface with JavaFX

For screenshots click here

Technologies

• Java - widely used object-oriented language, the core of our system
• JavaFX - Java user interface library
• MySQL - data storage solution
• JFoenix - JavaFX Material Design Library

Tools

• Netbeans IDE 8.2
• XAMPP
• Scene Builder

Set Up Instructions For Running Application

1. Set up your XAMPP environment(Apache Server, phpMyAdmin).
2. Create the foody schema on the database tool, and import the database from the SQL file, or copy the SQL code.
3. Download the project of the application and open it in NetBeans.
4. Connect with the database in the Services tab under MySQL Server(localhost). The MySQL JDBC driver is embedded in the project.
5. Enter your server properties(Host Name, Port Number, Admin UserName/Password).

Note The Foody folder is Food Ordering App and FoodyOrder folder is order retrieve App code

online-food-ordering-system's Issues

HTTP Status 500 – Internal Server Error

Hello,

"foody" was built successfully but it displayed this error screen instead of the ordering app. Please help.

HTTP Status 500 – Internal Server Error
Type Exception Report

Message An exception occurred processing [/index.jsp] at line [47]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: An exception occurred processing [/index.jsp] at line [47]

44:                         <%
45:                             //Getting all cart details of the customer
46:                             ResultSet resultCount = DatabaseConnection.getResultFromSqlQuery("select count(*) from tblcart where customer_id='" + session.getAttribute("id") + "'");
47:                             resultCount.next();
48:                             int count = resultCount.getInt(1);
49:                         %>
50:                         <h3>


Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:605)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:498)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Root Cause

java.lang.NullPointerException: Cannot invoke "java.sql.ResultSet.next()" because "resultCount" is null
	org.apache.jsp.index_jsp._jspService(index_jsp.java:162)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Note The full stack trace of the root cause is available in the server logs.

Apache Tomcat/8.5.78

Error while running the application

Hello,

I am getting the below error while running the application. Please help.

C:\Users\Sai\Desktop\Capstone\Food order\Foody\nbproject\jfx-impl.xml:3550: The following error occurred while executing this line:
C:\Users\Sai\Desktop\Capstone\Food order\Foody\nbproject\jfx-impl.xml:3578: The following error occurred while executing this line:
C:\Users\Sai\Desktop\Capstone\Food order\Foody\nbproject\jfx-impl.xml:3597: The following error occurred while executing this line:
C:\Users\Sai\Desktop\Capstone\Food order\Foody\nbproject\jfx-impl.xml:1251: The following error occurred while executing this line:
C:\Users\Sai\Desktop\Capstone\Food order\Foody\nbproject\jfx-impl.xml:1328: Warning: Could not find resource file "C:\Users\Sai\Desktop\Capstone\Food order\Foody${libs.MySQLDriver.classpath}" to copy.
BUILD FAILED (total time: 1 second)