[关闭]
@liruiyi962464 2024-08-08T01:10:07.000000Z 字数 584 阅读 61

QueryWrapper 不差用的

代码


QueryWrapper apply拼接sql查询

  1. QueryWrapper<YwTerminalDistribution> queryWrapper = QueryGenerator.initQueryWrapper(ywTerminalDistribution, req.getParameterMap());
  2. queryWrapper.apply("actual_start_time <= {0} AND actual_end_time >= {0}",time);

QueryWrapper or使用

  1. int count = zctMatchedBaseService.count(new QueryWrapper<ZctMatchedBase>().eq("id", id).and(wrapper -> wrapper.eq("is_weld", "1").or().eq("is_detection", "1")));

QueryWrapper 查询返回单个字段

  1. String usernameString = sysUserService.list(new QueryWrapper<SysUser>().in("id", userIds))
  2. .stream()
  3. .map(SysUser::getUsername)
  4. .collect(Collectors.joining(","));
添加新批注
在作者公开此批注前,只有你和作者可见。
回复批注