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

monody666

30000人浏览 · 2021-12-15 16:23:41

monody666 · 2021-12-15 16:23:41 发布

// 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());
            });