java错误：无法从游标窗口读取第0行第1列。在从光标访问数据之前，请确保光标已正确初始化

Question

我收到一个错误，无法从CursorWindow读取第0行第1列。在从光标访问数据之前，请确保光标已正确初始化。 我什么都试过了，但似乎什么都不管用

变量：

private static final String COLUMN_SERVICE_DETAILS = " service_details";
private static final String COLUMN_SERVICE_TIME = " service_time";
private static final String COLUMN_SERVICE_COST = " service_cost";
private static final String TABLE_DETAILS = "details";

表格创建

    query = "CREATE TABLE " +TABLE_DETAILS+"("
            +COLUMN_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, "
            +COLUMN_SERVICE_TIME+ " TEXT, "
            +COLUMN_SERVICE_DETAILS+ " TEXT, "
            +COLUMN_SERVICE_COST+ " TEXT " +
            ");";
    sqLiteDatabase.execSQL(query);

在调试我的应用程序后，它停止使用此方法 getUserDetails

public UserDetails getUserDetails(){

    UserDetails ud = new UserDetails();
    String selectQuery = "select * from  " + TABLE_DETAILS + " where 1;";

    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);
    // Move to first row
    cursor.moveToFirst();
    while (!cursor.isAfterLast()) {

        ud.set_service_details(cursor.getString(cursor.getColumnIndex(COLUMN_SERVICE_DETAILS)));
        ud.set_service_time(cursor.getString(cursor.getColumnIndex(COLUMN_SERVICE_TIME)));
        ud.set_service_cost(cursor.getString(cursor.getColumnIndex(COLUMN_SERVICE_COST)));


        cursor.moveToNext();
    }
    cursor.close();
    db.close();

    return ud;
}

错误日志：

03-17 17:27:03.553 14627-14627/com.automobilecare.automobilecare E/AndroidRuntime: FATAL EXCEPTION: main                                                                               
              Process: com.automobilecare.automobilecare, PID: 14627
              java.lang.RuntimeException: Unable to start activity ComponentInfo{com.automobilecare.automobilecare/com.automobilecare.automobilecare.userArea.UserAreaActivity}: java.lang.IllegalStateException: Couldn't read row 0, col -1 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it.
               at 安卓.app.ActivityThread.performLaunchActivity(ActivityThread.java:2584)
               at 安卓.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2666)
               at 安卓.app.ActivityThread.-wrap11(ActivityThread.java)
               at 安卓.app.Activitat 安卓.os.Handler.dispatchMessage(Handler.java:111)
               at 安卓.os.Looper.loop(Looper.java:207)
               at 安卓.app.ActivityThread.main(ActivityThread.java:5769)
               at java.lang.reflect.Method.invoke(Native Method)
               at com.安卓.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:789)
               at com.安卓.internal.os.ZygoteInit.main(ZygoteInit.java:679)
               at de.robv.安卓.xposed.XposedBridge.main(XposedBridge.java:102)
Caused by: java.lang.IllegalStateException: Couldn't read row 0, col -1 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it.
               at 安卓.database.CursorWindow.nativeGetString(Native Method)
               at 安卓.database.CursorWindow.getString(CursorWindow.java:438)
               at 安卓.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:66)
               at com.automobilecare.automobilecare.internalDBConnectivity.DBHandler.getUserDetails(DBHandler.java:240)
               at com.automobilecare.automobilecare.userArea.UserAreaActivity.onCreate(UserAreaActivity.java:85)
               at 安卓.app.Activity.performCreate(Activity.java:6583)
               at 安卓.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1114)
               at 安卓.app.ActivityThread.performLaunchActivity(ActivityThread.java:2531)
               at 安卓.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2666) 
               at 安卓.app.ActivityThread.-wrap11(ActivityThread.java) 
               at 安卓.app.ActivityThread$H.handleMessage(ActivityThread.java:1493) 
               at 安卓.os.Handler.dispatchMessage(Handler.java:111) 
               at 安卓.os.Looper.loop(Looper.java:207) 
               at 安卓.app.ActivityThread.main(ActivityThread.java:5769) 
               at java.lang.reflect.Method.invoke(Native Method) 
               at com.安卓.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:789) 
               at com.安卓.internal.os.ZygoteInit.main(ZygoteInit.java:679) 
               at de.robv.安卓.xposed.XposedBridge.main(XposedBridge.java:102)

谢谢你的帮助