mybatis-plus的LambdaQueryWrapper中and、or的用法

// WHERE xxxx!=id And ( xxxx=ANo or xxxx=BNo)LambdaQueryWrapper<Student> queryWrapper = new LambdaQueryWrapper<>();queryWrapper.ne(Student::getId,sysstudents.getId());queryWrapper.and((wra

普通网友

3725人浏览 · 2022-03-08 11:58:21

普通网友 · 2022-03-08 11:58:21 发布

// WHERE xxxx!=id And ( xxxx=ANo or xxxx=BNo)
            LambdaQueryWrapper<Student> queryWrapper = new LambdaQueryWrapper<>();
            queryWrapper.ne(Student::getId,sysstudents.getId());
            queryWrapper.and((wrapper)->{
                wrapper.eq(Student::getANo,sysstudents.getBillNo())
                        .or().eq(Student::getBNo,sysstudents.getBillNo());
            });