非常简单的SQLite查询"no such column"

Question

这应该是一个非常简单的任务，但我已经卡住了一个小时。

我在sqlite浏览器中尝试了这个查询，其工作:

SELECT name FROM msUser WHERE username='admin' AND password='admin'

但是当我在Java代码中尝试这个时，它不工作:

querySelect = "SELECT name FROM " + TABLE_NAME + " WHERE username = " + username + " AND password = " + password;

日志显示:

01-19 14:21:02.279: E/AndroidRuntime(3117): android.database.sqlite.SQLiteException: no such column: admin: , while compiling: SELECT name FROM msUser WHERE username = admin AND password = admin

D

Answer 1

试试这个:

querySelect = "SELECT name FROM " + TABLE_NAME + " WHERE username = '" + username + "' AND password = '" + password +"'";