listing 11-95.java

来自「这是JAVA开发大全的源代码」· Java 代码 · 共 15 行

try {
  String query = new String (" SELECT SalesRepNumber " +
    " FROM Sales  "+ 
    " WHERE StoreNumber IN " +
    " (SELECT StoreNum " + 
    " FROM Orders " + 
    " WHERE Estimate < Amount) ");
  DataRequest = Database.createStatement();
  Results = DataRequest.executeQuery (query);
  System.out.println("Store");
  System.out.println("-----");
  DisplayResults (Results);
  DataRequest.close();
}