displaypage.java

一个完整的办公资源管理系统

package org.qiming.tianke.common;

import java.sql.ResultSet;
import java.util.*;

public class DisplayPage implements Constant{

	public DisplayPage() {
		 
	}
 /*
  * ��ҳ
  * pam columns ����
  * pam tables �?���Զ�?
  * pam order  
  * pam condition
  * pam targetPge �����ҳ
  * */
	public static List displayOnPage(String columns,String tables,String order,String condition,String targetPage){
       //��ʼ��
		int pageSize=Constant.pageSize;  
        int currentPage=1;
        int totalPage=0;
        int totalSum=0;
        List list=new ArrayList();
        //�õ��ܼ�¼
        String count_sql="select count(*) from "+ tables+ " where 1=1 "+condition;
        DataBaseConnection aDBConnection=new DataBaseConnection();
        totalSum=aDBConnection.countSumAnnal(count_sql);
        //�õ���ҳ��
        if(totalSum%pageSize==0)
        {
        	totalPage=totalSum/pageSize;
        }else{
        	totalPage=totalSum/pageSize+1;
        }
        
        if(targetPage!=null)
        {
          int requestPage=Integer.parseInt(targetPage);
          if(requestPage>totalPage&&totalPage>0)
          {
        	  currentPage=totalPage;
          }else if(requestPage<1)
          {
        	  currentPage=1;
          }else{
        	  currentPage=requestPage;
          }
        }
        
        String sql="select top "+pageSize+" "+columns+" from "+tables+" where 1=1 "+condition +
                   " and "+order+" not in ( select top "+(currentPage-1)*pageSize+" "+order+" from "+tables+" where 1=1 "+condition+" order by "+order+")"+
                   " order by "+order; 
        System.out.print("-----sql------"+sql);
        ResultSet rs=aDBConnection.doQuery(sql);
        list.add(0,pageSize+"");
        list.add(1,currentPage+"");
        list.add(2,totalPage+"");
        list.add(3,totalSum+"");
        list.add(4,rs);
		return list;
	}
}