mybatis返回复合类型参数

川长思鸟来 2021-09-28 10:50 513阅读 0赞

返回的数据模型

  1. package com.imooc.myo2o.entity;
  3. import java.util.Date;
  4. import java.util.List;
  6. public class Shop {
  8.     private Long shopId;
  9.     private Long ownerId;
  10.     private Long shopCategoryId;
  11.     private String shopName;
  12.     private String shopDesc;
  13.     private String shopAddr;
  14.     private String phone;
  15.     private String shopImg;
  16.     private Double longitude;
  17.     private Double latitude;
  18.     private Integer priority;
  19.     private Date createTime;
  20.     private Date lastEditTime;
  21.     private Integer enableStatus;
  22.     private String advice;
  24.     private List<ShopAuthMap> staffList;
  25.     private Area area;
  26.     private ShopCategory shopCategory;
  27.     private ShopCategory parentCategory;
  29.     public Long getShopId() {
  30.         return shopId;
  31.     }
  33.     public void setShopId(Long shopId) {
  34.         this.shopId = shopId;
  35.     }
  37.     public Long getOwnerId() {
  38.         return ownerId;
  39.     }
  41.     public void setOwnerId(Long ownerId) {
  42.         this.ownerId = ownerId;
  43.     }
  45.     public Long getShopCategoryId() {
  46.         return shopCategoryId;
  47.     }
  49.     public void setShopCategoryId(Long shopCategoryId) {
  50.         this.shopCategoryId = shopCategoryId;
  51.     }
  53.     public String getShopName() {
  54.         return shopName;
  55.     }
  57.     public void setShopName(String shopName) {
  58.         this.shopName = shopName;
  59.     }
  61.     public String getShopDesc() {
  62.         return shopDesc;
  63.     }
  65.     public void setShopDesc(String shopDesc) {
  66.         this.shopDesc = shopDesc;
  67.     }
  69.     public String getShopAddr() {
  70.         return shopAddr;
  71.     }
  73.     public void setShopAddr(String shopAddr) {
  74.         this.shopAddr = shopAddr;
  75.     }
  77.     public String getPhone() {
  78.         return phone;
  79.     }
  81.     public void setPhone(String phone) {
  82.         this.phone = phone;
  83.     }
  85.     public String getShopImg() {
  86.         return shopImg;
  87.     }
  89.     public void setShopImg(String shopImg) {
  90.         this.shopImg = shopImg;
  91.     }
  93.     public Double getLongitude() {
  94.         return longitude;
  95.     }
  97.     public void setLongitude(Double longitude) {
  98.         this.longitude = longitude;
  99.     }
  101.     public Double getLatitude() {
  102.         return latitude;
  103.     }
  105.     public void setLatitude(Double latitude) {
  106.         this.latitude = latitude;
  107.     }
  109.     public Integer getPriority() {
  110.         return priority;
  111.     }
  113.     public void setPriority(Integer priority) {
  114.         this.priority = priority;
  115.     }
  117.     public Date getCreateTime() {
  118.         return createTime;
  119.     }
  121.     public void setCreateTime(Date createTime) {
  122.         this.createTime = createTime;
  123.     }
  125.     public Date getLastEditTime() {
  126.         return lastEditTime;
  127.     }
  129.     public void setLastEditTime(Date lastEditTime) {
  130.         this.lastEditTime = lastEditTime;
  131.     }
  133.     public Integer getEnableStatus() {
  134.         return enableStatus;
  135.     }
  137.     public void setEnableStatus(Integer enableStatus) {
  138.         this.enableStatus = enableStatus;
  139.     }
  141.     public List<ShopAuthMap> getStaffList() {
  142.         return staffList;
  143.     }
  145.     public void setStaffList(List<ShopAuthMap> staffList) {
  146.         this.staffList = staffList;
  147.     }
  149.     public Area getArea() {
  150.         return area;
  151.     }
  153.     public void setArea(Area area) {
  154.         this.area = area;
  155.     }
  157.     public ShopCategory getShopCategory() {
  158.         return shopCategory;
  159.     }
  161.     public void setShopCategory(ShopCategory shopCategory) {
  162.         this.shopCategory = shopCategory;
  163.     }
  165.     public String getAdvice() {
  166.         return advice;
  167.     }
  169.     public void setAdvice(String advice) {
  170.         this.advice = advice;
  171.     }
  173.     public String toString() {
  174.         return "[shopId=" + shopId + ", shopName=" + shopName + "]";
  175.     }
  177.     public ShopCategory getParentCategory() {
  178.         return parentCategory;
  179.     }
  181.     public void setParentCategory(ShopCategory parentCategory) {
  182.         this.parentCategory = parentCategory;
  183.     }
  185. }

mapper

  1. <mapper namespace="com.imooc.myo2o.dao.ShopDao">
  2.     <resultMap id="shopMap" type="com.imooc.myo2o.entity.Shop">
  3.         <id column="shop_id" property="shopId" />
  4.         <result column="owner_id" property="ownerId" />
  5.         <result column="shop_category_id" property="shopCategoryId" />
  6.         <result column="shop_name" property="shopName" />
  7.         <result column="shop_desc" property="shopDesc" />
  8.         <result column="shop_addr" property="shopAddr" />
  9.         <result column="phone" property="phone" />
  10.         <result column="shop_img" property="shopImg" />
  11.         <result column="longitude" property="longitude" />
  12.         <result column="latitude" property="latitude" />
  13.         <result column="priority" property="priority" />
  14.         <result column="create_time" property="createTime" />
  15.         <result column="last_edit_time" property="lastEditTime" />
  16.         <result column="enable_status" property="enableStatus" />
  17.         <result column="advice" property="advice" />
  18.         <association property="area" column="area_id"
  19.             javaType="com.imooc.myo2o.entity.Area">
  20.             <id column="area_id" property="areaId" />
  21.             <result column="area_name" property="areaName" />
  22.             <result column="area_desc" property="areaDesc" />
  23.             <result column="priority" property="priority" />
  24.             <result column="create_time" property="createTime" />
  25.             <result column="last_edit_time" property="lastEditTime" />
  26.         </association>
  27.         <association property="shopCategory" column="shop_category_id"
  28.             javaType="com.imooc.myo2o.entity.ShopCategory">
  29.             <id column="shop_category_id" property="shopCategoryId" />
  30.             <result column="shop_category_name" property="shopCategoryName" />
  31.             <result column="shop_category_desc" property="shopCategoryDesc" />
  32.             <result column="shop_category_img" property="shopCategoryImg" />
  33.             <result column="priority" property="priority" />
  34.             <result column="create_time" property="createTime" />
  35.             <result column="last_edit_time" property="lastEditTime" />
  36.         </association>
  37.         <association property="parentCategory" column="parent_category_id"
  38.             javaType="com.imooc.myo2o.entity.ShopCategory">
  39.             <id column="parent_category_id" property="shopCategoryId" />
  40.             <result column="shop_category_name" property="shopCategoryName" />
  41.             <result column="shop_category_desc" property="shopCategoryDesc" />
  42.             <result column="shop_category_img" property="shopCategoryImg" />
  43.             <result column="priority" property="priority" />
  44.             <result column="create_time" property="createTime" />
  45.             <result column="last_edit_time" property="lastEditTime" />
  46.         </association>
  47.         <collection property="staffList" column="shop_id"
  48.             ofType="com.imooc.myo2o.entity.ShopAuthMap">
  49.             <id column="shop_auth_id" property="shopAuthId" />
  50.             <result column="employee_id" property="employeeId" />
  51.             <result column="shop_id" property="shopId" />
  52.             <result column="name" property="name" />
  53.             <result column="title" property="title" />
  54.             <result column="title_flag" property="titleFlag" />
  55.             <result column="create_time" property="createTime" />
  56.             <result column="last_edit_time" property="lastEditTime" />
  57.             <result column="enable_status" property="enableStatus" />
  58.         </collection>
  59.     </resultMap>
  60.     <select id="queryShopList" resultMap="shopMap">
  61.         SELECT
  62.         shop_id,
  63.         owner_id,
  64.         area_id,
  65.         shop_category_id,
  66.         parent_category_id,
  67.         shop_name,
  68.         shop_desc,
  69.         shop_addr,
  70.         phone,
  71.         shop_img,
  72.         longitude,
  73.         latitude,
  74.         priority,
  75.         create_time,
  76.         last_edit_time,
  77.         enable_status,
  78.         advice
  79.         FROM
  80.         tb_shop
  81.         <where>
  82.             <if test="shopCondition.shopId!=null">
  83.                 and shop_id = #{shopCondition.shopId}
  84.             </if>
  85.             <if
  86.                 test="shopCondition.shopCategory!=null
  87.                  and shopCondition.shopCategory.shopCategoryId!=null">
  88.                 and shop_category_id =
  89.                 #{shopCondition.shopCategory.shopCategoryId}
  90.             </if>
  91.             <if
  92.                 test="shopCondition.parentCategory!=null
  93.                  and shopCondition.parentCategory.shopCategoryId!=null">
  94.                 and parent_category_id =
  95.                 #{shopCondition.parentCategory.shopCategoryId}
  96.             </if>
  97.             <if
  98.                 test="shopCondition.area!=null
  99.                  and shopCondition.area.areaId!=null">
  100.                 and area_id =
  101.                 #{shopCondition.area.areaId}
  102.             </if>
  103.             <!-- 写like语句的时候 一般都会写成 like '% %' 在mybatis里面写就是应该是 like '%${name} %' 而不是 
  104.                 '%#{name} %' ${name} 是不带单引号的，而#{name} 是带单引号的 -->
  105.             <if test="shopCondition.shopName!=null">
  106.                 and shop_name like '%${shopCondition.shopName}%'
  107.             </if>
  108.             <if test="shopCondition.enableStatus!=null">
  109.                 and enable_status = #{shopCondition.enableStatus}
  110.             </if>
  111.         </where>
  112.         ORDER BY
  113.         priority DESC
  114.         LIMIT #{rowIndex},#{pageSize};
  115.     </select>

原文转自：mybatis 返回复合类型

发表评论

表情：
评论列表 （有 0 条评论，513人围观）

还没有评论，来说两句吧...

相关阅读

    相关 go 复合类型

    1、pointer：指针，默认值：nil 指针是一个代表着某个内存地址的值。这个内存地址往往是在内存中存储的另一个变量的值的起始位置，go语言对指针的支持介于java语言

    叁歲伎倆叁歲伎倆/ 0 赞/ 224 阅读

    相关 【c++】复合类型

    什么是复合类型？ 我在之前说过，具体的定义我说不出来，不过可以怎么理解，复合类型比基本类型高级一些，它可以存储别的变量。你要知道通过基本的数据类型的是无法完成什么大事情的。

    青旅半醒青旅半醒/ 0 赞/ 288 阅读

    相关 JS复合类型

    1：JS复合类型 符合类型是由多个基本数据类型（也可以包括复合类型）组成的数据体。JS中大致可以分为3种符合类型： Object：对象。[详情点此][Link 1] Ar

    ╰半橙微兮°╰半橙微兮°/ 0 赞/ 266 阅读