查询条件构造有两个,一个是QueryWrapper,另一个是LambdaQueryWrapper。LambdaQueryWrapper是为了防止QueryWrapper构造条件的时候将字段名写错引发错误,因此LambdaQueryWrapper更加常用。
LambdaQueryWrapper
LambdaQueryWrapper<SmsResult> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper
.eq(SmsResult::getDeptId,userInfo.getDeptId())
.between(SmsResult::getReceiveTime,pageBean.getCondition().getStartDate(),pageBean.getCondition().getEndDate());
QueryWrapper
QueryWrapper<SmsResult> queryWrapper = new QueryWrapper<>();
queryWrapper
.eq("dept_id",userInfo.getDeptId())
.between("receive_time", pageBean.getCondition().getStartDate(),pageBean.getCondition().getEndDate());