Mybatis查询二级评论SQL

 

 

 

 Mybatis查询评论

    <select id="getCommentByID" resultMap="getCommentResultMap">
        SELECT com1.*,com2.*
        FROM itkb_comment_info com1 LEFT JOIN itkb_comment2_info com2 ON com1.id = com2.c2comment1Id
        WHERE com1.articleid=#{articleid}
    </select>

    <resultMap id="getCommentResultMap" type="com.example.demo.itkb.square.article.entity.Comment">
        <id property="id" column="id"/>
        <result property="articleid" column="articleid"/>
        <result property="username" column="username"/>
        <result property="commentDate" column="commentDate" />
        <result property="commentContent" column="commentContent" />
        <collection property="comment2" ofType="com.example.demo.itkb.square.article.entity.Comment2">
            <id property="c2id" column="c2id"/>
            <result property="c2comment1Id" column="c2comment1Id" />
            <result property="c2username" column="c2username" />
            <result property="c2commentDate" column="c2commentDate" />
            <result property="c2commentContent" column="c2commentContent" />
        </collection>
    </resultMap>