Mybatis一对多

蔚落 2022-02-17 03:21 175阅读 0赞

一、新建实体

public class GoodNotesListRequset {
    
        private String goodClassName;
        private String goodNoteTypeName;
        private List<GoodNotesListVo> noteNameList;
    
        public String getGoodClassName() {
            return goodClassName;
        }
    
        public void setGoodClassName(String goodClassName) {
            this.goodClassName = goodClassName;
        }
    
        public String getGoodNoteTypeName() {
            return goodNoteTypeName;
        }
    
        public void setGoodNoteTypeName(String goodNoteTypeName) {
            this.goodNoteTypeName = goodNoteTypeName;
        }
    
        public List<GoodNotesListVo> getNoteNameList() {
            return noteNameList;
        }
    
        public void setNoteNameList(List<GoodNotesListVo> noteNameList) {
            this.noteNameList = noteNameList;
        }
    }

新建实体中的List

public class GoodNotesListVo {
        private String noteName;//备注名
        private String noteId;//备注id
    
        public String getNoteName() {
            return noteName;
        }
    
        public void setNoteName(String noteName) {
            this.noteName = noteName;
        }
    
        public String getNoteId() {
            return noteId;
        }
    
        public void setNoteId(String noteId) {
            this.noteId = noteId;
        }
    }

mybatis

<resultMap id="goodnoteslist" type="com.goldpac.ocs.common.goodsservice.vo.GoodNotesListRequset">
        <result column="common_good_notes_classname" property="goodClassName" jdbcType="VARCHAR" />
        <result column="common_good_notes_type" property="goodNoteTypeName" jdbcType="VARCHAR" />
        <collection property="noteNameList" javaType="ArrayList" ofType="com.goldpac.ocs.common.goodsservice.vo.GoodNotesListVo">
          <result column="common_good_notes_classid" property="noteId" jdbcType="VARCHAR" />
          <result column="common_good_notes_name" property="noteName" jdbcType="VARCHAR" />
        </collection>
      </resultMap>
    
    
      <select id="selectByExample" resultMap="goodnoteslist" parameterType="com.goldpac.ocs.common.goodsservice.entity.CommonGoodNotesExample" >
        select
        <if test="distinct" >
          distinct
        </if>
        <include refid="Base_Column_List" />
        from common_good_notes
        <if test="_parameter != null" >
          <include refid="Example_Where_Clause" />
        </if>
        <if test="orderByClause != null" >
          order by ${orderByClause}
        </if>
      </select>