package hg.demo.mybatis.plus.demo;
import lombok.Data;
@Data
public class Demo {
private String id;
private String name;
private Integer age;
}
2、依赖hutool工具
3、依赖lombokcn.hutool hutool-all4.5.16
4、依赖mybatisplus版本org.projectlombok lombok
3.4.1二、常用where 1、and
2、or1)and直接使用
QueryWrapperqueryWrapper = new QueryWrapper<>(); queryWrapper.lambda().eq(Demo::getId, "1"); 2)and非空时,使用
QueryWrapperqueryWrapper = new QueryWrapper<>(); String id = ""; queryWrapper.lambda().eq(StrUtil.isNotEmpty(id), Demo::getId, id);
1)直连or
期望效果:
select * from demo where id = 1 or name = 'a'对应代码:
QueryWrapperqueryWrapper = new QueryWrapper<>(); String id = "1"; String name = "a"; queryWrapper.lambda() .eq(StrUtil.isNotEmpty(id), Demo::getId, id) .or() .eq(StrUtil.isNotEmpty(name), Demo:: getName, name) ; 2)and + or
期望效果:
select * from demo where id = 1 and (name = 'a' or age = 10)对应代码:
QueryWrapperqueryWrapper = new QueryWrapper<>(); String id = "1"; String name = "a"; Integer age = 10; queryWrapper.lambda() .eq(StrUtil.isNotEmpty(id), Demo::getId, id) .and(StrUtil.isNotEmpty(name), q -> { q.eq(StrUtil.isNotEmpty(name), Demo:: getName, name) .or() .eq(null != age, Demo::getAge, age) ; }); 说明: and()里面,需要加进入条件,不然如果内容为空,会有异常;
异常信息可参考:



