NpStatement

Functions

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

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.

Set a parameter by name

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

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

Execute the statement and close it.

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

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

Execute the statement and close it.

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