Slide 15
Slide 15 text
DSL APIの例
fun main(args: Array) {
//an example connection to H2 DB
Database.connect("jdbc:h2:mem:test", driver = "org.h2.Driver")
transaction {
// insert new city. SQL: INSERT INTO Cities (name) VALUES ('St. Petersburg')
val stPeteId = Cities.insert {
it[name] = "St. Petersburg"
} get Cities.id
// 'select *' SQL: SELECT Cities.id, Cities.name FROM Cities
println("Cities: ${Cities.selectAll()}")
}
}
object Cities: IntIdTable() {
val name = varchar("name", 50)
}
15
出典 | https://github.com/JetBrains/Exposed/wiki/Getting-Started