城市公交线路查询系统mysql_基于Java环境下的城市公交查询系统设计与实现毕业论文+开题报告+答辩PPT+演示视频+设计源码+Mysql文件...

摘  要

随着城市现代化和智能化程度的不断提高，城市交通的通畅受到了极大的挑战，便利的出行成为越来越多人的追求，但目前的公交查询系统平台质量普遍不高，路线选择单一，信息更新不及时，查询效率不高等问题存在于多个影响力较高的应用中，对市民出行造成了较大困扰。该系统通过Java技术来建立能够解决以上问题的公交查询平台。建立一个功能完善的公交查询系统，突出公交信息的智能化呈现。本平台在用户端实现用户注册、登录，起点终点的输入，可行路线的展示，路线选择后的提示等功能，后台实现公交信息的实时更新，用户特定时段所选路线的记录，统计所有用户的选择并向用户端反馈，其宗旨是及时、准确地更新公交信息，给用户提供智能化的选择，人性化的反馈。后台管理功能：主要是存储完整的公交信息和记录用户信息。前台的信息呈现：根据起点终点提供所有可行路线及沿途站点等具体信息，为用户提供所有出行选择。信息反馈功能：通过记录用户选择向前台发出路况反馈，缓解路线高频率选择导致的拥堵状况。

通过数据库系统与软件系统的连接来实现软件界面观察和处理操作数据；系统内部的业务逻辑通过JavaBean组件实现，JavaBean组件在WWW服务器运行，通过JSP返回用户浏览器；系统使用JDBC中间件访问数据库，数据库服务器定义了本平台所需的事物逻辑和数据逻辑；因为MySql可编程，可使用视图修改数据，功能完善，而且教程多，易于学习，所以使用MySql，实现数据库的建立、连接和维护工作。MySql也给编程人员提供了得心应手的集成开发环境。

[关键词] 城市公交查询系统；数据库；JSP；Mysql

Abstract

With the continuous improvement of urban modernization and intelligence, the smooth flow of urban traffic has been greatly challenged, convenient travel has become the pursuit of more and more people, but the current public transportation query system platform quality is generally not high, the route choice is single. The problems of information updating and low query efficiency exist in many influential applications, which cause great troubles to citizens' travel. The system uses Java technology to establish a public transportation query platform which can solve the above problems. Set up a perfect public transportation inquiry system, highlight the intelligent presentation of public transport information. The platform implements user registration, login, and registration at the user side. The input of the terminal point, the display of the feasible route, the prompt after the route selection, etc. The background realizes the real-time update of the bus information, the record of the route selected by the user in a specific time period, the statistics of all the users' choice and feedback to the user. Its aim is to update public transportation information timely and accurately, to provide users with intelligent choice and humanized feedback. Background management function: mainly store complete bus information and record user information. Front desk information presentation: according to the starting point and the end point to provide all feasible routes and sites along the specific information to provide users with all travel options. Information feedback function: sent to the foreground by recording the user's choice Feedback on road conditions to alleviate congestion caused by high frequency selection of routes.

Through the connection between the database system and the software system, the software interface can observe and process the operation data, the internal business logic of the system is realized by the JavaBean component, the JavaBean component runs in the WWW server, and the user browser is returned through JSP. The system uses JDBC middleware to access the database, and the database server defines the transaction logic and data logic required by the platform. Because MySql is programmable, can use views to modify data, function is perfect, and many tutorials, easy to learn, so use MySql, to achieve database establishment, connection and maintenance work. MySq L also provides programmers with a handy integrated development environment.

00001Key words: City Buses inquiry system；Databases；JSP；Mysql

目  录