private  void DownRow ( ResultSet DisplayResults )throws SQLException
{
  String FirstName= new String();
  String LastName= new String();
  String Street= new String();
  String City = new String();
  String State = new String();
  String ZipCode= new String();
  long Sales;
  String printrow;
  FirstName = DisplayResults.getString ( 1 ) ;
  LastName = DisplayResults.getString ( 2 ) ;
  Street = DisplayResults.getString ( 3 ) ;
  City = DisplayResults.getString ( 4 ) ;
  State = DisplayResults.getString ( 5 ) ;
  ZipCode = DisplayResults.getString ( 6 ) ;
  Sales = DisplayResults.getLong ( 7 ) ;
  printrow = FirstName + " " + LastName + " " + 
    City + " " + State +  " " + ZipCode + " " + Sales;
  System.out.println(printrow);
}