JdbcPreparedStatementApi

interface JdbcPreparedStatementApi : PreparedStatementApi

Base class representing a precompiled SQL java.sql.PreparedStatement from the JDBC SPI.

Inheritors

JdbcPreparedStatementImpl

Members

Properties

fetchSize

Link copied to clipboard

abstract var fetchSize: Int?

The number of result set rows that should be fetched when generated by an executed statement.

resultSet

Link copied to clipboard

abstract val resultSet: JdbcResult?

The JdbcResult generated by the executed statement, or null if none was retrieved.

timeout

Link copied to clipboard

abstract var timeout: Int?

The number of seconds the JDBC driver will wait for a statement to execute.

Functions

addBatch

Link copied to clipboard

abstract fun addBatch()

Adds parameters to the statement's batch of SQL commands.

cancel

Link copied to clipboard

abstract fun cancel()

Cancels the statement, if supported by the database.

closeIfPossible

Link copied to clipboard

abstract fun closeIfPossible()

Closes the statement, if still open, and releases any of its database and/or driver resources.

executeBatch

Link copied to clipboard

abstract fun executeBatch(): List<Int>

Executes batched SQL statements stored as a java.sql.PreparedStatement.

executeMultiple

Link copied to clipboard

abstract fun executeMultiple(): List<StatementResult>

Executes multiple SQL statements stored in a single java.sql.PreparedStatement.

executeQuery

Link copied to clipboard

abstract fun executeQuery(): JdbcResult

Executes an SQL query stored in a java.sql.PreparedStatement.

executeUpdate

Link copied to clipboard

abstract fun executeUpdate(): Int

Executes an SQL statement stored in a java.sql.PreparedStatement.

fillParameters

Link copied to clipboard

open fun fillParameters(args: Iterable<Pair<IColumnType<*>, Any?>>): Int

set

Link copied to clipboard

abstract fun set(index: Int, value: Any, columnType: IColumnType<*>)

setArray

Link copied to clipboard

abstract fun setArray(index: Int, type: ArrayColumnType<*, *>, array: Array<*>)

setInputStream

Link copied to clipboard

abstract fun setInputStream(index: Int, inputStream: InputStream, setAsBlobObject: Boolean)

setNull

Link copied to clipboard

abstract fun setNull(index: Int, columnType: IColumnType<*>)