论文总字数：27020字

摘 要

现代社会为了便于人们的出行，火车，高铁等在国内也是快速发展起来。但是在节假日以及其他各种人流量高峰期，我们可以发现在各个客运站，售票点都是人满为患。而且，这不是简单的增加人工服务人员，以及维持现场秩序就能快速解决的现状。所以我们需要将订票服务与网络相结合，在网络端推出售票系统，给能够网上操作的人群一个选择。

虽然网上订票的目的是能够减轻线下售票点的压力，给客户一个更加便捷快速的操作方式，但是这个订票网站任然需要提供给官方人员的管理机制。只有在秩序井然的网络社会服务下，才能够实现票务的正规销售，防止黄牛以及其他人利用网上系统非法售票。

本应用基于Java语言，主要实现了订票系统的用户的登录，注册，密码修改，订单查询，车票的查询，订票，改签，退单，管理员对车票的修改，管理员身份的认证，会员身份管理，火车信息管理，站点信息管理，线路信息管理，车票信息管理，订单管理。一般用户和管理的拥有相互独立的操作界面，防止普通用户误操作进入管理界面，造成不良影响。

开发本应用的操作平台为Windows10，用到了MySQL数据库，这是一款可以根据用户个性化操作的数据库。整个过程使用MyEclipse和sqlyog作为开发工具来完成，MyEclipse是一个非常适合网站开发的软件，sqlyog是一款非常高效便捷的MySQL数据库管理工具。

关键词：Java 订票系统 MySQL

Java-based train booking system development

Abstract

In order to facilitate people's travel in modern society, trains and high-speed rails have also developed rapidly in China. However, during the holidays and other peaks of various traffic, we can find that at each passenger station, the ticketing points are overcrowded. Moreover, this is not simply a matter of increasing the number of human service personnel and the ability to quickly resolve the order. Therefore,we need to combine the ticketing service with the network and launch a ticketing system on the network side to give people who can operate online a choice.

Although the purpose of online booking is to reduce the pressure on offline ticketing points and give customers a more convenient and quick way to operate, this booking website still needs to provide management mechanisms for official personnel. Only under the orderly network social service can the regular sales of ticketing be realized, preventing the scalpers and others from using the online system to illegally sell tickets.

This application is based on the Java language and mainly implements the login, registration, password modification, order inquiry, ticket inquiry, ticket booking, change of the ticket, return order, administrator's modification of the ticket, and authentication of the administrator's identity. , membership management, train information management, site information management, line information management, ticket information management, order management. The general user and the management have independent operation interfaces to prevent ordinary users from entering the management interface by mistake, which may cause adverse effects.

The operating platform for developing this application is Windows 10, which uses the MySQL database, which is a database that can be customized according to users. The whole process is completed with MyEclipse and sqlyog as a development tool. MyEclipse is a very suitable software for website development. sqlyog is a very efficient and convenient MySQL database management tool.

Keywords:Java; Booking system，MySQL

目录

第一章 引言 1

1.1 课题背景 1

1.2课题内容及意义 2

1.3论文的组织结构 2

第二章 相关技术介绍 4

2.1 Java介绍 4

2.2 MySQL数据库介绍 5

第三章 基于Java的火车订票系统的详细设计 6

3.1需求分析 6

3.1.1 使用特点分析 6

3.1.2 用户特点及功能需求描述 6

3.1.3 用例图 7

3.2功能结构设计 8

3.2.1整体结构图 8

3.2.2各模块介绍 8

3.3 实体类设计 10

3.4系统数据库设计 11

3.4.1实体的E-R图 11

3.4.2数据库表的详细介绍 11

第四章 基于Java的火车订票系统的实现与测试 15

4.1系统开发环境 15

4.2系统的实现 15

4.2.1数据库的连接 15

4.2.2用户登录注册 17

4.2.3车票查询，购买，修改和退单和订票查询 21

4.2.4管理员的登录 24

4.2.5管理员对订单，车票和用户的管理 25

4.3系统功能测试 27

4.3.1测试方案及目的 27

4.3.2测试用例及结果 28

第五章 总结与展望 29

5.1 总结 29

5.2 展望 29

参考文献 31

致谢 33

请支付后下载全文，论文总字数：27020字