data1是字符串?需要加上引号
07-22 15:55:29.832: E/AndroidRuntime(23914): FATAL EXCEPTION: main
07-22 15:55:29.832: E/AndroidRuntime(23914): android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x11ba958
07-22 15:55:29.832: E/AndroidRuntime(23914): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:180)
07-22 15:55:29.832: E/AndroidRuntime(23914): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:136)
07-22 15:55:29.832: E/AndroidRuntime(23914): at android.content.ContentProviderProxy.query(ContentProviderNative.java:358)
07-22 15:55:29.832: E/AndroidRuntime(23914): at android.content.ContentResolver.query(ContentResolver.java:311)
07-22 15:55:29.832: E/AndroidRuntime(23914): at com.txrj.sms.manager.SmsDataManager.getNameByAddress(SmsDataManager.java:139)
07-22 15:55:29.832: E/AndroidRuntime(23914): at com.txrj.sms.activity.ShowSmsActivity$1.handleMessage(ShowSmsActivity.java:41)
07-22 15:55:29.832: E/AndroidRuntime(23914): at android.os.Handler.dispatchMessage(Handler.java:99)
07-22 15:55:29.832: E/AndroidRuntime(23914): at android.os.Looper.loop(Looper.java:137)
07-22 15:55:29.832: E/AndroidRuntime(23914): at android.app.ActivityThread.main(ActivityThread.java:4517)
07-22 15:55:29.832: E/AndroidRuntime(23914): at java.lang.reflect.Method.invokeNative(Native Method)
07-22 15:55:29.832: E/AndroidRuntime(23914): at java.lang.reflect.Method.invoke(Method.java:511)
07-22 15:55:29.832: E/AndroidRuntime(23914): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:993)
07-22 15:55:29.832: E/AndroidRuntime(23914): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:760)
07-22 15:55:29.832: E/AndroidRuntime(23914): at dalvik.system.NativeStart.main(Native Method)
07-22 16:01:08.913: E/AndroidRuntime(24385): FATAL EXCEPTION: main
07-22 16:01:08.913: E/AndroidRuntime(24385): android.database.sqlite.SQLiteException: near ")": syntax error: , while compiling: SELECT DISTINCT display_name FROM view_data_restricted data WHERE (1) AND ((mimetype='?' and data1=?-)) // data1是字符串?需要加上引号
07-22 16:01:08.913: E/AndroidRuntime(24385): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:180)
07-22 16:01:08.913: E/AndroidRuntime(24385): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:136)
07-22 16:01:08.913: E/AndroidRuntime(24385): at android.content.ContentProviderProxy.query(ContentProviderNative.java:358)
07-22 16:01:08.913: E/AndroidRuntime(24385): at android.content.ContentResolver.query(ContentResolver.java:311)
07-22 16:01:08.913: E/AndroidRuntime(24385): at com.txrj.sms.manager.SmsDataManager.getNameByAddress(SmsDataManager.java:139)
07-22 16:01:08.913: E/AndroidRuntime(24385): at com.txrj.sms.activity.ShowSmsActivity$1.handleMessage(ShowSmsActivity.java:41)
07-22 16:01:08.913: E/AndroidRuntime(24385): at android.os.Handler.dispatchMessage(Handler.java:99)
07-22 16:01:08.913: E/AndroidRuntime(24385): at android.os.Looper.loop(Looper.java:137)
07-22 16:01:08.913: E/AndroidRuntime(24385): at android.app.ActivityThread.main(ActivityThread.java:4517)
07-22 16:01:08.913: E/AndroidRuntime(24385): at java.lang.reflect.Method.invokeNative(Native Method)
07-22 16:01:08.913: E/AndroidRuntime(24385): at java.lang.reflect.Method.invoke(Method.java:511)
07-22 16:01:08.913: E/AndroidRuntime(24385): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:993)
07-22 16:01:08.913: E/AndroidRuntime(24385): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:760)
07-22 16:01:08.913: E/AndroidRuntime(24385): at dalvik.system.NativeStart.main(Native Method)
相关文章
- python字符串
- unity如何停止不用字符串方式开启协程的方法
- Java实现 LeetCode 459 重复的子字符串
- 【python cookbook】【字符串与文本】11.从字符串中去掉不需要的字符
- 防范sql注入式攻击(Java字符串校验,高可用性)
- 2380. 二进制字符串重新安排顺序需要的时间
- JAVA字符串比较equals()和equalsIgnoreCase()差异
- DFS和动态规划——字符串匹配 真蛋疼 为*的情况需考虑匹配0个、1个、2个情况 DFS会超时 正则匹配的话 需要向前看x*的情况 打包处理
- Java如何拆分正则表达式和字符串?
- 【Java字符串】String类、字符串操作、格式化字符串、正则表达式
- C++使用技巧(二十三):回顾整形转化为字符串