如何修复“java.lang.IllegalStateException：无法从CursorWindow读取第2行，第7行”。

Question

public class MusicAdapter extends ArrayAdapter<Music>
{
    Activity context;
    int resource;
    List<Music> objects;

     int Like =0; 

    public MusicAdapter(Activity context, int resource, List<Music> objects)
    {
        super(context, resource, objects);
        this.context = context;
        this.resource = resource;
        this.objects = objects;
    }

    @Override
    public View getView(final int position, View convertView, ViewGroup parent)
    {
        LayoutInflater inflater = this.context.getLayoutInflater();
        View row = inflater.inflate(this.resource,null);

        TextView txtMa = row.<TextView>findViewById(R.id.txtMa);
        TextView txtTen = row.<TextView>findViewById(R.id.txtTen);
        TextView txtCaSi = row.<TextView>findViewById(R.id.txtCaSi);

        final TextView txtLike = row.<TextView>findViewById(R.id.txtLike);        final TextView txtDisLike = row.<TextView>findViewById(R.id.txtDisLike); 
        ImageButton btnLike = row.<ImageButton>findViewById(R.id.btnLike);
        ImageButton btnDisLike = row.<ImageButton>findViewById(R.id.btnDisLike);

        final Music music = this.objects.get(position);
        txtTen.setText(music.getTen());
        txtMa.setText(music.getMa());
        txtCaSi.setText(music.getCaSi());


        btnLike.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                xuLyThich(music, position,txtLike);

            }
        });

        btnDisLike.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v)
            {
                xuLyKhongThich(music,position,txtDisLike);

            }
        });

        return row;
    }

    private void xuLyKhongThich(Music music, int pos,TextView txtDisLike)
    {

        int no_un_like =0;
        Cursor cursor=MainActivity.database.query("ArirangSongList",null,
                null,null,
                null,null,null);


        try {
            if (cursor!= null) {
                cursor.move(pos+1);
                no_un_like = cursor.getInt(8);
                Log.d("no_unlike",String.valueOf(no_un_like));
            }

        } finally {
            cursor.close();
        }

        ContentValues row = new ContentValues();

        row.put("Dislike",  no_un_like+1);


        try{
            MainActivity.database.update("ArirangSongList", row, "MABH= ?", new String[]{String.valueOf(music.getMa())});
            txtDisLike.setText(String.valueOf(no_un_like+1));
        }finally {

        }
    }

    private void xuLyThich(Music music, int pos,TextView txtlike)
    {
         int no_like =0;
        Cursor cursor=MainActivity.database.query("ArirangSongList",null,
                null,null,
                null,null,null);


        try {
            if (cursor!= null) {
                cursor.move(pos+1);
                no_like = cursor.getInt(7);
                Log.d("no_like",String.valueOf(no_like));
            }

        } finally {
            cursor.close();
        }

        ContentValues row = new ContentValues();

        row.put("Like",  no_like+1);


        try{
            MainActivity.database.update("ArirangSongList", row, "MABH= ?", new String[]{String.valueOf(music.getMa())});

            txtlike.setText(String.valueOf(no_like+1));

        }finally {

        }
    }

}

java.lang.IllegalStateException: Couldn't read row 2, col 7 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it.
        at android.database.CursorWindow.nativeGetLong(Native Method)
        at android.database.CursorWindow.getLong(CursorWindow.java:507)
        at android.database.CursorWindow.getInt(CursorWindow.java:574)
        at android.database.AbstractWindowedCursor.getInt(AbstractWindowedCursor.java:69)
        at muitenvang.adapter.MusicAdapter.xuLyThich(MusicAdapter.java:136)
        at muitenvang.adapter.MusicAdapter.access$000(MusicAdapter.java:23)
        at muitenvang.adapter.MusicAdapter$1.onClick(MusicAdapter.java:74)
        at android.view.View.performClick(View.java:4204)
        at android.view.View$PerformClick.run(View.java:17355)
        at android.os.Handler.handleCallback(Handler.java:725)
        at android.os.Handler.dispatchMessage(Handler.java:92)
        at android.os.Looper.loop(Looper.java:137)
        at android.app.ActivityThread.main(ActivityThread.java:5041)
        at java.lang.reflect.Method.invokeNative(Native Method)
        at java.lang.reflect.Method.invoke(Method.java:511)
        at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
        at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
        at dalvik.system.NativeStart.main(Native Method)

Answer 1

您的问题是试图从不存在的光标中读取一行。

这是由于列表中的位置不是偏移量，而是序列号。也就是说，第一个位置为1，而光标中的等效行为0（位置2与行1相关，以此类推）。

按照cursor.move(POS+1)向位置添加1；使异常更有可能发生，因为不检查移动的结果（如果不能使移动为true，则为false）以查看移动是否成功。

尽管不是理想的变化：-

        if (cursor!= null) {
            cursor.move(pos+1);
            no_like = cursor.getInt(7);
            Log.d("no_like",String.valueOf(no_like));
        }

致：-

        if (cursor.move(pos-1) {
            no_like = cursor.getInt(7);
            Log.d("no_like",String.valueOf(no_like));
        } else {
            Log.d("no_like","Ooops could not move to row + String.valueOf(pos));
        }

会更有可能奏效。

null