内容提供者错误:绑定或列索引超出范围:句柄0x234590

本文介绍了内容提供者错误:绑定或列索引超出范围:句柄0x234590的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我已经实现了内容提供程序，它导致以下错误

I have implemented a Content Provider, it is resulting in following error

04-25 00:25:16.856:E/AndroidRuntime(520):原因:android.database.sqlite.SQLiteException:绑定或列索引超出范围:处理0x234590

04-25 00:25:16.856: E/AndroidRuntime(520): Caused by: android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x234590

Content Provider中的查询是

The query in Content Provider is

Cursor cursor = qb.query(db, projection, selection, selectionArgs, null, null, sortOrder);

并致电Content Provider是

and call to Content Provider is

cursor = cr.query(uri, new String[] { ContactTableMetaData.ABC, ContactTableMetaData.MNP }, ContactTableMetaData.XYZ + "=?", new String[] { "phonenumber1", "phonenumber2", "phonenumber3", "phonenumber4", "phonenumber5", "email1", "email2", "email3", "email4", "email5" }, null);

完整的logcat是

04-25 00:25:16.856: E/AndroidRuntime(520): FATAL EXCEPTION: main 04-25 00:25:16.856: E/AndroidRuntime(520): java.lang.RuntimeException: Unable to start activity 04-25 00:25:16.856: E/AndroidRuntime(520): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.app.ActivityThread.access$2300(ActivityThread.java:125) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2033) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.os.Handler.dispatchMessage(Handler.java:99) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.os.Looper.loop(Looper.java:123) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.app.ActivityThread.main(ActivityThread.java:4627) 04-25 00:25:16.856: E/AndroidRuntime(520): at java.lang.reflect.Method.invokeNative(Native Method) 04-25 00:25:16.856: E/AndroidRuntime(520): at java.lang.reflect.Method.invoke(Method.java:521) 04-25 00:25:16.856: E/AndroidRuntime(520): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868) 04-25 00:25:16.856: E/AndroidRuntime(520): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626) 04-25 00:25:16.856: E/AndroidRuntime(520): at dalvik.system.NativeStart.main(Native Method) 04-25 00:25:16.856: E/AndroidRuntime(520): Caused by: android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x234590 04-25 00:25:16.856: E/AndroidRuntime(520): at android.database.sqlite.SQLiteProgram.native_bind_string(Native Method) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:241) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.database.sqlite.SQLiteQuery.bindString(SQLiteQuery.java:182) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:48) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:330) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.database.sqlite.SQLiteQueryBuilder.query(SQLiteQueryBuilder.java:280) 04-25 00:25:16.856: E/AndroidRuntime(520): at com.wissenways.helper.VoiceAppContactContentProvider.query(VoiceAppContactContentProvider.java:171) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.content.ContentProvider$Transport.query(ContentProvider.java:163) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.content.ContentResolver.query(ContentResolver.java:245) 04-25 00:25:16.856: E/AndroidRuntime(520): at com.wissenways.checkcontacts.DisplayGreatPeople.onCreate(DisplayGreatPeople.java:45) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047) 04-25 00:25:16.856: E/AndroidRuntime(520): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627) 04-25 00:25:16.856: E/AndroidRuntime(520): ... 11 more

谢谢.

推荐答案

String selection = ContactTableMetaData.XYZ + "=?"; String[] selectionArgs = new String[] { "phonenumber1", "phonenumber2", "phonenumber3", "phonenumber4", "phonenumber5", "email1", "email2", "email3", "email4", "email5" }

?的数量必须与 selectionArgs 的数量匹配.如果您提供10个项目，则选择必须具有10个?.

The amount of ? must match the amount of selectionArgs. If you provide 10 items then the selection has to have 10 ?.

选择中的第N个?被 selectionArgs 中的第N个项目代替.

The N-th ? in selection is replaced by the N-th item in selectionArgs.

如果要检查ContactTableMetaData.XYZ是否是其中的任何一个，则可以

If you want to check if ContactTableMetaData.XYZ is any of those then either do

String selection = ContactTableMetaData.XYZ + "=? OR " + ContactTableMetaData.XYZ + "=? OR " + ...

或

String selection = ContactTableMetaData.XYZ + " IN (?, ?, ?, ?, ..)"

我希望第二个:)