基于.NET的城市公交查詢系統的設計與實現

論文字數:11947,頁數:31

摘 要
隨著Internet的快速發展，互聯網已成為人們快速獲取、發布和傳遞信息的重要渠道，顯然它已成為社會生活的一部分。但我國的城市公交信息查詢卻還處于比較落后的水平上，廣大的市民獲取路線信息方式也比較少，最常用的方式只局限在詢問和交通地圖上。而城市公交查詢系統就是使人們能夠在因特網上方便、簡單的查詢出各條路線，了解自己所經過的每個站點等信息，以便能更好的制定自己的行動計劃而設計的。它主要實現的模塊是公交信息的查詢模塊，其中包括的功能有：線路查詢、站點查詢、站站查詢、車站查詢；而系統管理模塊主要實現的是對各個數據表進行添加、編輯、刪除等功能操作以及對留言版進行一些相應的回復。
城市公交查詢系統開發技術采用的是基于.NET的B/S架構，它的前端選用ASP.NET為主要的編程框架，其.ASPX文件包含組成用戶界面的 HTML 文本和控件，而后臺選用了C#編程語言。用.NET編程的最大好處在于易于管理和重用性比較高。數據庫選用的是SQL Server 2000，而應用程序通過ADO.NET與SQL Server 2000數據庫建立鏈接，并且運用SQL 語言實現對其數據庫進行操作。在此系統中，大量采用了存儲過程來對數據庫進行操作。

關鍵詞：互聯網；城市公交查詢；.NET；存儲過程
The Design and Realization of City Bus Inquiry System Based on .NET
Abstract
With the rapid development of Internet, the Internet has become an important channel of people acquiring, publishing and transmitting information and obviously become one part of social life. But China's technology of urban public transport information inquiry is still in a relatively backward level. The numerous citizens have a little access to acquire the information about bus lines. The most common ways are confined to traffic maps or the reference to stranger. And the urban public transport system is designed for people to inquire of all lines in the Internet conveniently and simply and get to know every site that they passed away in order to make their plans more efficiently. The main module of this system is the bus information query module. Its functions include line inquiry, site inquiry, station-to-station inquiry and station inquiry. The system management module mainly realizes the functional operation on adding, editing, deleting of all data tables and responses to the message correspondingly.
The development technology of the city bus inquiry system adopt B/S framework based on .NET. Its front-end part uses ASP.NET as the major framework. The .ASPX file contains HTML text and controls which make up of user interface. The back-end chooses C# as its programming language. The greatest benefit of choosing .NET to programming is the easy managements and reusability. Database uses the SQL Server 2000, and the application accesses the database by ADO.NET and uses SQL language to operate the database. The stored procedure is used a lot to operate the database in the system.

Key words: Internet; City Bus inquiries; .NET; Stored Procedure.

目  錄

1引言 1
1.1 城市公交查詢系統的前景 1
1.2 城市公交查詢系統的作用 2
2城市公交查詢系統的實現技術和工具 2
2.1 ASP.NET 2
2.1.1 什么是ASP.NET 2
2.1.2 .NET Framework概述 2
2.1.3 ASP.NET的特點 3
2.2 C# 4
2.3 ADO.NET對象操作數據庫 4
2.4 SQL Server 2000 5
2.5 Microsoft Visual Studio.NET 5
3 城市公交車查詢系統的分析與設計 5
3.1 需求分析 5
3.2 概要設計 6
3.2.1 系統功能描述 6
3.2.2 系統功能模塊劃分 6
3.2.3 系統流程設計 8
3.2.4 系統E-R圖 10
4 數據庫結構設計與實現 12
4.1 數據表的創建 12
4.2 數據庫的連接 13
4.3 存儲過程 14
5 城市公交查詢系統的實現 15
5.1 系統首頁 15
5.2 后臺管理界面 18
6 系統測試 23
6.1 測試用戶查詢模塊 23
6.2 測試系統管理模塊 23
6.3 測試留言簿管理 24
結    論 25
參考文獻 25
致   謝 26
聲   明 27