Mybatisplus条件构造器

 //条件构造器
    @Test
    public void testSelect() {
        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
        /**
         * gt: greater than 大于
         * lt: less than 小于
         * e:equal
         */
        //queryWrapper.ge("age",21);

        //eq、ne
        //queryWrapper.eq("name","Tom");

        //between、notBetween
        //queryWrapper.between("age",24,28);

        //like、notLike、likeLeft、likeRight
        //queryWrapper.like("name","张");

        //orderBy、orderByDesc、orderByAsc
       queryWrapper.orderByDesc("id");

        List<User> users = userMapper.selectList(queryWrapper);

        System.out.println(users);

    }
    //条件构造器
    @Test
    public void testSelect3() {
        LambdaQueryWrapper<User> userLambdaQueryWrapper = new LambdaQueryWrapper<>();
        userLambdaQueryWrapper.eq(User::getName,"Tom");
        User user1 = userMapper.selectOne(userLambdaQueryWrapper);
        System.out.println("user1"+user1);
        System.out.println("-----------------------------------");
        User user2 = userMapper.selectOne(new LambdaQueryWrapper<User>().eq(User::getName, "Tom"));
        System.out.println("user2"+user2);
        System.out.println("-----------------------------------");
        User user3 = userMapper.selectOne(Wrappers.<User>lambdaQuery().eq(User::getName,"Tom"));
        System.out.println("user3"+user3);

    }
posted @ 2021-09-29 23:45  丁帅帅dss  阅读(77)  评论(0)    收藏  举报