love.yinlin.cs.server-engine/love.yinlin.cs.service/Database

Database

Types

@Serializable

data class Config(val host: String = "localhost", val port: Int = 3306, val name: String = "mysql", val username: String = "root", val password: String = "", val maximumPoolSize: Int = 10, val minimumIdle: Int = 2, val idleTimeout: Long = 30000, val connectionTimeout: Long = 30000, val maxLifetime: Long = 1800000)

Functions

fun close()

fun deleteSQL(sql: String, vararg args: Any?): Boolean

fun querySQL(sql: String, vararg args: Any?): JsonArray?

fun querySQLSingle(sql: String, vararg args: Any?): JsonObject?

throwExecuteSQL

fun throwExecuteSQL(sql: String, vararg args: Any?)

throwInsertSQLDuplicateKey

fun throwInsertSQLDuplicateKey(sql: String, vararg args: Any?): Boolean

throwInsertSQLGeneratedKey

fun throwInsertSQLGeneratedKey(sql: String, vararg args: Any?): Long

fun throwQuerySQL(sql: String, vararg args: Any?): JsonArray

throwQuerySQLSingle

fun throwQuerySQLSingle(sql: String, vararg args: Any?): JsonObject

throwTransaction

fun <R : Any> throwTransaction(call: (Connection) -> R): R

fun updateSQL(sql: String, vararg args: Any?): Boolean