android sqlite 获取总行数,android – 从SQLite获取所有行

我一直在尝试从SQLite数据库中获取所有行。但是我从以下代码中只得到最后一行。

FileChooser类：

public ArrayList readFileFromSQLite() {

fileName = new ArrayList();

fileSQLiteAdapter = new FileSQLiteAdapter(FileChooser.this);

fileSQLiteAdapter.openToRead();

cursor = fileSQLiteAdapter.queueAll();

if (cursor != null) {

if (cursor.moveToFirst()) {

do {

fileName.add(cursor.getString(cursor.getColumnIndex(FileSQLiteAdapter.KEY_CONTENT1)));

} while (cursor.moveToNext());

}

cursor.close();

}

fileSQLiteAdapter.close();

return fileName;

}

FileSQLiteAdapter类：

public Cursor queueAll() {

String[] columns = new String[] { KEY_ID, KEY_CONTENT1 };

Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns, null,

null, null, null, null);

return cursor;

}

请告诉我我的错误在哪里欣赏。