Hibernate分页

import org.hibernate.Query;
import java.util.*;
import com.Test;
import com.hibernate.HibernateSessionFactory;

public class Test2 {

//分页类
public static void page(String tableName,String orderColumnName,String key,
    int pageNumber,int page){
    if(pageNumber==0)
    pageNumber=10;
    if(page==0)
    page=0;
    StringBuffer buffer=new StringBuffer("from "+tableName+" as table ");
    if(key!=null&&!key.equals(""))
    buffer.append(key+" ");
    if(orderColumnName!=null&&!orderColumnName.equals(""))
    buffer.append("order by table."+orderColumnName+" ");
    Query query=HibernateSessionFactory.getSession().createQuery(buffer.toString());
    query.setMaxResults(pageNumber).setFirstResult((page-1)*pageNumber);
    List list=query.list();
    Iterator i=list.iterator();
    while(i.hasNext()){
    Test t=(Test)i.next();
    System.out.println(t.getName()+" "+t.getPassword()+" "+t.getTest());
    }
    }
    public static void main(String[] args){
    long m=System.currentTimeMillis();
    Test2.page("Test", "password desc", "where password<99990", 10, 1);
    System.out.println(System.currentTimeMillis()-m);
    }
}

评论

1 楼 jg1wxd 2009-09-27  

if(page==0)
    page=0;
与
query.setMaxResults(pageNumber).setFirstResult((page-1)*pageNumber);
是不是有问题呀，你测试过了吗