# JdbcPreparedStatementApi

interface JdbcPreparedStatementApi : PreparedStatementApi

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

#### Inheritors

JdbcPreparedStatementImpl

## 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<*>)