| Package | com.maclema.mysql |
| Class | public class ResultSet |
| Inheritance | ResultSet Object |
| Property | Defined 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 | ||
| Method | Defined By | ||
|---|---|---|---|
ResultSet(token:MySqlToken)
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 | ||
| numColumns | property |
numColumns:int [read-only] Returns the number of columns in the ResultSet
public function get numColumns():int| position | property |
position:int public function get position():int public function set position(value:int):void| token | property |
token:MySqlToken [read-only] Returns the token object that created this result set.
public function get token():MySqlToken| ResultSet | () | Constructor |
public function ResultSet(token:MySqlToken)Constructs a new ResultSet object
Parameterstoken:MySqlToken |
| dispose | () | method |
public function dispose():voidCleans up resources held by this result set
| first | () | method |
public function first():BooleanMoves the pointer to the first row
ReturnsBoolean |
| getBinary | () | method |
public function getBinary(column:*):ByteArrayReturns a binary ByteArray for the specified column
Parameters
column:* |
ByteArray |
| getBoolean | () | method |
public function getBoolean(column:*):BooleanReturns a boolean value for the specified column.
Parameters
column:* |
Boolean |
| getColumns | () | method |
public function getColumns():ArrayReturns an array for Field objects
ReturnsArray |
| getDate | () | method |
public function getDate(column:*):DateReturns a Date object for the specified column
Parameters
column:* |
Date |
| getInt | () | method |
public function getInt(column:*):intReturns an int for the specifiec column
Parameters
column:* |
int |
| getNumber | () | method |
public function getNumber(column:*):NumberReturns a Number for the specifiec column
Parameters
column:* |
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) |
* |
| getString | () | method |
public function getString(column:*):StringReturns a String value from the specified column. You may specify columns using a 1-based number or the column name
Parameters
column:* |
String |
| getTime | () | method |
public function getTime(column:*):DateReturns 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:* |
Date |
| last | () | method |
public function last():BooleanMoves the pointer to the last row.
ReturnsBoolean |
| next | () | method |
public function next():BooleanAdvances the pointer to the next row
ReturnsBoolean |
| previous | () | method |
public function previous():BooleanMoves the pointer to the previous row
ReturnsBoolean |
| size | () | method |
public function size():intReturns the number of rows in the ResultSet
Returnsint |