快捷導(dǎo)航

Mybatis返回結(jié)果多重嵌套List方式

更新時(shí)間：2026年01月10日 14:44:20 作者：柿餅zzzz

文章介紹了在實(shí)際開發(fā)中處理JSON多重嵌套返回格式的方法,通過定義`resultMap`并創(chuàng)建相應(yīng)的實(shí)體類（如`PersonPosGroup`和`PersonData`）來實(shí)現(xiàn)自動映射,SQL查詢代碼會根據(jù)層級關(guān)系自動映射出查詢結(jié)果

Mybatis返回結(jié)果多重嵌套List

實(shí)際開發(fā)中，在定義接口的返回格式時(shí)往往會遇到返回json多重嵌套的情況：

我們可以通過resultMap自動映射來實(shí)現(xiàn)

    <resultMap type="PersonDetailsVo" id="personDetailsMap">
        <result column="sequence_id" property="sequenceId" />
        <collection property="personPosGroup" javaType="java.util.List" ofType="com.ruoyi.project.business.main.domain.PersonPosGroup">
            <result column="camera_id" property="cameraId" />
            <collection property="personData" javaType="java.util.List" ofType="com.ruoyi.project.business.main.domain.PersonData">
                <result column="person_id" property="personId" />
                <result column="position_info" property="positionInfo" />
                <result column="worker_type" property="workerType" />
            </collection >
        </collection >
    </resultMap>

比如這樣的resultMap結(jié)構(gòu)就實(shí)現(xiàn)了三層嵌套，我們要注意創(chuàng)建PersonPosGroup、PersonData實(shí)體類來完成映射。

PersonPosGroup

public class PersonPosGroup implements Serializable {

    private String cameraId;
    private List<PersonData> personData;

    public String getCameraId() {
        return cameraId;
    }

    public void setCameraId(String cameraId) {
        this.cameraId = cameraId;
    }

    public List<PersonData> getPersonData() {
        return personData;
    }

    public void setPersonData(List<PersonData> personData) {
        this.personData = personData;
    }
}

PersonData

public class PersonData implements Serializable {

    private String personId;
    private String workerType;
    private JSONObject positionInfo;

    public String getPersonId() {
        return personId;
    }

    public void setPersonId(String personId) {
        this.personId = personId;
    }

    public String getWorkerType() {
        return workerType;
    }

    public void setWorkerType(String workerType) {
        this.workerType = workerType;
    }

    public JSONObject getPositionInfo() {
        return positionInfo;
    }

    public void setPositionInfo(String positionInfo) {
        this.positionInfo = JSONObject.parseObject(positionInfo);
    }
}

sql代碼

<select id="selectPersonInfoBySequenceId" parameterType="java.util.Map" resultMap="personDetailsMap">
        select
            sequence_id,
            camera_id,
            person_id,
            position_info,
            worker_type
        from video_person_details_info
        where
            1=1
            <if test="video_id != null  and video_id != ''"> and video_id = #{video_id}</if>
            <if test="start_sequence_id != null">
              and sequence_id >= #{start_sequence_id} and  #{end_sequence_id} > sequence_id
            </if>
    </select>

查詢數(shù)據(jù)會根據(jù)層級關(guān)系自動映射出查詢結(jié)果