android 显示表数据,如何使用SQLite将整个数据库表数据显示到android中的TextView中...

我的问题是,TextView中显示的唯一数据是最后一行

桌子.

所以这是我从数据库表中获取整个数据的代码：public List getAllPerson()

{

List personList = new ArrayList();

//select query

String selectQuery = "SELECT * FROM " + DATABASE_TABLE;

SQLiteDatabase db = this.getWritableDatabase();

Cursor cursor = db.rawQuery(selectQuery, null);

for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext())

{

Person person = new Person();

person.setId(Integer.parseInt(cursor.getString(0)));

person.setName(cursor.getString(1));

person.setHotness(cursor.getString(2));

person.setAge(Integer.parseInt(cursor.getString(3)));

// Adding person to list

personList.add(person);

}

return personList;

}

这是我将表数据显示到TextView的代码：public class SQLiteView extends Activity