listing 11-77.java

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

try {
  String query = new String (
    " SELECT COUNT(OrderNumber), AVG(Quantity),   SUM(Quantity) " +
    " FROM Orders o, customers c " +
    " WHERE o.CustomerNumber = c.CustNumber"); 
  DataRequest = Database.createStatement();
  Results = DataRequest.executeQuery (query);
  DisplayResults (Results);
  DataRequest.close();
  }