Posted on 2007-04-23 15:11
samfree 閱讀(2211)
評論(5) 編輯 收藏
我在用hibernate對mysql進行分頁的方法
/**
* 函數說明：獲得所有的信息
* 參數說明：
* 返回值：信息的集合
*/
public List getProducts(final int pageSize, final int startRow) throws HibernateException {
return this.getHibernateTemplate().executeFind(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Query query=session.createQuery("FROM Products as p");
query.setMaxResults(pageSize);
query.setFirstResult(startRow);
List list = query.list();
return list;
}
});
}
運行時怎么老給出異常阿？請幫幫我看看好嗎？
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '40 products0_.game_id as game1_0_, products0_.game_name_en as game2_0_, products' at line 1"