public static void printCursorInfo(Cursor c) {
if (c != null) {
int pos = c.getPosition();
c.moveToPosition(-1);
String[] columns = c.getColumnNames();
int counts = columns.length;
Log.v(TAG, "=======cursor size: " + c.getCount() + " , columns: " + counts);
int i = 0;
while (c.moveToNext()) {
Log.v(TAG,"---------Record: " + ++i);
for (int j = 0; j < counts; j++) {
int type = c.getType(j);
switch (type) {
case Cursor.FIELD_TYPE_BLOB:
//modify for findbugs
Log.v(TAG, c.getColumnName(j) + ": "
+ new String(c.getBlob(j), Charset.defaultCharset()));
break;
case Cursor.FIELD_TYPE_FLOAT:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getFloat(j));
break;
case Cursor.FIELD_TYPE_INTEGER:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getInt(j));
break;
case Cursor.FIELD_TYPE_STRING:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getString(j));
break;
case Cursor.FIELD_TYPE_NULL:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getString(j));
break;
default:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getString(j));
}
}
}
c.moveToPosition(pos);
} else {
Log.v(TAG, "cursor is null!");
}
}
if (c != null) {
int pos = c.getPosition();
c.moveToPosition(-1);
String[] columns = c.getColumnNames();
int counts = columns.length;
Log.v(TAG, "=======cursor size: " + c.getCount() + " , columns: " + counts);
int i = 0;
while (c.moveToNext()) {
Log.v(TAG,"---------Record: " + ++i);
for (int j = 0; j < counts; j++) {
int type = c.getType(j);
switch (type) {
case Cursor.FIELD_TYPE_BLOB:
//modify for findbugs
Log.v(TAG, c.getColumnName(j) + ": "
+ new String(c.getBlob(j), Charset.defaultCharset()));
break;
case Cursor.FIELD_TYPE_FLOAT:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getFloat(j));
break;
case Cursor.FIELD_TYPE_INTEGER:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getInt(j));
break;
case Cursor.FIELD_TYPE_STRING:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getString(j));
break;
case Cursor.FIELD_TYPE_NULL:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getString(j));
break;
default:
Log.v(TAG, c.getColumnName(j) + ": "
+ c.getString(j));
}
}
}
c.moveToPosition(pos);
} else {
Log.v(TAG, "cursor is null!");
}
}