Android程序查询包含“*＂ ＂#”的号码时出错的解决办法

Android程序查询包含“*＂ ＂#”的号码时出错的解决办法

代码错误提示: 
E/AndroidRuntime(1145): Caused by: android.database.sqlite.SQLiteException: near "*": syntax error: , while compiling: SELECT numbertype, new, duration, _id, numberlabel, name, number, type, date FROM calls WHERE (number = **9) ORDER BY date desc 
 
解决:  

1.     strQuery = "number = " + strQueryNumber;  
2.             callLogCursor = TApplication.nowTApplication.getContentResolver()  
3.                     .query(CallLog.Calls.CONTENT_URI, null, strQuery, null,  
4.                             "date desc");                          

查询代码改成:  

1.                               
2.                                 strQuery = "number = " + "'strQueryNumber'";  
3.             callLogCursor = TApplication.nowTApplication.getContentResolver()  
4.                     .query(CallLog.Calls.CONTENT_URI, null, strQuery, null,  
5.                             "date desc");  

总结:因为"*"为数据库里的关键字(未经证实),所有查找是会报语法错误,只需要拼接字符串,把"*"改成非关键字即可

ps:模拟器不知道为何直接拔打数字+"#"会清空屏幕,而只能拨打"#"开头的号码