The-Design-and-Implementation-of-Online-Meal-Order

AdvancedMaterialsResearchVols.562-564(2012)pp1630-1633Onlineavailablesince2012/Aug/30at©(2012)TransTechPublications,Switzerlanddoi:10.4028/@163.com,[e-mail],[e-mail]:OnlineMealOrdering,E-commerce,B/Cmodule,OracleAbstract.WiththeupgradingofinformationindustryandthedevelopmentofInternet,differentkindsofnetworkapplicationsareavailabletothousandsoffamilies.E-commerce,whichisanewconsumptionmodebasedonInternet,emergesandspreadsrapidly.Nowadays,peoplearecareaboutfoodsafetyandconvenience,andaresobusythatthebestchoiceforhavingmealishomedelivery.Therefore,designarestaurantonlinemealorderingsystemissignificantlyimportantforpeople.Thispaperfocusesonthedesignandimplementoftheonlinemealorderingsystem.IntroductionWiththedevelopmentofcomputerandinformation,cashtransactionisbeingreplacedbyelectronicoronlinetransactions.E-commerce,asaproductofperiods,hasbeendevelopedintherecentlyyears.Accordingto2000year-endstatisticsreleased,therewereonly10millionInternetusersinChina,andthemostfrequentlyusewase-mailandweb[1].However,from2003to2006,withthefastimprovementoflogisticsindustryandcreditguaranteesystem,E-commercehadrapidlydeveloped.E-commercetransactionsin2007reachedto2.17trilliontotallyinChina[2].Nowadays,B2C[3]E-commercehasbecomepopular.OnlineOrderingWebsiteshavebeenspringingupincities,particularlybecomepopularinfamilies,schoolsandcompanies.Withtheimprovementoflivingcondition,peoplearecareaboutfoodsafetyandconvenience,andtheyaresobusythatthebestchoiceforhavingmealishomedelivery.Therefore,designingarestaurantonlinemealorderingsystemissignificantlyimportantforpeople.ThispaperwillfocusonhowtodesignandimplementanonlinemealorderingsystembasedonOracleandJava6.0.RelatedWorksAfewamountofresearchhasbeenconductedononlinemealorderingsystem.Manysystemswereimplementedtosolvetheonlineorderingforpeoplehavingmealmoreconvenience.Inpaper[4],itintroducesasimpleonlinemealorderingsystem,althoughitcanfulfillmostfunctions,itisnotconvenientforbothconsumersandrestaurantenterprises,suchastheyshouldinteractwitheachotheraboutthequalityoffoodsandservices,whichisveryimportantforthem,especiallyforrestaurantenterprisesinordertoenhancecorecompetitivenessintheindustry.Anorderingsystem[5]designedforaspecificcompanyallowstaffsordermealseveninthecomingweek,thesystemisjustsuitableforcompanyinternalrestaurant,butnotgoodtospreadtotherestaurantindustry.RequirementAnalysisTheimprovementofE-commerceplatformisitsownrequirement,whichisawaytoimprovecorecompetitiveness.Specializedsoftwarecanprovideconsummationservicesforenterprisesandconvenientshoppingplatformforcustomers.ThefunctionalstructureofonlinemealorderingsystemisasshowninFigure1.Allrightsreserved.NopartofcontentsofthispapermaybereproducedortransmittedinanyformorbyanymeanswithoutthewrittenpermissionofTTP,(ID:132.239.1.231,UniversityofCalifornia,SanDiego,LaJolla,UnitedStatesofAmerica-18/04/14,02:36:41)AdvancedMaterialsResearchVols.562-5641631Fig.1ServicefunctionaldiagramFig.2ServiceflowTheprimaryserviceofrestaurantissellingcookedfood,themainflowisthatacustomercometoorderfirst,hemaynotonlyvisitthespottosubscribemeal,butalsobyorderingthroughthetelephonetosubscribemeal,atthattime,weneedtomakethecustomerknowthatwhichdisheshereareavailable,thenmakesthechoiceamongthese,thenrecordedbythesalesclerk,handovertothekitchentoprocess,aftermanufacturing,theoutgoingmemberswilldeliverthedishestothecertainlocation,thenreceivethefees(deliverypayment),atlast,theuserwillhaveafinalappraisal(foruseinimprovingservice).Ifthecustomerisveryunsatisfiedtotheservice,hemaycanceltheorder.Figure2showtheprocess.Fig.3SystemtoplayerDFD1632MaterialsEngineeringandAutomaticControlDataflowanalysis.Whenthecustomerneedstosubscribemeal,heneedsfirsttoregistertobecomethemember,heneedstosupplysomebasicinformation,likethename,thecredentialnumber,thetelephonenumberandsoon,theseinformationwillberegisteredinthesystem,whichwillformtheuserinformationtable.Afterbecomingthemember,theycanoperatesubscribingmeal.Theuserinformationandthedishinformationwillbecombined,whichwillformtheorderinformation,whichwillbestoredintheorderforminformationtable.Thesalesclerkmayoperatestocksmerchandise,firstly,theyshouldregisterthedishinformation,likethedishname,theserialnumber,quantity,thepriceandsoon,formingthedishinformationtable,andrenewsthetotaldishinformationinthedishinformationtable.Afterthis,wecansellthedishes,thedetailinformationforwillbestoredinthelistoforderrecords.System'stoplayerdataflowchartasshowninFigure3.DatabaseandSystemDesignDatabaseDesign.TheEntity-RelationshipmodeloftheonlinemealorderingsystemisshowninFigure4.Thereareseventableswillbeconstructed,theyareUserinformationtable,Employeeinformationtable,Dishesin