在使用SQL 查询时强制关闭

Question

在查询标题开头为 n 的记录时，出现了强制关闭。

log：

04-01 12:19:37.833: D/AndroidRuntime(676): Shutting down VM  
04-01 12:19:37.833: W/dalvikvm(676): threadid=1: thread exiting with uncaught exception (group=0x40015560)  
04-01 12:19:37.913: E/AndroidRuntime(676): FATAL EXCEPTION: main  
04-01 12:19:37.913: E/AndroidRuntime(676): android.database.sqlite.SQLiteException: near "%": syntax error: , while compiling: SELECT DISTINCT _id, title, body, cdate, passw FROM notes WHERE title LIKE n%  
04-01 12:19:37.913: E/AndroidRuntime(676):  at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
04-01 12:19:37.913: E/AndroidRuntime(676):  at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92) 

代码：

public Cursor search(String title) {
    Cursor mCursor =
            mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,
                    KEY_TITLE, KEY_BODY,KEY_CDATE,KEY_PASS}, KEY_TITLE + " LIKE" +" " + title +  '%', null,
                    null, null, null, null);
        if (mCursor != null) {
            mCursor.moveToFirst();
        }
        return mCursor;
 }

Answer 1

请在 n% 前后加上引号，如：

SELECT DISTINCT _id, title, body, cdate, passw FROM notes WHERE title LIKE “n%”

至于你说的代码，可以这样写：

 mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,
                    KEY_TITLE, KEY_BODY,KEY_CDATE,KEY_PASS}, KEY_TITLE + " LIKE '" +" " + title +  "%'", null,
                    null, null, null, null);