UIQ3/net.sourceforge.uiq3.database/SQLiteStatement

SQLiteStatement

open class SQLiteStatement

extracts category ids to be deleted from DB

Author

"Martin Krischik" «krischik@users.sourceforge.net»

Since

1.0

Constructors

SQLiteStatement

constructor(database: SQLiteDatabase, statement: String)

create a statement by compiling the string representation of a statement against a database

constructor(delegate: SQLiteStatement)

create a statement from an existing one.

Properties

val delegate: SQLiteStatement

What is OO good for if every other class can't be extended because the constructor is protected and the class must be created using a factory.

Functions

open fun bindBlob(index: Int, value: Array<Byte>)

Bind a byte array value to this statement.

open fun bindBlob(index: Int, value: String)

Converts the string to a byte array and Bind value to this statement.

open fun bindBoolean(index: Int, value: Boolean)

bind value or a null if the value is null

open fun bindByte(index: Int, value: Byte)

bind value or a null if the value is null

open fun bindDate(index: Int, value: Date)

bind value or a null if the value is null

open fun bindDouble(index: Int, value: Double)

bind value or a null if the value is null

open fun bindFile(index: Int, data: String, file: File)

Converts the string to a byte array and Bind value to this statement.

open fun bindFloat(index: Int, value: Float)

bind value or a null if the value is null

open fun bindInteger(index: Int, value: Integer)

bind value or a null if the value is null

open fun bindLong(index: Int, value: Long)

bind value or a null if the value is null

open fun bindNull(index: Int)

bind null

open fun bindString(index: Int, value: String)

bind value or a null if the value is null

open fun bindURI(index: Int, value: URI)

bind value or a null if the value is null Note that there are three “URL” classes and you need to choose wisely:

java.net.URL: Java 1.0 class to handle URLs. Tries to resolve the URL on the net. Will hang and throw exception when this fails. Try to avoid if at all possible.
java.net.URI: Java 1.4 replacement for java.net.URL. Use when you need a instance which is java.io.Serializable.
android.net.Uri: Android replacement for java.net.URL. Use when you need a instance which is android.os.Parcelable.

open fun bindUri(index: Int, value: Uri)

bind value or a null if the value is null Note that there are three “URL” classes and you need to choose wisely:

java.net.URL: Java 1.0 class to handle URLs. Tries to resolve the URL on the net. Will hang and throw exception when this fails. Try to avoid if at all possible.
java.net.URI: Java 1.4 replacement for java.net.URL. Use when you need a instance which is java.io.Serializable.
android.net.Uri: Android replacement for java.net.URL. Use when you need a instance which is android.os.Parcelable.

open fun bindURL(index: Int, value: URL)

bind value or a null if the value is null Note that there are three “URL” classes and you need to choose wisely:

java.net.URL: Java 1.0 class to handle URLs. Tries to resolve the URL on the net. Will hang and throw exception when this fails. Try to avoid if at all possible.
java.net.URI: Java 1.4 replacement for java.net.URL. Use when you need a instance which is java.io.Serializable.
android.net.Uri: Android replacement for java.net.URL. Use when you need a instance which is android.os.Parcelable.

protected open fun clone(): Any

open fun close()

open fun equals(obj: Any): Boolean

open fun executeInsert(): Long

execute the statement.

protected open fun finalize()

fun getClass(): Class<out Any>

open fun hashCode(): Int

fun notify()

fun notifyAll()

open fun toString(): String

create debug string

fun wait()