Scala 数据库访问库:Scala Slick
jopen
12年前
Slick 是 TypeSafe 推出的 Scala 数据库访问库。开发者可以使用 Scala 语言风格来编写数据查询,而不是用 SQL,
示例代码:
object Coffees extends Table[(String, Int, Double)]("COFFEES") { def name = column[String]("COF_NAME", O.PrimaryKey) def supID = column[Int]("SUP_ID") def price = column[Double]("PRICE") def * = name ~ supID ~ price } Coffees.insertAll( ("Colombian", 101, 7.99), ("Colombian_Decaf", 101, 8.99), ("French_Roast_Decaf", 49, 9.99) ) val q = for { c <- Coffees if c.supID === 101 // ^ comparing Rep[Int] to Rep[Int]! } yield (c.name, c.price) println(q.selectStatement) q.foreach { case (n, p) => println(n + ": " + p) }