当前位置: 首页 > 工具软件 > Squeryl > 使用案例 >

play 集成squeryl ORM持久化框架

顾俊茂
2023-12-01

The recommended version is 0.9.5-6

Supported Scala versions are 2.10.0, 2.9.2, 2.9.1, 2.9.0, 2.8.1 and 2.8.0

SBT

After having setup your project to use SBT (see how to setup SBT)
Declare the Squeryl dependency in the SBT project definiition

01libraryDependencies  ++=  Seq(
02  "org.squeryl" %% "squeryl" % "0.9.5-6",
03  yourDatabaseDependency
04)
05  
06//yourDatabaseDependency is one of the supported databases :
07 
08val h2 = "com.h2database" % "h2" % "1.2.127"
09val mysqlDriver = "mysql" % "mysql-connector-java" % "5.1.10"
10val posgresDriver = "postgresql" % "postgresql" % "8.4-701.jdbc4"
11val msSqlDriver = "net.sourceforge.jtds" % "jtds" % "1.2.4"
12val derbyDriver = "org.apache.derby" % "derby" % "10.7.1.1"

Note : The Oracle driver is not available via SBT/Maven, you will have to downloaded manually.

The remaining steps are :

  1. Bootstrap the session factory
  2. Define, and initialise a schema

You should now be ready to insert, update, delete data, and of course run queries.

Manual dependency management

If you want to manage your dependencies without SBT or Maven, you will need the following jars :

  • The Scala runtime jar, version 2.10.0, 2.9.2, 2.9.1 (or 2.9.0, 2.8.1, 2.8.0)
  • The Squeryl jar found here
  • The CGLIB cglib-nodep-2.2.jar, found here
  • A JDBC driver for your database, see supported databases
 类似资料: