mysql resultlist_resultList = query.list(); 到这块就出现错误

publicPageResultgetPageResult(Stringhql,StringcurrentPage,intpageSize){//定义pager对象，用于传到页�inttotalRows=0;ListresultList=null;PageBeanpager=null;Session...

public PageResult getPageResult(String hql, String currentPage, int pageSize)

{

// 定义pager对象，用于传到页�

int totalRows = 0;

List resultList = null;

PageBean pager = null;

Session session = this.getSessionFactory().getCurrentSession();

Query query = session.createQuery(hql);

totalRows = (query.list()).size(); // 取得总计录数

pager = new PageBean(totalRows, pageSize);

if ((Integer.parseInt(currentPage)) <= pager.getTotalPages())

{

// 从当前页记录数开�

query

.setFirstResult((Integer.parseInt(currentPage) - 1)

* pageSize);

query.setMaxResults(pageSize);

query.setMaxResults(1);

if (totalRows >= 0)

{

resultList = query.list();

}

}

// 把分页查询的结果和对象放入PagerResult

PageResult pagerResult = new PageResult();

pagerResult.setPageBean(pager);

pagerResult.setResultList(resultList);

return pagerResult;

}

错误信息

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 '1 manager0_.M_ID as M1_2_, manager0_.M_LOGIN_NAME as M2_2_, manager0_.M_LOGIN_PW' at line 1

query.setMaxResults(1);

设置了就会出错 不设置就正常。。。

在线等。。。

展开