DB

Basic Database Accessor

You can start with DB and blocks if using scalikejdbc.ConnectionPool.singleton.

Using DBSession:

 ConnectionPool.singleton("jdbc:...","user","password")
 case class User(id: Int, name: String)

 val users = DB readOnly { session =>
   session.list("select * from user") { rs =>
     User(rs.int("id"), rs.string("name"))
   }
 }

 DB autoCommit { session =>
   session.update("insert into user values (?,?)", 123, "Alice")
 }

 DB localTx { session =>
   session.update("insert into user values (?,?)", 123, "Alice")
 }

 using(DB(ConnectionPool.borrow())) { db =>
   db.begin()
   try {
     DB withTx { session =>
       session.update("update user set name = ? where id = ?", "Alice", 123)
     }
     db.commit()
   } catch { case e =>
     db.rollbackIfActive()
     throw e
   }
 }

Using SQL:

 ConnectionPool.singleton("jdbc:...","user","password")
 case class User(id: Int, name: String)

 val users = DB readOnly { implicit session =>
   SQL("select * from user").map { rs =>
     User(rs.int("id"), rs.string("name"))
   }.list.apply()
 }

 DB autoCommit { implicit session =>
   SQL("insert into user values (?,?)").bind(123, "Alice").update.apply()
 }

 DB localTx { implicit session =>
   SQL("insert into user values (?,?)").bind(123, "Alice").update.apply()
 }

 using(DB(ConnectionPool.borrow())) { db =>
   db.begin()
   try {
     DB withTx { implicit session =>
       SQL("update user set name = ? where id = ?").bind("Alice", 123).update.apply()
     }
     db.commit()
   } catch { case e =>
     db.rollbackIfActive()
     throw e
   }
 }