printCursorInfo

最新推荐文章于 2022-01-05 18:05:30 发布

原创最新推荐文章于 2022-01-05 18:05:30 发布 · 624 阅读

0 ·

CC 4.0 BY-SA版权

Android 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一个用于打印Android中SQLite查询结果的方法。此方法通过遍历Cursor对象获取每一列的数据类型和值，并使用日志记录下来，有助于开发者调试和理解查询结果。

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!");
        }
    }