listing 11-92.java

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

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