我在Kotlin的第一张桌子出现错误 [英] Error in my first table in kotlin

问题描述

当我尝试在Android中使用Kotlin在数据库中插入列时遇到问题.

I'm facing a problem when I try to insert a column in the database using Kotlin in Android.

这是错误:

08-04 19:45:03.781 14302-14302/com.example.hello.note E/Zygote:v2 08-04 19:45:03.781 14302-14302/com.example.hello.note E/Zygote:accessInfo:0 08-04 19:45:20.471 14302-14302/com.example.hello.note E/Qmage:isQIO:流不是QIO文件 08-04 19:45:20.521 14302-14302/com.example.hello.note E/Qmage:isQIO:流不是QIO文件 08-04 19:45:20.531 14302-14302/com.example.hello.note E/Qmage:isQIO:流不是QIO文件 08-04 19:45:20.541 14302-14302/com.example.hello.note E/MotionRecognitionManager:mSContextService = null 08-04 19:45:20.541 14302-14302/com.example.hello.note E/MotionRecognitionManager:motionService = com.samsung.android.motion.IMotionRecognitionService$Stub$Proxy@78b77 08-04 19:45:47.991 14302-14302/com.example.hello.note E/Qmage:isQIO:流不是QIO文件 08-04 19:45:47.991 14302-14302/com.example.hello.note E/Qmage:isQIO:流不是QIO文件 08-04 19:45:47.991 14302-14302/com.example.hello.note E/Qmage:isQIO:流不是QIO文件 08-04 19:47:40.311 14302-14302/com.example.hello.note E/Qmage:isQIO:流不是QIO文件 08-04 19:48:14.131 14302-14302/com.example.hello.note E/SQLiteLog:(1)没有这样的表:注释 08-04 19:48:14.141 14302-14302/com.example.hello.note E/SQLiteDatabase:插入Title = note Desc = desc时出错 android.database.sqlite.SQLiteException:没有这样的表:Notes(代码1):，而在编译时:INSERT INTO Notes(Title，Desc)VALUES(?，?) ################################################ ############### 错误代码:1(SQLITE_ERROR) 引起原因:SQL(query)错误或数据库丢失. (没有这样的表:Notes(代码1):，而在编译时:INSERT INTO Notes(Title，Desc)VALUES(?，?)) ################################################ ############### 在android.database.sqlite.SQLiteConnection.nativePrepareStatement(本机方法) 在android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1004) 在android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:569) 在android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) 在android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:59) 在android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31) 在android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1633) 在android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1505) 在com.example.hello.note.DbManger.Insert(DbManger.kt:40) 在com.example.hello.note.addNotes.buAdd(addNotes.kt:24) 在java.lang.reflect.Method.invoke(本机方法) 在android.support.v7.app.AppCompatViewInflater $ DeclaredOnClickListener.onClick(AppCompatViewInflater.java:288) 在android.view.View.performClick(View.java:5721) 在android.widget.TextView.performClick(TextView.java:10931) 在android.view.View $ PerformClick.run(View.java:22620) 在android.os.Handler.handleCallback(Handler.java:739) 在android.os.Handler.dispatchMessage(Handler.java:95) 在android.os.Looper.loop(Looper.java:148) 在android.app.ActivityThread.main(ActivityThread.java:7409) 在java.lang.reflect.Method.invoke(本机方法) 在com.android.internal.os.ZygoteInit $ MethodAndArgsCaller.run(ZygoteInit.java:1230) 在com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)

08-04 19:45:03.781 14302-14302/com.example.hello.note E/Zygote: v2 08-04 19:45:03.781 14302-14302/com.example.hello.note E/Zygote: accessInfo : 0 08-04 19:45:20.471 14302-14302/com.example.hello.note E/Qmage: isQIO : stream is not a QIO file 08-04 19:45:20.521 14302-14302/com.example.hello.note E/Qmage: isQIO : stream is not a QIO file 08-04 19:45:20.531 14302-14302/com.example.hello.note E/Qmage: isQIO : stream is not a QIO file 08-04 19:45:20.541 14302-14302/com.example.hello.note E/MotionRecognitionManager: mSContextService = null 08-04 19:45:20.541 14302-14302/com.example.hello.note E/MotionRecognitionManager: motionService = com.samsung.android.motion.IMotionRecognitionService$Stub$Proxy@78b77 08-04 19:45:47.991 14302-14302/com.example.hello.note E/Qmage: isQIO : stream is not a QIO file 08-04 19:45:47.991 14302-14302/com.example.hello.note E/Qmage: isQIO : stream is not a QIO file 08-04 19:45:47.991 14302-14302/com.example.hello.note E/Qmage: isQIO : stream is not a QIO file 08-04 19:47:40.311 14302-14302/com.example.hello.note E/Qmage: isQIO : stream is not a QIO file 08-04 19:48:14.131 14302-14302/com.example.hello.note E/SQLiteLog: (1) no such table: Notes 08-04 19:48:14.141 14302-14302/com.example.hello.note E/SQLiteDatabase: Error inserting Title=note Desc=desc android.database.sqlite.SQLiteException: no such table: Notes (code 1): , while compiling: INSERT INTO Notes(Title,Desc) VALUES (?,?) ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (no such table: Notes (code 1): , while compiling: INSERT INTO Notes(Title,Desc) VALUES (?,?)) ################################################################# at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1004) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:569) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:59) at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1633) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1505) at com.example.hello.note.DbManger.Insert(DbManger.kt:40) at com.example.hello.note.addNotes.buAdd(addNotes.kt:24) at java.lang.reflect.Method.invoke(Native Method) at android.support.v7.app.AppCompatViewInflater$DeclaredOnClickListener.onClick(AppCompatViewInflater.java:288) at android.view.View.performClick(View.java:5721) at android.widget.TextView.performClick(TextView.java:10931) at android.view.View$PerformClick.run(View.java:22620) at android.os.Handler.handleCallback(Handler.java:739) at android.os.Handler.dispatchMessage(Handler.java:95) at android.os.Looper.loop(Looper.java:148) at android.app.ActivityThread.main(ActivityThread.java:7409) at java.lang.reflect.Method.invoke(Native Method) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)

数据库代码:

class DbManger(context: Context) {
    val dbName = "MyNotes"
    val dbTable = "Notes"
    val colID = "ID"
    val colTitle = "Title"
    val colDesc = "Desc"
    var dbVer = 4

    val sqlCreateTable = "CREATE TABLE IF NOT EXISTS " + dbTable + "(" + colID + " INTEGER PRIMARY KEY," + colTitle + " TEXT," + colDesc + " TEXT " + ");"
    var sqlDataBase: SQLiteDatabase? = null

    inner class dbHelperNotes : SQLiteOpenHelper {
        var context: Context? = null

        constructor(context: Context) : super(context, dbName, null, dbVer) {
            this.context = context

        }

        override fun onCreate(p0: SQLiteDatabase?) {
            p0!!.execSQL(sqlCreateTable)
            Toast.makeText(this.context, "Database is created", Toast.LENGTH_LONG).show()
        }

        override fun onUpgrade(p0: SQLiteDatabase?, p1: Int, p2: Int) {
            p0!!.execSQL("drop table IF EXISTS " + dbTable)
        }


    }

    fun Insert(values: ContentValues): Long {
        val ID = sqlDataBase!!.insert(dbTable, "", values)
        return ID
    }

    init {
        var db = dbHelperNotes(context)
        sqlDataBase = db.writableDatabase
    }
}

推荐答案

@laalto是正确的，一旦删除表，您需要重新创建表，您需要在onUpgrade()方法.

@laalto is right, you need to re-create your table once you've dropped it, you need to add a call to onCreate(p0) inside your onUpgrade() method.

我在班级上删除了一些不需要的字段，现在看起来是这样:

I removed a couple of unneeded fields on your class, this is how it looks now:

class DbManger(context: Context) {
    val dbName = "MyNotes"
    val dbTable = "Notes"
    val colID = "ID"
    val colTitle = "Title"
    val colDesc = "Desc"
    var dbVer = 4

    val sqlCreateTable = "CREATE TABLE IF NOT EXISTS $dbTable($colID INTEGER PRIMARY KEY,$colTitle TEXT,$colDesc TEXT);"
    var sqlDataBase: SQLiteDatabase? = null

    inner class dbHelperNotes(val context: Context) : SQLiteOpenHelper(context, dbName, null, dbVer) {
        override fun onCreate(database: SQLiteDatabase?) {
            database?.execSQL(sqlCreateTable)
            Toast.makeText(context, "Database is created", Toast.LENGTH_LONG).show()
        }

        override fun onUpgrade(database: SQLiteDatabase?, oldVersion: Int, newVersion: Int) {
            database?.execSQL("drop table IF EXISTS " + dbTable)
            onCreate(database)
        }
    }

    fun insert(values: ContentValues): Long {
        val id = sqlDataBase!!.insert(dbTable, "", values)
        return id
    }

    init {
        val db = dbHelperNotes(context)
        sqlDataBase = db.writableDatabase
    }
}

我相信您的班级名称上也有错字，应该是"DbManager".

I believe you also have a typo on your class name, should be 'DbManager'.

这篇关于我在Kotlin的第一张桌子出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！