本科生毕业设计(论文)I摘要销售管理子系统是一个B2C模式的以网上零售为主的在线购物系统,采用三层架构的B/S开发技术,数据库选择了MicrosoftSQLServer2000,并利用了目前流行的WEB开发技术-JSP,通过JavaBean和JSTL的使用,实现了前台商品的展示、购物车、留言板;后台商品管理、订单处理、单据生成等主要功能。将业务模型最终以程序的形式实现,从而使得该系统能充分满足基于B2C模式的网上销售系统的需要。使用该软件既能够对企业内部库存、采购和客户关系等部门实施电子化管理;也能够通过互联网,在线进行商品销售和结算管理。该系统可以顺畅企业内部信息流,为企业开拓了具有巨大潜力的网上销售市场,也减少企业内部工作流程,进而提高工作效率和工作质量,使企业在激烈的市场竞争中获得竞争优势。本文主要对网上销售系统进行总体设计,并对销售管理子系统进行系统分析、系统设计、系统实现和系统测试。关键词:B2C;购物车;JavaBean;订单处理本科生毕业设计(论文)IIAbstractSalesmanagementsubsystemtechnicallyisaB2Conlinesalesystem,mainfunctionofwhichistopromoteonlineretailactivitiesofabusiness.Thesystemadoptsathree-tierarchitectureB/Sdevelopmenttechnology.BackgrounddatabaseofthesystemadoptstheMicrosoftSQLServer2000.ByusingJavaBeanandJSTL(JavaServerPagesStandardTagLibrary)ofJSP(JavaServerPage)technology,thesystemintegratesmanypracticalfunctions,whichincludesForegroundItemDisplay,ShoppingCart,FeedbackBoard,InventoryManagement,OrderProcessing,andBillGenerationetc.Therealbusinessmodefinallyisembodiedinformofcomputerprogram.Therefore,thesystemcanfullymeetrequirementsofaB2Conlinesalemode.Withthesystembusinessescanrealizetheinformativemanagementinaspectsofinventory,procurementandcustomerrelationship,aswellascanhandletheonlinesalesprocessandsettlementviainternet.Thesystemcanhelpbusinessestofacilitatetheirinternalinformationflowanddeveloppotentiale-market,aswellassimplifybusinessprocessandimproveworkefficiencyandquality.Itwillbringcompetitiveedgetobusinesses.Thepaperpresentsageneraldesignoftheonlinesalessystem,andparticularly,presentsthedetailedsystemanalysis,systemdesign,systemimplementationandsystemtestoftheSalesManagementModule..Keywords:B2C;Shoppingvehicle;JavaBean;Disposetheorderforms本科生毕业设计(论文)III目录第1章绪论..........................................................................................................11.1设计构想...................................................................................................11.2开发工具选择...........................................................................................11.3开发方案选择...........................................................................................21.4开发方法...................................................................................................4第2章可行性研究................................................................................................72.1技术可行性...............................................................................................72.2经济可行性...............................................................................................72.3操作可行性...............................................................................................82.4其他方面可行性.......................................................................................8第3章需求分析....................................................................................................93.1系统的需求分析.......................................................................................93.2业务流程...................................................................................................93.3数据流程.................................................................................................103.4数据字典..................................................................................................14第4章数据库的设计..........................................................................................184.1数据库设计总述.....................................................................................184.2概念设计.................................................................................................194.3逻辑设计.................................................................................................204.4物理设计.................................................................................................214.4.1设计原理......................................................................................214.4.2设计方案......................................................................................224.5数据库实现.............................................................................................224.6数据库的安全性设计.............................................................................26第5章系统的设计..............................................................................................275.1系统设计原则.........................................................................................275.2系统的功能结构的设计.........................................................................27第6章系统实现..................................................................................................316.1系统界面的实现.....................................................................................316.2用户与管理员登陆的实现.....................................................................33本科生毕业设计(论文)IV6.3商品管理的实现.....................................................................................346.4商品浏览与查询的实现.........................................................................366.5订单处理的实现............................................