image.png
pojo
1.在domain下创建商品微服务的子文件夹item，商品相关的字Moudel都会放在这个下面
2.从依赖最少的模块pojo（dao和领域模型）开始
3.创建foodie-item-pojo子模块（把商品域item嵌入在foodie-pojo中)
4.添加依赖项，主要是支持Dao层(持久层依赖)
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>foodie-cloud</artifactId>
<groupId>com.imooc</groupId>
<version>1.0-SNAPSHOT</version>
<relativePath>../../../pom.xml</relativePath>
</parent>
<modelVersion>4.0.0</modelVersion>
<artifactId>foodie-item-pojo</artifactId>
<dependencies>
<dependency>
<groupId>javax.persistence</groupId>
<artifactId>persistence-api</artifactId>
<version>1.0</version>
</dependency>
<dependency>
<groupId>org.hibernate.validator</groupId>
<artifactId>hibernate-validator</artifactId>
</dependency>
</dependencies>
</project>
5.文件移植
a.移植Items:Items、ItemsComments、ItemsImg、ItemsParam、ItemsSpec
b.移植vo:
> do bo划分？不会把DO直接传递一次再透传回来，屏蔽底层的修改影响到上游
mapper
1.创建foodie-item-mapper项目
依赖pojo
pom的依赖不要写版本号，另外一种方式实现
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>foodie-cloud</artifactId>
<groupId>com.imooc</groupId>
<version>1.0-SNAPSHOT</version>
<relativePath>../../../pom.xml</relativePath>
</parent>
<modelVersion>4.0.0</modelVersion>
<artifactId>foodie-item-mapper</artifactId>
<dependencies>
<dependency>
<groupId>${project.groupId}</groupId>
<artifactId>foodie-dev-pojo</artifactId>
<version>${project.version}</version>
</dependency>
<dependency>
<groupId>${project.groupId}</groupId>
<artifactId>foodie-cloud-common</artifactId>
<version>${project.version}</version>
</dependency>
</dependencies>
</project>
2.copy foodie下面的mapper到item
import路径正确但还是标红，重新导入
3.ItemsMapperCustom文件搜索功能的移植（TODO）
package com.imooc.item.mapper;
import com.imooc.pojo.vo.ItemCommentVO;
import com.imooc.pojo.vo.SearchItemsVO;
import com.imooc.pojo.vo.ShopcartVO;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;
public interface ItemsMapperCustom {
public List<ItemCommentVO> queryItemComments(@Param("paramsMap") Map<String, Object> map);
//TODO 迁移到foodie-search
// public List<SearchItemsVO> searchItems(@Param("paramsMap") Map<String, Object> map);
//
// public List<SearchItemsVO> searchItemsByThirdCat(@Param("paramsMap") Map<String, Object> map);
public List<ShopcartVO> queryItemsBySpecIds(@Param("paramsList") List specIdsList);
public int decreaseItemSpecStock(@Param("specId") String specId,
@Param("pendingCounts") int pendingCounts);
}
4.移植resource文件，将所有的mapper文件复制到resource/mapper文件夹下
修改mapper的路径(替换方式)
5.注释ItemsMapperCustom对应的sql
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.imooc.item.mapper.ItemsMapperCustom" >
<select id="queryItemComments" parameterType="Map" resultType="com.imooc.item.pojo.vo.ItemCommentVO">
SELECT
ic.comment_level as commentLevel,
ic.content as content,
ic.sepc_name as specName,
ic.created_time as createdTime,
u.face as userFace,
u.nickname as nickname
FROM
items_comments ic
LEFT JOIN
users u
ON
ic.user_id = u.id
WHERE
ic.item_id = #{paramsMap.itemId}
<if test=" paramsMap.level != null and paramsMap.level != '' ">
AND ic.comment_level = #{paramsMap.level}
</if>
</select>
<!-- <select id="searchItems" parameterType="Map" resultType="com.imooc.item.pojo.vo.SearchItemsVO">-->
<!-- SELECT-->
<!-- i.id as itemId,-->
<!-- i.item_name as itemName,-->
<!-- i.sell_counts as sellCounts,-->
<!-- ii.url as imgUrl,-->
<!-- tempSpec.price_discount as price-->
<!-- FROM-->
<!-- items i-->
<!-- LEFT JOIN-->
<!-- items_img ii-->
<!-- on-->
<!-- i.id = ii.item_id-->
<!-- LEFT JOIN-->
<!-- (SELECT item_id,MIN(price_discount) as price_discount from items_spec GROUP BY item_id) tempSpec-->
<!-- on-->
<!-- i.id = tempSpec.item_id-->
<!-- WHERE-->
<!-- ii.is_main = 1-->
<!-- <if test=" paramsMap.keywords != null and paramsMap.keywords != '' ">-->
<!-- AND i.item_name like '%${paramsMap.keywords}%'-->
<!-- </if>-->
<!-- order by-->
<!-- <choose>-->
<!-- <when test=" paramsMap.sort == "c" ">-->
<!-- i.sell_counts desc-->
<!-- </when>-->
<!-- <when test=" paramsMap.sort == "p" ">-->
<!-- tempSpec.price_discount asc-->
<!-- </when>-->
<!-- <otherwise>-->
<!-- i.item_name asc-->
<!-- </otherwise>-->
<!-- </choose>-->
<!-- </select>-->
<!-- <!– k: 默认，代表默认排序，根据name–>-->
<!-- <!– c: 根据销量排序–>-->
<!-- <!– p: 根据价格排序–>-->
<!-- <select id="searchItemsByThirdCat" parameterType="Map" resultType="com.imooc.item.pojo.vo.SearchItemsVO">-->
<!-- SELECT-->
<!-- i.id as itemId,-->
<!-- i.item_name as itemName,-->
<!-- i.sell_counts as sellCounts,-->
<!-- ii.url as imgUrl,-->
<!-- tempSpec.price_discount as price-->
<!-- FROM-->
<!-- items i-->
<!-- LEFT JOIN-->
<!-- items_img ii-->
<!-- on-->
<!-- i.id = ii.item_id-->
<!-- LEFT JOIN-->
<!-- (SELECT item_id,MIN(price_discount) as price_discount from items_spec GROUP BY item_id) tempSpec-->
<!-- on-->
<!-- i.id = tempSpec.item_id-->
<!-- WHERE-->
<!-- ii.is_main = 1-->
<!-- and-->
<!-- i.cat_id = #{paramsMap.catId}-->
<!-- order by-->
<!-- <choose>-->
<!-- <when test=" paramsMap.sort == "c" ">-->
<!-- i.sell_counts desc-->
<!-- </when>-->
<!-- <when test=" paramsMap.sort == "p" ">-->
<!-- tempSpec.price_discount asc-->
<!-- </when>-->
<!-- <otherwise>-->
<!-- i.item_name asc-->
<!-- </otherwise>-->
<!-- </choose>-->
<!-- </select>-->
<select id="queryItemsBySpecIds" parameterType="List" resultType="com.imooc.item.pojo.vo.ShopcartVO">
SELECT
t_items.id as itemId,
t_items.item_name as itemName,
t_items_img.url as itemImgUrl,
t_items_spec.id as specId,
t_items_spec.`name` as specName,
t_items_spec.price_discount as priceDiscount,
t_items_spec.price_normal as priceNormal
FROM
items_spec t_items_spec
LEFT JOIN
items t_items
ON
t_items.id = t_items_spec.item_id
LEFT JOIN
items_img t_items_img
on
t_items_img.item_id = t_items.id
WHERE
t_items_img.is_main = 1
AND
t_items_spec.id IN
<foreach collection="paramsList" index="index" item="specId" open="(" separator="," close=")">
#{specId}
</foreach>
</select>
<update id="decreaseItemSpecStock">
update
items_spec
set
stock = stock - #{pendingCounts}
where
id = #{specId}
and
stock >= #{pendingCounts}
</update>
</mapper>
网友评论