文章按回复时间排序

文章类

Class Article ：

private Set<Comment> comments;   //关联的评论

...

映射

<set name="comments" table="SNS_comment" lazy ="true" order-by="id desc">
       <key column="article_id" />
          <one-to-many class="com.job5156.sns.article.entity.Comment"/> 
 </set>

--------------

评论类

Class Comment

private Article article;   //评论的文章

...

 

映射

<many-to-one name="article" column="article_id" class="com.zgct.article.entity.Article" />

按文章的最新回复时间 排序,注意这里是Hibernate 查询语句hql

 

hql ="SELECT DISTINCT art FROM Article art LEFT JOIN art.comments c

          WHERE art.status=2 ORDER BY c.createtime DESC"