mybatis一对多,多对一关系resultMap写法

最新推荐文章于 2024-07-24 10:10:58 发布

孟林洁

最新推荐文章于 2024-07-24 10:10:58 发布

阅读量2.1k

点赞数

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/menglinjie/article/details/78675814

版权

mybatis 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

场景:博客下有文章集合,并且有关联作者对象

resultMap

<resultMap id="detailedBlogResultMap" type="Blog">
  <constructor>
    <idArg column="blog_id" javaType="int"/>
  </constructor>
  <result property="title" column="blog_title"/>
  <association property="author" javaType="Author">
    <id property="id" column="author_id"/>
    <result property="username" column="author_username"/>
    <result property="password" column="author_password"/>
    <result property="email" column="author_email"/>
    <result property="bio" column="author_bio"/>
    <result property="favouriteSection" column="author_favourite_section"/>
  </association>
  <collection property="posts" ofType="Post">
    <id property="id" column="post_id"/>
    <result property="subject" column="post_subject"/>
    <association property="author" javaType="Author"/>
    <collection property="comments" ofType="Comment">
      <id property="id" column="comment_id"/>
    </collection>
    <collection property="tags" ofType="Tag" >
      <id property="id" column="tag_id"/>
    </collection>
    <discriminator javaType="int" column="draft">
      <case value="1" resultType="DraftPost"/>
    </discriminator>
  </collection>
</resultMap>