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);
}
不积跬步,无以至千里;不积小流,无以成江海。
浙公网安备 33010602011771号