可以这样写么?
SQL="Select * from OSeasonSched";
rs = dbt.executeQuery(SQL);
String SQL1="select AIRPORT_IATA from SAirport where CITY_IATA = (select CITY_IATA from SCity where NAME_CHINESE ='"+city1+"')";
res1=dbt.executeQuery(SQL1);
String SQL2="select AIRPORT_IATA from SAirport where CITY_IATA = (select CITY_IATA from SCity where NAME_CHINESE ='"+city2+"')";
res2=dbt.executeQuery(SQL2);
whlie(rs.next() && res1.next() && res2.next())
{ }