日期:2014-05-17  浏览次数:20734 次

用ssh和access数据库连接分页报错
先贴 源码:
action:
public String list(){
List<Waiyuzhengshu> list=waiyuService.list(waiyu);
getRequest().setAttribute("list", list);
// 分页处理
String currentPage = (String) getRequest().getParameter("page");
if (null == currentPage || "".equals(currentPage)) {
currentPage = "1";
}
final int pageSize = 10;
PageBean pageBean = new PageBean(pageSize, currentPage,"listInfomation.action?where1=1", list);
PageResult result = pageBean.doExecute();
getRequest().setAttribute("page", result.getPageStr());
getRequest().setAttribute("resultList", result.getResultList());
  return "success";

}

用到的pageBean 和PageResult:PageBean
public String list(){
List<Waiyuzhengshu> list=waiyuService.list(waiyu);
getRequest().setAttribute("list", list);
// 分页处理
String currentPage = (String) getRequest().getParameter("page");
if (null == currentPage || "".equals(currentPage)) {
currentPage = "1";
}
final int pageSize = 10;
PageBean pageBean = new PageBean(pageSize, currentPage,"listInfomation.action?where1=1", list);
PageResult result = pageBean.doExecute();
getRequest().setAttribute("page", result.getPageStr());
getRequest().setAttribute("resultList", result.getResultList());
  return "success";

}

PageResult:public class PageResult {

private String pageStr;
private String pageInfoStr;
private List resultList = new ArrayList();
//set get方法
 。。。。
}

dao层:package com.dao.ImplDAO;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

 
import com.bean.Waiyuzhengshu;
import com.dao.WaiyuzhengshuDAO;

public class WaiyuzhengshuImplDAO extends HibernateDaoSupport implements WaiyuzhengshuDAO {
  /*显示 所有 用户信息
  * (non-Javadoc)
  * @see com.dao.WaiyuzhengshuDAO#list()
  */
@Override
public List<Waiyuzhengshu> list(Waiyuzhengshu waiyu) {
// TODO Auto-generated method stub
/*StringBuffer sb = new StringBuffer();
sb.append("FROM Waiyuzhengshu");*/
  String hql="select top 10 * from Waiyuzhengshu where(ID not in(select top 20 ID from " +
  "Waiyuzhengshu ))";
return this.getHibernateTemplate().find(hql);
}

}


现在的问题是:运行时候 提示 sql语句 错误, line 1:12: unexpected token: 10
line 1:12: unexpected token: 10
at org.hibernate.hql.antlr.HqlBaseParser.identPrimary(HqlBaseParser.java:4037)
at org.hibernate.hql.antlr.HqlBaseParser.primaryExpression(HqlBaseParser.java:861)
at org.hibernate.hql.antlr.HqlBaseParser.atom(HqlBaseParser.java:3438)
at org.hibernate.hql.antlr.HqlBaseParser.unaryExpression(HqlBaseParser.java:3216)
at org.hibernate.hql.antlr.HqlBaseParser.multiplyExpression(HqlBaseParser.java:3098)
at org.hibernate.hql.antlr.HqlBaseParser.additiveExpression(HqlBaseParser.java:2818)
at org.hibernate.hql.antlr.HqlBaseParser.concatenation(HqlBaseParser.java:570)
at org.hibernate.hql.antlr.HqlBaseParser.relationalExpression(HqlBaseParser.java:2586)
at org.hibernate.hql.antlr.HqlBaseParser.equalityExpression(HqlBaseParser.java:2449)
at org.hibernate.hql.antlr.HqlBaseParser.negatedExpression(HqlBaseParser.java:2413)
at org.hibernate.hql.antlr.HqlBaseParser.logicalAndExpression(HqlBaseP