數(shù)據(jù)庫課程設(shè)計論文收費(fèi)停車場管理系統(tǒng)數(shù)據(jù)庫設(shè)計畢業(yè)論文-資料下載頁
2025-06-23 23:58本頁面
【正文】 create procedure sof2asselect count(cwno) 自由車位總數(shù)from Ffedwhere cwtype=39。自由39。create procedure sof3asselect 11count() 空閑自由車位from Ffed,stopwhere = and cwtype=39。自由39。 and carat=1create procedure sof4asselect count(cwno) 車位總數(shù)from Ffedcreate procedure sof5@nom char(10)asselect *from moneynotewhere carno=@nomcreate procedure sof6@s_carno char(10),@s_carsb char(10),@s_carcolor char(4)asinsert into carvalues(@s_carno,@s_carsb,@s_carcolor)create procedure sof7@s_Cwno char(10),@s_Cwpace char(10),@s_Cwtype char(4),@s_Carno char(10),@s_Carname char(10),@s_Carsb char(10),@s_Carcolor char(4),@s_Carpho bit,@s_Caradd char(20),@s_Cartel char(20),@s_Carmon floatasinsert into Ffedvalues(@s_Cwno,@s_Cwpace,@s_Cwtype,@s_Carno,@s_Carname,@s_Carsb,@s_Carcolor,@s_Carpho,@s_Caradd,@s_Cartel,@s_Carmon)create procedure sof8@s_Cwno char(10),@s_Carno char(10),@s_Carat bit,@s_Carin datetime,@s_Carout datetime,@s_Timetype char(6)asinsert into Stopvalues(@s_Cwno,@s_Carno,@s_Carat,@s_Carin,@s_Carout,@s_Timetype)create procedure sof9@s_Cwno char(10),@s_Carno char(10),@s_Cartime float,@s_Moneypay float,@s_Piece char(10)asinsert into Moneynotevalues(@s_Cwno,@s_Carno,@s_Cartime,@s_Moneypay,@s_Piece)create procedure sof10asselect *from Carcreate procedure sof11asselect *from FFEDcreate procedure sof12asselect *from STOPcreate procedure sof13asselect *from MONEYNOTEREATE PROCEDURE sof14@s_carno char(10)asdeletefrom moneynotewhere carno=@s_carnocreate procedure sof15@s_carno char(10)asupdate ffedset carmon=150where carno=@s_carnoCreate trigger insert_or_update_carmonOn ffed for insert,updateAsIf exists(select* From ffed Where Carmon120)BeginPrint 39。最低余額必須大于等于120 39。RollbackEnd。Create trigger tri_moneypayOn moneynote for upodateAsIf exists(select * From inserted join Delete on = Where =50And 50)RollbackBeginPrint 39。禁止無端修改，修改不成功39。End。Create trigger tri_del_moOn moneynote for deleteAsIf exists(select * From deleted Where moneypay70)RollbackBeginPrint39。刪除失敗39。End。 V1Carinformation車位號,車牌號查詢在位車輛信息V2Carfixedtion車位號,車牌號,車主,車名,車色,車照,地址,電話,余額查詢在固定車位停車的車輛信息V3carfreetion車位號,車牌號,車名,車色查詢在自由車位停車的車輛信息V4Carinouttion車位號、車牌號、進(jìn)入時間、離開時間、時間段查詢車輛進(jìn)出記錄V5moneytime時間段、費(fèi)率查詢及修改收費(fèi)費(fèi)率V6Moneytion總收費(fèi)查詢停車場總收費(fèi)v7Carmoney車牌號、繳費(fèi)總額查詢每輛車的繳費(fèi)額 v3查詢在自由車位停車的車輛信息的視圖功能驗證V7 查詢每輛車的繳費(fèi)總額的視圖功能驗證V1 查詢在位車輛的所有信息V6
化學(xué)相關(guān)推薦
鄂ICP備17016276號-1