---- class Person { @DBField var id: Int = 0 @DBField var name: String = "" @DBField var udate: Date = null @DBField var utime: Date = null override def toString = "Person(" + ... }
val db = new DBFlavor( classOf[org.apache.derby.jdbc.EmbeddedDriver], "jdbc:derby:DB/TestDB;create=true")
db.execute( "CREATE TABLE PERSON(id int primary key, name varchar(255), udate date, utime time)")
for ((id, name) <- List((1, "Foo"), (2, 'Boo), (3, "Bar"))) db.execute("INSERT INTO PERSON(id, name, udate, utime) VALUES(?, ?, ?, ?)", id, name, new Date, new Date)
for (row <- db.executeQueryObject( "SELECT id, name, udate, utime FROM PERSON", classOf[Person])) println(row)