mybatis一对多查询注解方式

最新推荐文章于 2024-08-28 19:28:12 发布

轻尘×

最新推荐文章于 2024-08-28 19:28:12 发布

阅读量2k

点赞数 1

分类专栏： mybatis

本文链接：https://blog.csdn.net/leisure_life/article/details/84591140

版权

mybatis 专栏收录该内容

46 篇文章 0 订阅

订阅专栏

三层数据结构如下

{
    "code": 1,
    "data": {
        "projectID": 1,
        "projectStageList": [
            {
                "stageID": 1,
                "projectID": 1,
                "stageName": "第一阶段",
                "taskList": [
                    {
                        "mangerID": 31,
                        "taskName": "学习客服基本职责",
                        "taskID": 1066224890860171264,
                        "stageID": 1
                    },
                    {
                        "mangerID": 19,
                        "taskName": "直通车优化内容",
                        "taskID": 1066229261945696256,
                        "stageID": 1
                    }
                ]
            },
            {
                "stageID": 2,
                "projectID": 1,
                "stageName": "第二阶段",
                "taskList": []
            },
            {
                "stageID": 5,
                "projectID": 1,
                "stageName": "看待歌手陈羽凡吸毒被抓一事",
                "taskList": []
            }
        ]
    },
    "success": true,
    "info": "default info"
}

简而言之，一个项目有多个阶段，一个阶段有多个任务

One

package cn.com.suntree.cmp.entity;

import com.baomidou.mybatisplus.annotations.TableField;
import com.baomidou.mybatisplus.annotations.TableId;
import com.baomidou.mybatisplus.annotations.TableName;
import com.baomidou.mybatisplus.enums.IdType;
import lombok.Data;

import java.util.List;


@Data
@TableName("t_cmp_project")
public class CmpProject {

    @TableId(value = "projectID",type = IdType.AUTO)
    @TableField("projectID")
    private Long projectID;
    @TableField("projectName")
    private String projectName;
    private List<CmpProjectStage> projectStageList;//阶段
  

}

many

package cn.com.suntree.cmp.entity;

import com.baomidou.mybatisplus.annotations.TableField;
import com.baomidou.mybatisplus.annotations.TableId;
import com.baomidou.mybatisplus.annotations.TableName;
import com.baomidou.mybatisplus.enums.IdType;
import lombok.Data;

import java.io.Serializable;
import java.util.List;
import java.util.Map;


@Data
@TableName("t_cmp_project_stage")
public class CmpProjectStage implements Serializable {

    @TableId(value = "stageID",type = IdType.AUTO)
    @TableField("stageID")
    private Long stageID;//阶段编号
    @TableField("projectID")
    private Long projectID;//项目编号
    List<Map<Object,Object>> taskList;//关联任务
}

one 方mapper

@Select("select * from "+tableName+" where projectID = #{projectID}")
    @Results({
            @Result(property = "projectStageList", column = "projectID",id = true,many = @Many(select = "cn.com.suntree.cmp.mapper.CmpProjectStageMapper.getStageListByProjectID"))
    })
    CmpProject getProjectByProgectID(Long projectID);

many方mapper

@Select("select * from "+tableName+" where projectID = #{projectID}")
    @Results({
            @Result(property = "stageID",column = "stageID"),
            @Result(property = "taskList",id = true,column = "stageID", many = @Many(select = "cn.com.suntree.cmp.mapper.MissionTaskMapper.getTaskListByStageID"))
    })
    List<CmpProjectStage> getStageListByProjectID(Long projectID);

最里层mapper

@Select("Select t.stageID AS stageID,t.taskID,t.taskName,t.mangerID,t.mangerName from "+tableName +" t where stageID = #{stageID}")
	List<Map<Object,Object>> getTaskListByStageID(Long stageID);

有个需要注意的地方，就是many方mapper的@Result(property = "stageID",column = "stageID")如果不加，第二层的关联id会是null