Packages

•  package 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()
  }

root package 