求实现思路

JiaLingTianXia 2017-11-08 07:14:28
假设有一个车次1经过5个站,站点1,站点2,站点3,站点4,站点5(另外有一个车次2,经过站点3,站点4,站点6)
有3个座位,座位1,座位2,座位3
有乘客,买了站点1到站点3的座位1,站点4到站点5的座位1,
站点2到站点4的座位2,站点1到站点2的座位3,站点3到站点5的座位3,
自己确定数据库表的结构
问:怎么查到站点3到站点4的车次信息,它的余票,哪个座位有余票
需要实现思路
...全文
280 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
嘉凌天下 2017-11-10
  • 打赏
  • 举报
 回复
题目是 有乘客,买了站点1到站点3的座位1,站点4到站点5的座位1, 意思是 站点1上 站点3 下 站点4上 站点5 下 站点3上到站点4下的没有卖出 车次一的站点3到站点4的车票没有卖,为什么isOrder 为1
小刀雨斑 2017-11-09
  • 打赏
  • 举报
 回复
始终是两个相邻站点的票等于空位 跨站点 相当于求剩余票可组成改票的所有票数
自由自在_Yu 2017-11-09
  • 打赏
  • 举报
 回复 
--查询余票
select num,count(1) from train_order where isOrder = 0 and site = '站点3' or site = '站点4' group by num;
--查询空位
select num,site,seat_num from train_order where isOrder = 0 and site = '站点3' or site = '站点4';
好像我这样写的有问题，把站点当成数据统计了，其实应该统计站点到站点之间这一块，值提供一个参考哈
李德胜1995 2017-11-09
  • 打赏
  • 举报
 回复
引用 2 楼 yuxiangaaaaa 的回复:
粗略的统计一下，一张表就可以了 code=sql]--订票信息表 drop table train_order; create table train_order( num varchar(6), --车次 site varchar(10),--站点 isOrder int,--是否预定：0-否，1-是 seat_num varchar(10),--座位号 order_people varchar(10),--预定人 primary key(num, site,seat_num) );[/code] 
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点1', 1, '1', 'A');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点2', 1, '1', 'A');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点3', 1, '1', 'A');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点4', 1, '1', 'B');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点5', 1, '1', 'B');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点1', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点2', 1, '2', 'C');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点3', 1, '2', 'C');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点4', 1, '2', 'C');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点5', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点1', 1, '3', 'D');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点2', 1, '3', 'D');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点3', 1, '3', 'E');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点4', 1, '3', 'E');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点5', 1, '3', 'E');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点1', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点2', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点3', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点4', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点5', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点1', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点2', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点3', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点4', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点5', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点1', 0, '3', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点2', 0, '3', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点3', 0, '3', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点4', 0, '3', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点5', 0, '3', null);

--查询余票
select num,count(1) from train_order where isOrder = 0 group by num;
--查询空位
select num,site,seat_num from train_order where isOrder = 0;
自由自在_Yu 2017-11-09
  • 打赏
  • 举报
 回复
粗略的统计一下，一张表就可以了 code=sql]--订票信息表 drop table train_order; create table train_order( num varchar(6), --车次 site varchar(10),--站点 isOrder int,--是否预定：0-否，1-是 seat_num varchar(10),--座位号 order_people varchar(10),--预定人 primary key(num, site,seat_num) );[/code] 
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点1', 1, '1', 'A');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点2', 1, '1', 'A');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点3', 1, '1', 'A');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点4', 1, '1', 'B');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点5', 1, '1', 'B');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点1', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点2', 1, '2', 'C');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点3', 1, '2', 'C');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点4', 1, '2', 'C');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点5', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点1', 1, '3', 'D');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点2', 1, '3', 'D');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点3', 1, '3', 'E');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点4', 1, '3', 'E');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次1', '站点5', 1, '3', 'E');
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点1', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点2', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点3', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点4', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点5', 0, '1', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点1', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点2', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点3', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点4', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点5', 0, '2', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点1', 0, '3', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点2', 0, '3', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点3', 0, '3', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点4', 0, '3', null);
INSERT INTO TRAIN_ORDER (NUM, SITE, ISORDER, SEAT_NUM, ORDER_PEOPLE) VALUES ('车次2', '站点5', 0, '3', null);

--查询余票
select num,count(1) from train_order where isOrder = 0 group by num;
--查询空位
select num,site,seat_num from train_order where isOrder = 0;
自由自在_Yu 2017-11-09
  • 打赏
  • 举报
 回复
有乘客,买了站点1到站点3的座位1,站点4到站点5的座位1, 站点2到站点4的座位2,站点1到站点2的座位3,站点3到站点5的座位3,这些事车次1的还是车次2的？
大整数乘法实现思路
1、大整数乘法的实现思路（一）：模拟手工列竖式计算两个大整数的乘积 模拟手工计算两个整数相乘的过程：逐位相乘，错位累加，最后进位。以1235789×64523511235789×64523511235789\times6452351为例： 相乘的前提： 被乘数位数 >= 乘数位数。x×yx×yx\times y的逐位相乘次数取决于乘数y的位数。 低位补0：乘数y从十位数开始乘以被乘数...
基于栈实现表达式求值问题（C++）
目录一、问题描述二、实现思路三、解题代码四、运行结果 一、问题描述 基于栈实现表达式求值问题，输入一个简单表达式，输出表达式的结果 二、实现思路 在基于顺序栈实现表达式求值中，该算法主要分为将算术表达式转换成后缀表达式和后缀表达式求值两个步骤。 将算术表达式转换为后缀表达式的主要思路为：在从左到右扫描算术表达式exp的一个运算符op时，如果栈为空或者栈顶为’(‘，直接将其进栈；如果栈不空，只有当op的优先级高于栈顶运算符的优先级时才直接将op进栈;否则依次出栈运算符并存人后缀表达式postexp。直
表达式求值（最详细分析+代码实现+表达式之间的相互转换）
目录 一、概念 二、前缀表达式的逻辑和实现方式 1.定义 2.前缀表达式的计算机求值 3.例子 4.代码实现 三、中缀表达式的逻辑和实现方式 1.定义 2.中缀表达式规则 3.中缀表达式的计算机求值 4.代码实现 四、后缀表达式的逻辑和实现方式（逆波兰表达式求值） 1.定义 2.后缀表达式计算机求值 3.例子 4.代码实现 五、相互转换 1.中缀表达式转化为前缀表达式 ①算法描述 ②例子 2.前缀表达式转化为中缀表达式 3.中缀表达式转化为后缀表达式 ①算法描述
verilog语言实现C语言求余操作思路
verilog语言没有C语言的%操作符，需进行分解实现，思路如下： int mod(int a,int b) { int i; for(i=0;i<b;i++) { if(a==a/b*b+i) /* 因为a/b都是整数，所以结果也是整数，小数被截去 */ return i; /* 比如a=3，b=2； 满足条件时会有这样的式子成立3==3/2*2+1 ...
最短路径问题实现思路
把从一个顶点v0到到途中其余任意一点v1路径上所有边权值之和定义为该路径带权路径长度，带权路径长度最短的那条路径称作最短路径。 求解最短路径的算法通常依赖于一种性质，两点之间的最短路径也包含了路径上其它顶点的最短路径。 带权有向图最短路径问题分为两类： 1、单源最短路径 2、每一对顶点间的最短路径 Dijkstra算法求单源最短路径问题 求带权有向图某个源点到其余各顶点的最短路径，常用Dijkst...
Java

50,731

社区成员

85,691

社区内容

发帖
与我相关
我的任务
社区描述
Java相关技术讨论
javaspring bootspring cloud 技术论坛（原bbs）
社区管理员
  • Java相关社区
  • 小虚竹
  • 谙忆
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章