android 数据库select,android数据库sqlite 不支持select top 10的写法

改成 select * from tablename desc limit 0,9 就可以了

比如

// 获取前十条记录

public List GetPayListTopTen() {

List userList = new ArrayList();

Cursor cursor = db.rawQuery("select * from account desc limit 0,9", null);

cursor.moveToFirst();

while (!cursor.isAfterLast() && (cursor.getString(1) != null)) {

Payment pay = new Payment();

pay.setId(cursor.getInt(0));

pay.setMoney(cursor.getString(1));

pay.setText(cursor.getString(2));

pay.setTime(cursor.getString(3));

userList.add(pay);

cursor.moveToNext();

}

cursor.close();

return userList;

}