基于.NET的城市公交查询系统的设计与实现 摘 要 随着Internet的快速发展,互联网已成为人们快速获取、发布和传递信息的重要渠道,显然它已成为社会生活的一部分。但我国的城市公交信息查询却还处于比较落后的水平上,广大的市民获取路线信息方式也比较少,最常用的方式只局限在询问和交通地图上。而城市公交查询系统就是使人们能够在因特网上方便、简单的查询出各条路线,了解自己所经过的每个站点等信息,以便能更好的制定自己的行动计划而设计的。它主要实现的模块是公交信息的查询模块,其中包括的功能有:线路查询、站点查询、站站查询、车站查询;而系统管理模块主要实现的是对各个数据表进行添加、编辑、删除等功能操作以及对留言版进行一些相应的回复。 城市公交查询系统开发技术采用的是基于.NET的B/S架构,它的前端选用ASP.NET为主要的编程框架,其.ASPX文件包含组成用户界面的 HTML 文本和控件,而后台选用了C#编程语言。用.NET编程的最大好处在于易于管理和重用性比较高。数据库选用的是SQL Server2000,而应用程序通过ADO.NET与SQL Server2000数据库建立链接,并且运用SQL 语言实现对其数据库进行操作。在此系统中,大量采用了存储过程来对数据库进行操作。 关键词:互联网;城市公交查询;.NET;存储过程 TheDesign and Realization of City Bus Inquiry System Based on .NET Abstract With the rapid development of Internet, the Internethas become an important channel of people acquiring, publishing andtransmitting information and obviously become one part of social life. But China's technologyof urban public transport information inquiry is still in a relatively backwardlevel. The numerous citizens have a little access to acquire the informationabout bus lines. The most common ways are confined to traffic maps or thereference to stranger. And the urban public transport system is designed forpeople to inquire of all lines in the Internet conveniently and simply and getto 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. Itsfunctions include line inquiry, site inquiry, station-to-station inquiry andstation inquiry. The system management module mainly realizes the functionaloperation on adding, editing, deleting of all data tables and responses to themessage correspondingly. The development technology of the city bus inquiry system adopt B/S framework based on .NET. Its front-endpart uses ASP.NET as the major framework. The .ASPX file contains HTML text andcontrols which make up of user interface. The back-end chooses C# as its programminglanguage. The greatest benefit of choosing .NET to programming is the easy managementsand reusability. Database usesthe SQL Server 2000, and the application accesses the database by ADO.NET anduses SQL language to operate the database. The stored procedure is used a lotto operate the database in the system. Key words: Internet; City Bus inquiries; .NET; Stored Procedure.
|