创建lambda表达式的三种方法
**
-
LambdaQueryWrapper < User> lambda1=new LambdaQueryWrapper<>();
-
LambdaQueryWrapper < User> lambda2=new QueryWrapper().Lambda();
-
LambdaQueryWrapper < User> lambda3=Wrappers.LambdaQuery();
-
List users = new LambdaQueryChainWrapper(userMapper)
.like(User::getName, “通”).ge(User::getAge, 20).list();
注:ge是大于等于
**
用法
1 模糊查询姓名带‘通’并且年龄小于30岁的
LambdaQueryWrapper<User> lambda3 = Wrappers.<User>lambdaQuery();
lambda3.like(User::getName, "通").lt(User::getAge, 30);
List<User> users = userMapper.selectList(lambda3);
users.forEach(System.out::println);
2.名字为林姓并且(年龄大于等于30并且邮箱不为空)
LambdaQueryWrapper<User> lambda3 = Wrappers.<User>lambdaQuery();
lambda3.likeLeft(User::getName, "林").and(qw -> qw.lt(User::getAge, 40).or().isNotNull(User::getEmail));
//上面这句也可以换成下面这两句
// lambda3.likeLeft(User::getName, "林");
//lambda3.ge(User::getAge, 40).or().isNotNull(User::getEmail);
List<User> users = userMapper.selectList(lambda3);
users.forEach(System.out::println);