文章类
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"