Fills the specified cursor window by iterating over the contents of the cursor. - Android Database

Android examples for Database:Cursor

  1. HOME
  2. Android
  3. Database
  4. Cursor

Description

Fills the specified cursor window by iterating over the contents of the cursor.

Demo Code

/*//from   w  w  w  . j a va2 s. c o  m
 * Copyright (C) 2006 The Android Open Source Project
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
import android.database.Cursor;
import android.database.CursorWindow;

public class Main {
  /**
   * Fills the specified cursor window by iterating over the contents of the
   * cursor. The window is filled until the cursor is exhausted or the window
   * runs out of space.
   *
   * The original position of the cursor is left unchanged by this operation.
   *
   * @param cursor
   *          The cursor that contains the data to put in the window.
   * @param position
   *          The start position for filling the window.
   * @param window
   *          The window to fill.
   * @hide
   */
  public static void cursorFillWindow(final Cursor cursor, int position,
      final CursorWindow window) {
    if (position < 0 || position >= cursor.getCount()) {
      return;
    }
    final int oldPos = cursor.getPosition();
    final int numColumns = cursor.getColumnCount();
    window.clear();
    window.setStartPosition(position);
    window.setNumColumns(numColumns);
    if (cursor.moveToPosition(position)) {
      rowloop: do {
        if (!window.allocRow()) {
          break;
        }
        for (int i = 0; i < numColumns; i++) {
          final int type = cursor.getType(i);
          final boolean success;
          switch (type) {
          case Cursor.FIELD_TYPE_NULL:
            success = window.putNull(position, i);
            break;

          case Cursor.FIELD_TYPE_INTEGER:
            success = window.putLong(cursor.getLong(i), position, i);
            break;

          case Cursor.FIELD_TYPE_FLOAT:
            success = window.putDouble(cursor.getDouble(i), position, i);
            break;

          case Cursor.FIELD_TYPE_BLOB: {
            final byte[] value = cursor.getBlob(i);
            success = value != null ? window.putBlob(value, position, i)
                : window.putNull(position, i);
            break;
          }

          default: // assume value is convertible to String
          case Cursor.FIELD_TYPE_STRING: {
            final String value = cursor.getString(i);
            success = value != null ? window.putString(value, position, i)
                : window.putNull(position, i);
            break;
          }
          }
          if (!success) {
            window.freeLastRow();
            break rowloop;
          }
        }
        position += 1;
      } while (cursor.moveToNext());
    }
    cursor.moveToPosition(oldPos);
  }
}

Related Tutorials