LambdaQueryWrapper在Mybatis-plus中的应用

最新推荐文章于 2025-07-31 14:36:50 发布

原创最新推荐文章于 2025-07-31 14:36:50 发布 · 364 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis

LambdaQueryWrapper 是 MyBatis-Plus 中非常强大的工具，用于构建类型安全的查询条件。它利用 Java 的 Lambda 表达式，使得查询条件的编写更加简洁和直观。

public R getAppArticleCategoryPage(@ParameterObject Page page,
			@ParameterObject AppArticleCategoryEntity appArticleCategory) {
		LambdaQueryWrapper<AppArticleCategoryEntity> wrapper = Wrappers.lambdaQuery();
		wrapper.like(StrUtil.isNotBlank(appArticleCategory.getName()), AppArticleCategoryEntity::getName,
				appArticleCategory.getName());
		return R.ok(appArticleCategoryService.page(page, wrapper));
	}

1.等值查询

LambdaQueryWrapper<ProftitlemngorgEntity> wrapper = Wrappers.lambdaQuery();
wrapper.eq(ProftitlemngorgEntity::getId, 1);
List<ProftitlemngorgEntity> result = proftitlemngorgMapper.selectList(wrapper);

2.多条件查询

LambdaQueryWrapper<ProftitlemngorgEntity> wrapper = Wrappers.lambdaQuery();
wrapper.eq(ProftitlemngorgEntity::getName, "张三")
       .gt(ProftitlemngorgEntity::getAge, 20);
List<ProftitlemngorgEntity> result = proftitlemngorgMapper.selectList(wrapper);

3.模糊查询

LambdaQueryWrapper<ProftitlemngorgEntity> wrapper = Wrappers.lambdaQuery();
wrapper.like(ProftitlemngorgEntity::getName, "张");
List<ProftitlemngorgEntity> result = proftitlemngorgMapper.selectList(wrapper);

4.排序查询

LambdaQueryWrapper<ProftitlemngorgEntity> wrapper = Wrappers.lambdaQuery();
wrapper.orderByAsc(ProftitlemngorgEntity::getAge);
List<ProftitlemngorgEntity> result = proftitlemngorgMapper.selectList(wrapper);

5.分组查询

LambdaQueryWrapper<ProftitlemngorgEntity> wrapper = Wrappers.lambdaQuery();
wrapper.groupBy(ProftitlemngorgEntity::getDepartment);
List<ProftitlemngorgEntity> result = proftitlemngorgMapper.selectList(wrapper);