[Student design] Design and Implementation of Urban Public Transit Query System

With the rapid development of the Internet, the Internet has become an important channel for people to quickly obtain, publish, and transmit information. Obviously, it has become part of social life. However, the urban public transit information query in China is still relatively lagging behind, and the majority of citizens have less ways to obtain route information. The most common method is limited to inquiry and traffic map. The urban public transit query system enables people to conveniently and easily query each route on the Internet and learn information about each site they have traveled, so that they can better develop their own action plans. It mainly implements the bus information query module, which includes the following functions: line query, Site query, station query, station query; the system management module adds, edits, and deletes data tables and replies to message boards.
The city bus query system development technology is based on. net B/S architecture, and its front-end adopts ASP. net is the main programming framework, its. the aspx file contains HTML text and controls that make up the user interface, while the C # programming language is used in the background. The biggest advantage of using. NET programming is the ease of management and high reusability. The database selects SQL Server 2000, and the application uses ADO. Net to establish a connection with the SQL Server 2000 database, and uses the SQL language to operate its database. In this system, a large number of stored procedures are used to operate databases.

Keywords: Internet; Urban Public Transit Query;. Net; Stored Procedure

3 Analysis and Design of Urban Bus Query System
3.1 Requirement Analysis
In this system, you can query all routes or sites in the city to learn the details of each route or site. If you want to query a line or site, you can directly use the functions of the system. The system meets the following requirements:
Ease of operation: the city bus query system is easy to use, convenient, and user friendly.
System functions: This system provides the following functions: Query station information, train information, site information and station information functions, information messages and system management functions. For example, in the query function, the user enters the information such as the number of trains to be queried to obtain the results related to it. In the system management function, administrators can add, edit, and delete information.
3.2 Outline Design
3.2.1 System Function Description
After the user enters the main interface, the user can quickly query the line information that meets the user's conditions through the vehicle query, Site query, station query, and station query. You can also leave a message directly in the message book. The message content can be a query of the line, or provide your own opinions on the deficiencies of the system. After the Administrator enters the system, the administrator can add, delete, and edit information in the database. He is also responsible for managing users' message information. By reviewing the message information, he can determine whether to reply to or delete the message.
3.2.2 system function modules
After understanding the functional requirements of the system, you can divide the system into the following three modules: user query module, message book module, and system management module 3-1.
 
Figure 3-1 Urban Public Transit Query System Function Module

The following describes each module:

1. user query module
In the user query module, the main function module is to query the line information required by the user. It mainly includes:
(1) query the vehicle count information: Enter the number of vehicles to be queried for search. You can query the corresponding site name and site description information.
(2) query site information: enter the site to be queried for search. You can query the location information based on the corresponding vehicle Name, departure time, vehicle receiving time, and vehicle receiving description. If you do not know the full name of the site, you can fuzzy query all site information containing keywords in advanced queries.
(3) query the station information: select the station to be queried and search for the corresponding vehicle Name, departure time, vehicle receiving time, and vehicle receiving description information.
(4) query station information: Enter the start station and end station to be queried for the search. You can query the route for the query.
2. System Management Module
In the system management module, you can manage tables in the database. It mainly includes:
(1) log on as an administrator.
(2) Message book management: you can reply to and Delete content in the message book. In the message book management, it also contains a search engine, which allows administrators to search for the message topic to be queried, in this way, you can quickly find a topic and reply to or delete it.
(3) site and vehicle count management: You can add, delete, and edit the basic information of the site, vehicle count, and vehicle order information. They all contain a search engine, which can quickly query information such as the site or vehicle count you want to modify. This search engine uses fuzzy search.
3. Message book Module
In the message book module, you can leave a message online without having to register or reply to the goods for discussion on a specific message title, you can also view the information you have posted in the message book.

More information: http://home.51cto.com/apps/photo/index.php? S =/index/albums/UID/2499182

This article is from the technology sharing Database Blog, please be sure to keep this source http://foreverzyy.blog.51cto.com/2499182/1546520

[Student design] Design and Implementation of Urban Public Transit Query System