Platforms to show: All Mac Windows Linux Cross-Platform

JavaResultSetMBS class

Super class: JavaObjectMBS

• 2 properties
  • property FetchDirection as Integer
  • property FetchSize as Integer
• 105 methods
  • method absolute(row as Integer) as boolean
  • method afterLast
  • method beforeFirst
  • method cancelRowUpdates
  • method clearWarnings
  • method CLOSE_CURSORS_AT_COMMIT as Integer
  • method CONCUR_READ_ONLY as Integer
  • method CONCUR_UPDATABLE as Integer
  • method Constructor   Private
  • method deleteRow
  • method FETCH_FORWARD as Integer
  • method FETCH_REVERSE as Integer
  • method FETCH_UNKNOWN as Integer
  • method findColumn(column as string) as Integer
  • method first as boolean
  • method getAsciiStream(column as Integer) as JavaInputStreamMBS
  • method getAsciiStream(column as string) as JavaInputStreamMBS
  • method getBinaryStream(column as Integer) as JavaInputStreamMBS
  • method getBinaryStream(column as string) as JavaInputStreamMBS
  • method getBlob(column as Integer) as JavaBlobMBS
  • method getBlob(column as string) as JavaBlobMBS
  • method getBoolean(column as Integer) as boolean
  • method getBoolean(column as string) as boolean
  • method getByte(column as Integer) as Integer
  • method getByte(column as string) as Integer
  • method getBytes(column as Integer) as string
  • method getBytes(column as string) as string
  • method getClob(column as Integer) as JavaClobMBS
  • method getClob(column as string) as JavaClobMBS
  • method getConcurrency as Integer
  • method getCursorName as string
  • method getDate(column as integer) as JavaObjectMBS   New in 24.4
  • method getDate(column as string) as JavaObjectMBS   New in 24.4
  • method getDouble(column as Integer) as Double
  • method getDouble(column as string) as Double
  • method getFloat(column as Integer) as single
  • method getFloat(column as string) as single
  • method getInt(column as Integer) as Integer
  • method getInt(column as string) as Integer
  • method getLong(column as Integer) as int64
  • method getLong(column as string) as int64
  • method getMetaData as JavaResultSetMetaDataMBS
  • method getRow as Integer
  • method getShort(column as Integer) as Integer
  • method getShort(column as string) as Integer
  • method getString(column as Integer) as string
  • method getString(column as string) as string
  • method getTime(column as integer) as JavaObjectMBS   New in 24.4
  • method getTime(column as string) as JavaObjectMBS   New in 24.4
  • method getTimestamp(column as integer) as JavaObjectMBS   New in 24.4
  • method getTimestamp(column as string) as JavaObjectMBS   New in 24.4
  • method getType as Integer
  • method getUnicodeStream(column as Integer) as JavaInputStreamMBS
  • method getUnicodeStream(column as string) as JavaInputStreamMBS
  • method HOLD_CURSORS_OVER_COMMIT as Integer
  • method insertRow
  • method isAfterLast as boolean
  • method isBeforeFirst as boolean
  • method isFirst as boolean
  • method isLast as boolean
  • method last as boolean
  • method moveToCurrentRow
  • method moveToInsertRow
  • method NextRecord as boolean
  • method previousRecord as boolean
  • method refreshRow
  • method relative(row as Integer) as boolean
  • method rowDeleted as boolean
  • method rowInserted as boolean
  • method rowUpdated as boolean
  • method TYPE_FORWARD_ONLY as Integer
  • method TYPE_SCROLL_INSENSITIVE as Integer
  • method TYPE_SCROLL_SENSITIVE as Integer
  • method updateBlob(column as Integer, value as JavaBlobMBS)
  • method updateBlob(column as string, value as JavaBlobMBS)
  • method updateBoolean(column as Integer, value as boolean)
  • method updateBoolean(column as string, value as boolean)
  • method updateByte(column as Integer, value as Integer)
  • method updateByte(column as string, value as Integer)
  • method updateBytes(column as Integer, Value as String)
  • method updateBytes(column as string, Value as String)
  • method updateClob(column as Integer, value as JavaClobMBS)
  • method updateClob(column as string, value as JavaClobMBS)
  • method updateDate(column as integer, value as JavaObjectMBS)   New in 24.4
  • method updateDate(column as string, value as JavaObjectMBS)   New in 24.4
  • method updateDouble(column as Integer, value as Double)
  • method updateDouble(column as string, value as Double)
  • method updateFloat(column as Integer, value as single)
  • method updateFloat(column as string, value as single)
  • method updateInt(column as Integer, value as Integer)
  • method updateInt(column as string, value as Integer)
  • method updateLong(column as Integer, value as int64)
  • method updateLong(column as string, value as int64)
  • method updateNull(column as Integer)
  • method updateNull(column as string)
  • method updateRow
  • method updateShort(column as Integer, value as Integer)
  • method updateShort(column as string, value as Integer)
  • method updateString(column as Integer, value as string)
  • method updateString(column as string, value as string)
  • method updateTime(column as integer, value as JavaObjectMBS)   New in 24.4
  • method updateTime(column as string, value as JavaObjectMBS)   New in 24.4
  • method updateTimestamp(column as integer, value as JavaObjectMBS)   New in 24.4
  • method updateTimestamp(column as string, value as JavaObjectMBS)   New in 24.4
  • method wasNull as boolean

Super class JavaObjectMBS

• 16 properties
  • property ClassName as String
  • property Database as Variant
  • property Handle as Integer
  • property Lasterror as Integer
  • property Tag as Variant
  • property VM as JavaVMMBS
  • property BooleanField(TheField as JavaFieldMBS) as boolean
  • property ByteField(TheField as JavaFieldMBS) as Integer
  • property CharField(TheField as JavaFieldMBS) as Integer
  • property DoubleField(TheField as JavaFieldMBS) as Double
  • property Field(TheField as JavaFieldMBS) as Variant
  • property FloatField(TheField as JavaFieldMBS) as single
  • property IntField(TheField as JavaFieldMBS) as Integer
  • property LongField(TheField as JavaFieldMBS) as Int64
  • property ObjectField(TheField as JavaFieldMBS) as JavaObjectMBS
  • property ShortField(TheField as JavaFieldMBS) as Integer
• 28 methods
  • method CallBooleanMethod(MethodID as JavaMethodMBS, args as memoryblock) as boolean
  • method CallByteMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
  • method CallCharMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
  • method CallDoubleMethod(MethodID as JavaMethodMBS, args as memoryblock) as Double
  • method CallFloatMethod(MethodID as JavaMethodMBS, args as memoryblock) as single
  • method CallIntMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
  • method CallLongMethod(MethodID as JavaMethodMBS, args as memoryblock) as Int64
  • method CallMethod(MethodID as JavaMethodMBS, args() as Variant) as Variant
  • method CallNonvirtualBooleanMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as boolean
  • method CallNonvirtualByteMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
  • method CallNonvirtualCharMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
  • method CallNonvirtualDoubleMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Double
  • method CallNonvirtualFloatMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as single
  • method CallNonvirtualIntMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
  • method CallNonvirtualLongMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Int64
  • method CallNonvirtualMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args() as Variant) as Variant
  • method CallNonvirtualObjectMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as JavaObjectMBS
  • method CallNonvirtualShortMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
  • method CallNonvirtualVoidMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock)
  • method CallObjectMethod(MethodID as JavaMethodMBS, args as memoryblock) as JavaObjectMBS
  • method CallShortMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
  • method CallVoidMethod(MethodID as JavaMethodMBS, args as memoryblock)
  • method Constructor   Private
  • method GetDirectBufferAddress(directbuffer as JavaObjectMBS) as Integer
  • method GetDirectBufferCapacity(directbuffer as JavaObjectMBS) as Integer
  • method IsInstanceOf(TheClass as JavaClassMBS) as boolean
  • method IsSameObject(obj as JavaObjectMBS) as boolean
  • method ObjectClass as JavaClassMBS

This class has no sub classes.

Some methods using this class:

• JavaDatabaseMetaDataMBS.getCatalogs as JavaResultSetMBS
• JavaDatabaseMetaDataMBS.getColumnPrivileges(catalog as string, schema as string, table as string, columnNamePattern as string) as JavaResultSetMBS
• JavaDatabaseMetaDataMBS.getCrossReference(primaryCatalog as string, primarySchema as string, primaryTable as string, foreignCatalog as string, foreignSchema as string, foreignTable as string) as JavaResultSetMBS
• JavaDatabaseMetaDataMBS.getExportedKeys(catalog as string, schema as string, table as string) as JavaResultSetMBS
• JavaDatabaseMetaDataMBS.getSuperTypes(catalog as string, schemaPattern as string, typeNamePattern as string) as JavaResultSetMBS
• JavaDatabaseMetaDataMBS.getTablePrivileges(catalog as string, schemaPattern as string, tableNamePattern as string) as JavaResultSetMBS
• JavaDatabaseMetaDataMBS.getTables(catalog as string, schemaPattern as string, tableNamePattern as string, types() as string) as JavaResultSetMBS
• JavaDatabaseMetaDataMBS.getTableTypes as JavaResultSetMBS
• JavaDatabaseMetaDataMBS.getTypeInfos as JavaResultSetMBS
• JavaPreparedStatementMBS.executeQuery as JavaResultSetMBS

Some examples using this class:

• /Java/JavaDatabase/java Database Thread Tests
• /Java/JavaDatabase/JavaDatabase MDB
• /Java/JavaDatabase/JavaDatabase MySQL Blob and Clob
• /Java/JavaDatabase/JavaDatabase MySQL test
• /Java/JavaDatabase/JavaDatabase MySQL test with Threading
• /Java/JavaDatabase/JavaDatabase MySQL with JavaInputStreamMBS
• /Java/JavaDatabase/JavaDatabase SQLite
• /Java/JavaDatabase/JavaDatabase SQLite blob
• /Java/JavaDatabase/JavaDatabase to JSON
• /Java/JavaDatabase/JDBCMultipleDrivers

Blog Entries

• MBS Xojo Plugins, version 24.4pr3
• Prefetching records from databases
• Encrypted Access database in Xojo
• MBS Real Studio Plugins, version 13.1pr7
• MBS Real Studio Plugins, version 11.3pr1

Release notes

• Version 24.4
  • Added date and time getters and setters for JavaResultSetMBS class.

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

JavaPreparedStatementMBS   -   JavaResultSetMetaDataMBS