mybatis or查询
分类: Java 专栏: java 标签: mybatis or查询
2023-03-01 13:35:45 684浏览
mybatis or查询
public List<EtStuWarning> getList( EtStuWarning o){
LambdaQueryWrapper<EtStuWarning> lambdaQueryWrapper = Wrappers.lambdaQuery();
if (Objects.nonNull(o.getStuname()) && o.getStuname().trim().length()>0 ) {
lambdaQueryWrapper.like(EtStuWarning ::getStuname, o.getStuname());
}
if (Objects.nonNull(o.getStuno()) && o.getStuno().trim().length()>0 ) {
lambdaQueryWrapper.like(EtStuWarning ::getStuno, o.getStuno());
}
if (Objects.nonNull(o.getMajor()) && o.getMajor().trim().length()>0 ) {
lambdaQueryWrapper.like(EtStuWarning ::getMajor, o.getMajor());
}
if ( o.getTid()!=null ) {
lambdaQueryWrapper.eq(EtStuWarning ::getTid, o.getTid());
}
if ( o.getCid()!=null ) {
lambdaQueryWrapper.eq(EtStuWarning::getCid, o.getCid());
}
if ( o.getSelType()!=null && o.getSelType().equals("s") ) {
lambdaQueryWrapper .and(wq -> wq
.gt(EtStuWarning::getNotSignNum, 2)
.or()
.gt(EtStuWarning::getNotTestNum,0));
}
List<EtStuWarning> li = stuWarningDao.selectList(lambdaQueryWrapper);
return li;
}
好博客就要一起分享哦!分享海报
此处可发布评论
评论(0)展开评论
暂无评论,快来写一下吧
展开评论
您可能感兴趣的博客
他的专栏
他感兴趣的技术



java
vue
springboot
Mysql
ssm
小程序
uniapp
js和jquery