帮我写一下SQL语句

 

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]

 

哪里错了??

大哥,你写的是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]