mybatis plus 条件筛选数据

        //创建QueryWrapper对象
        QueryWrapper<User> wrapper = new QueryWrapper<>();
        //通过QueryWrapper设置条件
        /**
         *  代表含义
         *  ge   >
         *  gt   >=
         *  le   <
         *  lt   <=
         *  eq   =
         *  ne   !=
         *  between  范围
         *  orderByDesc/Asc  倒序/升序
         *  last    语句最后拼接sql语句
         *  select   指定列
         */
        wrapper.gt("age", 25);
        List<User> users = userMapper.selectList(wrapper);
        System.out.println(users);

        wrapper.eq("name", "Jone");
        List<User> users2 = userMapper.selectList(wrapper);
        System.out.println(users2);

        wrapper.between("age", 20, 29);
        List<User> users3 = userMapper.selectList(wrapper);
        System.out.println(users3);

        wrapper.orderByDesc("age");
        List<User> users4 = userMapper.selectList(wrapper);
        System.out.println(users4);

        wrapper.last("limit 1");
        List<User> users5 = userMapper.selectList(wrapper);
        System.out.println(users5);

        wrapper.select("name", "age");
        List<User> users7 = userMapper.selectList(wrapper);
        System.out.println(users7);