Scala 数据库访问库:Scala Slick

jopen 10年前

Slick 是 TypeSafe 推出的 Scala 数据库访问库。开发者可以使用 Scala 语言风格来编写数据查询,而不是用 SQL,
 Scala 数据库访问库:Scala Slick
示例代码:

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) }


 

项目主页:http://www.open-open.com/lib/view/home/1360763519984