【正文】 _RECORD .................................................................................................................................................. 16 表 TABLE_CAR_WORKER ....................................................................................................................................... 17 存儲過程 .................................................................................................................................................................. 17 proc_insert_Worker................................................................................................... 17 proc_insert_Customer ............................................................................................... 18 proc_insert_Car........................................................................................................... 19 proc_insert_CarClass ................................................................................................... 20 proc_insert_Record...................................................................................................... 21 proc_find_AllCarClass................................................................................................. 22 proc_find_Cars ........................................................................................................... 23 proc_find_Car ............................................................................................................. 23 proc_find_Customer .................................................................................................... 24 proc_find_CustomerRecord ........................................................................................ 24 proc_find_CarRecord ................................................................................................. 25 proc_find_CustomerFavorite ....................................................................................... 25 函數(shù) .......................................................................................................................................................................... 26 func_CreateRecordNO ................................................................................................. 26 func_IdToAge ............................................................................................................. 26 觸發(fā) 器 ................................................................................................................................................................... 27 Trigger_insertCar_addCarClassCnt .............................................................................. 27 Trigger_deleteCar_subtractCarClassCnt ....................................................................... 27 Trigger_updateCar ..................................................................................................... 28 Trigger_updateRecordReturnDate ................................................................................ 28 七、 運行結(jié)果 .................................................................................................................................................................... 29 租賃汽車 ................................................................................................................................................................. 29 資料查詢 .................................................................................................................................................................. 30 訂單查詢 .................................................................................................................................................................. 30 查詢一類汽車 .......................................................................................................................................................... 31 還車登記 .................................................................................................................................................................. 31 統(tǒng)計某一年齡最喜歡的類型 ................................................................................................................................. 32 八、 總結(jié) ............................................................................................................................................................................ 32 九、 附錄 ............................................................................................................................................................................ 33 存儲過程代碼 ......................................................................................................................................................... 33 proc_insert_Car........................................................................................................... 33 proc_insert_CarClass ................................................................................................... 33 proc_insert_Customer .................................................................................................. 34 proc_insert_Record...................................................................................................... 34 proc_insert_Worker ..................................................................................................... 34 proc_find_AllCarClass................................................................................................. 35 proc_find_Car ............................................................................................................. 35 proc_find_Cars ........................................................................................................... 35 proc_find_CarRecord................................................................................................... 36 proc_find_Customer ...................