Xojo Conferences
MBSOct2019CologneDE

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items Next items

JavaResultSetMBS.getClob(column as Integer) as JavaClobMBS
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 Clob object in the Java programming language.
Notes:
Column: the first column is 1, the second is 2, ...
Returns a Clob object representing the SQL CLOB value in the specified column

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getClob(column as string) as JavaClobMBS
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 Clob object in the Java programming language.
Notes:
column: the name of the column from which to retrieve the value
Returns a Clob object representing the SQL CLOB value in the specified column

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getConcurrency 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 concurrency mode of this ResultSet object.
Notes:
The concurrency used is determined by the Statement object that created the result set.
Returns:
the concurrency type, either ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE

Feedback, Comments & Corrections

JavaResultSetMBS.getCursorName as string
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 name of the SQL cursor used by this ResultSet object.
Notes:
In SQL, a result table is retrieved through a cursor that is named. The current row of a result set can be updated or deleted using a positioned update/delete statement that references the cursor name. To insure that the cursor has the proper isolation level to support update, the cursor's SELECT statement should be of the form SELECT FOR UPDATE. If FOR UPDATE is omitted, the positioned updates may fail.

The JDBC API supports this SQL feature by providing the name of the SQL cursor used by a ResultSet object. The current row of a ResultSet object is also the current row of this SQL cursor.

Note: If positioned update is not supported, a SQLException is thrown.

Returns:
the SQL name for this ResultSet object's cursor

Feedback, Comments & Corrections

JavaResultSetMBS.getDouble(column as Integer) as Double
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 double.
Notes: See the java documentation for details on java.sql.ResultSet.getDouble.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getDouble(column as string) as Double
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 double.
Notes: See the java documentation for details on java.sql.ResultSet.getDouble.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getFloat(column as Integer) as single
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 float 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.getFloat(column as string) as single
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 float 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.getInt(column as Integer) 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: Gets the value of the designated column in the current row of this ResultSet object as an int.
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 the java documentation for details on java.sql.ResultSet.getInt.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getInt(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: Gets the value of the designated column in the current row of this ResultSet object as an int.
Example:
dim r as JavaResultSetMBS // your result set
MsgBox str(R.getInt("test_id"))+" "+r.getString("test_val")
Notes: See the java documentation for details on java.sql.ResultSet.getInt.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getLong(column as Integer) as int64
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 an int64.
Notes: See the java documentation for details on java.sql.ResultSet.getLong.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getLong(column as string) as int64
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 an int64.
Notes: See the java documentation for details on java.sql.ResultSet.getLong.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getMetaData as JavaResultSetMetaDataMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Retrieves the number, types and properties of this ResultSet object's columns.
Notes:
Returns:
the description of this ResultSet object's columns

Feedback, Comments & Corrections

JavaResultSetMBS.getRow 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: Retrieves the current row number.
Notes: See the java documentation for details on java.sql.ResultSet.getRow.

Feedback, Comments & Corrections

JavaResultSetMBS.getShort(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 short 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.getShort(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 short 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.getString(column as Integer) as string
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 String.
Notes: See the java documentation for details on java.sql.ResultSet.getString.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getString(column as string) as string
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 String.
Example:
dim r as JavaResultSetMBS // your result set
MsgBox str(R.getInt("test_id"))+" "+r.getString("test_val")
Notes: See the java documentation for details on java.sql.ResultSet.getString.

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getType 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 type of this ResultSet object.
Notes:
The type is determined by the Statement object that created the result set.
Returns:
ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

Feedback, Comments & Corrections

JavaResultSetMBS.getUnicodeStream(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: Deprecated. use getCharacterStream in place of getUnicodeStream
Notes:
Retrieves the value of the designated column in the current row of this ResultSet object as as a stream of two-byte 3 characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHARvalues. The JDBC driver will do any necessary conversion from the database format into Unicode.
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 two-byte Unicode 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
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.getUnicodeStream(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: Deprecated. use getCharacterStream instead
Notes:
Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC technology-enabled driver will do any necessary conversion from the database format into Unicode.
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 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 two-byte Unicode 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
SQLFeatureNotSupportedException - if the JDBC driver does not support this method

See also:

Feedback, Comments & Corrections

JavaResultSetMBS.HOLD_CURSORS_OVER_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 not be closed when the method Connection.commit is called.

Feedback, Comments & Corrections

JavaResultSetMBS.insertRow
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method Java Database MBS Java Plugin 8.3 Yes Yes Yes Yes No
Function: Inserts the contents of the insert row into this ResultSet objaect and into the database.
Notes: See the java documentation for details on java.sql.ResultSet.insertRow.

Feedback, Comments & Corrections

JavaResultSetMBS.isAfterLast 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: Indicates whether the cursor is after the last row in this ResultSet object.
Notes: See the java documentation for details on java.sql.ResultSet.isAfterLast.

Feedback, Comments & Corrections

JavaResultSetMBS.isBeforeFirst 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: Retrieves whether the cursor is before the first row in this ResultSet object.
Notes:
Returns:
true if the cursor is before the first row; false if the cursor is at any other position or the result set contains no rows

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

Feedback, Comments & Corrections

JavaResultSetMBS.isFirst 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: Indicates whether the cursor is on the first row of this ResultSet object.
Notes: See the java documentation for details on java.sql.ResultSet.isFirst.

Feedback, Comments & Corrections

JavaResultSetMBS.isLast 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: Indicates whether the cursor is on the last row of this ResultSet object.
Notes: See the java documentation for details on java.sql.ResultSet.isLast.

Feedback, Comments & Corrections

JavaResultSetMBS.last 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 last row in this ResultSet object.
Notes: See the java documentation for details on java.sql.ResultSet.last.

Feedback, Comments & Corrections

JavaResultSetMBS.moveToCurrentRow
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 remembered cursor position, usually the current row.
Notes:
This method has no effect if the cursor is not on the insert row.

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

Feedback, Comments & Corrections

JavaResultSetMBS.moveToInsertRow
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 insert row.
Notes:
The current cursor position is remembered while the cursor is positioned on the insert row. The insert row is a special row associated with an updatable result set. It is essentially a buffer where a new row may be constructed by calling the updater methods prior to inserting the row into the result set. Only the updater, getter, and insertRow methods may be called when the cursor is on the insert row. All of the columns in a result set must be given a value each time this method is called before calling insertRow. An updater method must be called before a getter method can be called on a column value.

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

Feedback, Comments & Corrections

Previous items Next items

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

The biggest plugin in space...




Links
MBS Xojo Chart Plugins