1、城市公交查詢系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)(論文范文,ASP.NET畢業(yè)設(shè)計(jì))摘 要隨著Internet的快速發(fā)展,互聯(lián)網(wǎng)已成為人們快速獲取發(fā)布和傳遞信息的重要渠道,顯然它已成為社會(huì)生活的一部分但我國的城市公交信息查詢卻還處于比較落后的水平上,廣大的市民獲取路線信息方式也比較少,最常用的方式只局限在詢問和交通地圖上而城市公交查詢系統(tǒng)就是使人們能夠在因特網(wǎng)上方便簡單的查詢出各條路線,了解自己所經(jīng)過的每個(gè)站點(diǎn)等信息,以便能更好的制定自己的行動(dòng)計(jì)劃而設(shè)計(jì)的它主要實(shí)現(xiàn)的模塊是公交信息的查詢模塊,其中包括的功能有:線路查詢站點(diǎn)查詢站站查詢車站查詢;而系統(tǒng)管理模塊主要實(shí)現(xiàn)的是對各個(gè)數(shù)據(jù)表進(jìn)行添加編輯刪除等功能操作以及對

2、留言版進(jìn)行一些相應(yīng)的回復(fù)城市公交查詢系統(tǒng)開發(fā)技術(shù)采用的是基于.NET的B/S架構(gòu),它的前端選用ASP.NET為主要的編程框架,其.ASPX文件包含組成用戶界面的 HTML 文本和控件,而后臺選用了C#編程語言用.NET編程的最大好處在于易于管理和重用性比較高數(shù)據(jù)庫選用的是SQL Server 2000,而應(yīng)用程序通過ADO.NET與SQL Server 2000數(shù)據(jù)庫建立鏈接,并且運(yùn)用SQL 語言實(shí)現(xiàn)對其數(shù)據(jù)庫進(jìn)行操作在此系統(tǒng)中,大量采用了存儲(chǔ)過程來對數(shù)據(jù)庫進(jìn)行操作關(guān)鍵詞:互聯(lián)網(wǎng);城市公交查詢;.NET;存儲(chǔ)過程AbstractWith the rapid dev

3、elopment 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 num

4、erous 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

5、 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 func

6、tional 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 con

7、trols 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 o

8、perate 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. 目  錄總頁數(shù):26頁1引言   11.1 城市公交查詢系統(tǒng)的前景    11.2 城市公交查詢系統(tǒng)的作用   

9、; 22城市公交查詢系統(tǒng)的實(shí)現(xiàn)技術(shù)和工具 22.1 ASP.NET 2 什么是ASP.NET 2 .NET Framework概述    22.1.3 ASP.NET的特點(diǎn) 32.2 C#  42.3 ADO.NET對象操作數(shù)據(jù)庫    42.4 SQL Server 2000 52.5 Microsoft Visual Studio.NET 53 城市公交車查詢系統(tǒng)的分析與設(shè)計(jì) 

10、60;53.1 需求分析 53.2 概要設(shè)計(jì) 6 系統(tǒng)功能描述   6 系統(tǒng)功能模塊劃分   6 系統(tǒng)流程設(shè)計(jì)   8 系統(tǒng)E-R圖 104 數(shù)據(jù)庫結(jié)構(gòu)設(shè)計(jì)與實(shí)現(xiàn)    124.1 數(shù)據(jù)表的創(chuàng)建 124.2 數(shù)據(jù)庫的連接 134.3 存儲(chǔ)過程 145 城市公交查詢系統(tǒng)的實(shí)現(xiàn)  155.1 系統(tǒng)首頁 155.2 后臺管理界面 186 系統(tǒng)測試   236.1 測試用戶查詢模塊 236.2 測試系統(tǒng)管理模塊 236.3 測試留言簿管理   24