1 Item商品详情功能开发
功能开发 Sku信息,图片信息,销售属性切换
解决方案1 :
1 在页面展示销售属性列表之前
用当前sku查询中间表,找到当前sku关联的销售属性值
2 用当前sku关联的销售属性值遍历页面展示销售属性列表
如果匹配则将页面展示销售属性列表isCheck属性置为1,否则默认0
3 页面使用三元表达式进行判断
如果isCheck则返回redborder,否则返回灰色
解决方案2:
不使用通用mapper
SELECT
sa.*, sav.*,sa.id as sa_id ,sav.id as sav_id,
IF (ssav.sku_id, 1, 0) AS isChecked
FROM
pms_product_sale_attr sa
INNER JOIN pms_product_sale_attr_value sav ON sa.sale_attr_id = sav.sale_attr_id
AND sa.product_id = sav.product_id
AND sa.product_id = #{spuId}
LEFT JOIN pms_sku_sale_attr_value ssav ON sav.id = ssav.sale_attr_value_id
AND ssav.sku_id = #{skuId}
2 代码落实阶阶段
1 新建item-web工程(item-service即manage-service)
2 添加thymeleaf的松校验和热部署
a 在web-util中添加依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org.csource</groupId>
<artifactId>fastdfs-client-java</artifactId>
<version>1.27-SNAPSHOT</version>
</dependency>
<dependency>
<groupId>net.sourceforge.nekohtml</groupId>
<artifactId>nekohtml</artifactId>
</dependency>
<dependency>
<groupId>xml-apis</groupId>
<artifactId>xml-apis</artifactId>
</dependency>
<dependency>
<groupId>org.apache.xmlgraphics</groupId>
<artifactId>batik-ext</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/org.jsoup/jsoup -->
<dependency>
<groupId>org.jsoup</groupId>
<artifactId>jsoup</artifactId>
</dependency>
b .在item-web中添加依赖
<dependency>
<groupId>com.atguigu.gmall</groupId>
<artifactId>gmall-web-util</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>
c 在item-web中添加static模块
d application.properties
server.port=8082
logging.level.root=info
# dubbo的配置
spring.dubbo.registry.address=192.168.222.20:2181
spring.dubbo.registry.protocol=zookeeper
spring.dubbo.protocol.name=dubbo
spring.dubbo.base-package=com.atguigu.gmall
spring.dubbo.application.name=gmall-item-web
spring.dubbo.consumer.check=false
spring.dubbo.consumer.timeout=600000
#thymeleaf
spring.thymeleaf.mode=LEGACYHTML5
spring.thymeleaf.cache=false
e 已经在service-util中添加了关于redis.clients即jedis连接池的内容的依赖
关于连接池,好像我现在做的关乎框架的东西都是去配置一下,去连接池取值,在页面显示
上条规律还待观察