Packages

•  package root

  Definition Classes

  root

•  package scalikejdbc

  ScalikeJDBC - SQL-Based DB Access Library for Scala

  ScalikeJDBC - SQL-Based DB Access Library for Scala

  Just write SQL:

  ScalikeJDBC is a SQL-based DB access library for Scala developers. This library naturally wraps JDBC APIs and provides you easy-to-use APIs. Users do nothing other than writing SQL and mapping from java.sql.ResultSet objects to Scala values.

  Basic Usage:

  Using scalikejdbc.DBSession:

  import scalikejdbc._
  import org.joda.time.DateTime
  case class User(id: Long, name: String, birthday: Option[DateTime])
  
  val activeUsers: List[User] = DB readOnly { session =>
    session.list("select * from users where active = ?", true) { rs =>
      User(id = rs.long("id"), name = rs.string("name"), birthday = Option(rs.date("birthday")).map(_.toJodaDateTime))
    }
  }

  Using scalikejdbc.SQL:

  import scalikejdbc._
  import org.joda.time.DateTime
  case class User(id: Long, name: String, birthday: Option[DateTime])
  
  val activeUsers: List[User] = DB readOnly { implicit session =>
    SQL("select * from users where active = ?")
      .bind(true)
      .map { rs => User(id = rs.long("id"), name = rs.string("name"), birthday = Option(rs.date("birthday")).map(_.toJodaDateTime)) }.list.apply()
  }

  or

  val activeUsers: List[User] = DB readOnly { implicit session =>
    SQL("select * from users where active = /*'active*/true")
      .bindByName('active -> true)
      .map { rs => User(id = rs.long("id"), name = rs.string("name"), birthday = Option(rs.date("birthday")).map(_.toJodaDateTime)) }.list.apply()
  }

  Definition Classes

  root

• BasicResultNameSQLSyntaxProvider
• ColumnSQLSyntaxProvider
• ConditionSQLBuilder
• DeleteSQLBuilder
• ExceptQuerySQLBuilder
• ForUpdateQuerySQLBuilder
• GroupBySQLBuilder
• InsertSQLBuilder
• IntersectQuerySQLBuilder
• PagingSQLBuilder
• PartialResultSQLSyntaxProvider
• PartialSubQueryResultNameSQLSyntaxProvider
• PartialSubQueryResultSQLSyntaxProvider
• PartialSubQuerySQLSyntaxProvider
• QuerySQLSyntaxProvider
• ResultNameSQLSyntaxProvider
• ResultSQLSyntaxProvider
• SQLBuilder
• SQLSyntaxProvider
• SQLSyntaxSupport
• SelectSQLBuilder
• SubQueryResultNameSQLSyntaxProvider
• SubQueryResultSQLSyntaxProvider
• SubQuerySQLBuilder
• SubQuerySQLSyntaxProvider
• TableAsAliasSQLSyntax
• TableDefSQLSyntax
• UnionQuerySQLBuilder
• UpdateOperation
• UpdateSQLBuilder
• WhereSQLBuilder

scalikejdbc