android - SQLite异常: no such table:

Question

这是我从 SqliteTmp 表中选择某些内容的代码:

 Cursor c=null;
                    DataBaseHelper myDbHelper = new DataBaseHelper(StaffActivity.this);
                    try {
                        myDbHelper.createDataBase();
                    } catch (IOException ioe) {
                        throw new Error("Unable to create database");
                    }
                    try {
                        myDbHelper.openDataBase();

                    }catch(SQLException sqle){

                        throw sqle;
                    }
                    Toast.makeText(StaffActivity.this, "Success", Toast.LENGTH_SHORT).show();
                    c=myDbHelper.query("SqliteTmp", null, null, null, null,null, null);
                    if(c.moveToFirst())
                    {
                        do {

                            Toast.makeText(StaffActivity.this,
                                    "_id: " + c.getString(0) + "\n",  
                                    Toast.LENGTH_LONG).show();
                        } while (c.moveToNext());
                    }
                }

Logcat 是这样说的:

android.database.sqlite.SQLiteException: no such table: SqliteTmp (code 1): , while compiling: SELECT * FROM SqliteTmp

但是 SqlTmp.db 显示:

CREATE TABLE `SqliteTmp` (
    `_id`   int(11) NOT NULL,
    `ean`   varchar(12) NOT NULL,
    `bezeichnung`   varchar(100) NOT NULL,
    `art`   varchar(1),
    `stammkost` varchar(4),
    `marker`    varchar(1),
    PRIMARY KEY(_id)
);

为什么找不到 SqliteTmp 表？确实在里面。

Answer 1

我想我也遇到了同样的问题。请确保每个表都有不同的数据库名称。这肯定会解决您的问题。