#分类查询一对多设置

jiaosong

2023-09-11 e46582c7d8bc7520daa324d3785abad7a4fcd18e

#分类查询一对多设置

 server/service/src/main/java/com/doumee/dao/business/BaseCateParamMapper.java

@@ -2,6 +2,9 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.doumee.dao.business.model.BaseCateParam;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author æ±Ÿè¹„蹄
@@ -9,4 +12,12 @@
 */
public interface BaseCateParamMapper extends BaseMapper<BaseCateParam> {


    /**
     *
     * æŸ¥è¯¢å‚数配置
     * @param categoryId
     * @return
     */
    List<BaseCateParam> getBaseCateParamList(@Param("categoryId") Integer categoryId);
}

 server/service/src/main/java/com/doumee/dao/business/model/BaseCategory.java

@@ -12,6 +12,7 @@

import java.math.BigDecimal;
import java.util.Date;
import java.util.List;

/**
 * ç´ æåº“-品类信息表
@@ -89,8 +90,11 @@
    @ExcelColumn(name="加价系数")
    private BigDecimal priceRate;

    @ApiModelProperty(value = "图标")
    @ExcelColumn(name="图标")
    @ApiModelProperty(value = "图标 å…¨è·¯å¾„")
    @TableField(exist = false)
    private String imgfullurl;

    @ApiModelProperty(value = "品类参数")
    @TableField(exist = false)
    private List<BaseCateParam> baseCateParamList;
}

 server/service/src/main/resources/mappers/BaseCateParamMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
<?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.doumee.dao.business.BaseCateParamMapper">

    <resultMap id="BaseCateParam" type="com.doumee.dao.business.model.BaseCateParam">
        <id column="ID" jdbcType="INTEGER" property="id" />
        <result column="CREATOR" jdbcType="INTEGER" property="creator" />
        <result column="CREATE_DATE" jdbcType="VARCHAR" property="createDate" />
        <result column="EDITOR" jdbcType="VARCHAR" property="editor" />
        <result column="EDIT_DATE" jdbcType="VARCHAR" property="editDate"/>
        <result column="ISDELETED" jdbcType="TIMESTAMP" property="isdeleted"/>
        <result column="NAME" jdbcType="TIMESTAMP" property="name"/>
        <result column="REMARK" jdbcType="TIMESTAMP" property="remark"/>
        <result column="STATUS" jdbcType="TIMESTAMP" property="status"/>
        <result column="SORTNUM" jdbcType="TIMESTAMP" property="sortnum"/>
        <result column="CATEGORY_ID" jdbcType="TIMESTAMP" property="categoryId"/>
    </resultMap>
    <select id="getBaseCateParamList" resultType="com.doumee.dao.business.model.BaseCateParam">
        select * from base_cate_param where CATEGORY_ID = #{categoryId}
    </select>
</mapper>

 server/service/src/main/resources/mappers/BaseCategoryMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,14 @@
<?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.doumee.dao.business.BaseCategoryMapper">
    <resultMap id="BaseCategory" type="com.doumee.dao.business.model.BaseCategory" autoMapping="true">
        <id column="ID" jdbcType="INTEGER" property="id"/>
        <collection property="baseCateParamList"
                    column="{id=categoryId}"
                    ofType="com.doumee.dao.business.model.BaseCateParam"
                    javaType="ArrayList"
                    select="com.doumee.dao.system.getStudent" />
    </resultMap>


</mapper>