Lambda

LambdaQueryWrapper<OutCompanyEntity> queryWrapper = new LambdaQueryWrapper();
queryWrapper.ne(OutCompanyEntity::getId, id);
queryWrapper.and(e -> {
    // 公司编号/公司名称 不能重复
    e.eq(OutCompanyEntity::getCode, req.getCode()).or().eq(OutCompanyEntity::getName, req.getName());
});
if (this.count(queryWrapper) > 0) {
    throw new BusinessException("0004", new Object[]{"该公司编号/名称已存在"});
}
@Test
    void testQueryWrapper() {
//        QueryWrapper<User> queryWrapper = new QueryWrapper<>();
//        // QueryWrapper 条件查询
//        queryWrapper.like("user_name", "唐" );
//        List<User> userList = userMapper.selectList(queryWrapper);
//        userList.forEach(System.out::println);

        // QueryWrapper 条件查询
        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.like(User::getLogincd, "13" );
        List<User> userList2 = userMapper.selectList(lambdaQueryWrapper);
        userList2.forEach(System.out::println);

    }


    @Test
    void testUpdateWrapper() {
        LambdaUpdateWrapper<User> updateWrapper = new LambdaUpdateWrapper();
        updateWrapper.eq(User::getId, 1);
        // 更新指定字段
        updateWrapper.set(User::getUserName, "TOM" );
        updateWrapper.set(User::getPhone, "15123235656" );
        userMapper.update(null, updateWrapper);
    }

    @Test
    void testPage() {
        // QueryWrapper 条件查询
        LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.like(User::getUserName, "王" );

        Page page = new Page<>();
        page.setCurrent(1);
        page.setSize(5);
        IPage<User> dataPage = userMapper.selectPage(page, lambdaQueryWrapper);
        dataPage.getRecords().forEach(System.out::println);
    }
posted @ 2022-08-26 16:41  亲爱的阿道君  阅读(78)  评论(0)    收藏  举报