基于.NET的城市公交查询系统的设计与实现

包括论文,设计,论文字数:11947,页数:31

摘 要
随着Internet的快速发展，互联网已成为人们快速获取、发布和传递信息的重要渠道，显然它已成为社会生活的一部分。但我国的城市公交信息查询却还处于比较落后的水平上，广大的市民获取路线信息方式也比较少，最常用的方式只局限在询问和交通地图上。而城市公交查询系统就是使人们能够在因特网上方便、简单的查询出各条路线，了解自己所经过的每个站点等信息，以便能更好的制定自己的行动计划而设计的。它主要实现的模块是公交信息的查询模块，其中包括的功能有：线路查询、站点查询、站站查询、车站查询；而系统管理模块主要实现的是对各个数据表进行添加、编辑、删除等功能操作以及对留言版进行一些相应的回复。
城市公交查询系统开发技术采用的是基于.NET的B/S架构，它的前端选用ASPNET/ style=text-decoration:underline;font-size:14px;color:#2B4DD5; target=_blank>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 ASPNET/ style=text-decoration:underline;font-size:14px;color:#2B4DD5; target=_blank>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 ASPNET/ style=text-decoration:underline;font-size:14px;color:#2B4DD5; target=_blank>ASP.NET 2
2.1.1 什么是ASPNET/ style=text-decoration:underline;font-size:14px;color:#2B4DD5; target=_blank>ASP.NET 2
2.1.2 .NET Framework概述 2
2.1.3 ASPNET/ style=text-decoration:underline;font-size:14px;color:#2B4DD5; target=_blank>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