问题描述
在线订房系统,如何实现查询当前是否有所要查询的房间,表结构如下:--房间表room:roomId,groupId,roomName--房间分组表group:groupId,groupName--订单明细表orderItem:orderItemId,roomId,StartDate,EndDate如何实现在页面输入起始时间:如startDate:2010-3-1,endDate:2010-3-5查询出空房信息,显示在页面上,如:标准客房:已满;商务房:可预订
解决方案
select groupName from group where groupid in (select groupId from room where roomid not in (select roomid from orderItem where (startTime > '2010-3-1' and startTime < '2010-3-5' ) || (endTime > '2010-3-1' and endTime < '2010-3-5' )));
解决方案二:
select ....from room , group where room.groupId=group.groupId and roomId in (select roomId from orderItem where StartDate>输入的离店日期 or EndDate <输入的入住日期)两个问题:房型、预定对应表中的具体什么属性?日期的比较?这两个问题自己搞定呗
时间: 2024-09-20 00:09:29