p
root package
package root
Package Members
- 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() }
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:
Using scalikejdbc.SQL:
or