如何解决CursorIndexOutOfBoundsException

现在我正在工作JSON应用程序使用sqllite存储所有json values.The值正确存储,我正在提取sqllite数据以下错误发生请帮助我…

12-09 13:51:22.808: ERROR/AndroidRuntime(217): Uncaught handler: thread main exiting due to uncaught exception 12-09 13:51:22.808: ERROR/AndroidRuntime(217): android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 5 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at android.database.AbstractCursor.checkPosition(AbstractCursor.java:580) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:172) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:41) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at ez.com.Action_module_screen.setListval1(Action_module_screen.java:1059) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at ez.com.Action_module_screen$4.handleMessage(Action_module_screen.java:695) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at android.os.Handler.dispatchMessage(Handler.java:99) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at android.os.Looper.loop(Looper.java:123) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at android.app.ActivityThread.main(ActivityThread.java:4203) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at java.lang.reflect.Method.invokeNative(Native Method) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at java.lang.reflect.Method.invoke(Method.java:521) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:791) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:549) 12-09 13:51:22.808: ERROR/AndroidRuntime(217): at dalvik.system.NativeStart.main(Native Method) 

这是我的来源:

  Cursor curser=myDB.rawQuery("select * from "+TABLE_NAME+"",null); if(curser.moveToFirst()) { int k=0; System.out.println("enter first"); do { System.out.println("enter second"); if(status1==true) { System.out.println("enter third"); for(int i=0;i<items.length;i++) { System.out.println("item"+items.length); System.out.println("enter fourth"); Cursor dbcur = myDB.rawQuery("select * from "+TABLE_NAME+" where Status='"+items[i]+"'", null); System.out.println("enter fifth"); int title=curser.getColumnIndex("Title"); String tit=curser.getString(title); System.out.println("value"+tit); /* String title1=dbcur.getString(dbcur.getColumnIndex("Title")); System.out.println("title"+title1); String name1=dbcur.getString(dbcur.getColumnIndex("Name")); System.out.println("name"+name1); String open1=dbcur.getString(dbcur.getColumnIndex("Open")); System.out.println("open"+open1); String close1=dbcur.getString(dbcur.getColumnIndex("Close")); System.out.println("close"+close1); String no1=dbcur.getString(dbcur.getColumnIndex("No")); System.out.println("no"+no1); no.add(no1+","+k); first.put(no1+","+k, title1); second.put(no1+","+k,name1); third.put(no1+","+k, open1); fourth.put(no1+","+k,close1); k=k+1; mylist=sorting(no,1,true); */ } } }while(curser.moveToNext()); } curser.close(); myDB.close(); } 

要么

 if(cursor.moveToFirst() && cursor.getCount() >= 1){ do{ .... .... }while(cursor.moveToNext()); 

或者你可以做

 if(cursor.getCount() >= 1){ while(cursor.moveToNext()){ .... .... } 

光标位于索引-1的内部

什么是你的光标“光标”定义? 你可以请张贴吗

编辑:正如我所看到的,你的第二个光标dbcur不放置在任何位置,所以它在他的顶部位置-1。 请尝试使用dbcur.moveToFirst()dbcur.moveToNext()

我只select状态值。只有一个光标是足够的….下面的代码工作正确……..

正确的代码:

 Cursor dbcur = myDB.rawQuery("select * from "+TABLE_NAME+" where Status='"+items[i]+"'", null); if(dbcur.moveToFirst()) { int k=0; System.out.println("enter first"); do { String title1=dbcur.getString(dbcur.getColumnIndex("Title")); System.out.println("title"+title1); String name1=dbcur.getString(dbcur.getColumnIndex("Name")); System.out.println("name"+name1); String open1=dbcur.getString(dbcur.getColumnIndex("Open")); System.out.println("open"+open1); String close1=dbcur.getString(dbcur.getColumnIndex("Close")); System.out.println("close"+close1); String no1=dbcur.getString(dbcur.getColumnIndex("No")); System.out.println("no"+no1); no.add(no1+","+k); first.put(no1+","+k, title1); second.put(no1+","+k,name1); third.put(no1+","+k, open1); fourth.put(no1+","+k,close1); k=k+1; mylist=sorting(no,1,true); }while(dbcur.moveToNext()); } dbcur.close(); myDB.close();