今天在工作中碰到了一个小问题,来记录一下,工作中使用到了Mybatis-plus,在查询的时候我们都知道要用到 QueryWrapper
。由于在查询的时候前端不想要一个字段,我懵逼了,之前只知道要某个字段.select("需要的数据库列")
,完整代码如下:
代码如下:
@Override
public List<LoginUserDTO> getList(LoginLogParam param) {
List<LoginUserDTO> list = new ArrayList<>();
this.list(new QueryWrapper<CusUserLog>().lambda()
.select(CusUserLog::getUsername, CusUserLog::getCreateTime,CusUserLog::getAvatarUrl)
.ge(CusUserLog::getCreateTime, param.getStartTime())
.le(CusUserLog::getCreateTime, param.getEndTime())
).forEach(user -> {
LoginUserDTO loginUserDTO = new LoginUserDTO();
loginUserDTO.setUsername(user.getUsername());
loginUserDTO.setCreateTime(user.getCreateTime());
loginUserDTO.setAvatarUrl(user.getAvatarUrl());
list.add(loginUserDTO);
});
return list;
}
但是只想排除某个字段,要是我把所有字段都列举出来未免显得太傻,经过查询资料。发现下面的写法:
LambdaQueryWrapper<CusArticle> eq = Wrappers.lambdaQuery(CusArticle.class)
// 不查数据库里面 content 数据,减少传输数据量
.select(CusArticle.class, i -> !i.getColumn().equals("content"))
.like(!StringUtils.isEmpty(cusArticleDto.getTitle()), CusArticle::getTitle, cusArticleDto.getTitle())
.like(!StringUtils.isEmpty(cusArticleDto.getAuthor()), CusArticle::getAuthor, cusArticleDto.getAuthor())
.like(!StringUtils.isEmpty(cusArticleDto.getType()), CusArticle::getType, cusArticleDto.getType())
.eq(!Objects.isNull(cusArticleDto.getIsTop()),CusArticle::getIsTop,cusArticleDto.getIsTop())
.orderByDesc(CusArticle::getModifiedDt);
select(CusArticle.class, i -> !i.getColumn().equals("content"))
这种写法equals里面写的是数据库字段名称
.select(CusArticle.class,info -> !info.getProperty().equals("content"))
这种写法equals里面写的是java类中的字段名称