官术网_书友最值得收藏!

CRUD operations

The following code snippet shows an example of how to do create, read, update, delete (CRUD) operations with Exposed:

    transaction {

// Insert new message Messages.insert {
it[name] = "Hello Kotlin Developers!"
}

// Update an existing message
Messages.update({Users.id eq 1}) {
it[name] = "Hello Spring-Kotlin Developers"
}
// Delete the messages table drop(Messages) }

It results in the following queries:

    INSERT INTO Messages (name) VALUES ('Hello Kotlin Developers!')
UPDATE Messages SET name='Hello Spring-Kotlin Developers' WHERE
Messages.id = 1
DROP TABLE Messages

Get all the users from the database:

    for (message in Messages.selectAll()) {
println("$message[Messages.name]}")
}

It will result in the following query:

    SELECT Messages.name FROM Messages;

Now it must be pretty clear how to use the Exposed library for Spring and how it works internally.

The reason for using the Exposed library instead of Spring JPA is because, at the time of writing, there is no official support for Kotlin data classes and JPA, that is Spring Data JPA.  JetBrains noticed this and they released their own SQL ORM library called Exposed.
Read more at https://github.com/JetBrains/Exposed.

主站蜘蛛池模板: 陇西县| 逊克县| 成安县| 泗阳县| 金平| 百色市| 溧水县| 湘乡市| 黎平县| 闻喜县| 五常市| 永安市| 闸北区| 马鞍山市| 天柱县| 英山县| 龙游县| 仁寿县| 四会市| 壤塘县| 涪陵区| 邳州市| 博兴县| 潮州市| 通道| 弥渡县| 新和县| 岐山县| 黎城县| 德格县| 奉新县| 青浦区| 贵阳市| 永清县| 得荣县| 宝鸡市| 双流县| 张家界市| 石棉县| 得荣县| 利辛县|