【Android】Cursorをいじるメソッドで気をつけたいPositionの話 ref: http://qiita.com/operandoOS/items/6527b30f7e9bd8b60200

file0.java

public static void dumpLastRecord(Cursor cursor) {
    Log.d("dumpLastRecord", "=============");
    if (cursor != null) {
        cursor.moveToPosition(-1);
        if (cursor.moveToLast()) {
            String[] columnNames = cursor.getColumnNames();
            int length = columnNames.length;
            for (int i = 0; i < length; i++) {
                String value;
                try {
                    value = cursor.getString(i);
                } catch (SQLiteException e) {
                    value = "<unprintable>";
                }
                Log.d("dumpLastRecord", columnNames[i] + " : " + value);
            }
        }
    }
    Log.d("dumpLastRecord", "=============");
}

file1.java

Cursor c = db.query(....);
c.moveToFirst();
Log.d("Before Cursor Position","" + c.getPosition());
dumpLastRecord(c);
Log.d("After Cursor Position","" + c.getPosition());

file2.txt

D/Bfter Cursor Position﹕ 0
D/After Cursor Position﹕ 9

file3.java

public static void dumpLastRecord(Cursor cursor) {
    Log.d("dumpLastRecord", "===========================");
    if (cursor != null) {
        int startPosition = cursor.getPosition();
        cursor.moveToPosition(-1);
        if (cursor.moveToLast()) {
            String[] columnNames = cursor.getColumnNames();
            int length = columnNames.length;
            for (int i = 0; i < length; i++) {
                String value;
                try {
                    value = cursor.getString(i);
                } catch (SQLiteException e) {
                    value = "<unprintable>";
                }
                Log.d("dumpLastRecord", columnNames[i] + " : " + value);
            }
        }
        cursor.moveToPosition(startPosition);
    }
    Log.d("dumpLastRecord", "===========================");
}

file4.java

public static void dumpLastRecord(Cursor cursor) {
    Log.d("dumpLastRecord", "===========================");
    if (cursor != null) {
        int startPosition = cursor.getPosition(); // Cursorをいじる前に現在のPositionを一旦変数に保持
        // 省略
        cursor.moveToPosition(startPosition); // Cursorをいじり終わったら元のPositionに戻してあげる
    }
    Log.d("dumpLastRecord", "===========================");
}

file5.txt

D/Bfter Cursor Position﹕ 0
D/After Cursor Position﹕ 0