Maybatis-Plus lambdaQuery与lambdaUpdate

发布时间 2023-04-21 13:28:19作者: 白玉神驹

lambdaQuery与lambdaUpdate

1. 等于

//EQ 就是 EQUAL等于
taskFlowService.lambdaQuery().eq(TaskFlow::getCreateTime,DateUtil.now())

2. 不等于

//NE就是 NOT EQUAL不等于
taskFlowService.lambdaQuery().ne(TaskFlow::getCreateTime,DateUtil.now());

3. 大于

//GT 就是 GREATER THAN大于
taskFlowService.lambdaQuery().gt(TaskFlow::getCreateTime,DateUtil.now());

4. 小于

//LT 就是 LESS THAN小于
taskFlowService.lambdaQuery().lt(TaskFlow::getCreateTime,DateUtil.now());

5. 大于等于

//GE 就是 GREATER THAN OR EQUAL 大于等于
taskFlowService.lambdaQuery().ge(TaskFlow::getCreateTime,DateUtil.now());

6. 小于等于

//LE 就是 LESS THAN OR EQUAL 小于等于
taskFlowService.lambdaQuery().le(TaskFlow::getCreateTime,DateUtil.now());

7. 根据id查询对象

Student one = studentService.lambdaQuery().eq(Student::getSno, 1).one();

8. 带条件的查询集合

List<Student> studentList = studentService.lambdaQuery().eq(Student::getAddress, "上海").list();

9. 带条件的删除

studentService.lambdaUpdate().eq(Student::getName,"张三").eq(Student::getAge,15).remove();

10 .带条件的修改

studentService.lambdaUpdate().set(Student::getAddress,"湖南").eq(Student::getSno,1).update();

11. 分页查询

IPage<Student> studentIPage = studentService.page(new Page(current,size),new QueryWrapper<Student>().like(StrUtil.isNotBlank(name),"name",name));