电子商务网站设计

中文摘要

在当今瞬息万变的商业环境中，能够做出反应是非常重要的。

以最有效、及时的方式向客户提供需求。如果您的客户希望看到您的

在线商务和即时访问您的产品或服务。

网上购物是一种生活方式的电子商务网站应用，零售各种时尚和

生活用品（目前女装）这个项目允许查看各种产品。

可用的使注册用户立即使用即时支付购买所需的产品，也可以通过使用货到付款的方

式进行订单。

该项目为管理员和管理人员提供方便查看订单的机会。使用后付款和即时支付选项。

为了开发一个电子商务网站，必须研究一些技术。理解。

这些包括多层架构、服务器和客户端脚本技术，

如java实现技术，JSP关系数据库。这是一个项目，目的是开发一个基本的网站。

消费者提供购物车应用程序，也了解技术。用于开发这样的应用程序。

本文将讨论创建和实现电子商务的每一项底层技术。网站。

EnglishAbstract

Intoday'sfast-changingbusinessenvironment,it'sextremelyimportanttobeableto

respondtoclientneedsinthemosteffectiveandtimelymanner.Ifyourcustomerswishto

seeyourbusinessonlineandhaveinstantaccesstoyourproductsorservices.

OnlineShoppingisalifestylee-commercewebapplication,whichretailsvarious

fashionandlifestyleproducts(clothes).Thisprojectallowsviewingvariousproducts

availableenablesregistereduserstopurchasedesiredproductsinstantlyusingInstantPay

andalsocanplaceorderbyusingCashonDeliveryoption.

ThisprojectprovidesaneasyaccesstoAdministratorsandManagerstovieworders

placedusingPayLaterandInstantPayoptions.

Inordertodevelopanc-commcrccwebsite,anumberofTechnologiesmustbestudied

andunderstood.Theseincludemulti-tieredarchitecture,serverandclientsidescripting

techniques,implementationtechnologiessuchasJAVA,JSPandrelationaldatabases.

Thisisaprojectwiththeobjectivetodevelopabasicwebsitewherea

consumerisprovidedwithashoppingcartapplicationandalsotoknowaboutthe

technologiesusedtodevelopsuchanapplication.

Thisdocumentwilldiscusseachoftheunderlyingtechnologiestocreateandimplementan

ecommercewebsite.

-II-

目录(ChineseContents)

中文摘要I

英文摘要II

介绍4

1.1一般描述4

1.2描述4

1.3角色4

2技术与发展5

2.1日食5

2.1.1是什么MyEclipse6

2.2界面研究综述7

2.2.1工作台7

2.2.2菜单8

2.2.3工具栏8

2.2.4编辑8

2.3MySQL9

2.3.1是什么MySQL9

2.3.2MySQLYOG10

2.3.3会话保存点11

2.3.4汽车-弹出12

2.3.5柱宽预置12

2.4MySQL数据库13

3要求与分析14

3.1要求14

3.1.1Tomcat/Xampp14

3.1.2Drcamv/cavcr14

3.2分析与设计14

3.2.1数据库设计14

3.2.2鞋子和衣服15

3.2.3购物车15

3.2.4产品16

-Ill-

3.2.5命令16

3.2.6用户详细信息16

3.2.7图像17

3.3用户界面设计17

4设计模型18

4.0什么是设计模型18

4.1建模分析与设计模型18

4.1.2模型设计思想18

4.2瀑布模型18

4.2.1瀑布模型是什么18

4.2.2优势19

4.2.3缺点19

4.3综合瀑布模型的网站20

5实施21

5.1购物车21

5.1.1管理登录21

5.1.2用户注册22

5.1.3用户详细信息23

5.1.4购物车23

5.1.5下订单24

5.1.6结帐25

5.1.7仪表板26

5.1.8主页27

5.1.9产品27

5.1.10管理设置28

5.1.11常见问题解答29

5.1.12接触29

5.2网上交易30

5.2.1原子的30

5.2.2一致的30

-IV-

5.2.3隔离30

5.2.4耐久性30

6测试32

6.1什么是软件测试32

6.1.2测试类型32

6.2系统测试32

7结论34

7.1确认34

8.0工具书类35

8.1网站35

球大学3m^业论文（W）

EnglishContents

ChineseAbstractI

EnglishAbstractII

Introduction4

1.1GeneralDescription4

1.2Description4

1.3Roles4

2TechnologyandDevelopment5

2.1Eclipse5

2.1.1WhatisMyEclipse5

2.2Reviewontheinterface6

2.2.1WorkBench7

2.2.2Menu7

2.2.3ToolBar8

2.2.4Editor8

2.3MySQL9

2.3.1WhatisMySQL9

2.3.2MySQLYOG10

2.3.3SessionSavePoint11

2.3.4Auto-Popup12

2.3.5Columnwidthpresisitence12

2.4MySQLDatabase13

3RequirmentandAnalysis14

3.1Requirement14

3.1.1Tomcat/Xampp14

3.1.2Dreamv/eaver14

3.2AnalysisansDesign14

3.2.1DatabaseDesign14

3.2.2ShoesandClothes15

3.2.3ShoppingCart16

3.2.4Product16

3.2.5Order16

3.2.6UsersDetails16

3.2.7Image17

3.3UserInterfaceDesign17

球大学3m^业论文（W）

4DesignModel18

4.0WhatisDesignModel18

4.1ModelingAnalysisandDesignModel18

4.1.2IdeaofModelDesign18

4.2WaterfallModel18

4.2.1WhatisWaterfallModel18

4.2.2Advantages19

4.2.3Disadvantages19

4.3Intergrationofwaterfallmodelonwebsite20

5Implementation21

5.1ShoppingCart21

5.1.1Administrationlogin21

5.1.2UsersRegistration22

5.1.3UsersDetails23

5.1.4ShoppingCart23

5.1.5Placeanorder24

5.1.6Checkout25

5.1.7Dashboard26

5.1.8Homepage27

5.1.9Product27

5.1.10AdministrationSettings28

5.1.11FAQ29

5.1.12Contact29

5.2Transactiononline30

5.2.1Atomic30

5.2.2Consistent30

5.2.3Isolation30

5.2.4Durability30

6Testing32

6.1WhatisSotwareTesting32

6.1.2TypesofTesting32

6.2SystemTesting32

7Conclusion34

7.1Acknowledgment34

8.0References35

8.1Website35

2-

球大学3m^业论文（W）

Chapter1

Introduction

Theexistenceofbusinessonlineelectronicallywasadreamformanyintheearlieryears

butnowitisveryeasytoestablishduetovastmajorityofinternetusersandcheap

domainswherewecansetupourvirtualofficeforexecutingalltypeoftransactions

E-commerceisfastgaininggroundasanacceptedandusedbusinessparadigm.More

andmorebusinesshousesareimplementingwebsitesprovidingfunctionalityfor

performingcommercialtransactionsovertheweb.Itisreasonabletosaythattheprocess

ofshoppingonthewebisbecomingcommonplace.

Theobjectiveofthisprojectistodevelopageneralpurposee-commercestorewhere

productlikeclothescanbeboughtfromthecomfortofhomethroughtheInternet.

However,forimplementationpurposes,thispaperwilldealwithanonlineshoppingfor

clothes.

AnonlinestoreisavirtualstoreontheInternetwherecustomerscanbrowsethecatalog

andselectproductsofinterest.Theselecteditemsmaybecollectedinashoppingcart.At

checkouttime,theitemsintheshoppingcartwillbepresentedasanorder.Atthattime,

moreinformationwillbeneededtocompletethetransaction.Usually,thecustomerwillbe

askedtofillorselectabillingaddress,ashippingaddress,ashippingoption,andpayment

informationsuchascreditcardnumber.Ane-mailnotificationissenttothecustomeras

soonastheorderisplaced.

1.1GeneralDescription:

1.2Description:

•Anymembercanregisterandviewavailableproducts.

•Onlyregisteredmembercanpurchasemultipleproductsregardlessofquantity.

•ContactuspageisavailabletocontactAdminforqueries.

•Therearcthreerolesavailable:Databasemanager(DBM),UserandAdmin.

1.3ROLES:

•Databasemanagersarcresponsiblewiththebackendconstructionofthewebsite.

•Usercanviewandpurchaseproducts.

•AnAdminhassomeextraprivilegeincludingallprivilegeofvisitoranduser.

•Admincanaddproducts,editproductinformationandadd/removeproduct.

•Admincanadduser,edituserinformationandcanremoveuser.

3-

献大学业论文（W）

Chapter2

TechnologyandDevelopment

2.1Eclipse

2.1.1WhatisMyEclipse?

MyEclipseisacommerciallyavailableJavaEEandAjaxIDEcreatedandmaintained

MyEclipseisbuiltupontheEclipseplatform,andintegratesbothproprietaryandopen

sourcecodeintothedevelopmentenvironment.

MyEclipsehasIwoprimaryversions(apartfromthe"BlueEditionand"MyEclipse

SpringEditionreferredtobelow):aprofessionalandastandardedition.Thestandard

editionaddsdatabasetools,avisualwebdesigner,persistencetools,springtools,Struts

andJSFtooling,andanumberofotherfeaturestothebasicEclipseJavaDeveloperprofile.

ItcompeteswiththeWebToolsProject,whichisapartofEclipseitself,butMyEclipseis

aseparateprojectentirelyandoffersadifferentfeatureset.

EQ2017Q-AnguUr・MyNewAnguUrProje^/src/app/shMed^rwne-list/name-list.service.specXs-MyEclip^EnterpriseWoricben<h

Search£rcyMtgun

FS,5<>7r.：：：.「6律•一

|QuKkA<ce«|：吧Q

>釉M)-NewAnguUrProj»ct>tre>L。>pp).n«m«*liU>.f|rMme-litt.t<rvK«.tp«.Kt

QM>£chpseEjcplocer[£nime-l^tsefvice.spec.tsH友Outlie笈JMiramap

口虫JaA音华P1Import(ReflectiveXnjector}fro**a*n«ular/core':♦。0

2iaport(BaseRequestOptions,ConnectionBackend,Http,Response/Respons

Qtyp«Wtertotv7缶'rwnt-lii«.Mrv»ce.»pec-

3{Mo<k0«ckend}from,^»ngul»r/http/testing*;

>漏-DWRSprm9JPASxAmpteicaampletA4iaport{Observabl*}froa*rxjs/Ob&«rvabl<*;>®imports

>的MyAng2Project•.mam

v酬MyNewAngulafProject6iaport{NawcListService}Frow,list.service*;

>BKJavaScriptResourcesoexportfunction»ain()(

)纥必describcCNowcListService*,()->(

>£?node_mod*4wletnaaieLBtService:N««eiist$ervice;

▼的sreletbackend:Mockfiackend;

letinitialRcsponse:any;

▼於*PP

>。

dashboard14*?b«foreEach(()•><

>e10KIS

vQsharedIC*letinjector-Reflectivelnjector.resolveAxiCreate((

▼—flMTM-liSt17Service,

(J)mdex.tsBas«IUqu«stOptions.

MockBackend^

,Tservice/

{provide:Http,

国neme-fe$t.s«*vice.l

useFactory:funct£on(backend2:ConnectionBjickendvdefAultOpti

>sidebarreturnnewHttp(b«ckend2(defaultOptions);

>@topfwv

d«p»:FMo<k8«ckend.lefteoue»tOption>1

GBT«nn»naKcZ0Console*Mxkefj击GrtStaging3*C>llHierwchy

IX|O■CProject：Myf4«wAn9uUrPfOj«<t

S<rvtfSU.St-

・ItyNewAngulaf^roject

店MyEclipteTcmotv8.

y@AngularCUversion:

NPMversion:ie

CiMyAng2Project

GMyfiewAnguiarPr

GU>adfnm-r*92

1itemselectedUpdatingcd«xet

AsimplerepresentationofMyEclipse

4

献大学业论文（W）

2.2ReviewsontheInterface:

Theplatformisveryflexibleandextensible,butthisflexibilityhasaserious

drawback.Inparticular,thereisnowaywithintheprogramtoensureuserinterface

consistencybetweentheregisteredcomponentswithintheplatform.Thisdocument

attemptstoreconcilethisproblem,bydefiningstandarduserinterfaceguidelinesforthe

creationofnewcomponents.Iftheseguidelinesareadoptedwithinyourowntools,itwill

leadtogreaterconsistencywiththeplatformandothertools,andaneasierlearningcurve

foryourcustomers.

TheseguidelinesareintendedforusebydesignersandimplementersofanEclipse

interfaceextension.

WorkbenchwindowPerspectiveEditor

ShortcutbarMenubarToolbar

Statusline

Views

Structuralrepresentationoftheinterface

5-

献大学业论文（W）

2.2.1WorkBench:

Thisisacontainerofallideasontheeclipse.Itconsistofallcomponentsliketoolbars,

menubar,packageexploreretc.inabriefsummary,ifstheheartofeclipse.

2.2.2Menu:

Amenubarisagraphicalcontrolelementwhichcontainsdropdownmenus.Themenu

bar'spurposeistosupplyacommonhousingforwindow-orapplication-specificmenus

whichprovideaccesstosuchfunctionsasopeningfiles,interactingwithanapplication,or

displayinghelpdocumentationormanuals.

6-

献大学业论文（W）

2.2.3ToolBar:

Thesearehorizontalandverticalstructuresontheeclipseplatformstoolsthatrepresent

thedesignsandinstructionsonthesoftware

曰匕白o酉/I@电6b学▼Qr*小30。

Representationoftoolbar

2.2.4Editor:

Itprovidesdesignandverificationlanguagespecificcodeviewer,contentsoutline,code

assistetc.IthelpscodinganddebugginginhardwaredevelopmentbasedonVerilogor

VHDL.

夕ColorThemeManager.JaMH

•ReturnsthetheinestoredunderQan«re.

,@paraananeThetheaetoreturn.

•^returnTherequestedthceeor<codc>rHjll</codc>ifnonewiththatname

•exists.

publicMap<String,Strmg>getThM»(Sxrlngnar€){

returntheses.get(rame);

•Changesthepreferencesofotherpluginstcapplythecolorthere.

•fiparwthciieThenameofthe侬如Theiietcapply.

,/

publicvoidapplyTheme(Stringthese){

for(ThefiePreferenceMdppereditor：editors){

editor.clearO;

if(thenes.get(Th(?fle)<=null)

editor.aap(th«ies.get(theee))；

try{

editor.flush()；

}catch(BackingStorcExceptione){

//TODOS'owipropererror父gc(StdtusHdno^ef

e.printStdckTraceO;

50WritabkSm*rtinsert121:32

RepresentationofEditor

7-

献大学业论文（W）

2.3MySQL

2.3.1WhatisMySQL?

MySQLisanopen-sourcerelationaldatabaseimnagementsystem.SQL(Structured

QueryLanguage)isaspecial-purposeprogramminglanguagedesignedformanagingdata

heldinarelationaldatabase.SQLisusefultoqueryrelationaldatabaseslikeOracle

MySQLorMicrosoftSQLServer.

TheRELATIONALModel

TheWwtMowtheconntcbornbttwwitht•ntitiMand

expresstheone-to-manyretttionsbp

SQLRepresentationRelationalModeltoDatabase

8—

献大学业论文（W）

2.3.2MySQLYOG?

SQLyogisaGUItoolfortheRDBMSMySQL.ItisdevelopedbyWebyog,Inc.based

inBangalore,IndiaandSantaClaraCalifornia.FurtherasubsetofSQLyog.

Enterprise/UltimatefunctionalitiesisavailablewiththefreeSJA(SQLyogJobAgent)for

LinuxasanativeLinuxutility.Thismakesitpossibletospecifyandtest'scheduledjobs1

onaWindowsenvironmentandportexecutionparametersseamlesslytoaLinux

environment.

RepresentationofSQYOG

9-

献大学业论文（W）

2.3.3SessionSavepoints:

SQLyogalsohastheabilitytosaveSessionSavepointsandopenconnectionsfromasave

pointtothesamestateaswhenthesavepointwasgenerated.Asintheautomaticrestoringof

theprevioussessiononstartup,theterm“session”encompassesallopenconnectionsaswell

asallQuery,QueryBuilder,SchemaDesignertabsopenedforeveryconnectionaswellas

theHistorytab.TheSessionSavepointcommandsislocatedontheFilemenu.

。SQL/og32-[LocalAdmin-root©localhost]

FileEditFavoritesDatabaseTableOthersToolsPowertools

怜NewConnectionUsingCurrentSettingsCtrkN

°NewConnection...Ctrl*M

围NewQueryEditorCtrkT

WNewQueryBuilderCtrkK匠C

NewSchemaDesignerCtrkAlt+DAutoi

1

送NewDataSearchCtrkShift-D

x)CloseTabAlt-L

/RerameTabAH+F2

rDisconnectCtrkF4/Ctrl*W

*DisconnectAll

宓Open...Ctrl+O

ASave...CtrkS

[ASaveAs...

①6OpenSessionSavepoint...Ctrl+Shift*0

®SaveSession...Ctrl*Shift*S

@SaveSessionAs...

EncSessionCtrl+Shift+X

RecentFiles

■ExitAlt+F4

23.4Auto-popup'or'Tooltip':

Wheneveryoutypeanobjectnamefollowedbyaperiod(.),alistofavailablechild

objectswillpopupinasmallwindow.Youcanihcnsclculanitemfromlliclistby:

usingtheupanddownarrowkeystomovetheselectionhighlighting,andthen,

PressingtheTABorENTERkeytoselecttheitem.

Forinstance,trytypingadatabasenamelike“sakila."tobringupthelistoftableswithin

thesakiladatabase

io-

献大学业论文（W）

国QueryXHistory+

Autocomplete:[Tab]->NextTag.(Ctrl+Space]->ListAllTags.[Ctrl+En

SELECT*FROMsakila.|;

actor-info

address

-category

77city

coung

customer

cu3tcnier_li3t

film

film_actor

~film_category

~MS、~IS

2.3.5Column-widthPersistence

TheResultTabdisplaysthedatafromSELECTqueriesinaGridviewbydefault.It

formatstheresultsinExccl-likcrowsandcolumns.(FormandTextviewsarcalsoavailable.)

TheGridviewoffersafewbenefits,suchassorting:Clickingontheheadersortstheresults

bythatcolumn.Thissortingisdoneontheclientsidewithoutsendinganyadditionalqueries

totheMySQLserver.

InSQLyog,theGridviewoffersanotheradvantage.WithmostotherGUItoolsusinga

DataGRIDyouwillneedtospendtimeadjustingthewidthofcolumnheaderseverytime

youopentheprogram.InSQLyog,columnwidthsarepersistentacrosssessionsandeven

acrossmaster/slavereplicasofsamedatabase

Qunrv*mHtRtmy

Autocomplete:(T«b]->NextTag.(Ctrl4-Space)>>ListAllTOQS.[Ctrl*Enter]>>ListMatchingTa^s.(Ctrl♦ShiftsSpace)->ListFunctiona...

SELECT

•8，

*name',

,type、，

・apecitlc_nanie",

•language'

FROM