铁路售票系统应用软件需求分析报告

该报告详述了铁路售票系统的需求分析,旨在提升软件开发的透明度和管理效率。系统目标是改进现有售票系统,实现数据同步,支持实名制购票。系统由五个模块组成,包括查询、存储等功能,采用Delphi开发,硬件要求为奔腾133以上PC,内存16MB。报告还涵盖了数据结构、软件功能、操作人员要求、网络接口及数据库同步需求。
摘要由CSDN通过智能技术生成

铁路售票系统应用软件需求分析报告

前言:

(1)需求分析报告的编写目的

本需求分析报告的目的是规范化本软件的编写,旨在于提高软件开发过程中的能见度,便于对软件开发过程中的控制与管理,同时提出了本铁路售票系统的软件开发过程,便于程序员与客户之间的交流、协作,并作为工作成果的原始依据,同时也表明了本软件的共性,以期能够获得更大范围的应用。

(2)产品背景明细

软件名称:铁路售票系统

软件开发者:

(3)缩写及缩略语

铁路售票应用系统软件:基本元素为构成铁路售票及相关行为所必须的各种部分。
  需求:用户解决问题或达到目标所需的条件或功能;系统或系统部件要满足合同、标准,规范或其它正式规定文档所需具有的条件或权能。
  需求分析:包括提炼,分析和仔细审查已收集到的需求,以确保所有的风险承担者都明其含义并找出其中的错误,遗憾或其它不足的地方。
  模块的独立性:是指软件系统中每个模块只涉及软件要求的具体的子功能,而和软件系统中其他的模块的接口是简单的。

本工程描述:

(1)软件开发的目标:

完善目前铁路售票系统,使之能跟上时代的发展。同时通过实践来提高自己的动手能力。(2)应用范围:

理论上能够实现于铁路部门的售票系统,其目的在于在原有的系统基础使得铁路售票实名化,以期实现完善日常生活中铁路售票的各种缺陷。

(3)硬件配置要求:

  硬件外部设备需奔腾133以上的pc机,

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
软件工程铁路售票系统铁路售票管理系统软件使用说明书 铁路售票管理系统软件系统测试报告 铁路售票系统软件设计说明书 铁路售票系统需求说明书 create database railwaymanagementdb go use railwaymanagementdb go create table commontrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) create table dtrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) create table ktrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) create table ttrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) create table ztrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) CREATE TABLE adultticket ( ticketnum varchar(10), origin varchar(30) , destination varchar(30) , length int , starttime varchar(20) , arrivetime varchar(20), timeused varchar(20) , tickettype varchar(10), price int, leftnum int ) CREATE TABLE childticket ( ticketnum varchar(10) , origin varchar(30) , destination varchar(30) , length int , starttime varchar(20) , arrivetime varchar(20) , timeused varchar(20) , tickettype varchar(10) , price int, leftnum int ) CREATE TABLE stuticket ( ticketnum varchar(10) , origin varchar(30) , destination varchar(30) , length int , starttime varchar(20) , arrivetime varchar(20) , timeused varchar(20) , tickettype varchar(10) , price int, leftnum int ) CREATE TABLE admin ( adminID varchar(30) , adminpwd varchar(30) , adminusername varchar(30) , adminsalary int ) CREATE TABLE seller ( sellerID varchar(30) , sellerpwd varchar(30) , sellerusername varchar(30) , sellernum int, sellersalary int ) CREATE TABLE ticketstatistics ( ticketnum varchar(10) , sellnum int, totalmoney int ) insert into commontrain values ('2509' ,'普通火车', 1 ,'哈尔滨', '14:32', 0 ,'始发站' ,'0' ,0 ,0, 0, 0) insert into commontrain values('2509' ,'普通火车', 2 ,'肇东', '15:16' ,2, '15:14', '42分钟' ,80, 8, 16, 30) insert into commontrain values('2509', '普通火车' ,3 ,'大庆' ,'16:29', 4 ,'16:25' ,'1小时53分钟', 260 ,19, 40 ,75) insert into commontrain values('2509', '普通火车', 4, '齐齐哈尔', '---', -1, '18:16', '3小时44分钟', 500 ,25 ,50 ,95) insert into commontrain values('2124' ,'普通火车', 1, '哈尔滨' ,'04:03', 0, '0', '0', 0, 0, 0 ,0) insert into commontrain values('2124' ,'普通火车', 2, '呼兰', '04:39', 3 ,'04:36' ,'33分钟' ,32, 5 ,10, 22) insert into commontrain values('2124', '普通火车' ,3, '康金井', '05:00', 2, '04:58', '55分钟', 60 ,8, 15 ,30) insert into commontrain values('2124', '普通火车' ,4 ,'绥化' ,'06:01' ,4, '05:57', '1小时54分钟' ,125, 14 ,30, 56) insert into commontrain values('1394', '普通火车', 1 ,'哈尔滨', '18:11' ,0 ,'始发站', '0' ,0, 0 ,0, 0) insert into commontrain values('1394' ,'普通火车', 2 ,'沈阳北', '00:53', 0 ,'00:42', '11分钟', 520, 60 ,115, 220) insert into commontrain values('1394', '普通火车', 3 ,'天津西', '08:54', 0 ,'08:46', '8分钟', 1203 ,105, 210 ,400) insert into commontrain values('1394' ,'普通火车', 4, '济南' ,'13:36', 0 ,'13:20', '16分钟', 1520 ,140 ,278 ,550) insert into dtrain values('D12', 'D12', 12, '12', '12', 12, '12', '12', 12, 12, 12, 12) insert into dtrain values('D28', '动车组', 1, '哈尔滨', '09:02', 0, '始发站', '0', 0, 0, 0, 0) insert into dtrain values('D28', '动车组', 2, '长春', '10:50', 2, '10:48', '1小时46分钟', 246, 91, 180, 270) insert into dtrain values('D28', '动车组', 3, '秦皇岛', '15:10', 1, '15:09', '6时7分钟', 950, 270, 430, 600) insert into dtrain values('D28', '动车组', 4, '北京', '15:10', 0, '17:10', '8小时8分钟 ', 1249, 360, 500, 700) insert into dtrain values('D18', '动车组', 1, '哈尔滨', '08:50', 0, '始发站', '0', 0, 0, 0, 0) insert into dtrain values('D18', '动车组', 2, '齐齐哈尔', '---', -1, '10:30', '1小时40分钟', 300, 42, 84, 150) insert into dtrain values('D417', '动车组', 1, '哈尔滨', '7:00', 0, '始发站', '0', 0, 0, 0, 0) insert into dtrain values('D417', '动车组', 2, '天津', '---', -1, '19:32', '12小时32分钟', 1200, 152, 300, 512) insert into ktrain values('K12', 'K12', 12, '12', '12', 12, '12', '12', 12, 12, 12, 12) insert into ktrain values('K265', '快车', 1, '哈尔滨', '03:40 ', 0, '始发站', '0', 0, 0, 0, 0) insert into ktrain values('K265', '快车', 2, '一面坡', '06:03', 2, '06:01', '2小时21分钟', 160, 20, 40, 80) insert into ktrain values('K265', '快车', 3, '牡丹江', '---', 0, '09:09', '5小时29分钟', 420, 42, 85, 180) insert into ktrain values('K339', '快车', 1, '哈尔滨', '04:37', 0, '始发站', '0', 0, 0, 0, 0) insert into ktrain values('K339', '快车', 2, '绥化', '06:26 ', 5, '06:21', '2小时44分钟', 140, 16, 35, 77) insert into ktrain values('K339', 'K339', 3, '铁力', '07:55', 6, '07:49', '3小时12分钟', 233, 25, 52, 110) insert into ktrain values('K339', '快车', 4, '佳木斯', '---', 0, '12:06', '7小时29分钟', 550, 52, 110, 230) insert into ktrain values('K546', '快车', 1, '哈尔滨', '05:46', 0, '始发站', '0', 0, 0, 0, 0) insert into ktrain values('K546', '快车', 2, '肇东', '06:31', 3, '06:28', '42分钟', 70, 10, 20, 40) insert into ktrain values('K546', '快车', 3, '大庆', '07:38', 3, '07:35', '1小时49分钟', 163, 21, 45, 90) insert into ktrain values('K546', '快车', 4, '让胡路', '07:50', 2, '07:48', '2小时2分钟', 180, 26, 52, 100) insert into ttrain values('T184', '特快', 1, '哈尔滨', '08:40', 0, '始发站', '0', 0, 0, 0, 0) insert into ttrain values('T184', '特快', 2, '扶余 ', '09:51', 11, '09:40', '1小时', 102, 17, 109, 162) insert into ttrain values('T184', '特快', 3, '长春', '11:14', 6, '11:08', '2小时28分钟', 246, 41, 109, 162) insert into ttrain values('T184', '特快', 4, '四平', '12:20', 2, '12:18', ' 3小时38分钟', 361, 54, 109, 162) insert into ttrain values('T47', '特快', 1, '哈尔滨', '05:09', 15, '始发站', '0', 0, 0, 0, 0) insert into ttrain values('T47', '特快', 2, '大庆', '06:45', 9, '06:36', '1小时48分钟', 150, 30, 70, 100) insert into ttrain values('T47', '特快', 3, '齐齐哈尔', '---', 0, '07:57', '3小时', 220, 42, 90, 150) insert into ttrain values('T238', '特快', 1, '哈尔滨', '19:09', 0, '始发站', '0', 0, 0, 0, 0) insert into ttrain values('T238', '特快', 2, '长春', '21:28', 6, '21:22', '2小时13分钟', 246, 42, 109, 162) insert into ttrain values('T238', '特快', 3, '沈阳北', '00:15', 8, '00:07', '4小时58分钟', 546, 76, 143, 215) insert into ttrain values('T238', '特快', 4, '山海关', '03:59', 10, '03:49', '8小时40分钟', 934, 120, 222, 338) insert into ttrain values('T262', '特快', 1, '哈尔滨', '21:18', 0, '始发站', '0', 0, 0, 0, 0) insert into ttrain values('T262', '特快', 2, '沈阳北', '02:31', 10, '02:21', '5小时3分钟', 546, 76, 143, 215) insert into ttrain values('T262', '特快', 3, '大连', '---', 0, '06:33', '9小时15分钟 ', 946, 125, 231, 352) insert into ztrain values('Z16', '直达车', 1, '哈尔滨', '21:36 ', 0, '始发站', '0', 0, 0, 0, 0) insert into ztrain values('Z16', '直达车', 2, '唐山', '---', -1, '07:20', '9小时44分钟', 1249, 125, 250, 429) insert into ztrain values('Z18', '直达车', 1, '哈尔滨', '20:36', 0, '始发站', '0', 0, 0, 0, 0) insert into ztrain values('Z18', '直达车', 2, '天津', ' ---', -1, '07:20', '10小时44分钟', 1400, 150, 284, 450) insert into ztrain values('Z22', '直达车', 1, '哈尔滨', '21:36', 0, '始发站', '0', 0, 0, 0, 0) insert into ztrain values('Z22', '直达车', 2, '大连', '---', -1, '05:20', '7小时44分钟', 1049, 88, 180, 361) insert into ztrain values('Z25', '直达车', 1, '哈尔滨', '19:36', 0, '始发站', '0', 0, 0, 0, 0) insert into ztrain values('Z25', '直达车', 2, '石家庄', '---', -1, '07:20', '11小时44分钟', 1621, 188, 324, 562) insert into adultticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬座', 8, 400) insert into adultticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬卧下', 16, 100) insert into adultticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','软卧下', 30, 40) insert into adultticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬座', 19, 400) insert into adultticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬卧下', 40, 100) insert into adultticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','软卧下', 75, 40) insert into adultticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬座', 25, 400) insert into adultticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬卧下', 50, 100) insert into adultticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','软卧下', 95, 40) insert into adultticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬座', 91, 400) insert into adultticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬卧下', 180, 100) insert into adultticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','软卧下', 270, 40) insert into adultticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬座', 270, 400) insert into adultticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬卧下', 430, 100) insert into adultticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','软卧下', 600, 40) insert into adultticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬座', 360, 400) insert into adultticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬卧下', 500, 100) insert into adultticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','软卧下', 700, 40) insert into adultticket values('K339','哈尔滨','绥化',140,'04:37','06:21','2小时44分钟','硬座', 16, 400) insert into adultticket values('K339','哈尔滨','绥化',140,'04:37','06:21','2小时44分钟','硬卧下', 35, 100) insert into adultticket values('K339','哈尔滨','绥化',140,'04:37','06:21','2小时44分钟','软卧下', 77, 40) insert into adultticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬座', 25, 400) insert into adultticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬卧下', 52, 100) insert into adultticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','软卧下', 110, 40) insert into adultticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬座', 52, 400) insert into adultticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬卧下', 110, 100) insert into adultticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','软卧下', 230, 40) insert into adultticket values('T184','哈尔滨','扶余',102,'08:40','09:40','1小时','硬座', 17, 400) insert into adultticket values('T184','哈尔滨','扶余',102,'08:40','09:40','1小时','硬卧下', 109, 100) insert into adultticket values('T184','哈尔滨','扶余',102,'08:40','09:40','1小时','软卧下', 162, 50) insert into adultticket values('T184','哈尔滨','长春',246,'08:40','11:08','2小时28分钟','硬座', 41, 400) insert into adultticket values('T184','哈尔滨','长春',246,'08:40','11:08','2小时28分钟','硬卧下', 109, 100) insert into adultticket values('T184','哈尔滨','长春',246,'08:40','11:08','2小时28分钟','软卧下', 162, 40) insert into adultticket values('T184','哈尔滨','四平',361,'08:40','12:18','3小时38分钟','硬座', 54, 400) insert into adultticket values('T184','哈尔滨','四平',361,'08:40','12:18','3小时38分钟','硬卧下', 109, 1000) insert into adultticket values('T184','哈尔滨','四平',361,'08:40','12:18','3小时38分钟','软卧下', 163, 40) insert into adultticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬座', 125, 400) insert into adultticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬卧下', 250, 100) insert into adultticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','软卧下', 429, 50) insert into adultticket values('Z18','哈尔滨','天津',1400,'20:36','07:20','10小时44分钟','硬座', 150, 400) insert into adultticket values('Z18','哈尔滨','天津',1400,'20:36','07:20','10小时44分钟','硬卧下', 284, 100) insert into adultticket values('Z18','哈尔滨','天津',1400,'20:36','07:20','10小时44分钟','软卧下', 450, 50) insert into adultticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬座', 88, 400) insert into adultticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬卧下', 180, 100) insert into adultticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','软卧下', 361, 50) insert into adultticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬座', 188, 400) insert into adultticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬卧下', 324, 100) insert into adultticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','软卧下', 562, 50) insert into childticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬座', 4, 80) insert into childticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬卧下', 8, 20) insert into childticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','软卧下', 15, 20) insert into childticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬座', 10, 80) insert into childticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬卧下', 20, 20) insert into childticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','软卧下', 36, 20) insert into childticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬座', 13, 80) insert into childticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬卧下', 25, 20) insert into childticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','软卧下', 50, 20) insert into childticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬座', 45, 80) insert into childticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬卧下', 90, 20) insert into childticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','软卧下', 135, 20) insert into childticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬座', 135, 80) insert into childticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬卧下', 210, 20) insert into childticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','软卧下', 300, 20) insert into childticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬座', 180, 80) insert into childticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬卧下', 250, 20) insert into childticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','软卧下', 350, 20) insert into childticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','硬座', 8, 80) insert into childticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','硬卧下', 18, 20) insert into childticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','软卧下', 40, 20) insert into childticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬座', 13, 80) insert into childticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬卧下', 26, 20) insert into childticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','软卧下', 56, 20) insert into childticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬座', 26, 80) insert into childticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬卧下', 55, 20) insert into childticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','软卧下', 115, 20) insert into childticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','硬座', 22, 80) insert into childticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','硬卧下', 51, 20) insert into childticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','软卧下', 80, 50) insert into childticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','硬座', 20, 80) insert into childticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','硬卧下', 50, 20) insert into childticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','软卧下', 82, 20) insert into childticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','硬座', 28, 80) insert into childticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','硬卧下', 53, 200) insert into childticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','软卧下', 80, 20) insert into childticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬座', 63, 80) insert into childticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬卧下', 125, 20) insert into childticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','软卧下', 220, 20) insert into childticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','硬座', 80, 80) insert into childticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','硬卧下', 144, 20) insert into childticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','软卧下', 230, 20) insert into childticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬座', 45, 80) insert into childticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬卧下', 90, 20) insert into childticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','软卧下', 180, 20) insert into childticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬座', 92, 80) insert into childticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬卧下', 160, 20) insert into childticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','软卧下', 280, 20) insert into stuticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬座', 4, 80) insert into stuticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬卧下', 8, 20) insert into stuticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','软卧下', 15, 20) insert into stuticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬座', 10, 80) insert into stuticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬卧下', 20, 20) insert into stuticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','软卧下', 36, 20) insert into stuticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬座', 13, 80) insert into stuticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬卧下', 25, 20) insert into stuticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','软卧下', 50, 20) insert into stuticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬座', 45, 80) insert into stuticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬卧下', 90, 20) insert into stuticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','软卧下', 135, 20) insert into stuticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬座', 135, 80) insert into stuticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬卧下', 210, 20) insert into stuticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','软卧下', 300, 20) insert into stuticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬座', 180, 80) insert into stuticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬卧下', 250, 20) insert into stuticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','软卧下', 350, 20) insert into stuticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','硬座', 8, 80) insert into stuticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','硬卧下', 18, 20) insert into stuticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','软卧下', 40, 20) insert into stuticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬座', 13, 80) insert into stuticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬卧下', 26, 20) insert into stuticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','软卧下', 56, 20) insert into stuticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬座', 26, 80) insert into stuticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬卧下', 55, 20) insert into stuticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','软卧下', 115, 20) insert into stuticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','硬座', 22, 80) insert into stuticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','硬卧下', 51, 20) insert into stuticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','软卧下', 80, 50) insert into stuticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','硬座', 20, 80) insert into stuticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','硬卧下', 50, 20) insert into stuticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','软卧下', 82, 20) insert into stuticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','硬座', 28, 80) insert into stuticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','硬卧下', 53, 200) insert into stuticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','软卧下', 80, 20) insert into stuticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬座', 63, 80) insert into stuticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬卧下', 125, 20) insert into stuticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','软卧下', 220, 20) insert into stuticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','硬座', 80, 80) insert into stuticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','硬卧下', 144, 20) insert into stuticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','软卧下', 230, 20) insert into stuticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬座', 45, 80) insert into stuticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬卧下', 90, 20) insert into stuticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','软卧下', 180, 20) insert into stuticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬座', 92, 80) insert into stuticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬卧下', 160, 20) insert into stuticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','软卧下', 280, 20) insert into admin values ('admin','111111','张三',1000) insert into admin values ('lovett','123456','张银',1000) insert into admin values ('baliang','456789','八两',1000) insert into admin values ('yangchao','111111','杨超',1000) insert into admin values ('lushuai','456789','路帅',1000) insert into seller values ('keky','456789','大阪',1,1000) insert into seller values ('xiaoE','123456','小一',2,1000) insert into seller values ('smallwood','456789','刘林',3,1000) insert into seller values ('zhimin','456789','志民',4,1000) insert into seller values ('fenglv','456789','封侣',5,1000) insert into ticketstatistics values('T184', 0, 0) insert into ticketstatistics values('2509', 0, 0) insert into ticketstatistics values('D28', 0, 0) insert into ticketstatistics values('K339', 0, 0) insert into ticketstatistics values('Z16', 0, 0) insert into ticketstatistics values('Z18', 0, 0) insert into ticketstatistics values('Z22', 0, 0)
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值