hql between and具体的方法怎么写

[小枫620]

请教一下大神们，这个where条件查询写成HQL怎么写的？
SELECT sysRoomType.typeName, sysRoomOrders.room_id, sysRoomOrders.endDate, sysRoomOrders.starDate, sysRoomType.id
FROM sysRoomType INNER JOIN
sysRoom ON sysRoomType.id = sysRoom.roomType_id INNER JOIN
sysRoomOrders ON sysRoom.id = sysRoomOrders.room_id
where sysRoomOrders.starDate between 145745280 and 14571936001 and sysRoomType.id =1
or sysRoomOrders.endDate between 145745280 and 14571936001 and sysRoomType.id =1

[丶太阳]

你可以放进[CDATA]区里

[丶太阳]

<query name="getById"> <![CDATA[ from User u where u.id>=3 and u.id<=10 ]]> </query > 像这样

[小枫620]

不会用你的方法

[小枫620]

find的方法有错，是什么回事？

[xiedacon]

roomType是什么？ 是从sRoomOrders里面得来的？