piao.sql

来自「是以JAVA所编程的简单的火车订票系统.」· SQL 代码 · 共 151 行

create database hcdp
go
--********查票代码********
--***********************
--drop table chapiao

create table chapiao(票号 int primary key,
                     车次 varchar (20) null,
                     车类型 varchar (20) null,
                     起点站  varchar(20) null,
                     终点站 varchar(20) null,
                     日期 varchar(20) null,
                     时间 varchar(20) null,
                     车厢号 int null,
                     票价  int null, 
                     票位置 varchar(20) null,
                     座位号 varchar(20) null,
                     座类型 varchar(20) null,)
 
insert into chapiao values(01,'P001','普客','北京','南京','2.24','18:00',1,248,'1排','左','硬座')
insert into chapiao values(02,'P001','普客','北京','南京','2.24','18:00',1,248,'1排','中','硬座')
insert into chapiao values(03,'P001','普客','北京','南京','2.24','18:00',1,248,'1排','右','硬座')
insert into chapiao values(04,'P001','普客','北京','南京','2.24','18:00',2,350,'2排','左','软座')
insert into chapiao values(05,'P001','普客','北京','南京','2.24','18:00',2,350,'2排','中','软座')
insert into chapiao values(06,'P001','普客','北京','南京','2.24','18:00',2,350,'2排','右','软座')
insert into chapiao values(07,'P001','普客','北京','南京','2.24','18:00',3,450,'3排','上','软卧')
insert into chapiao values(08,'P001','普客','北京','南京','2.24','18:00',3,450,'3排','中','软卧')
insert into chapiao values(09,'P001','普客','北京','南京','2.24','18:00',3,450,'3排','下','软卧')

insert into chapiao values(10,'Z001','直达','北京','南京','2.25','19:00',1,111,'1排','左','硬座')
insert into chapiao values(11,'Z001','直达','北京','南京','2.25','19:00',1,111,'1排','中','硬座')
insert into chapiao values(12,'Z001','直达','北京','南京','2.25','19:00',1,111,'1排','右','硬座')
insert into chapiao values(13,'Z001','直达','北京','南京','2.25','19:00',2,222,'1排','左','软座')
insert into chapiao values(14,'Z001','直达','北京','南京','2.25','19:00',2,222,'1排','中','软座')
insert into chapiao values(15,'Z001','直达','北京','南京','2.25','19:00',2,222,'1排','右','软座')
insert into chapiao values(16,'Z001','直达','北京','南京','2.25','19:00',3,300,'1排','上','软卧')
insert into chapiao values(17,'Z001','直达','北京','南京','2.25','19:00',3,300,'1排','中','软卧')
insert into chapiao values(18,'Z001','直达','北京','南京','2.25','19:00',3,300,'1排','下','软卧')
--insert into chapiao values(20,'Z010','直达','北京','淮阴','2.25','19:00',3,300,'1排','中','硬座')


insert into chapiao values(19,'T001','特快','北京','上海','2.25','19:00',1,248,'1排','左','硬座')
insert into chapiao values(20,'T001','特快','北京','上海','2.25','19:00',1,248,'1排','中','硬座')
insert into chapiao values(21,'T001','特快','北京','上海','2.25','19:00',1,248,'1排','右','硬座')
insert into chapiao values(22,'T001','特快','北京','上海','2.25','19:00',2,400,'1排','左','软座')
insert into chapiao values(23,'T001','特快','北京','上海','2.25','19:00',2,400,'1排','中','软座')
insert into chapiao values(24,'T001','特快','北京','上海','2.25','19:00',2,400,'1排','右','软座')
insert into chapiao values(25,'T001','特快','北京','上海','2.25','19:00',3,558,'1排','上','软卧')
insert into chapiao values(26,'T001','特快','北京','上海','2.25','19:00',3,558,'1排','中','软卧')
insert into chapiao values(27,'T001','特快','北京','上海','2.25','19:00',3,558,'1排','下','软卧')
--insert into chapiao values(28,'T010','特快','北京','上海','2.25','19:00',1,248,'1排','中','软卧')

insert into chapiao values(31,'P011','普客','南京','上海','2.24','20:00',1,248,'1排','左','硬座')
insert into chapiao values(32,'P012','普客','南京','上海','2.24','20:00',1,248,'1排','中','硬座')
insert into chapiao values(33,'P013','普客','南京','上海','2.24','20:00',1,248,'1排','右','硬座')
insert into chapiao values(34,'P014','普客','南京','上海','2.24','20:00',2,350,'2排','左','软座')
insert into chapiao values(35,'P015','普客','南京','上海','2.24','20:00',2,350,'2排','中','软座')
insert into chapiao values(36,'P016','普客','南京','上海','2.24','20:00',2,350,'2排','右','软座')
insert into chapiao values(38,'P018','普客','南京','上海','2.24','20:00',3,450,'3排','上','软卧')
insert into chapiao values(39,'P019','普客','南京','上海','2.24','20:00',3,450,'3排','中','软卧')
insert into chapiao values(40,'P020','普客','南京','上海','2.24','20:00',3,450,'3排','下','软卧')

insert into chapiao values(51,'Z011','直达','北京','拉萨','2.25','18:00',1,111,'1排','左','硬座')
insert into chapiao values(52,'Z012','直达','北京','拉萨','2.25','18:00',1,111,'1排','中','硬座')
insert into chapiao values(53,'Z013','直达','北京','拉萨','2.25','18:00',1,111,'1排','右','硬座')
insert into chapiao values(54,'Z014','直达','北京','拉萨','2.25','18:00',2,222,'1排','左','软座')
insert into chapiao values(55,'Z015','直达','北京','拉萨','2.25','18:00',2,222,'1排','中','软座')
insert into chapiao values(56,'Z016','直达','北京','拉萨','2.25','18:00',2,222,'1排','右','软座')
insert into chapiao values(57,'Z017','直达','北京','拉萨','2.25','18:00',3,300,'1排','上','软卧')
insert into chapiao values(58,'Z018','直达','北京','拉萨','2.25','18:00',3,300,'1排','中','软卧')
insert into chapiao values(59,'Z019','直达','北京','拉萨','2.25','18:00',3,300,'1排','下','软卧')
insert into chapiao values(60,'Z020','直达','北京','拉萨','2.25','18:00',3,300,'1排','中','硬座')


insert into chapiao values(61,'T011','特快','北京','上海','6.29',1,248,'1排','左','硬座')
insert into chapiao values(62,'T012','特快','北京','上海','6.29',1,248,'1排','中','硬座')
insert into chapiao values(63,'T013','特快','北京','上海','6.29',1,248,'1排','右','硬座')
insert into chapiao values(64,'T014','特快','北京','上海','6.29',1,248,'1排','左','软座')
insert into chapiao values(65,'T015','特快','北京','上海','6.29',1,248,'1排','中','软座')
insert into chapiao values(66,'T016','特快','北京','上海','6.29',1,248,'1排','右','软座')
insert into chapiao values(67,'T017','特快','北京','上海','6.29',1,248,'1排','上','软卧')
insert into chapiao values(68,'T018','特快','北京','上海','6.29',1,248,'1排','中','软卧')
insert into chapiao values(69,'T019','特快','北京','上海','6.29',1,248,'1排','下','软卧')
insert into chapiao values(70,'T020','特快','北京','上海','6.29',1,248,'1排','中','软卧')
select * from chapiao
go

--********退票代码********
--***********************
--drop table tuipiao
create table tuipiao ( 票号 int null,
                     时间 varchar(20) null,
                    手续费 int null)
go

select * from tuipiao
go




--********已售票代码********
--***********************
drop table yishoupiao
create table yishoupiao(票号 int null,
                     车次 varchar (20) null,
                     车类型 varchar (20) null,
                     起点站  varchar(20) null,
                     终点站 varchar(20) null,
                     日期 varchar(20) null,
                     时间 varchar(20) null,
                     车厢号 int null,
                     票价  int null, 
                     票位置 varchar(20) null,
                     座位号 varchar(20) null,
                     座类型 varchar(20) null,)
go 


select * from dingpiao 



--********检卡代码********
--***********************
--drop table jianka

create table jianka( 卡号 int null,
                    姓名  varchar(30) null,)
go

insert into jianka values(01, 'admin')
insert into jianka values(02, 'aaa')
insert into jianka values(03, 'bbb')
insert into jianka values(04, 'ccc')
insert into jianka values(05, 'ddd')
insert into jianka values(06, 'eee')
insert into jianka values(07, 'fff')
insert into jianka values(08, 'hhh')


select * from jianka
delete from jianka where 姓名='ak'

go

update chapiao set 日期='2月25日' where 日期='2.25'
select * from chapiao

select * from yishoupiao
go