Mybatis-Plus条件查询器 Wrapper

email和name不为空 和年级大于等于12

 QueryWrapper<User> wrapper = new QueryWrapper();
        //email和name不为空 和年级大于等于12
        wrapper
//                不为空
                .isNotNull("email")
//                不为空
                .isNotNull("name")
//                大于
                .ge("age",12);
        System.out.println(iUserRepository.selectList(wrapper));

查询名字 selectone 查询一个

        QueryWrapper<User> wrapper = new QueryWrapper();
        wrapper
       // 名字为sandy
                .eq("name","Sandy");
        System.out.println(iUserRepository.selectOne(wrapper));

查询10-20中间 的个数

        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
                .between("age",10,22);
        System.out.println(iUserRepository.selectCount(wrapper));

模糊查询

 QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
                .notLike("name","e")
                .likeRight("email","t");
        iUserRepository.selectList(wrapper).forEach(System.out::println);

子查询

        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
                .inSql("id","select id from user where id > 6");
        iUserRepository.selectObjs(wrapper).forEach(System.out::println);

排序

QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper
                .orderByDesc("id");
        iUserRepository.selectList(wrapper).forEach(System.out::println);