MybatisPlus之QueryWrapper与LambdaQueryWrapper的用法及区别

List userList = userMapper.selectList(new QueryWrapper()
        .like("email", "24252")
        .between("age", 20, 22)
        .or()
        .eq("name", "zcx")
);
System.out.println("userList:" + userList.toString());

//2、排序用法
List users = userMapper.selectList(new QueryWrapper()
        .eq("nick_name", "xx")
        .orderByAsc("age")  //升序
        //                .orderByDesc("age") //降序
        .last("limit 0,3") //last用法：在sql末尾添加sql语句，有sql注入风险
);
System.out.println("users:"+users.toString());

LambdaQueryWrapper queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.eq(UserDo::getAccount, account);
queryWrapper.eq(UserDo::getIsDelete, 0);
queryWrapper.like(UserDo::getName,"lk");
queryWrapper.between(UserDo::getAge,18,20);
// queryWrapper.orderByAsc(UserDo::getDeptNo);
UserDo user = userMapper.selectOne(queryWrapper);
Integer count = userMapper.selectCount(queryWrapper);

UserDo user1 = userMapper.selectOne(new LambdaQueryWrapper()
.eq(UserDo::getAccount, username));