Java 基础 MyBatis-Plus 组装查询条件

	public List<Material> select(Long productId, Long storeId, Long categoryId) {
		LambdaQueryChainWrapper<Material> lambdaQueryChainWrapper = new LambdaQueryChainWrapper<Material>(baseMapper);
		if (Objects.nonNull(productId) && (productId > 0)) {
			lambdaQueryChainWrapper.eq(Material::getProductId, productId);
		}
		if (Objects.nonNull(storeId) && (storeId > 0)) {
			lambdaQueryChainWrapper.eq(Material::getStoreId, storeId);
		}
		if (Objects.nonNull(categoryId) && (categoryId > 0)) {
			lambdaQueryChainWrapper.eq(Material::getCategoryId, categoryId);
		}
		return lambdaQueryChainWrapper.list();
	}
posted @ 2020-12-18 09:32  古兴越  阅读(483)  评论(0)    收藏  举报