JetBrains_Exposed框架连接Oracle数据库

最新推荐文章于 2023-05-14 11:01:17 发布

飞奔的屎壳郎

最新推荐文章于 2023-05-14 11:01:17 发布

阅读量839

点赞数

分类专栏： java 文章标签：数据库 oracle Exposed

本文链接：https://blog.csdn.net/qq_35349982/article/details/127345288

版权

java 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

build.gradle.kts中添加oracle以及相关依赖

dependencies {
    testImplementation(kotlin("test"))
    implementation("org.jetbrains.exposed", "exposed-core", "0.40.1")
    implementation("org.jetbrains.exposed", "exposed-dao", "0.40.1")
    implementation("org.jetbrains.exposed", "exposed-jdbc", "0.40.1")
     implementation("com.oracle.database.jdbc:ojdbc6:11.2.0.4")
}

oracle_conn.kt


import org.jetbrains.exposed.dao.*
import org.jetbrains.exposed.dao.id.EntityID
import org.jetbrains.exposed.dao.id.IntIdTable
import org.jetbrains.exposed.sql.*
import org.jetbrains.exposed.sql.transactions.transaction


object Users : IntIdTable() {
    val name = varchar("name", 50).index()
    val city = reference("city", Cities)
    val age = integer("age")
}

object Cities: IntIdTable() {
    val name = varchar("name", 50)
}

class User(id: EntityID<Int>) : IntEntity(id) {
    companion object : IntEntityClass<User>(Users)

    var name by Users.name
    var city by City referencedOn Users.city
    var age by Users.age
}

class City(id: EntityID<Int>) : IntEntity(id) {
    companion object : IntEntityClass<City>(Cities)

    var name by Cities.name
    val users by User referrersOn Users.city
}

fun main() {
    val connect = Database.connect(
        "jdbc:oracle:thin:@127.0.0.1:1521:oracle",
        driver = "oracle.jdbc.driver.OracleDriver",
        user = "scott",
        password = "oracle"

    )



    transaction {
        addLogger(StdOutSqlLogger)

        SchemaUtils.create (Cities, Users)

        val stPete = City.new {
            name = "St. Petersburg"
        }

        val munich = City.new {
            name = "Munich"
        }

        User.new {
            name = "a"
            city = stPete
            age = 5
        }

        User.new {
            name = "b"
            city = stPete
            age = 27
        }

        User.new {
            name = "c"
            city = munich
            age = 42
        }

        println("Cities: ${City.all().joinToString {it.name}}")
        println("Users in ${stPete.name}: ${stPete.users.joinToString {it.name}}")
        println("Adults: ${User.find { Users.age greaterEq 18 }.joinToString {it.name}}")
    }

}