SQLite：Room3 之下的直接 APIRoom3 3.0.0-rc01

import androidx.sqlite.SQLiteConnection
import androidx.sqlite.SQLiteDriver
import androidx.sqlite.driver.AndroidSQLiteDriver

val driver: SQLiteDriver = AndroidSQLiteDriver()

// 打开连接
val connection: SQLiteConnection = driver.open("notes.db")

// 执行 DDL / 无参数语句
connection.prepare("CREATE TABLE IF NOT EXISTS note (id INTEGER PRIMARY KEY, title TEXT)")
    .close()

// 参数化查询
val statement = connection.prepare("INSERT INTO note(title) VALUES(?)")
statement.bindText(1, "购物清单")
statement.step()
statement.close()

// 查询并读结果
val query = connection.prepare("SELECT id, title FROM note")
while (query.step()) {
    val id = query.getLong(0)      // 0-based 列索引
    val title = query.getText(1)
}
query.close()

connection.close()

statement.bindText(1, "文本")   // bindLong/bindDouble/bindBlob/bindNull
statement.step()                // 有行返回 true；无行 false
statement.getLong(0)            // getText/getDouble/getBlob/isNull