帮我写一下SQL语句

Question

 

String hql="from ArticleInfo one limit 0,20";

Session session=HibernateSessionFactory.getSession();
Transaction tt=session.beginTransaction();

list=session.createQuery(hql).list();

tt.commit();
session.close();

unexpected token: limit near line 1, column 25 [from po.ArticleInfo one limit 0,20]

 

哪里错了？？

Answer 1

大哥，你写的是MySQL的语法吧？这是Hibernate，得写HQL语法：

[code="java"]
Session session=HibernateSessionFactory.getSession();
Transaction tt=session.beginTransaction();

Criteria crit = session.createCriteria(ArticleInfo.class);
crit.setMaxResults(20);
list = crit.list();
[/code]