mybatis 返回的对象包含集合

素颜马尾好姑娘i 2023-01-06 01:19 132阅读 0赞

DeviceQuestionInstruction.java

import com.hikari.cloud.data.entity.TbInstruction;
    import lombok.Data;
    
    import java.util.Date;
    import java.util.List;
    
    @Data
    public class DeviceQuestionInstruction { //tb_instruction 使用说明表
    
        private String dvqsTitle;
        private List<TbInstruction> instructionList;
    
    }

TbInstruction.java

import lombok.Data;
    
    import java.util.Date;
    
    @Data
    public class TbInstruction { //tb_instruction 使用说明表
        private Long id;
        private Long userId;
        private String title;
        private String detail;
        private String url;
        private Integer type;
        private Integer suffix;
        private String deviceCategory;
        private String deviceTypeName;
        private String deviceTypeNum;
        private Integer views;
        private Long dvqsId;
        private Integer dvqsLevel;
        private Date gmtCreate;
    }

TbDeviceQuestionMapper.java

import com.hikari.cloud.data.bean.DeviceQuestionInstruction;
    import org.apache.ibatis.annotations.Param;
    
    import java.util.List;
    
    
    public interface TbDeviceQuestionMapper { 
    
    
        List<DeviceQuestionInstruction> findByNo(@Param("deviceTypeNo") String deviceTypeNo);
    
    
    }

TbDeviceQuestionMapper.xml

<?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.hikari.cloud.data.mapper.TbDeviceQuestionMapper">
        <resultMap id="dataMap" type="com.hikari.cloud.data.bean.DeviceQuestionInstruction">
            <result column="dvqs_title" property="dvqsTitle"/>
            <collection property="instructionList" resultMap="insResultMap"/>
    
        </resultMap>
    
    
        <resultMap id="insResultMap" type="com.hikari.cloud.data.entity.TbInstruction">
            <result column="id" property="id"/>
            <result column="user_id" property="userId"/>
            <result column="title" property="title"/>
            <result column="detail" property="detail"/>
            <result column="url" property="url"/>
            <result column="type" property="type"/>
            <result column="suffix" property="suffix"/>
            <result column="device_category" property="deviceCategory"/>
            <result column="device_type_name" property="deviceTypeName"/>
            <result column="device_type_num" property="deviceTypeNum"/>
            <result column="views" property="views"/>
            <result column="dvqs_id" property="dvqsId"/>
            <result column="dvqs_level" property="dvqsLevel"/>
            <result column="gmt_create" property="gmtCreate"/>
        </resultMap>
    
    
        <select id="findByNo" resultType="com.hikari.cloud.data.bean.DeviceQuestionInstruction" resultMap="dataMap">
            SELECT tb_device_question.title AS dvqs_title,tb_instruction.* FROM tb_device_question
            LEFT JOIN tb_instruction
            ON tb_device_question.id=tb_instruction.dvqs_id
            WHERE tb_device_question.device_type_no='HSAT-K5'
            ORDER BY tb_instruction.dvqs_level ASC
        </select>
    
    
    </mapper>