Java Code Examples for android.database.Cursor#isBeforeFirst()

The following examples show how to use android.database.Cursor#isBeforeFirst() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: MessageListItem.java From zom-android-matrix with Apache License 2.0

6 votes

protected String convertMediaUriToPath(Uri uri) {
    String path = null;

    String [] proj={MediaStore.Images.Media.DATA};
    Cursor cursor = getContext().getContentResolver().query(uri, proj,  null, null, null);
    if (cursor != null && (!cursor.isClosed()))
    {
        if (cursor.isBeforeFirst())
        {
            int column_index = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);
            cursor.moveToFirst();
            path = cursor.getString(column_index);
        }

        cursor.close();
    }

    return path;
}

Example 2

Source File: MessageListItem.java From Zom-Android-XMPP with GNU General Public License v3.0

6 votes

protected String convertMediaUriToPath(Uri uri) {
    String path = null;

    String [] proj={MediaStore.Images.Media.DATA};
    Cursor cursor = getContext().getContentResolver().query(uri, proj,  null, null, null);
    if (cursor != null && (!cursor.isClosed()))
    {
        if (cursor.isBeforeFirst())
        {
            int column_index = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);
            cursor.moveToFirst();
            path = cursor.getString(column_index);
        }

        cursor.close();
    }

    return path;
}

Example 3

Source File: HashActivity.java From CameraV with GNU General Public License v3.0

6 votes

public String getRealPathFromURI(Uri contentUri) {
 String[] proj = { MediaStore.Images.Media.DATA };
 
 //This method was deprecated in API level 11
 //Cursor cursor = managedQuery(contentUri, proj, null, null, null);
 
 CursorLoader cursorLoader = new CursorLoader(
           this, 
           contentUri, proj, null, null, null);        
 Cursor cursor = cursorLoader.loadInBackground();
 
 int column_index = 
   cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);
 
 if (cursor.isBeforeFirst())
 {
  cursor.moveToFirst();
  return cursor.getString(column_index); 
 }
 else
  return null;
}

Example 4

Source File: CityManager.java From sms-ticket with Apache License 2.0

5 votes

public City getCity(Cursor c) {
    if (c.isClosed() || c.isAfterLast() || c.isBeforeFirst()) {
        return null;
    }

    return new City(
        c.getLong(c.getColumnIndex(Cities._ID)),
        c.getString(c.getColumnIndex(Cities.COUNTRY)),
        c.getString(c.getColumnIndex(Cities.CITY)),
        c.getString(c.getColumnIndex(Cities.CITY_PUBTRAN)),
        c.getDouble(c.getColumnIndex(Cities.LAT)),
        c.getDouble(c.getColumnIndex(Cities.LON)),
        c.getInt(c.getColumnIndex(Cities.VALIDITY)),
        c.getString(c.getColumnIndex(Cities.NOTE)),
        c.getString(c.getColumnIndex(Cities.PRICE)),
        c.getString(c.getColumnIndex(Cities.CURRENCY)),
        c.getString(c.getColumnIndex(Cities.PRICE_NOTE)),
        c.getString(c.getColumnIndex(Cities.REQUEST)),
        c.getString(c.getColumnIndex(Cities.NUMBER)),
        new String[]{c.getString(c.getColumnIndex(Cities.ADDITIONAL_NUMBER_1))},
        c.getString(c.getColumnIndex(Cities.IDENTIFICATION)),
        c.getString(c.getColumnIndex(Cities.P_DATE_FROM)),
        c.getString(c.getColumnIndex(Cities.P_DATE_TO)),
        c.getString(c.getColumnIndex(Cities.P_HASH)),
        c.getString(c.getColumnIndex(Cities.DATE_FORMAT)),
        c.getString(c.getColumnIndex(Cities.CONFIRM_REQ)),
        c.getString(c.getColumnIndex(Cities.CONFIRM)));
}

Example 5

Source File: DatabaseHelper.java From spidey with GNU General Public License v3.0

5 votes

/**
 * get single scan
 */
public Scan getScan(long scan_id) {
	SQLiteDatabase db = this.getReadableDatabase();

	String selectQuery = "SELECT  * FROM " + TABLE_SCANS + " WHERE "
			+ COLUMN_ID + " = " + scan_id;
	
	Cursor c = db.rawQuery(selectQuery, null);

	if (c != null && c.isBeforeFirst())
	{
		c.moveToFirst();

		Scan scan = new Scan();
		scan.setId(c.getInt(c.getColumnIndex(COLUMN_ID)));
		scan.setLocation(c.getString(c.getColumnIndex(COLUMN_LOCATION)));
		scan.setLatitude(c.getDouble(c.getColumnIndex(COLUMN_LATITUDE)));
		scan.setLongitude(c.getDouble(c.getColumnIndex(COLUMN_LONGITUDE)));
		scan.setCreatedAt(c.getString(c.getColumnIndex(COLUMN_CREATED_AT)));

		 List<CellInfo> cells = getAllCellsByScanId(scan.getId());
		 scan.setCellInfos(cells);
		
		return scan;
	}
	else
		return null;
}

Example 6

Source File: CursorHelper.java From libcommon with Apache License 2.0

4 votes

/**
 * 指定したCursorの現在のレコードを文字列に変換
 * @param cursor
 */
public static String toString(@Nullable final Cursor cursor) {
	if (cursor == null) {
		return "{null}";
	} else if (cursor.isClosed()) {
		return "{closed}";
	} else if (cursor.isBeforeFirst()) {
		return "{before first}";
	} else if (cursor.isAfterLast()) {
		return "{after last}";
	} else {
		final StringBuilder sb = new StringBuilder();
		final int n = cursor.getColumnCount();
		final String[] columnNames = cursor.getColumnNames();
		sb.append("{");
		for (int i = 0; i < n; i++) {
			switch (cursor.getType(i)) {
			case Cursor.FIELD_TYPE_FLOAT:
				sb.append(columnNames[i]).append("=").append(cursor.getDouble(i));
				break;
			case Cursor.FIELD_TYPE_INTEGER:
				sb.append(columnNames[i]).append("=").append(cursor.getLong(i));
				break;
			case Cursor.FIELD_TYPE_STRING:
				sb.append(columnNames[i]).append("=").append(cursor.getString(i));
				break;
			case Cursor.FIELD_TYPE_BLOB:
				sb.append(columnNames[i]).append("=").append("BLOB");
				break;
			case Cursor.FIELD_TYPE_NULL:
				sb.append(columnNames[i]).append("=").append("NULL");
				break;
			default:
				sb.append(columnNames[i]).append("=").append("UNKNOWN");
				break;
			}
			if (i < n-1) {
				sb.append(",");
			}
		}
		sb.append("}");
		return sb.toString();
	}
}

Example 7

Source File: HumanReadables.java From android-test with Apache License 2.0

4 votes

public static String describe(Cursor c) {
  if (c.isBeforeFirst()) {
    return "Cursor positioned before first element.";
  } else if (c.isAfterLast()) {
    return "Cursor positioned after last element.";
  }
  StringBuilder result = new StringBuilder("Row ").append(c.getPosition()).append(": {");
  String[] columns = c.getColumnNames();
  for (int i = 0; i < columns.length; i++) {
    result.append(columns[i]).append(":");
    int type = Cursor.FIELD_TYPE_STRING;
    if (Build.VERSION.SDK_INT > 10) {
      type = c.getType(i);
    }
    switch (type) {
      case Cursor.FIELD_TYPE_STRING:
        result.append("\"").append(c.getString(i)).append("\"");
        break;
      case Cursor.FIELD_TYPE_INTEGER:
        result.append(c.getLong(i));
        break;
      case Cursor.FIELD_TYPE_FLOAT:
        result.append(c.getDouble(i));
        result.append("f");
        break;
      case Cursor.FIELD_TYPE_NULL:
        result.append("null");
        break;
      case Cursor.FIELD_TYPE_BLOB:
        byte[] val = c.getBlob(i);
        result.append("[");
        for (int j = 0; j < 5 && j < val.length; j++) {
          result.append(val[j]);
          result.append(",");
        }
        if (5 < val.length) {
          result.append("... (").append(val.length - 5).append(" more elements)");
        }
        result.append("]");
        break;
      default:
        result.append("\"").append(c.getString(i)).append("\"");
        break;
    }
    result.append(", ");
  }
  result.append("}");
  return result.toString();
}