android - SQLite 异常 : no such column: (code 1)

Question

我有下面的方法，当执行时给出错误:

11-09 12:11:17.578: E/AndroidRuntime(21018): Caused by: android.database.sqlite.SQLiteException: no such column: happy (code 1): , while compiling: select * from Bank where english = happy

方法是:

public boolean BankHas(Word currentWord) {
        openDataBase();
        Cursor cursor = myDataBase.rawQuery("select * from Bank where english = " + currentWord.english, null); 
        return cursor.moveToFirst();
    }

我的表格方案:

CREATE TABLE `Bank` (
    `english`   TEXT
);

Answer 1

你错过了单引号，所以改变

"select * from Bank where english = " + currentWord.english

到

"select * from Bank where english ='" + currentWord.english + "'"

或者推荐的解决方案是使用参数化查询作为

Cursor cursor = myDataBase.rawQuery("select * from Bank where english =? ", new String [] {currentWord.english});

并从

更改您的创建表

CREATE TABLE `Bank` (
    `english`   TEXT
);

到

CREATE TABLE Bank (
    english TEXT
);