电子商务-简单建模（练习篇）

练习篇： 电子商务简单UML模型 个人喜欢UML建模后再建数据库，有段时间没用SQL SERVER，特此复习下，练习代码如下： master NOCOUNT ON ; dbo.sysdatabases ) DatabaseOptimization DatabaseOptimization ON (NAME ,FILENAME ,SIZE = 10 ,MAXSIZE = UNLIMITE

HTShop网上购物系统

HTShop网上购物系统由恒天网络科技有限公司根据国际先进技术和国内商务特点自主版权开发的一款具有强大功能的B2C电子商务网上购物平台。HTShop以国际上通用流行的B/S(浏览器/服务器)模式进行设计，采用微软公司的ASP.NET（C#）技术构建而成。 2007-11-10 HTShop CS 通用标准版 v1.1.11.10 更新内容自由更换模版功能开放 修改了购买多款商品，会员中心订单只显示

0

查看详情

练习篇：

电子商务简单UML模型

个人喜欢UML建模后再建数据库，有段时间没用SQL SERVER，，特此复习下，练习代码如下：

master NOCOUNT ON; dbo.sysdatabases ) DatabaseOptimization DatabaseOptimization ON ( NAME , FILENAME , SIZE = 10, MAXSIZE = UNLIMITED, FILEGROWTH ) LOG ON( NAME , FILENAME , SIZE = 5MB, MAXSIZE = UNLIMITED, FILEGROWTH ) GO USE DatabaseOptimization .() AS RANDOM . ( @Source varchar(256), @PaddingChar char(1), @TotalLength tinyint ) RETURNS varchar(512) (LTRIM(@Source)); ) ; ; (@Source); ) ; (512); () . ( @Length tinyint ) () ; ; (38,0); ; () ; ; ; () FROM VIEW_RANDOM; RETURN @Return; . ( ) RETURNS varchar(30) (30); (,,,dbo.padleft( dbo.Random(,8) ; ; ; ; ; ; ; ; ; ; ; ; -------------------------------------------------------------------------------------------------------- --(sys.objects (N) ) .; .( , (20) NOT NULL, (40) NOT NULL, (40) NOT NULL, (20) NULL, (20) NULL, (100) NULL, (11) NULL, (6) NULL, (GETDATE()), (0) ); IX_CUSTOMER_NAME .(Name); ; ; .(,,) VALUES (dbo.PadLeft(),,dbo.PadLeft(),,,); ; --(sys.objects (N) ) .; .( (30) NOT NULL, , (50) NULL, (20) NULL, (100) NULL, (11) NULL, (6) NULL, (500) NULL, (GETDATE()), (0), (0), ); .PK_Order_OrderID ) ; .FK_Order_OrderID ) .() ; .(); ; ; (30); ; OPEN CursorCustomer; CursorCustomer INTO @CursorID; (RAND()*@OrderCount) ; PRINT @RandomCount; ; dbo.RandomValue(); PRINT @RandomOrderID; .(,CustomerID,PostingWay,Receiver,Address,Phone,) VALUES (@RandomOrderID, @CursorID, (), , , , ()); ; ; CursorCustomer INTO @CursorID; END CLOSE CursorCustomer; DEALLOCATE CursorCustomer; -------------------------------------------------------------------------------------------------------- --(sys.objects (N) ) .; .( , (100) NOT NULL, (100) NULL, , , , (1), (500) NULL, (GETDATE()) ); ; ; ; .(,,)VALUES(NULL,'',1); ; .(),(), ; ; CursorProductType .(); ; ; ; ; OPEN CursorProductType; CursorProductType INTO @TypeCursorID; SET NOCOUNT ON; (RAND()*@ProductTypeLevel2Count) ; PRINT @TypeRandomCount; ; .(,,)VALUES(@TypeCursorID,'',2); ; .(),(), ; ; ; CursorProductType INTO @TypeCursorID; END CLOSE CursorProductType; DEALLOCATE CursorProductType; -------------------------------------------------------------------------------------------------------- --(sys.objects (N) ) .; .( , (100) NOT NULL, (Max) NULL, , (38, 2) NULL, (38, 2) NULL, (200) NULL, , , (0), (8, 1) NULL DEFAULT (1), (GETDATE()), (GETDATE()), (1) ) .FK_Product_ProductTypeID_ProductType_ID ) .() ; CursorProductTypeWithLevel .(); ; ; ; ; OPEN CursorProductTypeWithLevel; CursorProductTypeWithLevel INTO @ProductTypeCursorID; SET NOCOUNT ON; (RAND()* @ProductRandomMax) ; PRINT @ProductTypeRandomCount; ; .(,,,,)VALUES( ,); ; .(),(), ; ; CursorProductTypeWithLevel INTO @ProductTypeCursorID; END CLOSE CursorProductTypeWithLevel; DEALLOCATE CursorProductTypeWithLevel; -------------------------------------------------------------------------------------------------------- --(sys.objects (N) ) .; .( , (30) NOT NULL, , (38, 2) NULL, ) .() .() ; .() .() ; .(); ; (30); (38,2); (8,1); ; OPEN CursorOrder; CursorOrder INTO @OrderCursorID; CursorProduct ,DiscountRate,SalePrice .(); OPEN CursorProduct; CursorProduct INTO @ProductCursorID,@ProductCursorDiscountRate,@ProductCursorSalePrice; (RAND()*50) ; . ( , , ,) VALUES ( @OrderCursorID ,@ProductCursorID , ,@DetailQuantity) CursorProduct INTO @ProductCursorID,@ProductCursorDiscountRate,@ProductCursorSalePrice; END CLOSE CursorProduct; DEALLOCATE CursorProduct; CursorOrder INTO @OrderCursorID; END CLOSE CursorOrder; DEALLOCATE CursorOrder;