我有一个函数，它在sqlite数据库中的表上执行查询。我声明一个常量：public static final String CANADA_HISTORY =“加拿大历史”;这个存储在一个String变量中我们说难度，
我有一个查询：
Cursor c = mDb.rawQuery("select * from Questions_answers where CHAPTERS = '"+difficulty+"'",null);
它在撇号附近抛出异常。
Logcat输出：
I/Database( 1170): sqlite returned: error code = 1,msg = near "s": Syntax error D/AndroidRuntime( 1170): Shutting down VM W/dalvikvm( 1170): threadid=1: thread exiting with uncaught exception (group=0x40015560) E/AndroidRuntime( 1170): FATAL EXCEPTION: main E/AndroidRuntime( 1170): android.database.sqlite.sqliteException: near "s": Syntax error:,while compiling: select * from Questions_answers where CHAPTERS = 'Canada's History'
我也试过：
1. difficulty=difficulty.replaceAll("'","''");
2. difficulty=difficulty.replaceAll("'","\'");
3. difficulty = DatabaseUtils.sqlEscapeString(difficulty);
除此之外，它还为我的单词，如加拿大历史，我的意思是没有特殊字符。
请给我建议解决问题谢谢。
首先用这个替换char
原文链接：https://www.f2er.com/sqlite/198125.htmldifficulty=difficulty.replaceAll("'","\'");
然后在您的查询中传递它
"select * from Questions_answers where CHAPTERS='"+difficulty+"'";
编辑：
q = "select * from Questions_answers where CHAPTERS = ?";
database.rawQuery(q,new String[] { difficulty});
