mybatisplus where语句里面的条件用括号括起来

最新推荐文章于 2025-03-07 18:41:24 发布

潘小菲就是我昂

最新推荐文章于 2025-03-07 18:41:24 发布

阅读量2.2w

点赞数 13

分类专栏： JAVA mybatisplus 文章标签： mybatisplus where括号

本文链接：https://blog.csdn.net/pan_fei/article/details/96976468

版权

JAVA 同时被 2 个专栏收录

7 篇文章

订阅专栏

mybatisplus

2 篇文章

订阅专栏

这标题通俗易懂吧，说正事

queryWrapper.and(wrapper -> wrapper.eq("batch_name", prodBatch.getBatchName()).or().eq("batch_code", prodBatch.getBatchCode()));

	public Result<ProdBatch> add(@RequestBody ProdBatch prodBatch, HttpServletRequest request) {
		Result<ProdBatch> result = new Result<ProdBatch>();
		try {
			QueryWrapper<ProdBatch> queryWrapper = new QueryWrapper<ProdBatch>();
			queryWrapper.eq("is_delete", 0);
			queryWrapper.and(wrapper -> wrapper.eq("batch_name", prodBatch.getBatchName()).or().eq("batch_code", prodBatch.getBatchCode()));
			queryWrapper.eq("company_id", prodBatch.getCompanyId());
			queryWrapper.eq("plat_id", prodBatch.getPlatId());
			queryWrapper.orderByDesc("create_date");
			List<ProdBatch> prodBatchList = prodBatchService.list(queryWrapper);
			if (prodBatchList != null && prodBatchList.size() > 0) {
				result.setSuccess(false);
				result.setMessage("产品批次名称或产品批次编号重复");
				return result;
			}
			prodBatch.setCreateDate(new Date());
			prodBatch.setModifiedDate(new Date());
			prodBatchService.save(prodBatch); 
			result.success("添加成功！");
		} catch (Exception e) {
			e.printStackTrace();
			log.info(e.getMessage());
			result.error500("操作失败");
		}
		return result;
	}

切记不能丢了and

打印出来的sql为

SELECT
	id,
	batch_name,
	batch_code,
	create_type,
	sort,
	come_into_season_date,
	video_monitoring_url,
	company_video,
	shop_url,
	vr_video,
	remark,
	prod_id,
	matrix_id,
	info_show,
	info_show_model_id,
	qr_url,
	company_id,
	create_date,
	modified_date,
	create_pei_id,
	modified_pei_id,
	is_delete,
	delete_date,
	plat_id
FROM
	tb_prod_batch
WHERE
	is_delete = 0
AND (
	batch_name = '20190723次'
	OR batch_code = '190723P000004000140'
)
AND company_id = '000001'
AND plat_id = '000001'
ORDER BY
	create_date DESC