完美汽配网上商城的设计与实现

目录插图索引..........................................................................IV附 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 索引...........................................................................V第1章项目概况....................................................................11.1 设计 领导形象设计圆作业设计ao工艺污水处理厂设计附属工程施工组织设计清扫机器人结构设计 背景.................................................................11.2设计意义.................................................................11.3设计思路.................................................................1第2章需求分析....................................................................32.1需求描述.................................................................32.2用例建模.................................................................32.3用例描述.................................................................42.3.1登录注册用例描述....................................................42.3.2汽配评论用例描述....................................................42.3.3购物车用例描述......................................................52.3.4订单详情用例描述....................................................5第3章系统设计....................................................................63.1数据库设计...............................................................63.1.1概念模型............................................................83.1.2逻辑模型............................................................83.1.3物理模型............................................................93.1.4数据库脚本.........................................................103.2系统架构设计.............................................................203.3模块设计................................................................213.3.1登录注册类图.......................................................213.3.2汽配评论类图.......................................................223.3.3购物车类图.........................................................233.3.4购物车操作流程.....................................................243.3.5订单详情类图.......................................................25第4章产品实现...................................................................274.1登录注册模块实现.........................................................274.1.1界面设计...........................................................274.1.2功能实现...........................................................294.2汽配评论模块实现.........................................................314.2.1界面设计...........................................................314.2.2功能实现...........................................................334.3购物车模块实现...........................................................334.3.1界面设计...........................................................344.3.2功能实现...........................................................344.4订单详情模块实现.........................................................354.4.1界面设计...........................................................354.4.2功能实现...........................................................37第5章产品测试...................................................................385.1测试 方法 快递客服问题件处理详细方法山木方法pdf计算方法pdf华与华方法下载八字理论方法下载 与策略...........................................................385.2登录注册模块测试.........................................................385.3汽配评论模块测试.........................................................40II5.4购物车模块测试...........................................................405.5订单详情模块测试.........................................................41第6章结论.......................................................................436.1毕业设计成果特点.........................................................436.2设计成果的实用价值或应用前景.............................................436.3不足之处或遗留未予解决的问 题 快递公司问题件快递公司问题件货款处理关于圆的周长面积重点题型关于解方程组的题及答案关于南海问题 .............................................43III插图索引图2-1完美汽配网上商城用例模型图.............................................................................................3图3-1完美汽配网上商城概念模型图.............................................................................................8图3-2完美汽配网上商城逻辑模型图.............................................................................................9图3-3完美汽配网上商城物理模型图...........................................................................................10图3-4完美汽配网上商城架构设计图...........................................................................................21图3-5登录注册类图.......................................................................................................................22图3-6汽配评论类图.......................................................................................................................23图3-7购物车类图...........................................................................................................................24图3-8购物车信息时序图...............................................................................................................25图3-9订单详情类图.......................................................................................................................26图4-1完美汽配网上商城登录界面图...........................................................................................27图4-2完美汽配网上商城注册界面图...........................................................................................28图4-3完美汽配网上商城首页界面图...........................................................................................28图4-4完美汽配网上商城配件列表界面图...................................................................................29图4-5登录注册模块中登录界面主要代码图...............................................................................30图4-6登录注册模块中注册界面主要代码图...............................................................................31图4-8完美汽配网上商城配件详情界面图...................................................................................32图4-9汽配评论模块主要代码图...................................................................................................33图4-10购物车模块界面图...............................................................................................................34图4-11购物车模块主要代码图.......................................................................................................35图4-12订单模块界面图...................................................................................................................36图4-13订单模块付款界面图...........................................................................................................36图4-14订单模块主要代码图...........................................................................................................37IV附表索引表2-1登录注册用例描述表.............................................................................................................4表2-2汽配评论用例描述表.............................................................................................................4表3-1UserInfo表（用户信息表）...................................................................................................6表3-2GoodsInfo表（配件信息表）................................................................................................6表3-3Conmment表（评论表）......................................................................................................7表3-4Order表（订单表）...............................................................................................................7表3-5OrderInfo表（订单详情表）.................................................................................................7表3-6BigType表（类型表）............................................................................................................7表5-1登录注册模块测试用例表...................................................................................................38表5-2汽配评论模块测试用例表...................................................................................................40表5-3购物车模块测试用例表.......................................................................................................40表5-4订单详情模块测试用例表...................................................................................................41V第1章项目概况1.1设计背景完美汽配网上商城是专为汽配行业开发的系列汽配销售网站。经历了在数百家汽配公司、生产企业以及维修企业中的长期应用和跟踪服务、系统不断地改进和升级后的，最新推出的汽配展示覆盖面更宽、功能更强大，操作更简便，就如同是专门为您量身定做的一般。随着大数据、云计算、人工智能等技术逐步在向各产业领域下沉的大背景下完美汽配网上商城力求实现研发、技术的与时俱进,持续发挥自身品牌、服务等方面的实力与优势,助推互联网对汽配行业的深度渗透与融合。以提供更便捷的购买渠道为基础的,完美汽配网上商城旨在解决线下4S店汽配购买费用昂贵的问题，为广大车友提供优质、便捷的服务。1.2设计意义众所周知，汽车销售在近几年快速发展，一跃成为国内大型行业中的巨头。国内汽车销售迅速达到高峰期，这也带动了大量的汽车后市场行业比如汽车配件批发、汽车维修服务、汽车金融服务等。同时，随着我国经济不断的发展，物质生活水平不断的提高，人们开始对生活物质条件提出更高的要求。加上我国汽车工业迅猛发展，汽车已经成为一种便捷、高效的交通工具，这就对汽车配件的质量要求越来越高了。而传统的销售模式已经不适合当今飞速发展的时代要求，所以一系列新型销售模式的推出，而完美汽配网上商城完全契合了时代发展，可以更快速、更便捷的进行汽配销售的，省去了繁琐的线下流程。1.3设计思路本网站目前的主要对象是拥有汽车的居民。本系统分为四大模块，分别是登录注册模块、汽配评论模块、购物车模块、订单详情模块。1.登录模块：用于用户的登录和注册。2.汽配评论模块：购买汽车配件后的用户可以对汽配进行评论。3.购物车模块：用户对配件进行加入购物车处理。4.订单详情模块：用于订单详情查看和立即付款。1设计开发流程如下：1.需求分析：包括需求调研，系统功能，性能分析，业务流程分析。2.概要设计：包括系统架构设计，功能模块设计，数据库设计。3.详细设计：包括方法设计、方法的封装、数据结构设计、属性使用设计。4.系统实现：包括编写代码，系统单元测试。5.系统测试：对项目功能进行系统测试。2第2章需求分析2.1需求描述系统中有两种角色，两种角色拥有不同的功能；游客可以浏览配件，但是不能加入购物车，也不能进行评论；用户则拥有所有权限。用户可以添加自己心仪的配件到购物车，也可以直接生成订单、付款；线下短信提示到货后，用户确认收货后就可以对已购买过的汽车配件进行评论。2.2用例建模本系统中主要包括两类角色：游客、用户，游客指的是未登录的，用户指的是已登录的。根据前面的分析，可以得到完美汽配网上商城的登录模块和注册模块的总体用例图如下图2-1所示:图2-1完美汽配网上商城用例模型图32.3用例描述2.3.1登录注册用例描述汽配商城用户：游客登录后成为用户，其具体的用例描述如下表2-1所示：表2-1登录注册用例描述表用例编号CASE01用例名称汽配商城用户用例描述用户可以对汽配进行添加购物车处理和评论（即CRUD操作）前置条件必须是汽配商城的用户（已登录）后置条件无活动步骤1-用户输入用户名和密码2-点击登录按钮3-等待服务器响应4-登录成功扩展点无数据格式汽配信息2.3.2汽配评论用例描述汽配评论用例描述如表2-2所示：表2-2汽配评论用例描述表用例编号CASE02用例名称汽配商城用户用例描述对已经购买过的配件进行评论前置条件无后置条件无活动步骤1-用户进到了网站首页2-点到了配件详情界面3-点到配件详情界面就能进行评论扩展点无数据格式汽配信息42.3.3购物车用例描述用户登录后可以对配件进行添加购物车处理，可以对配件进行全选，反选，以及配件价格小计。存储用户精挑细选的商品、方便多个商品组合起来做促销；如果你看得长远一点就会发现，购物车甚至能帮助自营平台节省物流成本，把同类型商品提前归集，统一派分到同一仓库。举个例子：比如商品数量调整，需要从服务器端检查该商品是否有对应数量的库存，对应两种情况：库存充足和不足。实时检查商品库存能缓解‘结算按钮’的计算压力，同时能让用户购物更流畅。2.3.4订单详情用例描述用户的所有订单都在这个模块进行显示，以便用户查看。订单详情页展示场景：a)订单列表的下一个界面；b)支付成功后跳转订单详情；c)推送通知一笔订单支付成功或失败，点击推送通知直接跳转订单详情；d)在有预定详情，支付详情的产品场景中，支付详情可以跳转订单详情；5第3章系统设计根据汽配商城的需求分析结果，本章主要设计了完美汽配网上商城的数据库设计，以数据字典的形式一一罗列出表自身的组成结构，并使用PowerDesigner工具设计了概念模型、逻辑模型和物理模型，客观清晰的展示了表与表之间的关系；本系统采用MVC架构设计模型、划分了系统的功能模块使用UML类图和UML时序图详细描述了各功能的设计思路。3.1数据库设计完美汽配网上商城的数据库共设计了6张数据表，分别为用户信息表、配件信息表、评论表、订单表、订单详情表、类别表。各表的具体结构如下表3-1到3-6所示：表3-1UserInfo表（用户信息表）字段名中文名类别长度允许为空主键UID用户编号intNYUserName用户名varchar12UPhone手机号码varchar11USex性别bitNUstate用户状态varchar10UserPwd用户密码varchar50UImages用户头像varchar100UBirthday生日dateRealName真实姓名nvarchar20IDCard身份证号码nvarchar20表3-2GoodsInfo表（配件信息表）字段名中文名类别长度允许为空主键GIDintNYBID类别编号intNGoodsID配件编号varchar10GName配件名称varcharGPrice售价decimal10GDetail配件描述varchar500GTuiJian推荐语varchar500GImages配件图片varchar20GNums数量int6GTariff原价IntGstate上架状态nvarchar10表3-3Conmment表（评论表）字段名中文名类别长度允许为空主键CID评论编号intNYUID用户编号intNContnet评论 内容 财务内部控制制度的内容财务内部控制制度的内容人员招聘与配置的内容项目成本控制的内容消防安全演练内容 varchar500NCTime评论时间datetimeCType评论类别varchar10NGIDintNXinXin评论等级varchar表3-4Order表（订单表）字段名中文名类别长度允许为空主键OID订单编号intNYUID用户编号intNOStartTime订单开始时间datetimeOAID管理员编号intOState订单状态varchar10OPrice总售价decimal10OEndTime订单结束时间datetimeOApprove是否批准varchar10OTime批准时间datetimeOTariff总原价datetimeAddressID地址编号int表3-5OrderInfo表（订单详情表）字段名中文名类别长度允许为空主键ORID表主键intNYOID订单编号intNGID配件编号intNORNum配件数量intNORSumPrice总价decimal9N表3-6BigType表（类型表）字段名中文名类别长度允许为空主键7BID类型编号intYBigName类型名称varchar20完美汽配网上商城的登录模块和注册模块的设计与实现主要使用到了上表的3-1，购物车模块主要使用到了上表的3-2、3-4、3-5，其中3-3表主要用于配件评论模块,3-6表主要用于配件分类。3.1.1概念模型根据前文的数据字典的描述，通过使用PowerDesigner工具进一步设计了数据库的概念模型结构，展现出各表的自身结构以及各表与表之间的关联。完美汽配的概念模型如下图3-1所示：图3-1完美汽配网上商城概念模型图3.1.2逻辑模型根据前文的数据字典的描述，通过使用PowerDesigner工具进一步设计了数据库的逻辑模型结构，展现出各表的自身结构以及各表与表之间的关联。完美汽配的逻辑模型如下图3-2所示：8图3-2完美汽配网上商城逻辑模型图3.1.3物理模型利用PowerDesigner工具，在上节的逻辑模型基础上考虑各种具体的技术实现因素，进行数据库体系结构设计，真正实现数据在数据库中的存放。完美汽配的物理模型如下图3-3所示：9图3-3完美汽配网上商城物理模型图3.1.4数据库脚本USE[master]GO/******Object:Database[ShoppingCar2]CREATEDATABASE[ShoppingCar2]CONTAINMENT=NONEONPRIMARY(NAME=N'ShoppingCar2',FILENAME=N'E:\项目文件\完美\ShoppingCar2.mdf',SIZE=8192KB,MAXSIZE=UNLIMITED,FILEGROWTH=65536KB)LOGON(NAME=N'ShoppingCar2_log',FILENAME=N'E:\项目文件\完美\ShoppingCar2_log.ldf',SIZE=8192KB,MAXSIZE=2048GB,FILEGROWTH=65536KB)GOALTERDATABASE[ShoppingCar2]SETCOMPATIBILITY_LEVEL=140GOIF(1=FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))beginEXEC[ShoppingCar2].[dbo].[sp_fulltext_database]@action='enable'endGOALTERDATABASE[ShoppingCar2]SETANSI_NULL_DEFAULTOFFGOALTERDATABASE[ShoppingCar2]SETANSI_NULLSOFFGOALTERDATABASE[ShoppingCar2]SETANSI_PADDINGOFFGOALTERDATABASE[ShoppingCar2]SETANSI_WARNINGSOFFGOALTERDATABASE[ShoppingCar2]SETARITHABORTOFFGOALTERDATABASE[ShoppingCar2]SETAUTO_CLOSEOFFGOALTERDATABASE[ShoppingCar2]SETAUTO_SHRINKOFFGOALTERDATABASE[ShoppingCar2]SETAUTO_UPDATE_STATISTICSONGOALTERDATABASE[ShoppingCar2]SETCURSOR_CLOSE_ON_COMMITOFFGOALTERDATABASE[ShoppingCar2]SETCURSOR_DEFAULTGLOBALGOALTERDATABASE[ShoppingCar2]SETCONCAT_NULL_YIELDS_NULLOFF10GOALTERDATABASE[ShoppingCar2]SETNUMERIC_ROUNDABORTOFFGOALTERDATABASE[ShoppingCar2]SETQUOTED_IDENTIFIEROFFGOALTERDATABASE[ShoppingCar2]SETRECURSIVE_TRIGGERSOFFGOALTERDATABASE[ShoppingCar2]SETDISABLE_BROKERGOALTERDATABASE[ShoppingCar2]SETAUTO_UPDATE_STATISTICS_ASYNCOFFGOALTERDATABASE[ShoppingCar2]SETDATE_CORRELATION_OPTIMIZATIONOFFGOALTERDATABASE[ShoppingCar2]SETTRUSTWORTHYOFFGOALTERDATABASE[ShoppingCar2]SETALLOW_SNAPSHOT_ISOLATIONOFFGOALTERDATABASE[ShoppingCar2]SETPARAMETERIZATIONSIMPLEGOALTERDATABASE[ShoppingCar2]SETREAD_COMMITTED_SNAPSHOTOFFGOALTERDATABASE[ShoppingCar2]SETHONOR_BROKER_PRIORITYOFFGOALTERDATABASE[ShoppingCar2]SETRECOVERYFULLGOALTERDATABASE[ShoppingCar2]SETMULTI_USERGOALTERDATABASE[ShoppingCar2]SETPAGE_VERIFYCHECKSUMGOALTERDATABASE[ShoppingCar2]SETDB_CHAININGOFFGOALTERDATABASE[ShoppingCar2]SETFILESTREAM(NON_TRANSACTED_ACCESS=OFF)GOALTERDATABASE[ShoppingCar2]SETTARGET_RECOVERY_TIME=60SECONDSGOALTERDATABASE[ShoppingCar2]SETDELAYED_DURABILITY=DISABLEDGOEXECsys.sp_db_vardecimal_storage_formatN'ShoppingCar2',N'ON'GOALTERDATABASE[ShoppingCar2]SETQUERY_STORE=OFFGOUSE[ShoppingCar2]GO/******Object:Table[dbo].[Address]SETANSI_NULLSON11GOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[Address]([AID][int]IDENTITY(1,1)NOTNULL,[UID][int]NOTNULL,[SHson][nvarchar](50)NULL,[SHAddress][nvarchar](50)NULL,[SHPhone][nvarchar](11)NULL,CONSTRAINT[PK_Address]PRIMARYKEYCLUSTERED([AID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[AdminInfo]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[AdminInfo]([AID][int]IDENTITY(1,1)NOTNULL,[AName][varchar](12)NULL,[APwd][varchar](12)NULL,[AImages][varchar](20)NULL,[Amingzi][varchar](10)NULL,[APhone][varchar](20)NULL,[Aemail][varchar](20)NULL,[AQQ][varchar](10)NULL,[Age][int]NULL,[Asex][bit]NULL,CONSTRAINT[PK_ADMININFO]PRIMARYKEYNONCLUSTERED([AID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[BigType]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[BigType]([BID][int]NOTNULL,12[BigName][varchar](20)NULL,CONSTRAINT[PK_BIGTYPE]PRIMARYKEYNONCLUSTERED([BID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[Conmment]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[Conmment]([CID][int]IDENTITY(1,1)NOTNULL,[UID][int]NOTNULL,[Contnet][varchar](500)NOTNULL,[CTime][datetime]NULL,[CType][varchar](10)NOTNULL,[GID][int]NOTNULL,[XinXin][varchar](10)NULL,CONSTRAINT[PK_CONMMENT]PRIMARYKEYCLUSTERED([CID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[FanKui]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[FanKui]([FID][int]IDENTITY(1,1)NOTNULL,[UID][int]NOTNULL,[FContent][varchar](500)NULL,[FTime][datetime]NOTNULL,[FRead][nvarchar](10)NOTNULL,CONSTRAINT[PK_FANKUI]PRIMARYKEYNONCLUSTERED([FID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO13/******Object:Table[dbo].[GoodsInfo]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[GoodsInfo]([GID][int]IDENTITY(1,1)NOTNULL,[BID][int]NOTNULL,[GoodsID][varchar](10)NULL,[GName][varchar](100)NULL,[GPrice][decimal](10,2)NULL,[GDetail][varchar](500)NULL,[GTuiJian][varchar](500)NULL,[GImages][varchar](20)NULL,[GNums][int]NULL,[GTariff][decimal](10,2)NULL,[GState][nvarchar](10)NULL,CONSTRAINT[PK_GOODSINFO]PRIMARYKEYNONCLUSTERED([GID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[Order]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[Order]([OID][int]IDENTITY(1,1)NOTNULL,[UID][int]NOTNULL,[OStartTime][datetime]NULL,[OAID][int]NULL,[OState][varchar](10)NULL,[OPrice][decimal](10,2)NULL,[OEndTime][datetime]NULL,[OApprove][varchar](10)NULL,[OTime][datetime]NULL,[OTariff][decimal](10,2)NULL,[AddressID][int]NULL,CONSTRAINT[PK_ORDER]PRIMARYKEYNONCLUSTERED([OID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY]14)ON[PRIMARY]GO/******Object:Table[dbo].[OrderInfo]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[OrderInfo]([ORID][int]IDENTITY(1,1)NOTNULL,[OID][int]NOTNULL,[GID][int]NOTNULL,[ORNum][int]NOTNULL,[ORSumPrice][decimal](9,2)NOTNULL,CONSTRAINT[PK_ORDERINFO]PRIMARYKEYNONCLUSTERED([ORID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[ProfitDay]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[ProfitDay]([PDayID][int]IDENTITY(1,1)NOTNULL,[PdayName][nvarchar](2)NOTNULL,[ProfitMouthNum][decimal](18,2)NULL,[PmouthID][int]NOTNULL,CONSTRAINT[PK_ProfitDay]PRIMARYKEYCLUSTERED([PDayID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[ProfitMouth]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[ProfitMouth]([PmouthID][int]IDENTITY(1,1)NOTNULL,[PmouthName][nvarchar](2)NOTNULL,[ProfitMouthNum][decimal](18,2)NULL,15[PYearID][int]NOTNULL,CONSTRAINT[PK_ProfitMouth]PRIMARYKEYCLUSTERED([PmouthID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[ProfitYear]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[ProfitYear]([PYearID][int]IDENTITY(1,1)NOTNULL,[PyearName][nvarchar](4)NOTNULL,[ProfitYearNum][decimal](18,2)NULL,CONSTRAINT[PK_ProfitYear]PRIMARYKEYCLUSTERED([PYearID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[ShoppingcarInfo]SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[ShoppingcarInfo]([SHID][int]IDENTITY(1,1)NOTNULL,[UID][int]NOTNULL,[GID][int]NOTNULL,[SHNum][int]NOTNULL,[SHSumPrice][decimal](9,2)NOTNULL,[STime][datetime]NOTNULL,[SHSumTariff][decimal](9,2)NULL,CONSTRAINT[PK_ShoppingcarInfo_1]PRIMARYKEYCLUSTERED([SHID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Table[dbo].[UserInfo]SETANSI_NULLSON16GOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[UserInfo]([UID][int]IDENTITY(1,1)NOTNULL,[UserName][varchar](12)NULL,[UPhone][varchar](11)NULL,[USex][bit]NOTNULL,[Ustate][varchar](10)NULL,[UserPwd][varchar](50)NULL,[UImages][varchar](100)NULL,[UBirthday][date]NULL,[RealName][nvarchar](20)NULL,[IDCard][nvarchar](20)NULL,CONSTRAINT[PK_USERINFO]PRIMARYKEYNONCLUSTERED([UID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,IGNORE_DUP_KEY=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY])ON[PRIMARY]GO/******Object:Index[Relationship_3_FK]CREATENONCLUSTEREDINDEX[Relationship_3_FK]ON[dbo].[GoodsInfo]([BID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,SORT_IN_TEMPDB=OFF,DROP_EXISTING=OFF,ONLINE=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY]GO/******Object:Index[Relationship_4_FK]CREATENONCLUSTEREDINDEX[Relationship_4_FK]ON[dbo].[Order]([UID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,SORT_IN_TEMPDB=OFF,DROP_EXISTING=OFF,ONLINE=OFF,ALLOW_ROW_LOCKS=ON,ALLOW_PAGE_LOCKS=ON)ON[PRIMARY]GO/******Object:Index[Relationship_1_FK]CREATENONCLUSTEREDINDEX[Relationship_1_FK]ON[dbo].[OrderInfo]([OID]ASC)WITH(PAD_INDEX=OFF,STATISTICS_NORECOMPUTE=OFF,SORT_IN_TEMPDB