2.1 Session
2.2 Entity
2.3 Query
2.4 Schema
<dependency>
<groupId>org.squeryl</groupId>
<artifactId>squeryl_2.13</artifactId>
<version>0.9.11</version>
</dependency>
import org.squeryl.annotations._
class User(
@Column("user_id") val id: Long,
@Column("user_name") val name: String
) extends KeyedEntity[Long]
import org.squeryl.Schema
object MySchema extends Schema {
val users = table[User]("users")
}
import org.squeryl._
import org.squeryl.PrimitiveTypeMode._
object Main {
def main(args: Array[String]) {
val session = Session.create(
java.sql.DriverManager.getConnection("jdbc:mysql://localhost/mydatabase", "username", "password"),
new MySQLAdapter)
inTransaction {
MySchema.users.insert(new User(1, "Alice"))
MySchema.users.insert(new User(2, "Bob"))
}
session.close()
}
}
