trait QueryBuilder extends AnyRef
Provides interface to incrementally build and execute SQL statements.
QueryBuilder
is an immutable structure. A new builder is returned with each
requested modification, and a new statement and result set are created on
each requested execution.
import java.sql.Connection import little.sql.Implicits._ import little.sql.QueryBuilder implicit val conn: Connection = ??? QueryBuilder("select * from users where group = ? and enabled = ?") .params("staff", true) // Set input parameter values .maxRows(10) // Limit result set to 10 rows .foreach { rs => printf(s"uid=%d%n", rs.getInt("id")) } // Use implicit connection
- Alphabetic
- By Inheritance
- QueryBuilder
- AnyRef
- Any
- Hide All
- Show All
- Public
- All
Abstract Value Members
-
abstract
def
execute[T](handler: (Execution) ⇒ T)(implicit conn: Connection): T
Executes statement and passes result to supplied handler.
Executes statement and passes result to supplied handler.
- handler
execution handler
- conn
connection to execute statement
-
abstract
def
fetchSize(value: Int): QueryBuilder
Sets fetch size.
-
abstract
def
fetchSize: Int
Gets fetch size.
-
abstract
def
first[T](f: (ResultSet) ⇒ T)(implicit conn: Connection): 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.- f
function
- conn
connection to execute query
-
abstract
def
flatMap[T](f: (ResultSet) ⇒ GenTraversableOnce[T])(implicit conn: Connection): Seq[T]
Executes query and builds collection using elements mapped from each row of result set.
Executes query and builds collection using elements mapped from each row of result set.
- f
map function
- conn
connection to execute query
-
abstract
def
fold[T](init: T)(op: (T, ResultSet) ⇒ T)(implicit conn: Connection): T
Executes query and folds result set to single value using given initial value and binary operator.
Executes query and folds result set to single value using given initial value and binary operator.
- init
initial value
- op
binary operator
- conn
connection to execute query
-
abstract
def
foreach(f: (ResultSet) ⇒ Unit)(implicit conn: Connection): 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.
- f
function
- conn
connection to execute query
-
abstract
def
getUpdateCount(implicit conn: Connection): Long
Executes update and returns update count.
Executes update and returns update count.
- conn
connection to execute update
-
abstract
def
map[T](f: (ResultSet) ⇒ T)(implicit conn: Connection): 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.
- f
map function
- conn
connection to execute query
-
abstract
def
maxRows(value: Int): QueryBuilder
Sets max rows.
-
abstract
def
maxRows: Int
Gets max rows.
-
abstract
def
params(values: InParam*): QueryBuilder
Sets parameters.
-
abstract
def
params: Seq[InParam]
Gets parameters.
-
abstract
def
queryTimeout(value: Int): QueryBuilder
Sets query timeout.
-
abstract
def
queryTimeout: Int
Gets query timeout.
-
abstract
def
sql: String
Gets SQL.
-
abstract
def
withResultSet[T](handler: (ResultSet) ⇒ T)(implicit conn: Connection): T
Executes query and passes result set to supplied handler.
Executes query and passes result set to supplied handler.
- handler
result set handler
- conn
connection to execute query
Concrete Value Members
-
final
def
!=(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
final
def
##(): Int
- Definition Classes
- AnyRef → Any
-
final
def
==(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
final
def
asInstanceOf[T0]: T0
- Definition Classes
- Any
-
def
clone(): AnyRef
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )
-
final
def
eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
def
equals(arg0: Any): Boolean
- Definition Classes
- AnyRef → Any
-
def
finalize(): Unit
- Attributes
- protected[java.lang]
- Definition Classes
- AnyRef
- Annotations
- @throws( classOf[java.lang.Throwable] )
-
final
def
getClass(): Class[_]
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
-
def
hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @native()
-
final
def
isInstanceOf[T0]: Boolean
- Definition Classes
- Any
-
final
def
ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
-
final
def
notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
final
def
notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @native()
-
final
def
synchronized[T0](arg0: ⇒ T0): T0
- Definition Classes
- AnyRef
-
def
toString(): String
- Definition Classes
- AnyRef → Any
-
final
def
wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws( ... )
-
final
def
wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @native() @throws( ... )