从网络上知道了可以通过select * from wrongquestion order by random() limit number从数据库里可以随机从数据库里获取number个数据,通过select * from wrongquestion order by id limit 10;可以通过数据库每次获取一定顺序的数据。
通过Ormalte 这个框架如何执行一条sql语句呢? Dao<WrongQuestion,Integer> wrongquestionDao= DbHelper.GetInstance().getwrongQuestionDao();
ArrayList<WrongQuestion> wrongquestions=(ArrayList<WrongQuestion>) wrongquestionDao.queryBuilder().orderByRaw("random()").limit(number).query();
通过顺序Dao<WrongQuestion,Integer> wrongquestionDao= DbHelper.GetInstance().getwrongQuestionDao();
ArrayList<WrongQuestion> wrongquestions=(ArrayList<WrongQuestion>)wrongquestionDao.queryBuilder().orderByRaw("id").limit(number).query();