mybatis-plus不查询出全部的列，只查询出自己需要的列

只查询需要的列，使用select

    @Test
    public void testSelectColumn() {
        LambdaQueryWrapper<User> userQueryWrapper = Wrappers.<User>lambdaQuery()
                .select(User::getId,User::getName).likeRight(User::getName, "梅");
        List<User> users = userMapper.selectList(userQueryWrapper);
        System.out.println(users);
        //结果[User(id=1, name=梅长苏, age=null, email=null, parentId=null, createTime=null)]
    }

 

 

当要查询的字段较多的时候，可以采用排除法，排除不需要的字段

    @Test
    public void testSelectColumn2() {
        LambdaQueryWrapper<User> userQueryWrapper = Wrappers.<User>lambdaQuery()
                .likeRight(User::getName, "梅")
                .select(User.class,info->!info.getColumn().equals("name"));
        List<User> users = userMapper.selectList(userQueryWrapper);
        System.out.println(users);
        //[User(id=1, name=null, age=40, email=boss@qq.com, parentId=null, createTime=Fri Jan 11 14:20:20 CST 2019)]
    }