play 集成squeryl ORM持久化框架

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

01	libraryDependencies  ++=  Seq(

02	"org.squeryl" %% "squeryl" % "0.9.5-6",

03	yourDatabaseDependency

04

)

05

06	//yourDatabaseDependency is one of the supported databases :

07

08	val h2 = "com.h2database" % "h2" % "1.2.127"

09	val mysqlDriver = "mysql" % "mysql-connector-java" % "5.1.10"

10	val posgresDriver = "postgresql" % "postgresql" % "8.4-701.jdbc4"

11	val msSqlDriver = "net.sourceforge.jtds" % "jtds" % "1.2.4"

12	val 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