QueryWrapper 的简单使用

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

QueryWrapper<WfiOpinion> wrapper = new QueryWrapper<>();
wrapper.eq("tenantid",tenantid);
wrapper.eq("proinstid",proinstid);
String arr[] = dictionaryids.split(",");
ArrayList arrayList = new ArrayList();
for (String s : arr) {
    arrayList.add(s);
}
wrapper.in("opinioncontrolid",arrayList);
wrapper.orderByDesc("updatedate");
wrapper.select(WfiOpinion.class, i -> !i.getColumn().equals("available"));//排除某个字段            
wrapper.select(WfiOpinion.class, i -> i.getProperty().endsWith("valid"));//在某个字段结束，包括该字段
List<WfiOpinion> list = wfiOpinionMapper.selectList(wrapper);