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);
}
}
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);
}
}