Platforms to show: All Mac Windows Linux Cross-Platform

JavaStatementMBS class

Super class: JavaObjectMBS

• 6 properties
  • property EscapeProcessing as boolean
  • property FetchDirection as Integer
  • property FetchSize as Integer
  • property MaxFieldSize as Integer
  • property MaxRows as Integer
  • property QueryTimeout as Integer
• 28 methods
  • method addBatch(sql as string)
  • method cancel
  • method clearBatch
  • method clearWarnings
  • method close
  • method CLOSE_ALL_RESULTS as Integer
  • method CLOSE_CURRENT_RESULT as Integer
  • method Constructor   Private
  • method execute(sql as string) as boolean
  • method execute(sql as string, autoGeneratedKeys as Integer) as boolean
  • method executeBatch as Integer()
  • method executeQuery(sql as string) as JavaResultSetMBS
  • method executeUpdate(Sql as string) as Integer
  • method executeUpdate(Sql as string, autoGeneratedKeys as Integer) as Integer
  • method EXECUTE_FAILED as Integer
  • method getGeneratedKeys as JavaResultSetMBS
  • method getMoreResults as boolean
  • method getMoreResults(current as Integer) as boolean
  • method getResultSet as JavaResultSetMBS
  • method getResultSetConcurrency as Integer
  • method getResultSetHoldability as Integer
  • method getResultSetType as Integer
  • method getUpdateCount as Integer
  • method KEEP_CURRENT_RESULT as Integer
  • method NO_GENERATED_KEYS as Integer
  • method RETURN_GENERATED_KEYS as Integer
  • method setCursorName(name as string)
  • method SUCCESS_NO_INFO as Integer

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

Sub classes:

• class JavaCallableStatementMBS
• class JavaPreparedStatementMBS

Some methods using this class:

• JavaConnectionMBS.createStatement as JavaStatementMBS
• JavaConnectionMBS.createStatement(resultSetType as Integer, resultSetConcurrency as Integer) as JavaStatementMBS
• JavaConnectionMBS.createStatement(resultSetType as Integer, resultSetConcurrency as Integer, resultSetHoldability as Integer) as JavaStatementMBS

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

• Prefetching records from databases
• MBS Xojo / Real Studio Plugins, version 15.1pr1

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

JavaShortArrayMBS   -   JavaStringMBS