Packages

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
Linear Supertypes
AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. QueryBuilder
  2. AnyRef
  3. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Abstract Value Members

  1. 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

  2. abstract def fetchSize(value: Int): QueryBuilder

    Sets fetch size.

  3. abstract def fetchSize: Int

    Gets fetch size.

  4. 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

  5. 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

  6. 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

  7. 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

  8. abstract def getUpdateCount(implicit conn: Connection): Long

    Executes update and returns update count.

    Executes update and returns update count.

    conn

    connection to execute update

  9. 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

  10. abstract def maxRows(value: Int): QueryBuilder

    Sets max rows.

  11. abstract def maxRows: Int

    Gets max rows.

  12. abstract def params(values: InParam*): QueryBuilder

    Sets parameters.

  13. abstract def params: Seq[InParam]

    Gets parameters.

  14. abstract def queryTimeout(value: Int): QueryBuilder

    Sets query timeout.

  15. abstract def queryTimeout: Int

    Gets query timeout.

  16. abstract def sql: String

    Gets SQL.

  17. 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

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  5. def clone(): AnyRef
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @native() @throws( ... )
  6. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  7. def equals(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  8. def finalize(): Unit
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  9. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  10. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  11. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  12. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  13. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  14. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  15. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  16. def toString(): String
    Definition Classes
    AnyRef → Any
  17. final def wait(): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  18. final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  19. final def wait(arg0: Long): Unit
    Definition Classes
    AnyRef
    Annotations
    @native() @throws( ... )

Inherited from AnyRef

Inherited from Any

Ungrouped