listing 11-61.java

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

try {
  String query = new String ("SELECT c.CustNumber , " + 
    " c.FirstName, c.LastName, o.OrderNumber, " +
    " p.ProductName, o.Quantity " +
    " FROM Customers c, Orders o, Products  p" +
    " WHERE o.ProdNumber = p.ProductNumber " +
    " AND c.CustomerNumber = o.CustomerNumber");
  DataRequest = Database.createStatement();
  Results = DataRequest.executeQuery (query);
  DisplayResults (Results);
  DataRequest.close();
}