StatementMethods

little.sql.StatementMethods$package.StatementMethods
final implicit class StatementMethods(statement: Statement) extends AnyVal

Provides extension methods for java.sql.Statement.

Attributes

See also

PreparedStatementMethods

Graph
Supertypes
class AnyVal
trait Matchable
class Any

Members list

Value members

Concrete methods

def execute[T](sql: String)(f: Execution => T): T

Executes SQL and passes result to supplied function.

Executes SQL and passes result to supplied function.

Value parameters

f

function

sql

SQL statement

Attributes

def first[T](sql: String)(f: ResultSet => T): Option[T]

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

Executes query 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

function

sql

SQL query

Attributes

def flatMap[T](sql: String)(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

sql

SQL query

Attributes

def foreach(sql: String)(f: ResultSet => Unit): Unit

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

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

Value parameters

f

function

sql

SQL query

Attributes

def map[T](sql: String)(f: ResultSet => T): Seq[T]

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

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

Value parameters

f

map function

params

parameters

sql

SQL query

Attributes

def query[T](sql: String)(f: ResultSet => T): T

Executes query and passes result set to supplied function.

Executes query and passes result set to supplied function.

Value parameters

f

function

sql

SQL query

Attributes

def update[T](sql: String)(f: Long => T): T

Executes update and passes update count to supplied function.

Executes update and passes update count to supplied function.

Value parameters

f

function

sql

SQL query

Attributes