PreparedStatementMethods

little.sql.PreparedStatementMethods$package.PreparedStatementMethods
final implicit class PreparedStatementMethods(statement: PreparedStatement) extends AnyVal

Provides extension methods for java.sql.PreparedStatement.

Attributes

See also

StatementMethods

Graph
Supertypes
class AnyVal
trait Matchable
class Any

Members list

Value members

Concrete methods

def addBatch(params: Seq[InParam]): Unit

Adds parameters to batch of commands.

Adds parameters to batch of commands.

Value parameters

params

parameters

Attributes

def execute[T](params: Seq[InParam])(f: Execution => T): T

Sets parameters, executes statement, and passes result to supplied function.

Sets parameters, executes statement, and passes result to supplied function.

Value parameters

f

function

params

parameters

Attributes

def first[T](params: Seq[InParam])(f: ResultSet => T): Option[T]

Executes query with parameters and maps first row of result set using supplied function.

Executes query with parameters and maps first row of result set using supplied function.

If the result set is not empty, and if the supplied function's return value is not null, then Some value is returned; otherwise, None is returned.

Value parameters

f

map function

params

parameters

Attributes

def flatMap[T](params: Seq[InParam])(f: ResultSet => Iterable[T]): Seq[T]

Executes query and builds a collection using the elements mapped from each row of result set.

Executes query and builds a collection using the elements mapped from each row of result set.

Value parameters

f

map function

params

parameters

Attributes

def foreach(params: Seq[InParam])(f: ResultSet => Unit): Unit

Executes query with parameters and invokes supplied function for each row of result set.

Executes query with parameters and invokes supplied function for each row of result set.

Value parameters

f

function

params

parameters

Attributes

def map[T](params: Seq[InParam])(f: ResultSet => T): Seq[T]

Executes query with parameters and maps each row of result set using supplied function.

Executes query with parameters and maps each row of result set using supplied function.

Value parameters

f

map function

params

parameters

Attributes

def query[T](params: Seq[InParam])(f: ResultSet => T): T

Sets parameters, executes query, and passes result set to supplied function.

Sets parameters, executes query, and passes result set to supplied function.

Value parameters

f

function

params

parameters

Attributes

def set(index: Int, value: InParam): Unit

Sets parameter at index to given value.

Sets parameter at index to given value.

Value parameters

index

parameter index

value

parameter value

Attributes

def set(params: Seq[InParam]): Unit

Sets parameters.

Sets parameters.

Value parameters

index

parameter index

value

parameter value

Attributes

def setInstant(index: Int, value: Instant): Unit

Sets parameter to given Instant.

Sets parameter to given Instant.

Value parameters

index

parameter index

value

parameter value

Attributes

def setLocalDate(index: Int, value: LocalDate): Unit

Sets parameter to given LocalDate.

Sets parameter to given LocalDate.

Value parameters

index

parameter index

value

parameter value

Attributes

def setLocalDateTime(index: Int, value: LocalDateTime): Unit

Sets parameter to given LocalDateTime.

Sets parameter to given LocalDateTime.

Value parameters

index

parameter index

value

parameter value

Attributes

def setLocalTime(index: Int, value: LocalTime): Unit

Sets parameter to given LocalTime.

Sets parameter to given LocalTime.

Value parameters

index

parameter index

value

parameter value

Attributes

def update[T](params: Seq[InParam])(f: Long => T): T

Sets parameters, executes update, and passes update count to supplied function.

Sets parameters, executes update, and passes update count to supplied function.

Value parameters

f

function

params

parameters

Attributes