一、详细方法见官网
二、持久层(mapper)
UpdateWrapper
User user = new User();
user.setUsername("xiaoming");
user.setSex("男");
user.setId(4);
userMapper.updateById(user);
//eq是选择条件 ;相当于where后面的值
//set里面写入修改的字段和修改后的信息
UpdateWrapper<User> updateWrapper = new UpdateWrapper<>();
updateWrapper.eq("name","xiaoming")
.set("age",25);
userMapper.update(updateWrapper);
//可将需要更新的字段写入entity中
UpdateWrapper<User> updateWrapper2 = new UpdateWrapper<>();
updateWrapper2.eq("name","xiaoming");
userMapper.update(user,updateWrapper2);
QueryWrapper
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
//ge 大于等于
//gt 大于
//lt 小于
//le 小于等于
queryWrapper.eq("sex","女")
.ge("age",10)
.le("age",20);
System.out.println(userMapper.selectList(queryWrapper));
QueryWrapper<User> queryWrapper2 = new QueryWrapper<>();
queryWrapper2.like("sex","%%")
.ge("age",10)
.le("age",20);
System.out.println(userMapper.selectList(queryWrapper2));
//notBetween("age", 18, 30)--->age not between 18 and 30
//like("name", "王")--->name like '%王%'
//in("age", 1, 2, 3)--->age in (1,2,3)
//更多方法见官网