java Mysql搜索特定日期的单程航班
CREATE TABLE `FlightOperatedby` (
`2-let ID` char(2) NOT NULL DEFAULT '',
`flight #` int DEFAULT 0,
`departing airport` char(3),
`arriving airport` char(3),
`a. time` time,
`d. time` time,
`duration` varchar(100),
`number of stops` int,
`isinternational` boolean,
`isdomestic` boolean,
`fare_first` double,
`fare_business` double,
`fare_economy` double,
PRIMARY KEY (`2-let ID`,`flight #`),
FOREIGN KEY (`departing airport`) REFERENCES Airport(`3-let ID`) ON UPDATE CASCADE,
FOREIGN KEY (`arriving airport`) REFERENCES Airport(`3-let ID`) ON UPDATE CASCADE
)
CREATE TABLE `AircraftFlightDates` (
`2-let ID` char(2),
`aircraft #` int,
`operating day` varchar(100),
PRIMARY KEY (`2-let ID`, `aircraft #`, `operating day`),
FOREIGN KEY (`2-let ID`, `aircraft #`) REFERENCES Aircraft(`2-let ID`, `aircraft #`) ON UPDATE CASCADE
我正在创建一个航班预订系统,让客户登录并搜索特定日期的单程航班。现在,对于sql命令,我有
String searchOneWay =
"SELECT flight #, a. time, d. time, departing airport, arriving airport, 2-let id"
+ "FROM FlightOperatedby join AircraftFlightDates using(flight #, 2-let id)"
+ "WHERE ";
如果客户搜索2021年11月23日的航班,我必须将当天(星期二)的航班与客户想要的航班进行匹配,但我无法找到将飞机的运行日期与实际日期联系起来的方法,以便客户可以选择一个日期
共 (0) 个答案