Begins a auto-commit block easily with ConnectionPool.
Begins a auto-commit block easily with ConnectionPool.
return type
execution
connection pool context
result value
Returns auto-commit session instance.
Returns auto-commit session instance. You SHOULD close this instance by yourself.
connection pool context
session
Begins a auto-commit block easily with ConnectionPool and pass not session but connection to execution block.
Begins a auto-commit block easily with ConnectionPool and pass not session but connection to execution block.
return type
execution
connection pool context
result value
Get a connection and returns a DB instance.
Get a connection and returns a DB instance.
connection
DB instance
Returns a DB instance by using an implicit Connection object.
Returns a DB instance by using an implicit Connection object.
connection
DB instance
Returns describe style string value for the table
Returns describe style string value for the table
table name (with schema optionally)
connection pool context as implicit parameter
described information
Returns all the table names
Returns all the table names
connection pool context as implicit parameter
table information
Returns table information
Returns table information
table name (with schema optionally)
connection pool context as implicit parameter
table information
Returns multiple table information
Returns multiple table information
table name pattern (with schema optionally)
connection pool context as implicit parameter
table information
Begins a local-tx block easily with ConnectionPool.
Begins a local-tx block easily with ConnectionPool.
return type
execution
connection pool context
result value
Begins a local-tx block easily with ConnectionPool and pass not session but connection to execution block.
Begins a local-tx block easily with ConnectionPool and pass not session but connection to execution block.
return type
execution
connection pool context
result value
Begins a read-only block easily with ConnectionPool.
Begins a read-only block easily with ConnectionPool.
return type
execution
connection pool context
result value
Returns read-only session instance.
Returns read-only session instance. You SHOULD close this instance by yourself.
connection pool context
session
Begins a read-only block easily with ConnectionPool and pass not session but connection to execution block.
Begins a read-only block easily with ConnectionPool and pass not session but connection to execution block.
return type
execution
connection pool context
result value
Returns table name list
Returns table name list
table name pattern (with schema optionally)
connection pool context as implicit parameter
table name list
Begins a within-tx block easily with a DB instance as an implicit parameter.
Begins a within-tx block easily with a DB instance as an implicit parameter.
return type
execution
DB instance as an implicit parameter
result value
Returns within-tx session instance.
Returns within-tx session instance. You SHOULD close this instance by yourself.
DB instance as an implicit parameter
session
Begins a within-tx block easily with a DB instance as an implicit parameter and pass not session but connection to execution block.
Begins a within-tx block easily with a DB instance as an implicit parameter and pass not session but connection to execution block.
return type
execution
DB instance as an implicit parameter
result value
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 { session => SQL("select * from user").map { rs => User(rs.int("id"), rs.string("name")) }.list.apply() } DB autoCommit { session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } DB localTx { session => SQL("insert into user values (?,?)").bind(123, "Alice").update.apply() } using(DB(ConnectionPool.borrow())) { db => db.begin() try { DB withTx { session => SQL("update user set name = ? where id = ?").bind("Alice", 123).update.apply() } db.commit() } catch { case e => db.rollbackIfActive() throw e } }