listing 11-59.java

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

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