java hibernate分页_java hibernate分页

publicvoidpagination(HttpServletRequestrequest){intpageSize=10;StringcurrentPageStr=request.getParameter("currentPage");intcurrentPage=(currentPageStr==null)?0:Integer.pa...

public void pagination(HttpServletRequest request){

int pageSize=10;

String currentPageStr=request.getParameter("currentPage");

int currentPage=(currentPageStr==null)?0:Integer.parseInt(currentPageStr);

Session session=HibernateSessionFactory.getSession();

Query qy=session.createQuery("from Product");

Transaction tran=session.beginTransaction();

int count=qy.list().size();

int totalPage=(count-1)/pageSize+1;

qy.setFirstResult((currentPage-1)*pageSize);

qy.setMaxResults(pageSize);

List list=qy.list();

request.setAttribute("count", String.valueOf(count));

request.setAttribute("totalPage", String.valueOf(totalPage));

request.setAttribute("currentPage", String.valueOf(currentPage));

request.setAttribute("pageSize", String.valueOf(pageSize));

request.setAttribute("products", list);

String bar=setBar();

request.setAttribute("bar", bar);

}

为什么执行到:

qy.setFirstResult((currentPage-1)*pageSize);

qy.setMaxResults(pageSize);就报错,说:

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported

method: ResultSet.absolute应该怎样做才行?

展开