Hibernate 3 hql查询连接2表

Question

我想执行以下sql查询

SELECT * FROM users u JOIN `friendship` f ON u.id = f.f_uid WHERE f.u_uid = 118 AND u.lastDataFetched >= DATE_SUB(CURDATE(),INTERVAL 7 DAY)) order by f.mutual_friendship_count

如何使用hibernate 3.0为此编写hql查询

我是这样写的

String[] parameterName={"usersByUUid","inthepastday"};
Object[] paramValues = {user,"7"};
List<Friendship> friendshipFriend  = getHibernateTemplate().findByNamedParam(" from Users u JOIN Friendship f on  u.id = f.f_uid where f.u_uid = :usersByUUid and date_sub(now(),interval :inthepastday day) >=u.lastDataFetched  order by f.mutual_friendship_count ", parameterName,paramValues);

但它显示了hql语法错误

Answer 1

>

和：日期7天前

另一种方法是使用Native查询，因此可以编写纯SQL。只需添加注释@NamedNativeQuery。然后通过getHibernateTemboard（）. findByNamedQuery（"nameOfYourNamedQuery"）调用它；