From 32f88973e57e54e9c2ac0bcdacc2535c8f304fb4 Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Mon, 02 Sep 2024 10:41:16 +0800
Subject: [PATCH] test和数据库连接
---
src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallGoodsCategoryService.java | 1 +
src/main/resources/mapper/modules/MallGoodsStyleMapper.xml | 2 +-
2 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallGoodsCategoryService.java b/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallGoodsCategoryService.java
index 5d5ff09..06dadc4 100644
--- a/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallGoodsCategoryService.java
+++ b/src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallGoodsCategoryService.java
@@ -129,6 +129,7 @@
mallGoodsCategory.setIsRecommend(0);
}else{
mallGoodsCategory.setParentId(0L);
+ mallGoodsCategory.setParentIds("");
mallGoodsCategory.setIsRecommend(mallGoodsCategoryParam.getIsRecommend());
}
mallGoodsCategoryMapper.updateById(mallGoodsCategory);
diff --git a/src/main/resources/mapper/modules/MallGoodsStyleMapper.xml b/src/main/resources/mapper/modules/MallGoodsStyleMapper.xml
index 0742036..bd036b7 100644
--- a/src/main/resources/mapper/modules/MallGoodsStyleMapper.xml
+++ b/src/main/resources/mapper/modules/MallGoodsStyleMapper.xml
@@ -24,7 +24,7 @@
<select id="selectByGoodsId" resultMap="styleMap">
select a.*, b.id sku_sku_id, b.style_id sku_style_id from mall_goods_style a
- left join mall_goods_sku b on a.goods_id=b.goods_id
+ INNER JOIN mall_goods_sku b ON a.id = b.style_id
where a.goods_id=#{goodsId}
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.1