条件构造器(Wrapper)

可以构造的条件

image-20201030191152554

image-20201030191222757

QueryWrapper(LambdaQueryWrapper)

1
2
3
QueryWrapper<User> wrapper = new QueryWrapper<> ();
wrapper.eq ("id",5);
userMapper.selectMaps (wrapper);
1
2
3
SELECT  id,name,age,email,deleted,version,create_time,modify_time  FROM user 
 WHERE  deleted=0
AND (id = 5)

UpdateWrapper(LambdaUpdateWrapper)

1
2
3
UpdateWrapper<User> wrapper = new UpdateWrapper<> ();
wrapper.eq ("id",5);
userMapper.update (new User ().setAge (2000),wrapper);
1
2
3
4
UPDATE user  SET age=2000,
modify_time='2020-10-30T19:13:59.492+0800'  
WHERE  deleted=0
AND (id = 5)