读书人

How to get a tables columns arrayli

发布时间: 2012-08-17 02:08:34 作者: rapoo

How to get a tables columns arraylist on Android?

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();    }
?

读书人网 >Android

热点推荐