下载 >  课程资源 >  专业指导 > 软件工程系统开发铁路售票管理系统

软件工程系统开发铁路售票管理系统

2009-06-11 上传大小:2.81MB
软件工程铁路售票系统:
铁路售票管理系统软件使用说明书
铁路售票管理系统软件系统测试报告
铁路售票系统软件设计说明书
铁路售票系统需求说明书
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)                        
...展开收缩
综合评分:4
开通VIP 立即下载

评论共有10条

yutiantian111 2018-03-10 11:56:42
值得参考,很有帮助
浮生几度 2014-06-17 20:49:24
没有源代码
kirkdive 2014-04-14 15:43:34
没有代码,但是很有参考价值,谢谢
 
铁路窗口售票系统源代码JAVA版 立即下载
积分/C币:3
铁路售票管理系统+数据库 立即下载
积分/C币:3
c++课程设计——铁路售票系统 立即下载
积分/C币:3
java 火车售票系统 程序源码 立即下载
积分/C币:3
UML 火车票售票系统的分析与设计 立即下载
积分/C币:3
影城票务管理系统(java) 立即下载
积分/C币:8
火车票模拟订票系统 立即下载
积分/C币:5
java模拟火车站售票系统源代码 立即下载
积分/C币:3
铁路订票系统毕业设计文献综述 立即下载
积分/C币:3
铁路网上订票系统c# 立即下载
积分/C币:3

VIP会员动态

0 1 2
关闭
img

spring mvc+mybatis+mysql+maven+bootstrap 整合实现增删查改简单实例.zip

资源所需积分/C币 当前拥有积分 当前拥有C币
5 0 0
点击完成任务获取下载码
输入下载码
为了良好体验,不建议使用迅雷下载
img

软件工程系统开发铁路售票管理系统

会员到期时间: 剩余下载个数: 剩余C币: 剩余积分:0
为了良好体验,不建议使用迅雷下载
VIP下载
您今日下载次数已达上限(为了良好下载体验及使用,每位用户24小时之内最多可下载20个资源)

积分不足!

资源所需积分/C币 当前拥有积分
您可以选择
开通VIP
4000万
程序员的必选
600万
绿色安全资源
现在开通
立省522元
或者
购买C币兑换积分 C币抽奖
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 4 45
为了良好体验,不建议使用迅雷下载
确认下载
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 0 0
为了良好体验,不建议使用迅雷下载
开通VIP
img

资源所需积分/C币 当前拥有积分 当前拥有C币
5 4 45
您的积分不足,将扣除 10 C币
为了良好体验,不建议使用迅雷下载
确认下载
下载
无法举报自己的资源

兑换成功

你当前的下载分为234开始下载资源
你还不是VIP会员
开通VIP会员权限,免积分下载
立即开通

你下载资源过于频繁,请输入验证码

您因违反CSDN下载频道规则而被锁定帐户,如有疑问,请联络:webmaster@csdn.net!

举报

若举报审核通过,可返还被扣除的积分

  • 举报人:
  • 被举报人:
  • 举报的资源分:
  • *类型:
  • *详细原因: