//第1种方法 QueryWrapper
String xiaotang="小唐";
QueryWrapper<User> queryWrapper1 = new QueryWrapper<>();
queryWrapper1.eq("username", xiaotang);
User user1 = userMapper.selectOne(queryWrapper1);//只查一条数据
// selct * from User where username=xiaotang
//或 可以使用lambda
QueryWrapper<User> queryWrapper2 = new QueryWrapper<>();
queryWrapper2.lambda().eq(User::getUsername, xiaotang);
User user2 = userMapper.selectOne(queryWrapper2);
// 第 2 种方法 LambdaQueryWrapper 该方法可以少写 lambda
LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.eq(User::getUsername, xiaotang);
User user3 = userMapper.selectOne(lambdaQueryWrapper);
//或
LambdaQueryWrapper<User> lb = Wrappers.<User>lambdaQuery().eq(User::getUsername, "小唐");
User user4 = userMapper.selectOne(lambdaQueryWrapper);
// 第 3 种方法 LambdaQueryChainWrapper 链式查询
User user5 = new LambdaQueryChainWrapper<>(userMapper)
.eq(User::getUsername, xiaotang)
.one(); // 这步骤是查询一条记录,查询列表用:.list()
//降序
LambdaQueryWrapper<实体类> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.orderByAsc(实体类::需要排序的字段)
//判断Name不为空时 执行
queryWrapper.eq(User.getName() != null,User::getName,xiaotang);
//更新
LambdaUpdateWrapper<User> wrapper = new LambdaUpdateWrapper<>();
wrapper.eq(User::getName, xiaotang);
wrapper.set(User::getPassWord, 123456);
//SQL:update User set passWord = 123456 where Name = xiaotang
Mabatis-Plus 条件构造器语法
于 2022-11-12 22:14:14 首次发布