Packagecom.maclema.mysql
Classpublic class ResultSet
InheritanceResultSet Inheritance Object

The ResultSet class represents a data set retuends by MySql for a query.



Public Properties
 PropertyDefined By
  numColumns : int
[read-only] Returns the number of columns in the ResultSet
ResultSet
  position : int
ResultSet
  token : MySqlToken
[read-only] Returns the token object that created this result set.
ResultSet
Public Methods
 MethodDefined By
  
Constructs a new ResultSet object
ResultSet
  
dispose():void
Cleans up resources held by this result set
ResultSet
  
first():Boolean
Moves the pointer to the first row
ResultSet
  
getBinary(column:*):ByteArray
Returns a binary ByteArray for the specified column
ResultSet
  
getBoolean(column:*):Boolean
Returns a boolean value for the specified column.
ResultSet
  
getColumns():Array
Returns an array for Field objects
ResultSet
  
getDate(column:*):Date
Returns a Date object for the specified column
ResultSet
  
getInt(column:*):int
Returns an int for the specifiec column
ResultSet
  
getNumber(column:*):Number
Returns a Number for the specifiec column
ResultSet
  
getRows(dateTimesAsStrings:Boolean = false, offset:int = 0, len:int = 0):*
ResultSet
  
getString(column:*):String
Returns a String value from the specified column.
ResultSet
  
getTime(column:*):Date
Returns a Date object, where yyyy-mm-dd is always the current date, but the time values are HH:mm:ss from the column
ResultSet
  
last():Boolean
Moves the pointer to the last row.
ResultSet
  
next():Boolean
Advances the pointer to the next row
ResultSet
  
previous():Boolean
Moves the pointer to the previous row
ResultSet
  
size():int
Returns the number of rows in the ResultSet
ResultSet
Property Detail
numColumnsproperty
numColumns:int  [read-only]

Returns the number of columns in the ResultSet


Implementation
    public function get numColumns():int
positionproperty 
position:int


Implementation
    public function get position():int
    public function set position(value:int):void
tokenproperty 
token:MySqlToken  [read-only]

Returns the token object that created this result set.


Implementation
    public function get token():MySqlToken
Constructor Detail
ResultSet()Constructor
public function ResultSet(token:MySqlToken)

Constructs a new ResultSet object

Parameters
token:MySqlToken
Method Detail
dispose()method
public function dispose():void

Cleans up resources held by this result set

first()method 
public function first():Boolean

Moves the pointer to the first row

Returns
Boolean
getBinary()method 
public function getBinary(column:*):ByteArray

Returns a binary ByteArray for the specified column

Parameters

column:*

Returns
ByteArray
getBoolean()method 
public function getBoolean(column:*):Boolean

Returns a boolean value for the specified column.

Parameters

column:*

Returns
Boolean
getColumns()method 
public function getColumns():Array

Returns an array for Field objects

Returns
Array
getDate()method 
public function getDate(column:*):Date

Returns a Date object for the specified column

Parameters

column:*

Returns
Date
getInt()method 
public function getInt(column:*):int

Returns an int for the specifiec column

Parameters

column:*

Returns
int
getNumber()method 
public function getNumber(column:*):Number

Returns a Number for the specifiec column

Parameters

column:*

Returns
Number
getRows()method 
public function getRows(dateTimesAsStrings:Boolean = false, offset:int = 0, len:int = 0):*

Parameters

dateTimesAsStrings:Boolean (default = false)
 
offset:int (default = 0)
 
len:int (default = 0)

Returns
*
getString()method 
public function getString(column:*):String

Returns a String value from the specified column. You may specify columns using a 1-based number or the column name

Parameters

column:*

Returns
String
getTime()method 
public function getTime(column:*):Date

Returns a Date object, where yyyy-mm-dd is always the current date, but the time values are HH:mm:ss from the column

Parameters

column:*

Returns
Date
last()method 
public function last():Boolean

Moves the pointer to the last row.

Returns
Boolean
next()method 
public function next():Boolean

Advances the pointer to the next row

Returns
Boolean
previous()method 
public function previous():Boolean

Moves the pointer to the previous row

Returns
Boolean
size()method 
public function size():int

Returns the number of rows in the ResultSet

Returns
int