The-Design-and-Implementation-of-Online-Meal-Ordering-System1.pdf.doc

Advanced Materials Research Vols. 562-564 (2012) pp 1630-1633 Online available since 2012/Aug/30 at (2012) Trans Tech Publications, Switzerland doi:10.4028//AMR.562-564.1630The Design and Implementation of Online Meal Ordering SystemFang Shuojin 1, a, Mao Keji2,b and Shen Jian 3,c1 Zhejiang Business College, HangZhou, China2 Department of Computer, Zhejiang University of Technology, Hangzhou, China3 College of International,Zhejiang University of Technology, Hangzhou, China a Anna_, b , c 339383695Keywords: Online Meal Ordering, E-commerce, B/C module, OracleAbstract. With the upgrading of information industry and the development of Internet, different kinds of network applications are available to thousands of families. E-commerce, which is a new consumption mode based on Internet, emerges and spreads rapidly. Nowadays, people are care about food safety and convenience, and are so busy that the best choice for having meal is home delivery. Therefore, design a restaurant online meal ordering system is significantly important for people. This paper focuses on the design and implement of the online meal ordering system.IntroductionWith the development of computer and information, cash transaction is being replaced by electronic or online transactions. E-commerce, as a product of periods, has been developed in the recently years. According to 2000 year-end statistics released, there were only 10 million Internet users in China, and the most frequently use was e-mail and web 1. However, from 2003 to 2006, with the fast improvement of logistics industry and credit guarantee system, E-commerce had rapidly developed. E-commerce transactions in 2007 reached to 2.17 trillion totally in China 2.Nowadays, B2C 3 E-commerce has become popular. Online Ordering Websites have been springing up in cities, particularly become popular in families, schools and companies. With the improvement of living condition, people are care about food safety and convenience, and they are so busy that the best choice for having meal is home delivery. Therefore, designing a restaurant online meal ordering system is significantly important for people. This paper will focus on how to design and implement an online meal ordering system based on Oracle and Java 6.0.Related WorksA few amount of research has been conducted on online meal ordering system. Many systems were implemented to solve the online ordering for people having meal more convenience. In paper 4, it introduces a simple online meal ordering system, although it can fulfill most functions, it is not convenient for both consumers and restaurant enterprises, such as they should interact with each other about the quality of foods and services, which is very important for them, especially for restaurant enterprises in order to enhance core competitiveness in the industry. An ordering system 5 designed for a specific company allow staffs order meals even in the coming week, the system is just suitable for company internal restaurant, but not good to spread to the restaurant industry.Requirement AnalysisThe improvement of E-commerce platform is its own requirement, which is a way to improve core competitiveness. Specialized software can provide consummation services for enterprises and convenient shopping platform for customers. The functional structure of online meal ordering system is as shown in Figure 1.All rights reserved. No part of contents of this paper may be reproduced or transmitted in any form or by any means without the written permission of TTP, . (ID: 31, University of California, San Diego, La Jolla, United States of America-18/04/14,02:36:41)Advanced Materials Research Vols. 562-5641631Fig. 1 Service functional diagramFig. 2 Service flowThe primary service of restaurant is selling cooked food, the main flow is that a customer come to order first , he may not only visit the spot to subscribe meal, but also by ordering through the telephone to subscribe meal, at that time, we need to make the customer know that which dishes here are available, then makes the choice among these, then recorded by the sales clerk, hand over to the kitchen to process, after manufacturing, the outgoing members will deliver the dishes to the certain location, then receive the fees (delivery payment), at last, the user will have a final appraisal (for use in improving service). If the customer is very unsatisfied to the service, he may cancel the order. Figure 2 show the process.Fig. 3 System top layer DFD1632Materials Engineering and Automatic ControlData flow analysis. When the customer needs to subscribe meal, he needs first to register to become the member, he needs to supply some basic information, like the name, the credential number, the telephone number and so on, these information will be registered in the system, which will form the user information table. After becoming the member, they can operate subscribing meal. The user information and the dish information will be combined, which will form the order information, which will be stored in the order form information table. The sales clerk may operate stocks merchandise, firstly, they should register the dish information, like the dish name, the serial number, quantity, the price and so on, forming the dish information table, and renews the total dish information in the dish information table. After this, we can sell the dishes, the detail information for will be stored in the list of order records. Systems top layer data flow chart as shown in Figure 3.Database and System DesignDatabase Design. The Entity-Relationship model of the online meal ordering system is shown in Figure 4. There are seven tables will be constructed, they are User information table, Employee information table, Dishes information table, Consumption record table, Department staff association table, Staff evaluation table and Department information table.1NUsersManagementConsumerMMMBuyEvaluationManagementNNNNMDishesManagementStaffNMMManagementManagementBelong111ManagerBelongDepartments1Fig. 4 E-R modelSystem Design. There are three modules in the system, they are user front module, staff back module and manager background module.In user front module, Input is to filter the data once user inputs, filtering unsafe and non-standard input. Dishes searching is to find the dishes by fuzzy search according to the name of dishes, production of materials and description. Dished ordering is responsible for adding dishes in users shopping cart to the database and generating a transaction order, the distribution background and the users confirmation are all around this order. Transaction evaluation is after user receives the dishes, they should evaluate the restaurant service, quality and price and give an integrated scoring, as well as a detailed description of the evaluation.In staff back module, besides input and dishes searching, it includes user searching, dishes manage, which is used for staff to manage the in shelves/out shelves dishes and add dishes, as well as provide uploading image and automatic formatting pictures features, users manage, order distribution and database backup. Order distribution, is that after the users made the order, this order will be displayed distribution for employees in the background, employees can specify an outgoing member to deliver the dishes to the user-specified location at the time specified by the user. Of course, if the user cancel the order before the distribution, then this order becomes ineffective, at the same time, if the employee cancelled this order before the distribution, then this order will be invalid either. After the dishes sent out, the user will acknowledge receipt and evaluation of food, then the deal is completed.Advanced Materials Research Vols. 562-5641633In manager background module, it also includes input, dishes searching, user searching, dishes manage, and staff management, report generated, data analysis, database to restore. There are three kinds of reports, they are daily reports, monthly reports, and annual reports, counted separated by the hour, day, month based on consumption amount and traffic statistics, this can meet the basic data that the manager statistics need. Reports are presented in the form of tables and line charts.System ImplementationThis system is designed and realized by adopting module development, MVC framework and B/C module. The development environment is WindowsXPSP3, Eclipse and database is Oracle. The development of modularization is for convenient for re-development. MVC framework has the qualities of low coupling, high reusability, applicability, low maintenance costs and fast development process. B/C module is because of the development of internet and the improvement of server performance, and the most important, the concern of safety 6. Java has good transportability and the features of Oracle 10 database are openness, scalability, compatibility, concurrency, security, performance. The database will be huge, and the data mining will be plenty, and Oracle can satisfy these requirements.SummaryThe online meal ordering system solves the requirement of people about convenience for having meals and enhances the core competitiveness of restaurant enterprises. With the further recognition of online consumption among peoples and the constantly refining of E-business, adding with the innovation of logistics industry, the online ord