Example usage for android.database Cursor isNull

Introduction

In this page you can find the example usage for android.database Cursor isNull.

Prototype

boolean isNull(int columnIndex);

Source Link

Document

Returns true if the value in the indicated column is null.

Usage

From source file:com.silentcircle.contacts.list.EmailAddressListAdapter.java

protected void bindPhoto(final ContactListItemView view, Cursor cursor) {
    long photoId = 0;
    if (!cursor.isNull(EmailQuery.EMAIL_PHOTO_ID)) {
        photoId = cursor.getLong(EmailQuery.EMAIL_PHOTO_ID);
    }/*from  w  w  w .j  a  v  a2 s .  c om*/
    getPhotoLoader().loadThumbnail(view.getPhotoView(), photoId, true);
}

From source file:org.opendatakit.common.android.database.DataModelDatabaseHelper.java

/**
 * Accessor to retrieve the database tableId given a formId
 *
 * @param db/*  w  ww .j a  va  2 s  .  c om*/
 * @param formId
 *          -- either the integer _ID or the textual form_id
 * @return
 */
public static IdInstanceNameStruct getIds(SQLiteDatabase db, String formId) {
    boolean isNumericId = StringUtils.isNumeric(formId);

    Cursor c = null;
    try {
        c = db.query(FORMS_TABLE_NAME,
                new String[] { FormsColumns._ID, FormsColumns.FORM_ID, FormsColumns.TABLE_ID,
                        FormsColumns.INSTANCE_NAME },
                (isNumericId ? FormsColumns._ID : FormsColumns.FORM_ID) + "=?", new String[] { formId }, null,
                null, null);

        if (c.moveToFirst()) {
            int idxId = c.getColumnIndex(FormsColumns._ID);
            int idxFormId = c.getColumnIndex(FormsColumns.FORM_ID);
            int idxTableId = c.getColumnIndex(FormsColumns.TABLE_ID);
            int idxInstanceName = c.getColumnIndex(FormsColumns.INSTANCE_NAME);

            return new IdInstanceNameStruct(c.getInt(idxId), c.getString(idxFormId), c.getString(idxTableId),
                    c.isNull(idxInstanceName) ? null : c.getString(idxInstanceName));
        }
    } finally {
        if (c != null && !c.isClosed()) {
            c.close();
        }
    }
    return null;
}

From source file:android.database.DatabaseUtils.java

/**
 * Reads a String out of a column in a Cursor and writes it to a ContentValues.
 * Adds nothing to the ContentValues if the column isn't present or if its value is null.
 *
 * @param cursor The cursor to read from
 * @param column The column to read/*w w  w .j  a v a 2  s.co  m*/
 * @param values The {@link ContentValues} to put the value into
 */
public static void cursorStringToContentValuesIfPresent(Cursor cursor, ContentValues values, String column) {
    final int index = cursor.getColumnIndexOrThrow(column);
    if (!cursor.isNull(index)) {
        values.put(column, cursor.getString(index));
    }
}

From source file:android.database.DatabaseUtils.java

/**
 * Reads a Long out of a column in a Cursor and writes it to a ContentValues.
 * Adds nothing to the ContentValues if the column isn't present or if its value is null.
 *
 * @param cursor The cursor to read from
 * @param column The column to read//from   w  ww .  j  av a 2s  .  co  m
 * @param values The {@link ContentValues} to put the value into
 */
public static void cursorLongToContentValuesIfPresent(Cursor cursor, ContentValues values, String column) {
    final int index = cursor.getColumnIndexOrThrow(column);
    if (!cursor.isNull(index)) {
        values.put(column, cursor.getLong(index));
    }
}

From source file:android.database.DatabaseUtils.java

/**
 * Reads a Short out of a column in a Cursor and writes it to a ContentValues.
 * Adds nothing to the ContentValues if the column isn't present or if its value is null.
 *
 * @param cursor The cursor to read from
 * @param column The column to read/*from  www  .  j  a  v a 2 s .  c o m*/
 * @param values The {@link ContentValues} to put the value into
 */
public static void cursorShortToContentValuesIfPresent(Cursor cursor, ContentValues values, String column) {
    final int index = cursor.getColumnIndexOrThrow(column);
    if (!cursor.isNull(index)) {
        values.put(column, cursor.getShort(index));
    }
}

From source file:android.database.DatabaseUtils.java

/**
 * Reads a Integer out of a column in a Cursor and writes it to a ContentValues.
 * Adds nothing to the ContentValues if the column isn't present or if its value is null.
 *
 * @param cursor The cursor to read from
 * @param column The column to read//from  w ww  .j  a v a 2s.  co m
 * @param values The {@link ContentValues} to put the value into
 */
public static void cursorIntToContentValuesIfPresent(Cursor cursor, ContentValues values, String column) {
    final int index = cursor.getColumnIndexOrThrow(column);
    if (!cursor.isNull(index)) {
        values.put(column, cursor.getInt(index));
    }
}

From source file:android.database.DatabaseUtils.java

/**
 * Reads a Float out of a column in a Cursor and writes it to a ContentValues.
 * Adds nothing to the ContentValues if the column isn't present or if its value is null.
 *
 * @param cursor The cursor to read from
 * @param column The column to read/*from www .  ja  va 2  s  .  co m*/
 * @param values The {@link ContentValues} to put the value into
 */
public static void cursorFloatToContentValuesIfPresent(Cursor cursor, ContentValues values, String column) {
    final int index = cursor.getColumnIndexOrThrow(column);
    if (!cursor.isNull(index)) {
        values.put(column, cursor.getFloat(index));
    }
}

From source file:android.database.DatabaseUtils.java

/**
 * Reads a Double out of a column in a Cursor and writes it to a ContentValues.
 * Adds nothing to the ContentValues if the column isn't present or if its value is null.
 *
 * @param cursor The cursor to read from
 * @param column The column to read/*from  w  w w .  j  av  a 2 s  . c o m*/
 * @param values The {@link ContentValues} to put the value into
 */
public static void cursorDoubleToContentValuesIfPresent(Cursor cursor, ContentValues values, String column) {
    final int index = cursor.getColumnIndexOrThrow(column);
    if (!cursor.isNull(index)) {
        values.put(column, cursor.getDouble(index));
    }
}

From source file:android.database.DatabaseUtils.java

/**
 * Reads a Integer out of a field in a Cursor and writes it to a Map.
 *
 * @param cursor The cursor to read from
 * @param field The INTEGER field to read
 * @param values The {@link ContentValues} to put the value into, with the field as the key
 * @param key The key to store the value with in the map
 *///from   w ww  .  j a  v a 2s  .co  m
public static void cursorIntToContentValues(Cursor cursor, String field, ContentValues values, String key) {
    int colIndex = cursor.getColumnIndex(field);
    if (!cursor.isNull(colIndex)) {
        values.put(key, cursor.getInt(colIndex));
    } else {
        values.put(key, (Integer) null);
    }
}

From source file:android.database.DatabaseUtils.java

/**
 * Reads a Double out of a field in a Cursor and writes it to a Map.
 *
 * @param cursor The cursor to read from
 * @param field The REAL field to read//from   w w w .j ava2 s .com
 * @param values The {@link ContentValues} to put the value into
 * @param key The key to store the value with in the map
 */
public static void cursorDoubleToContentValues(Cursor cursor, String field, ContentValues values, String key) {
    int colIndex = cursor.getColumnIndex(field);
    if (!cursor.isNull(colIndex)) {
        values.put(key, cursor.getDouble(colIndex));
    } else {
        values.put(key, (Double) null);
    }
}