listing 11-83.java

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

try {
  String query = new String (
    " SELECT StoreNumber,SalesRepNumber, SUM(Sales) " +
    " FROM Sales " + 
    " Group By StoreNumber, SalesRepNumber");
  DataRequest = Database.createStatement();
  Results = DataRequest.executeQuery (query);
  System.out.println("Store  SalesRep   Sales");
  System.out.println("-----  --------   -----");
  DisplayResults (Results);
  DataRequest.close();
}