sqlObjectMapper/com.qualifiedcactus.sqlObjectMapper/NpCallableStatement

NpCallableStatement

class NpCallableStatement : NpStatement, CallableStatement

A named parameter(s) version of CallableStatement

Functions

addBatch

open override fun addBatch()

open override fun addBatch(p0: String)

cancel

open override fun cancel()

clearBatch

open override fun clearBatch()

clearParameters

open override fun clearParameters()

clearWarnings

open override fun clearWarnings()

open override fun close()

closeOnCompletion

open override fun closeOnCompletion()

enquoteIdentifier

open fun enquoteIdentifier(p0: String, p1: Boolean): String

enquoteLiteral

open fun enquoteLiteral(p0: String): String

enquoteNCharLiteral

open fun enquoteNCharLiteral(p0: String): String

execute

open override fun execute(): Boolean

open override fun execute(p0: String): Boolean

open override fun execute(p0: String, p1: Array<String>): Boolean

open override fun execute(p0: String, p1: Int): Boolean

open override fun execute(p0: String, p1: IntArray): Boolean

executeBatch

open override fun executeBatch(): IntArray

executeLargeBatch

open fun executeLargeBatch(): LongArray

executeLargeUpdate

open fun executeLargeUpdate(): Long

open fun executeLargeUpdate(p0: String): Long

open fun executeLargeUpdate(p0: String, p1: Array<String>): Long

open fun executeLargeUpdate(p0: String, p1: Int): Long

open fun executeLargeUpdate(p0: String, p1: IntArray): Long

executeQuery

open override fun executeQuery(): ResultSet

open override fun executeQuery(p0: String): ResultSet

executeUpdate

open override fun executeUpdate(): Int

open override fun executeUpdate(p0: String): Int

open override fun executeUpdate(p0: String, p1: Array<String>): Int

open override fun executeUpdate(p0: String, p1: Int): Int

open override fun executeUpdate(p0: String, p1: IntArray): Int

executeUpdateWithGeneratedKeys

fun <T : Any> executeUpdateWithGeneratedKeys(declaredGeneratedKeys: DeclaredGeneratedKeys<T>): List<T>

Execute update and get the auto generated key(s) as a list.

getArray

open override fun getArray(p0: Int): Array

open override fun getArray(p0: String): Array

getBigDecimal

open override fun getBigDecimal(p0: Int): BigDecimal

open override fun getBigDecimal(p0: String): BigDecimal

open override fun ~~getBigDecimal~~(p0: Int, p1: Int): BigDecimal

getBlob

open override fun getBlob(p0: Int): Blob

open override fun getBlob(p0: String): Blob

getBoolean

open override fun getBoolean(p0: Int): Boolean

open override fun getBoolean(p0: String): Boolean

getByte

open override fun getByte(p0: Int): Byte

open override fun getByte(p0: String): Byte

getBytes

open override fun getBytes(p0: Int): ByteArray

open override fun getBytes(p0: String): ByteArray

getCharacterStream

open override fun getCharacterStream(p0: Int): Reader

open override fun getCharacterStream(p0: String): Reader

getClob

open override fun getClob(p0: Int): Clob

open override fun getClob(p0: String): Clob

getConnection

open override fun getConnection(): Connection

getDate

open override fun getDate(p0: Int): Date

open override fun getDate(p0: String): Date

open override fun getDate(p0: Int, p1: Calendar): Date

open override fun getDate(p0: String, p1: Calendar): Date

getDouble

open override fun getDouble(p0: Int): Double

open override fun getDouble(p0: String): Double

getFetchDirection

open override fun getFetchDirection(): Int

getFetchSize

open override fun getFetchSize(): Int

getFloat

open override fun getFloat(p0: Int): Float

open override fun getFloat(p0: String): Float

getGeneratedKeys

open override fun getGeneratedKeys(): ResultSet

getGeneratedKeysList

fun <T : Any> getGeneratedKeysList(declaredGeneratedKeys: DeclaredGeneratedKeys<T>, expectedUpdateCount: Int = 0): List<T>

Get a list of one or more keys generated by the insert query.

getInt

open override fun getInt(p0: Int): Int

open override fun getInt(p0: String): Int

getLargeMaxRows

open fun getLargeMaxRows(): Long

getLargeUpdateCount

open fun getLargeUpdateCount(): Long

getLong

open override fun getLong(p0: Int): Long

open override fun getLong(p0: String): Long

getMaxFieldSize

open override fun getMaxFieldSize(): Int

getMaxRows

open override fun getMaxRows(): Int

getMetaData

open override fun getMetaData(): ResultSetMetaData

getMoreResults

open override fun getMoreResults(): Boolean

open override fun getMoreResults(p0: Int): Boolean

getNCharacterStream

open override fun getNCharacterStream(p0: Int): Reader

open override fun getNCharacterStream(p0: String): Reader

getNClob

open override fun getNClob(p0: Int): NClob

open override fun getNClob(p0: String): NClob

getNString

open override fun getNString(p0: Int): String

open override fun getNString(p0: String): String

getObject

open override fun getObject(p0: Int): Any

open override fun getObject(p0: String): Any

open override fun <T : Any> getObject(p0: Int, p1: Class<T>): T

open override fun getObject(p0: Int, p1: MutableMap<String, Class<*>>): Any

open override fun <T : Any> getObject(p0: String, p1: Class<T>): T

open override fun getObject(p0: String, p1: MutableMap<String, Class<*>>): Any

getParameterMetaData

open override fun getParameterMetaData(): ParameterMetaData

getQueryTimeout

open override fun getQueryTimeout(): Int

getRef

open override fun getRef(p0: Int): Ref

open override fun getRef(p0: String): Ref

getResultSet

open override fun getResultSet(): ResultSet

getResultSetConcurrency

open override fun getResultSetConcurrency(): Int

getResultSetHoldability

open override fun getResultSetHoldability(): Int

getResultSetType

open override fun getResultSetType(): Int

getRowId

open override fun getRowId(p0: Int): RowId

open override fun getRowId(p0: String): RowId

getShort

open override fun getShort(p0: Int): Short

open override fun getShort(p0: String): Short

getSQLXML

open override fun getSQLXML(p0: Int): SQLXML

open override fun getSQLXML(p0: String): SQLXML

getString

open override fun getString(p0: Int): String

open override fun getString(p0: String): String

getTime

open override fun getTime(p0: Int): Time

open override fun getTime(p0: String): Time

open override fun getTime(p0: Int, p1: Calendar): Time

open override fun getTime(p0: String, p1: Calendar): Time

getTimestamp

open override fun getTimestamp(p0: Int): Timestamp

open override fun getTimestamp(p0: String): Timestamp

open override fun getTimestamp(p0: Int, p1: Calendar): Timestamp

open override fun getTimestamp(p0: String, p1: Calendar): Timestamp

getUpdateCount

open override fun getUpdateCount(): Int

getURL

open override fun getURL(p0: Int): URL

open override fun getURL(p0: String): URL

getWarnings

open override fun getWarnings(): SQLWarning

isClosed

open override fun isClosed(): Boolean

isCloseOnCompletion

open override fun isCloseOnCompletion(): Boolean

isPoolable

open override fun isPoolable(): Boolean

isSimpleIdentifier

open fun isSimpleIdentifier(p0: String): Boolean

isWrapperFor

open override fun isWrapperFor(p0: Class<*>): Boolean

registerOutParameter

open fun registerOutParameter(p0: Int, p1: SQLType)

open override fun registerOutParameter(p0: Int, p1: Int)

open fun registerOutParameter(p0: String, p1: SQLType)

open override fun registerOutParameter(p0: String, p1: Int)

open fun registerOutParameter(p0: Int, p1: SQLType, p2: Int)

open fun registerOutParameter(p0: Int, p1: SQLType, p2: String)

open override fun registerOutParameter(p0: Int, p1: Int, p2: Int)

open override fun registerOutParameter(p0: Int, p1: Int, p2: String)

open fun registerOutParameter(p0: String, p1: SQLType, p2: Int)

open fun registerOutParameter(p0: String, p1: SQLType, p2: String)

open override fun registerOutParameter(p0: String, p1: Int, p2: Int)

open override fun registerOutParameter(p0: String, p1: Int, p2: String)

setArray

open override fun setArray(p0: Int, p1: Array)

setAsciiStream

open override fun setAsciiStream(p0: String, p1: InputStream)

open override fun setAsciiStream(p0: Int, p1: InputStream)

open override fun setAsciiStream(p0: String, p1: InputStream, p2: Int)

open override fun setAsciiStream(p0: String, p1: InputStream, p2: Long)

open override fun setAsciiStream(p0: Int, p1: InputStream, p2: Int)

open override fun setAsciiStream(p0: Int, p1: InputStream, p2: Long)

setBigDecimal

open override fun setBigDecimal(p0: String, p1: BigDecimal)

open override fun setBigDecimal(p0: Int, p1: BigDecimal)

setBinaryStream

open override fun setBinaryStream(p0: String, p1: InputStream)

open override fun setBinaryStream(p0: Int, p1: InputStream)

open override fun setBinaryStream(p0: String, p1: InputStream, p2: Int)

open override fun setBinaryStream(p0: String, p1: InputStream, p2: Long)

open override fun setBinaryStream(p0: Int, p1: InputStream, p2: Int)

open override fun setBinaryStream(p0: Int, p1: InputStream, p2: Long)

setBlob

open override fun setBlob(p0: String, p1: InputStream)

open override fun setBlob(p0: String, p1: Blob)

open override fun setBlob(p0: Int, p1: InputStream)

open override fun setBlob(p0: Int, p1: Blob)

open override fun setBlob(p0: String, p1: InputStream, p2: Long)

open override fun setBlob(p0: Int, p1: InputStream, p2: Long)

setBoolean

open override fun setBoolean(p0: String, p1: Boolean)

open override fun setBoolean(p0: Int, p1: Boolean)

setByte

open override fun setByte(p0: String, p1: Byte)

open override fun setByte(p0: Int, p1: Byte)

setBytes

open override fun setBytes(p0: String, p1: ByteArray)

open override fun setBytes(p0: Int, p1: ByteArray)

setCharacterStream

open override fun setCharacterStream(p0: String, p1: Reader)

open override fun setCharacterStream(p0: Int, p1: Reader)

open override fun setCharacterStream(p0: String, p1: Reader, p2: Int)

open override fun setCharacterStream(p0: String, p1: Reader, p2: Long)

open override fun setCharacterStream(p0: Int, p1: Reader, p2: Int)

open override fun setCharacterStream(p0: Int, p1: Reader, p2: Long)

setClob

open override fun setClob(p0: String, p1: Reader)

open override fun setClob(p0: String, p1: Clob)

open override fun setClob(p0: Int, p1: Reader)

open override fun setClob(p0: Int, p1: Clob)

open override fun setClob(p0: String, p1: Reader, p2: Long)

open override fun setClob(p0: Int, p1: Reader, p2: Long)

setCursorName

open override fun setCursorName(p0: String)

setDate

open override fun setDate(p0: String, p1: Date)

open override fun setDate(p0: Int, p1: Date)

open override fun setDate(p0: String, p1: Date, p2: Calendar)

open override fun setDate(p0: Int, p1: Date, p2: Calendar)

setDouble

open override fun setDouble(p0: String, p1: Double)

open override fun setDouble(p0: Int, p1: Double)

setEscapeProcessing

open override fun setEscapeProcessing(p0: Boolean)

setFetchDirection

open override fun setFetchDirection(p0: Int)

setFetchSize

open override fun setFetchSize(p0: Int)

setFloat

open override fun setFloat(p0: String, p1: Float)

open override fun setFloat(p0: Int, p1: Float)

setInt

open override fun setInt(p0: String, p1: Int)

open override fun setInt(p0: Int, p1: Int)

setLargeMaxRows

open fun setLargeMaxRows(p0: Long)

setLong

open override fun setLong(p0: String, p1: Long)

open override fun setLong(p0: Int, p1: Long)

setMaxFieldSize

open override fun setMaxFieldSize(p0: Int)

setMaxRows

open override fun setMaxRows(p0: Int)

setNCharacterStream

open override fun setNCharacterStream(p0: String, p1: Reader)

open override fun setNCharacterStream(p0: Int, p1: Reader)

open override fun setNCharacterStream(p0: String, p1: Reader, p2: Long)

open override fun setNCharacterStream(p0: Int, p1: Reader, p2: Long)

setNClob

open override fun setNClob(p0: String, p1: Reader)

open override fun setNClob(p0: String, p1: NClob)

open override fun setNClob(p0: Int, p1: Reader)

open override fun setNClob(p0: Int, p1: NClob)

open override fun setNClob(p0: String, p1: Reader, p2: Long)

open override fun setNClob(p0: Int, p1: Reader, p2: Long)

setNString

open override fun setNString(p0: String, p1: String)

open override fun setNString(p0: Int, p1: String)

setNull

open override fun setNull(p0: String, p1: Int)

open override fun setNull(p0: Int, p1: Int)

open override fun setNull(p0: String, p1: Int, p2: String)

open override fun setNull(p0: Int, p1: Int, p2: String)

setObject

open override fun setObject(p0: String, p1: Any)

open override fun setObject(p0: Int, p1: Any)

open fun setObject(p0: String, p1: Any, p2: SQLType)

open override fun setObject(p0: String, p1: Any, p2: Int)

open fun setObject(p0: Int, p1: Any, p2: SQLType)

open override fun setObject(p0: Int, p1: Any, p2: Int)

open fun setObject(p0: String, p1: Any, p2: SQLType, p3: Int)

open override fun setObject(p0: String, p1: Any, p2: Int, p3: Int)

open fun setObject(p0: Int, p1: Any, p2: SQLType, p3: Int)

open override fun setObject(p0: Int, p1: Any, p2: Int, p3: Int)

setParameter

fun setParameter(name: String, value: Any?): NpStatement

Set a parameter by name

setParametersByDto

fun setParametersByDto(dto: Any): NpStatement

Set parameter(s) using a data object (DTO)

setParametersByMap

fun setParametersByMap(valueMap: Map<String, Any?>): NpStatement

Set parameter(s) using a map of case-insensitive names and values

setPoolable

open override fun setPoolable(p0: Boolean)

setQueryTimeout

open override fun setQueryTimeout(p0: Int)

setRef

open override fun setRef(p0: Int, p1: Ref)

setRowId

open override fun setRowId(p0: String, p1: RowId)

open override fun setRowId(p0: Int, p1: RowId)

setShort

open override fun setShort(p0: String, p1: Short)

open override fun setShort(p0: Int, p1: Short)

setSQLXML

open override fun setSQLXML(p0: String, p1: SQLXML)

open override fun setSQLXML(p0: Int, p1: SQLXML)

setString

open override fun setString(p0: String, p1: String)

open override fun setString(p0: Int, p1: String)

setTime

open override fun setTime(p0: String, p1: Time)

open override fun setTime(p0: Int, p1: Time)

open override fun setTime(p0: String, p1: Time, p2: Calendar)

open override fun setTime(p0: Int, p1: Time, p2: Calendar)

setTimestamp

open override fun setTimestamp(p0: String, p1: Timestamp)

open override fun setTimestamp(p0: Int, p1: Timestamp)

open override fun setTimestamp(p0: String, p1: Timestamp, p2: Calendar)

open override fun setTimestamp(p0: Int, p1: Timestamp, p2: Calendar)

setUnicodeStream

open override fun ~~setUnicodeStream~~(p0: Int, p1: InputStream, p2: Int)

setURL

open override fun setURL(p0: String, p1: URL)

open override fun setURL(p0: Int, p1: URL)

unwrap

open override fun <T : Any> unwrap(p0: Class<T>): T

useExecuteLargeUpdate

fun useExecuteLargeUpdate(): Long

Execute the statement and close it.

useExecuteQuery

fun <T> useExecuteQuery(resultSetToValue: (rs: ResultSet) -> T): T

Execute the statement, execute resultSetToValue function and finally close the statement

useExecuteUpdate

fun useExecuteUpdate(): Int

Execute the statement and close it.

useExecuteUpdateWithGeneratedKeys

fun <T : Any> useExecuteUpdateWithGeneratedKeys(declaredGeneratedKeys: DeclaredGeneratedKeys<T>): List<T>

Execute update and get the auto generated key(s) as a list, then close the statement.

wasNull

open override fun wasNull(): Boolean

Properties

query

val query: NamedParameterQuery

statement

val statement: PreparedStatement