sql 语句:SELECT * FROM t_video WHERE type_id=12 AND del_flag=0 ORDER BY upload_date DESC LIMIT 2;
这条语句是完全可以限制的但是 当把它变为Hql 语句的时候, limit 会失效。
@Query("from Video where type.id=?1 and delFlag='" + Video.DEL_FLAG_NORMAL + "'order by uploadDate desc LIMIT 2")
所以用了 下面的办法
TypedQuery<Video> query = em.createQuery("from Video where type.id=?1 and delFlag='" + Video.DEL_FLAG_NORMAL + "'order by uploadDate desc", Video.class).setFirstResult(0).setMaxResults(2);
测试 有效!