LambdaQueryWrapper<Project>
时间: 2023-11-01 20:59:08 浏览: 88
LambdaQueryWrapper<Project>是一个Lambda表达式格式的查询包装器,用于构建查询条件。使用LambdaQueryWrapper可以方便地按照条件查询数据。下面是一些使用LambdaQueryWrapper的方法和功能:
1. 使用lt方法进行小于条件查询:
LambdaQueryWrapper<Project> lqw = new LambdaQueryWrapper<>();
lqw.lt(Project::getStartTime, LocalDateTime.now());
List<Project> projectList = projectDao.selectList(lqw);
System.out.println(projectList);
2. 使用or方法进行或者关系查询:
LambdaQueryWrapper<Project> lqw = new LambdaQueryWrapper<>();
lqw.eq(Project::getStatus, "active").or().eq(Project::getStatus, "pending");
List<Project> projectList = projectDao.selectList(lqw);
System.out.println(projectList);
3. 默认是并且关系查询:
LambdaQueryWrapper<Project> lqw = new LambdaQueryWrapper<>();
lqw.eq(Project::getType, "A").eq(Project::getStatus, "active");
List<Project> projectList = projectDao.selectList(lqw);
System.out.println(projectList);
阅读全文