如何转义特殊字符,如’在sqlite在android

前端之家收集整理的这篇文章主要介绍了如何转义特殊字符,如’在sqlite在android前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我有一个函数,它在sqlite@R_301_457@中的表上执行查询。我声明一个常量:public static final String CANADA_HISTORY =“加拿大历史”;这个存储在一个String变量中我们说难度, @H_403_1@我有一个查询

Cursor c = mDb.rawQuery("select * from Questions_answers where CHAPTERS = '"+difficulty+"'",null);
@H_403_1@它在撇号附近抛出异常。

@H_403_1@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'
@H_403_1@我也试过:

1.  difficulty=difficulty.replaceAll("'","''");
2.  difficulty=difficulty.replaceAll("'","\'");
3.  difficulty = DatabaseUtils.sqlEscapeString(difficulty);
@H_403_1@除此之外,它还为我的单词,如加拿大历史,我的意思是没有特殊字符。

@H_403_1@请给我建议解决问题谢谢。

首先用这个替换char
difficulty=difficulty.replaceAll("'","\'");
@H_403_1@然后在您的查询中传递它

"select * from Questions_answers where CHAPTERS='"+difficulty+"'";
@H_403_1@编辑:

q = "select * from Questions_answers where CHAPTERS = ?";
    database.rawQuery(q,new String[] { difficulty});

猜你在找的Sqlite相关文章