• mybatis 一对多 一对一 xml配置


    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.sdzy.member.service.model.ServiceProduct">
    <id column="productId" property="productId" />
    <result column="categoryId" property="categoryId" />
    <result column="companyId" property="companyId" />
    <result column="productNo" property="productNo" />
    <result column="productType" property="productType" />
    <result column="productName" property="productName" />
    <result column="productPic" property="productPic" />
    <result column="productIntroduction" property="productIntroduction" />
    <result column="productDescription" property="productDescription" />
    <result column="productOuterId" property="productOuterId" />
    <result column="state" property="state" />
    <result column="operatorId" property="operatorId" />
    <result column="operator" property="operator" />
    <result column="createDate" property="createDate" />
    <result column="modifyDate" property="modifyDate" />
    <result column="remark" property="remark" />

    <!--不在数据库字段-->
    <result column="companyCode" jdbcType="VARCHAR" property="companyCode" />
    <result column="categoryCode" jdbcType="VARCHAR" property="categoryCode" />
    <result column="companyName" jdbcType="VARCHAR" property="companyName" />
    <result column="categoryName" jdbcType="VARCHAR" property="categoryName" />


    <!-- 通用查询映射结果 -->
    <association property="serviceProductStat" javaType="com.sdzy.member.service.model.ServiceProductStat">
    <id column="statId" property="statId" />
    <result column="buyerType" property="buyerType" />
    <result column="buyerId" property="buyerId" />
    <result column="s_categoryId" property="categoryId" />
    <result column="totalAmount" property="totalAmount" />
    <result column="totalCount" property="totalCount" />
    <result column="expiredDate" property="expiredDate" />
    <result column="s_createDate" property="createDate" />
    <result column="s_modifyDate" property="modifyDate" />
    <result column="s_state" property="state" />
    <result column="remark" property="remark" />

    <result column="storeCode" property="storeCode" />
    <result column="storeName" property="storeName" />
    <result column="categoryName" property="categoryName" />
    <result column="categoryCode" property="categoryCode" />
    <result column="companyId" property="companyId" />
    <result column="storeId" property="storeId" />
    </association>

    <!--子查询-->
    <collection property="detailList" ofType="com.sdzy.member.service.model.ServiceProductPackage">
    <result column="p_productId" jdbcType="VARCHAR" property="productId" />
    <result column="packageId" jdbcType="VARCHAR" property="packageId" />
    <result column="standard" jdbcType="VARCHAR" property="standard" />
    <result column="standardValue" jdbcType="DECIMAL" property="standardValue" />
    <result column="unit" jdbcType="VARCHAR" property="unit" />
    <result column="price" jdbcType="DECIMAL" property="price" />
    <result column="discount" jdbcType="DECIMAL" property="discount" />
    <result column="p_state" jdbcType="INTEGER" property="state" />
    <result column="packageType" jdbcType="INTEGER" property="packageType" />
    <result column="p_createDate" jdbcType="TIMESTAMP" property="createDate" />
    <result column="p_modifyDate" jdbcType="TIMESTAMP" property="modifyDate" />
    <result column="p_remark" jdbcType="VARCHAR" property="remark" />
    </collection>

    </resultMap>

  • 相关阅读:
    linux目录结构介绍
    Linux下安装Redis
    SpringBoot启动器详解pom.xml
    Linux(CentOS6.X)安装mysql
    CentOS 7 安装 MySQL
    GIT和SVN的区别
    SourceTree安装教程
    Git版本控制软件结合GitHub从入门到精通常用命令学习手册
    WIN下Git GUI 教程
    把文件(项目)上传到Git@OSC
  • 原文地址:https://www.cnblogs.com/feathe/p/12060511.html
Copyright © 2020-2023  润新知