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