安卓Kotlin实现简单图书管理系统（SQlite数据库）保姆级教程

import android.content.Context
import android.database.sqlite.SQLiteDatabase
import android.database.sqlite.SQLiteOpenHelper

class BookDbHelper(context: Context) : SQLiteOpenHelper(context, "BookStore.db", null, 1) {

    override fun onCreate(db: SQLiteDatabase) {
        val createBookTableSql = "CREATE TABLE books (" +
                "id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                "title TEXT, " +
                "author TEXT, " +
                "price REAL, " +
                "pages INTEGER, " +
                "bookId TEXT)"
        db.execSQL(createBookTableSql)
    }

    override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) {
        // 这里可以根据需要实现数据库升级逻辑
    }
}