java - 执行查询时出现 SQLiteException

Question

我想执行一个 ManagedQuery 但我在我的日志中收到一个错误:

查询

 Cursor cursor = managedQuery(GroceryListContentProvider.NOTES_URI,projection,Notes.NOTE_TITLE+"="+S+" AND "+ Notes.NOTE_DATE+"="+S1, null, null);

错误日志

02-21 16:00:52.395: E/AndroidRuntime(22534): java.lang.RuntimeException: Unable to start activity ComponentInfo{net.schuemie.GroceryList/net.schuemie.GroceryList.shoppinglist}: android.database.sqlite.SQLiteException: near "new": syntax error: , while compiling: SELECT item_name FROM notes WHERE (title=shop new AND date=12/2/12) ORDER BY title

Answer 1

从查询中删除“new”并为字符串值添加引号

SELECT item_name FROM notes WHERE (title='shop' AND date=12/2/12) ORDER BY title