摘 要
隨著經濟的日益增長,信息化時代已經到來,生活中各種信息趨向數字化、清晰化。公交車作為現代城市生活中一種重要的交通工具,其數量增多,車型也不再單一,雇用的司機增多,這樣使得公交車公司的車輛信息管理復雜化。在這樣的背景下,提出了計算機管理的公交車管理系統,輔助公交車運營公司對車輛進行管理,實現公交車、公交線路和司機管理科學化,更合理的利用資源。
該系統主要根據實際的需求,以需求分析、系統的設計目標,并且重點進行系統功能模塊的詳細設計和實現,采用了Visual Studio .NET 2003開發平臺和 SQL Server 2000數據庫,實現了車輛信息管理、司機信息管理、線路信息管理和車輛分配線路管理等功能。在針對數據操作方面,主要通過存儲過程的方式實現數據的添加、刪除和查詢等操作。通過系統測試,解決了公交車輛管理系統主要問題。
關鍵詞: 管理系統;數據庫;存儲過程
The Design and Implementation of Bus Management System
Abstract
Along with economical growing, the information century has already arrived and each kind of information trends to digitization and clearness in our life. As an important transportation tool in the modern life, the number of the bus is increasing and its type is no longer unitary. As well, the bus drivers are also increasing. These make the information management of the bus companies more complicated. Under such background, the bus management system controlled by the computers is put forward. It will help the bus company manage its buses, make the management of the bus, the bus routine and the driver more scientific and make proper use of the resources.
The system is based on the practical requirements, and aimed at the demand analysis and the systematical design. It emphasizes the details of design and implementation of the systematical function module. It’s development platform are Visual Studio .NET 2003 and SQL Server 2000 Database and implements many functions, such as vehicles information management, driver information management, routine information management, vehicle assignment line management. for database implementation, it mainly uses the storage procedure to implement the addition, deletion and inquiry. By the systematical test, it can solve the main problems in the vehicles management system.