sqlite按照某个值倒序查询

sessionId：聊天存储纪录id

time：(第一次传比0小的值)，之后每次传入上次纪录的第一条的时间

pageSize：页面当前条数

public static List<ChatMessage> getPagedMessage(String sessionId,long time,int pageSize) {
        QueryBuilder<ChatMessage> queryBuilder = QueryBuilder.create(ChatMessage.class)
                .order("create_time desc")
                .where("easemob_id='" + sessionId + "'")
                .limit(pageSize);
        if(time > 0){
            queryBuilder.where("create_time<" + time);
        }
        if(queryBuilder == null) return new ArrayList<>();
        return queryBuilder.list();
    }

list的按照某个值排序

Collections.sort(messages, new Comparator<ChatMessage>() {
     public int compare(ChatMessage obj1, ChatMessage obj2) {
          return (int) (obj1.getCreate_time() - obj2.getCreate_time());
     }
});