Hibernate
alex_fung
这个作者很懒,什么都没留下…
展开
-
Hql语句中使用group by having中注意
String hql = "SELECT openId FROM ReadLog where createTime > :startTime group by openId having count(1)>:count"; 以上语句报错,原因是hql不允许使用count(1)正解:String hql = "SELECT openId FROM ReadLog where create...原创 2018-04-25 15:58:23 · 4208 阅读 · 0 评论 -
JPA添加Pageable实现翻页时报错
@Query("from Subject where name like CONCAT('%',:name,'%') and isDelete = 0 order by createTime desc") Page<Subject> findSubjectByName(@Param("name") String name, Pageable page); 报错: select ...原创 2018-06-14 16:27:43 · 1438 阅读 · 0 评论