scalikejdbc

DBSession

trait DBSession extends LogSupport

DB Session

This class provides readOnly/autoCommit/localTx/withinTx blocks and session objects.

import scalikejdbc._

val userIdList = DB autoCommit { session: DBSession =>
  session.list("select * from user") { rs => rs.int("id") }
}
Linear Supertypes
LogSupport, AnyRef, Any
Known Subclasses
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. Hide All
  2. Show all
  1. DBSession
  2. LogSupport
  3. AnyRef
  4. Any
Visibility
  1. Public
  2. All

Abstract Value Members

  1. val isReadOnly : Boolean

    is read-only session

    is read-only session

    Attributes
    abstract

Concrete Value Members

  1. def != (arg0: AnyRef): Boolean

    Attributes
    final
    Definition Classes
    AnyRef
  2. def != (arg0: Any): Boolean

    Attributes
    final
    Definition Classes
    Any
  3. def ## (): Int

    Attributes
    final
    Definition Classes
    AnyRef → Any
  4. def == (arg0: AnyRef): Boolean

    Attributes
    final
    Definition Classes
    AnyRef
  5. def == (arg0: Any): Boolean

    Attributes
    final
    Definition Classes
    Any
  6. def asInstanceOf [T0] : T0

    Attributes
    final
    Definition Classes
    Any
  7. def batch (template: String, paramsList: Seq[Any]*): Seq[Int]

    Executes java.

    Executes java.sql.PreparedStatement#executeBatch().

    template

    SQL template

    paramsList

    list of parameters

    returns

    count list

  8. def clone (): AnyRef

    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws()
  9. def close (): Unit

    Close the connection.

  10. lazy val connection : Connection

    Connection

  11. def eq (arg0: AnyRef): Boolean

    Attributes
    final
    Definition Classes
    AnyRef
  12. def equals (arg0: Any): Boolean

    Definition Classes
    AnyRef → Any
  13. def execute (template: String, params: Any*): Boolean

    Executes java.

    Executes java.sql.PreparedStatement#execute().

    template

    SQL template

    params

    parameters

    returns

    flag

  14. def executeUpdate (template: String, params: Any*): Int

    Executes java.

    Executes java.sql.PreparedStatement#executeUpdate().

    template

    SQL template

    params

    parameters

    returns

    result count

  15. def executeWithFilters (before: (PreparedStatement) ⇒ Unit, after: (PreparedStatement) ⇒ Unit, template: String, params: Any*): Boolean

    Executes java.

    Executes java.sql.PreparedStatement#execute().

    before

    before filter

    after

    after filter

    template

    SQL template

    params

    parameters

    returns

    flag

  16. def finalize (): Unit

    Attributes
    protected[lang]
    Definition Classes
    AnyRef
    Annotations
    @throws()
  17. def first [A] (template: String, params: Any*)(extract: (WrappedResultSet) ⇒ A): Option[A]

    Returns the first row optionally.

    Returns the first row optionally.

    A

    return type

    template

    SQL template

    params

    parameters

    extract

    extract function

    returns

    result optionally

  18. def foldLeft [A] (template: String, params: Any*)(z: A)(op: (A, WrappedResultSet) ⇒ A): A

    folding into one value.

    folding into one value.

    template

    SQL template

    params

    parameters

    z

    initial value

    op

    function

    returns

    folded value

  19. def foreach (template: String, params: Any*)(f: (WrappedResultSet) ⇒ Unit): Unit

    Applies side-effect to each row iteratively.

    Applies side-effect to each row iteratively.

    template

    SQL template

    params

    parameters

    f

    function

    returns

    result as list

  20. def getClass (): java.lang.Class[_]

    Attributes
    final
    Definition Classes
    AnyRef → Any
  21. def hashCode (): Int

    Definition Classes
    AnyRef → Any
  22. def isInstanceOf [T0] : Boolean

    Attributes
    final
    Definition Classes
    Any
  23. def list [A] (template: String, params: Any*)(extract: (WrappedResultSet) ⇒ A): List[A]

    Returns query result as scala.

    Returns query result as scala.List object.

    A

    return type

    template

    SQL template

    params

    parameters

    extract

    extract function

    returns

    result as list

  24. val log : Log

    Logger

    Logger

    Attributes
    protected
    Definition Classes
    LogSupport
  25. def ne (arg0: AnyRef): Boolean

    Attributes
    final
    Definition Classes
    AnyRef
  26. def notify (): Unit

    Attributes
    final
    Definition Classes
    AnyRef
  27. def notifyAll (): Unit

    Attributes
    final
    Definition Classes
    AnyRef
  28. def single [A] (template: String, params: Any*)(extract: (WrappedResultSet) ⇒ A): Option[A]

    Returns single result optionally.

    Returns single result optionally. If the result is not single, TooManyRowsException will be thrown.

    A

    return type

    template

    SQL template

    params

    parameters

    extract

    extract function

    returns

    result optionally

  29. def synchronized [T0] (arg0: ⇒ T0): T0

    Attributes
    final
    Definition Classes
    AnyRef
  30. def toString (): String

    Definition Classes
    AnyRef → Any
  31. def traversable [A] (template: String, params: Any*)(extract: (WrappedResultSet) ⇒ A): Traversable[A]

    Returns query result as scala.

    Returns query result as scala.collection.Traversable object.

    A

    return type

    template

    SQL template

    params

    parameters

    extract

    extract function

    returns

    result as traversable

  32. def update (template: String, params: Any*): Int

    Executes java.

    Executes java.sql.PreparedStatement#executeUpdate().

    template

    SQL template

    params

    parameters

    returns

    result count

  33. def updateAndReturnGeneratedKey (template: String, params: Any*): Long

    Executes java.

    Executes java.sql.PreparedStatement#executeUpdate() and returns the generated key.

    template

    SQL template

    params

    parameters

    returns

    generated key as a long value

  34. def updateAndReturnSpecifiedGeneratedKey (template: String, params: Any*)(key: Any): Long

    Executes java.

    Executes java.sql.PreparedStatement#executeUpdate() and returns the generated key.

    template

    SQL template

    params

    parameters

    key

    name

    returns

    generated key as a long value

  35. def updateWithFilters (returnGeneratedKeys: Boolean, before: (PreparedStatement) ⇒ Unit, after: (PreparedStatement) ⇒ Unit, template: String, params: Any*): Int

    Executes java.

    Executes java.sql.PreparedStatement#executeUpdate().

    returnGeneratedKeys

    is generated keys required

    before

    before filter

    after

    after filter

    template

    SQL template

    params

    parameters

    returns

    result count

  36. def updateWithFilters (before: (PreparedStatement) ⇒ Unit, after: (PreparedStatement) ⇒ Unit, template: String, params: Any*): Int

    Executes java.

    Executes java.sql.PreparedStatement#executeUpdate().

    before

    before filter

    after

    after filter

    template

    SQL template

    params

    parameters

    returns

    result count

  37. def wait (): Unit

    Attributes
    final
    Definition Classes
    AnyRef
    Annotations
    @throws()
  38. def wait (arg0: Long, arg1: Int): Unit

    Attributes
    final
    Definition Classes
    AnyRef
    Annotations
    @throws()
  39. def wait (arg0: Long): Unit

    Attributes
    final
    Definition Classes
    AnyRef
    Annotations
    @throws()

Inherited from LogSupport

Inherited from AnyRef

Inherited from Any