【正文】 ,name,price,proDate,storageFROM [Product_info]CREATE PROCEDURE Repair_info_GetMaxIdASDECLARE @TempID intSELECT @TempID = max([repairId])+1 FROM [Repair_info]IF @TempID IS NULLRETURN 1ELSERETURN @TempIDCREATE PROCEDURE Repair_info_Exists@repairId intASDECLARE @TempID intSELECT @TempID = count(1) FROM [Repair_info] WHERE repairId=@repairId IF @TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Repair_info_ADD@repairId int output,@repairName nchar(10),@repairtel nchar(10),@product varchar(50),@customer varchar(20),@date smalldatetime,@customertel nchar(10) AS INSERT INTO [Repair_info]([repairName],[repairtel],[product],[customer],[date],[customertel])VALUES(@repairName,@repairtel,@product,@customer,@date,@customertel)SET @repairId = @@IDENTITYCREATE PROCEDURE Repair_info_Update@repairId int,@repairName nchar(10),@repairtel nchar(10),@product varchar(50),@customer varchar(20),@date smalldatetime,@customertel nchar(10) AS UPDATE [Repair_info] SET [repairName] = @repairName,[repairtel] = @repairtel,[product] = @product,[customer] = @customer,[date] = @date,[customertel] = @customertelWHERE repairId=@repairId CREATE PROCEDURE Repair_info_Delete@repairId int AS DELETE [Repair_info]WHERE repairId=@repairId CREATE PROCEDURE Repair_info_GetModel@repairId int AS SELECT repairId,repairName,repairtel,product,customer,date,customertelFROM [Repair_info]WHERE repairId=@repairId CREATE PROCEDURE Repair_info_GetList AS SELECT repairId,repairName,repairtel,product,customer,date,customertelFROM [Repair_info]CREATE PROCEDURE Seller_info_Exists@name varchar(50)ASDECLARE @TempID intSELECT @TempID = count(1) FROM [Seller_info] WHERE name=@name IF @TempID = 0RETURN 0ELSERETURN 1CREATE PROCEDURE Seller_info_ADD@name varchar(50),@telephone varchar(20),@address varchar(50),@product varchar(50),@stockNum varchar(6),@stockDate smalldatetime,@stockPrice varchar(10) AS INSERT INTO [Seller_info]([name],[telephone],[address],[product],[stockNum],[stockDate],[stockPrice])VALUES(@name,@telephone,@address,@product,@stockNum,@stockDate,@stockPrice)CREATE PROCEDURE Seller_info_Update@name varchar(50),@telephone varchar(20),@address varchar(50),@product varchar(50),@stockNum varchar(6),@stockDate smalldatetime,@stockPrice varchar(10) AS UPDATE [Seller_info] SET [telephone] = @telephone,[address] = @address,[product] = @product,[stockNum] = @stockNum,[stockDate] = @stockDate,[stockPrice] = @stockPriceWHERE name=@name CREATE PROCEDURE Seller_info_Delete@name varchar(50) AS DELETE [Seller_info]WHERE name=@name CREATE PROCEDURE Seller_info_GetModel@name varchar(50) AS SELECT name,telephone,address,product,stockNum,stockDate,stockPriceFROM [Seller_info]WHERE name=@name CREATE PROCEDURE Seller_info_GetList AS SELECT name,telephone,address,product,stockNum,stockDate,stockPriceFROM [Seller_info]：USE [TimeGroup]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER trigger [dbo].[producttri]on [dbo].[Enter_storage]after updateasupdate Product_infoset storage=storage+1 where Product_info. proId =(select proId from inserted)6 安全性設(shè)計(jì)提示：提高軟件系統(tǒng)的安全性應(yīng)當(dāng)從 “管理 ”和 “設(shè)計(jì) ”兩方面著手。這里僅考慮數(shù)據(jù)庫的安全性設(shè)計(jì)。例如：應(yīng)用級的用戶帳號密碼不能與數(shù)據(jù)庫相同，防止用戶直接操作數(shù)據(jù)庫。用戶只能用帳號登陸到應(yīng)用軟件，通過應(yīng)用軟件訪問數(shù)據(jù)庫，而沒有其它途徑操作數(shù)據(jù)庫。 防止用戶直接操作數(shù)據(jù)庫的方法提示：用戶只能用帳號登陸到應(yīng)用軟件，通過應(yīng)用軟件訪問數(shù)據(jù)庫，而沒有其他途徑操作數(shù)據(jù)庫。 用戶帳號密碼的加密方法提示：對用戶帳號的密碼進(jìn)行加密處理，確保在任何地方都不會(huì)出現(xiàn)密碼的明文。例如：用戶帳號采用 MD5 進(jìn)行數(shù)據(jù)加密后再錄入數(shù)據(jù)庫，以防止任何地方密碼的安全性要求。Sa 密碼登錄 角色與權(quán)限提示：確定每個(gè)角色對數(shù)據(jù)庫表的操作權(quán)限，如創(chuàng)建、檢索、更新、刪除等。每個(gè)角色擁有剛好能夠完成任務(wù)的權(quán)限，不多也不少。在應(yīng)用時(shí)再為用戶分配角色，則每個(gè)用戶的權(quán)限等于他所兼角色的權(quán)限之和。角色 可以訪問的表與列 操作權(quán)限可訪問所有表 完全控制權(quán)限例如：管理員角色 B7 優(yōu)化提示：分析并優(yōu)化數(shù)據(jù)庫的 “時(shí)－空 ”效率，盡可能地 “提高處理速度 ”并且 “降低數(shù)據(jù)占用空間 ”。（ 1）分析 “時(shí)－空 ”效率的瓶頸，找出優(yōu)化對象（目標(biāo)） ，并確定優(yōu)先級。（ 2）當(dāng)優(yōu)化對象（目標(biāo)）之間存在對抗時(shí)，給出折衷方案。（ 3）給出優(yōu)化的具體措施，例如優(yōu)化數(shù)據(jù)庫環(huán)境參數(shù)，對表格進(jìn)行反規(guī)范化處理等。優(yōu)先級 優(yōu)化對象（目標(biāo)） 措施8 數(shù)據(jù)庫管理與維護(hù)說明提示：在設(shè)計(jì)數(shù)據(jù)庫的時(shí)候，及時(shí)給出管理與維護(hù)本數(shù)據(jù)庫的方法，有助于將來撰寫出正確完備的用戶手冊