mybatis中使用example.setOrderByClau

CardQtCheckExample example = new CardQtCheckExample();
example.setOrderByClause("`AFTER_CHECK_TIME` DESC");
example.createCriteria().andCsnEqualTo(csn).andCheckStatusEqualTo(0);
List<CardQtCheck> cardQtChecks = cardQtCheckDao.selectByExample(example);

当有多个排序字段时

// 查询结果先按`index`字段排序，如果相同，则按`AFTER_CHECK_TIME`排序
example.setOrderByClause("`index` ASC,`AFTER_CHECK_TIME` ASC");