Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Next items

JavaResultSetMBS.absolute(row as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Moves the cursor to the given row number in this ResultSet object.
Example:
dim db as JavaConnectionMBS // your database
dim r as JavaResultSetMBS
dim s as JavaStatementMBS

// check second row
s=db.createStatement
r=s.executeQuery("SELECT * from myTable")

if r<>Nil then
if r.absolute(2) then
MsgBox str(R.getInt("test_id"))+" "+r.getString("test_val")
end if
end if
Notes: See the java documentation for details on java.sql.ResultSet.absolute.

Feedback, Comments & Corrections

JavaResultSetMBS.afterLast
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Moves the cursor to the end of this ResultSet object, just after the last row.
Notes: See the java documentation for details on java.sql.ResultSet.afterLast.

Feedback, Comments & Corrections

JavaResultSetMBS.beforeFirst
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Moves the cursor to the front of this ResultSet object, just before the first row.
Notes: See the java documentation for details on java.sql.ResultSet.beforeFirst.

Feedback, Comments & Corrections

JavaResultSetMBS.cancelRowUpdates
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Cancels the updates made to the current row in this ResultSet object.
Notes:
This method may be called after calling an updater method(s) and before calling the method updateRow to roll back the updates made to a row. If no updates have been made or updateRow has already been called, this method has no effect.

See the java documentation for details on java.sql.ResultSet.cancelRowUpdates.

Feedback, Comments & Corrections

JavaResultSetMBS.clearWarnings
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Clears all warnings reported on this ResultSet object.
Notes: See the java documentation for details on java.sql.ResultSet.clearWarnings.

Feedback, Comments & Corrections

JavaResultSetMBS.CLOSE_CURSORS_AT_COMMIT as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that ResultSet objects should be closed when the method Connection.commit is called.

Feedback, Comments & Corrections

JavaResultSetMBS.CONCUR_READ_ONLY as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating the concurrency mode for a ResultSet object that may NOT be updated.

Feedback, Comments & Corrections

JavaResultSetMBS.CONCUR_UPDATABLE as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating the concurrency mode for a ResultSet object that may be updated.

Feedback, Comments & Corrections

JavaResultSetMBS.Constructor
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 15.1 Yes Yes Yes Yes No
Function: The private constructor.

Feedback, Comments & Corrections

JavaResultSetMBS.deleteRow
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Deletes the current row from this ResultSet object and from the underlying database.
Notes: See the java documentation for details on java.sql.ResultSet.deleteRow.

Feedback, Comments & Corrections

JavaResultSetMBS.FetchDirection as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Gives a hint as to the direction in which the rows in this ResultSet object will be processed.
Notes:
The initial value is determined by the Statement object that produced this ResultSet object. The fetch direction may be changed at any time.

Parameters:
direction - an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
(Read and Write computed property)

Feedback, Comments & Corrections

JavaResultSetMBS.FetchSize as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object.
Notes:
If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.

Parameters:
rows - the number of rows to fetch
(Read and Write computed property)

Feedback, Comments & Corrections

JavaResultSetMBS.FETCH_FORWARD as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that the rows in a result set will be processed in a forward direction; first-to-last.
Notes: This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

Feedback, Comments & Corrections

JavaResultSetMBS.FETCH_REVERSE as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that the rows in a result set will be processed in a reverse direction; last-to-first.
Notes: This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

Feedback, Comments & Corrections

JavaResultSetMBS.FETCH_UNKNOWN as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: The constant indicating that the order in which rows in a result set will be processed is unknown.
Notes: This constant is used by the method setFetchDirection as a hint to the driver, which the driver may ignore.

Feedback, Comments & Corrections

JavaResultSetMBS.findColumn(column as string) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Maps the given ResultSet column name to its ResultSet column index.
Example:
dim r as JavaResultSetMBS // your result set
MsgBox str(r.findColumn("test_id"))+" "+str(r.findColumn("test_val"))
Notes:
Returns 0 on any error.
See the java documentation for details on java.sql.ResultSet.findColumn.

Feedback, Comments & Corrections

JavaResultSetMBS.first as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Moves the cursor to the first row in this ResultSet object.
Notes: See the java documentation for details on java.sql.ResultSet.first.

Feedback, Comments & Corrections

JavaResultSetMBS.getAsciiStream(column as Integer) as JavaInputStreamMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 13.1 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters.
Notes:
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Parameters:
column: the first column is 1, the second is 2, ...

Returns a Java input stream that delivers the database column value as a stream of one-byte ASCII characters; if the value is SQL NULL, the value returned is null

Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getAsciiStream(column as string) as JavaInputStreamMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 13.1 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as an Array object in the Java programming language.
Notes:
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Parameters:
column: the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.

Throws:
SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getBinaryStream(column as Integer) as JavaInputStreamMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 13.1 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
Notes:
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Parameters:
column: the first column is 1, the second is 2, ...

Returns a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the value returned is null

Throws:
SQLException - if the columnIndex is not valid; if a database access error occurs or this method is called on a closed result set

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getBinaryStream(column as string) as JavaInputStreamMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 13.1 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes.
Notes:
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Parameters:
column: the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

Returns a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the result is null.

Throws SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getBlob(column as Integer) as JavaBlobMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
Notes:
Column: the first column is 1, the second is 2, ...

Returns a Blob object representing the SQL BLOB value in the specified column

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getBlob(column as string) as JavaBlobMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a Blob object in the Java programming language.
Notes:
column: the name of the column from which to retrieve the value
Returns a Blob object representing the SQL BLOB value in the specified column

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getBoolean(column as Integer) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Gets the value of the designated column in the current row of this ResultSet object as a boolean.
Notes: See the java documentation for details on java.sql.ResultSet.getBoolean.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getBoolean(column as string) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Gets the value of the designated column in the current row of this ResultSet object as a boolean.
Notes: See the java documentation for details on java.sql.ResultSet.getBoolean.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getByte(column as Integer) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
Notes:
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Returns:
the column value; if the value is SQL NULL, the value returned is 0

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getByte(column as string) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.
Notes:
Parameters:
columnName - the SQL name of the column
Returns:
the column value; if the value is SQL NULL, the value returned is 0

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getBytes(column as Integer) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 11.3 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
Notes:
column: the first column is 1, the second is 2, ...
the plugin gives you the bytes as a string with no encoding.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getBytes(column as string) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 11.3 Yes Yes Yes Yes No
Function: Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language.
Notes: the plugin gives you the bytes as a string with no encoding.

See also:

Feedback, Comments & Corrections

Next items

The items on this page are in the following plugins: MBS Java Plugin.




Links
MBS Xojo tutorial videos