How to get a tables columns arraylist on Android?

iteye_3854

于 2011-09-26 14:30:01 发布

阅读量97

点赞数

CC 4.0 BY-SA版权

分类专栏： Android 文章标签：移动开发

本文链接：https://blog.youkuaiyun.com/iteye_3854/article/details/82158789

Android 专栏收录该内容

180 篇文章

订阅专栏

Cursor ti = db.rawQuery("PRAGMA table_info(mytable)", null);
    if ( ti.moveToFirst() ) {
        do {
            System.out.println("col: " + ti.getString(1));
        } while (ti.moveToNext());
    }

try {
        Cursor c = db.query(tableName, null, null, null, null, null, null);
        if (c != null) {
            int num = c.getColumnCount();
            for (int i = 0; i < num; ++i) {
                String colname = c.getColumnName(i);

            }
        }

    } catch (Exception e) {
        Log.v(tableName, e.getMessage(), e);
        e.printStackTrace();
    }