mybatis中 排序(将指定的排在后/前面)

来源:互联网 发布:js日期控件只选择月份 编辑:程序博客网 时间:2024/05/22 04:55
public List<SuitEvidenceVo> selectWithFileByCaseId(Long caseId, List<Long> userIdList, Page evidencePge) {     SuitEvidenceDoExample example = new SuitEvidenceDoExample();     Criteria criteria = example.createCriteria();     criteria.andCaseIdEqualTo(caseId);     StringBuilder sb = new StringBuilder();     if(userIdList !=null && !userIdList.isEmpty()){         for(int i=0;i<userIdList.size();i++){             if (userIdList.get(i) == null  ) {                      continue;                  }             if (i < userIdList.size() - 1) {                      sb.append(userIdList.get(i) + ",");                  } else {                      sb.append(userIdList.get(i));                  }          }     }     example.setOrderByClause("case when use_id in (" + sb + ") then 2 else 1 end, id ");        example.setPage(evidencePge);        if (StringUtils.isEmpty(example.getOrderByClause())) {            example.setOrderByClause("id asc");        }        return this.selectListByExample(example);}
1 0
原创粉丝点击