81,092
社区成员
发帖
与我相关
我的任务
分享
/**
*函数说明:获取上传视频最多的前五个用户
*/
public List getRedTomatos() {
final String hql = "FROM User u, Video v where v.v_uid = u.userid GROUP BY u.username ORDER BY COUNT(v.v_uid) desc";
return this.getHibernateTemplate().executeFind(new HibernateCallback() {
public List doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery(hql);
query.setMaxResults(5);
return query.list();
}
});
}
availableItems = userService.getRedTomatos();
<s:iterator value="availableItems" status="a">
<s:if test="#a.getIndex()%1==0||#a.first">
<tr>
</s:if>
<td height="20">
<s:property value="username" />
</td>
</s:iterator>
<tr>
<td height="20"><span class="STYLE17">
<s:property value="availableItems[0]" /></span></td>
<tr><td height="20"><span class="STYLE17">
<s:property value="availableItems[1]" /></span></td>
<tr><td height="20"><span class="STYLE17">
<s:property value="availableItems[2]" /></span></td>
<tr><td height="20"><span class="STYLE17">
<s:property value="availableItems[3]" /></span></td>
<tr>
<td height="20"><span class="STYLE17">
<s:property value="availableItems[4]" /></span></td>
<s:iterator value="availableItems" status="a">
<s:if test="#a==null">
<tr> <td>NULL</td></tr>
</s:if>
<s:else>
<td height="20"><span class="STYLE17">
<s:property value="username" />YES</span></td></s:else>
</s:iterator>
<s:iterator value="availableItems10" status="rt">
<tr>
<td height="20">
<s:property value="username" />
</td>
</tr>
</s:iterator>
<s:if test="#a.getIndex()%1==0||#a.first">