倉(cāng)庫(kù)管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)本科畢業(yè)論文-在線瀏覽
2024-08-04 19:24本頁(yè)面
【正文】 [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, [Date] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [OUName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [PgName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Outbound_table] PRIMARY KEY CLUSTERED ( [OutboundID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])： CREATE TABLE [dbo].[Lend_out_table]( [LendoutID] [int] NOT NULL, [UserID] [int] NOT NULL, [TradeName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, [Borrowdate] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Returndate] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [LendersName] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Lend_out_table] PRIMARY KEY CLUSTERED ( [LendoutID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])： CREATE TABLE [dbo].[Goods_table]( [GoodsID] [int] NOT NULL, [TradeName] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, [Manufacturer] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [Model] [char](30) COLLATE Chinese_PRC_CI_AS NULL, [Standard] [char](20) COLLATE Chinese_PRC_CI_AS NULL, [Quantity] [int] NOT NULL, CONSTRAINT [PK_Goods_table] PRIMARY KEY CLUSTERED ( [GoodsID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])：CREATE TABLE [dbo].[Warehouse_keeper_table]( [WarehouseKeeperID] [int] NOT NULL, [WarehouseKeepername] [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Sex] [char](16) COLLATE Chinese_PRC_CI_AS NOT NULL, [Age] [int] NOT NULL, [Tel] [char](16) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Warehouse_keeper_table] PRIMARY KEY CLUSTERED ( [WarehouseKeeperID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])：CREATE TABLE [dbo].[Storage_table]( [WarehouseID] [int] NOT NULL, [Trade name] [char](100) COLLATE Chinese_PRC_CI_AS NULL, [GoodsID] [int] NULL, [Quantity] [int] NOT NULL, [Address] [char](100) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Storage_table] PRIMARY KEY CLUSTERED ( [WarehouseID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY])8. 索引用SQL語(yǔ)言建立的代碼ALTER TABLE [dbo].[Goods_table] ADD CONSTRAINT [PK_Goods_table] PRIMARY KEY CLUSTERED ( [GoodsID] ASC)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) 9. 管理員對(duì)用戶信息表的操作：① 插入SQL語(yǔ)言建立的代碼USE storageINSERT INTO Users VALUES(7,39。,39。,14563125845)SELECT *FROM Users插入后表格顯示：② 修改SQL語(yǔ)言建立的代碼USE storageUPDATE Users SET User_name= 39。 WHERE User_ID=7SELECT *FROM UsersWHERE User_ID=7修改后表格顯示：③ 刪除SQL語(yǔ)言建立的代碼：USE storageDELETE FROM Users WHERE User_ID=7SELECT *FROM UsersWHERE User_ID=7刪除后表格顯示：④ 查詢SQL語(yǔ)言建立的代碼：USE storageSELECT *FROM UsersWHERE User_ID=3查詢后表格顯示：10. 管理員對(duì)入庫(kù)單表的操作①插入SQL語(yǔ)言建立的代碼：USE storageINSERT INTO Receipt_table VALUES(2015051501,2,39。,39。,39。,39。,450,39。,39。,39。)SELECT *FROM Receipt_table插入后表格顯示：②修改SQL語(yǔ)言建立的代碼：USE storageUPDATE Receipt_tableSET DeliverymanName=39。WHERE ReceiptID=2015051501SELECT *FROM Receipt_tableWHERE ReceiptID=2015051501修改后表格顯示：③刪除SQL語(yǔ)言建立的代碼：USE storageDELETE FROM Receipt_tableWHERE ReceiptID=2015051501SELECT *FROM Receipt_table WHERE ReceiptID=2015051501刪除后表格顯示：④查詢SQL語(yǔ)言建立的代碼：USE storageSELECT *FROM Receipt_tableWHERE ReceiptID=2012062301查詢后表格顯示： ①插入SQL語(yǔ)言建立的代碼：USE storageINSERT INTO Outbound_tableVALUE
外語(yǔ)相關(guān)推薦
鄂ICP備17016276號(hào)-1