db9010 / com.jovial.db9010 / ReusableGenericStatement

ReusableGenericStatement

class ReusableGenericStatement

A generic statement that can be stored in a variable, and used multipe times. This saves the (small) overhead of a hash table lookup that's incurred when using Database.statement every time the same statement is run.

Functions

run

Call setBody to set any statement Parameter values, then call PreparedStatement.execute to run the SQL statement. If setBody sets a value for GenericStatement.resultHandler, call that with the result of PreparedStatement.execute.

infix fun run(setBody: (GenericStatement) -> Unit): Unit