Class msql.MsqlResult
All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class msql.MsqlResult

java.lang.Object
   |
   +----msql.MsqlResult

public class MsqlResult
extends Object
Object containing the results of a select query. A combination of two MsqlData instances representing the retrieved data and a description of the fields which make up the data.

Constructor Index

 o MsqlResult(MsqlData, MsqlData)
Constructor - Accepts row and field info as arguments

Method Index

 o _FetchField()
Fetch the field from the table
 o DataSeek(int)
Data Seek
 o FetchField()
Fetch the next field from the list of fields
 o FetchRow()
Fetch the next row from the table
 o FieldSeek(int)
Field Seek
 o getRow(int)
Fetch the nth row from the table
 o ListFields()
Return reference to array of field descriptions.
 o NumFields()
Return number of fields in table
 o NumRows()
Return number of rows in table

Constructors

 o MsqlResult
  public MsqlResult(MsqlData table,
                    MsqlData fields)
Constructor - Accepts row and field info as arguments
Parameters:
table - instance of MsqlData representing the data set.
fields - instance of MsqlData containing field information.

Methods

 o FetchRow
  public String[] FetchRow()
Fetch the next row from the table
Returns:
an array of Strings representing the columns of the row.
 o getRow
  public String[] getRow(int n)
Fetch the nth row from the table
Returns:
an array of Strings representing the columns of the row.
 o _FetchField
  public String[] _FetchField()
Fetch the field from the table
Returns:
an array of Strings representing the columns of the row.
 o FetchField
  public MsqlFieldDesc FetchField()
Fetch the next field from the list of fields
Returns:
an array of Strings representing the Name, Type, Length Non-null flag and key flag of the next field.
 o ListFields
  public MsqlFieldDesc[] ListFields()
Return reference to array of field descriptions.
Returns:
an array of MsqlFieldDesc.
 o NumRows
  public int NumRows()
Return number of rows in table
Returns:
the number of rows in this data set.
 o NumFields
  public int NumFields()
Return number of fields in table
Returns:
the number of fields in this data set.
 o DataSeek
  public void DataSeek(int i)
Data Seek
Parameters:
i - the index of the row to be retrieved.
 o FieldSeek
  public void FieldSeek(int i)
Field Seek
Parameters:
i - the index of the field to be retrieved.

All Packages  Class Hierarchy  This Package  Previous  Next  Index