package util;
import java.sql.ResultSet;
public class rsFenYe {
    ResultSet rs=null;//要分頁(yè)處理的記錄集
    int currentPage=1;//當(dāng)前頁(yè)碼
    int pageSize=10;//每頁(yè)的記錄條數(shù)，默認(rèn)為10
    /**
     * 得到分頁(yè)字串，并把記錄指針移動(dòng)到當(dāng)前頁(yè)的第一條記錄的前面位置
     * 輸入?yún)?shù)：返回的JSP頁(yè)面,refName數(shù)組為超鏈接中繼currentPage之后的？參數(shù)名，refValue為對(duì)應(yīng)的值
     * 輸出參數(shù)：字符串”共2頁(yè)，當(dāng)前第1頁(yè)  下一頁(yè) 末頁(yè)”
     */
    public String earn_fenyi_string(String returnJSP,String[] refName,String[] refValue){
        String returnString=new String("");
        if(rs==null) return(returnString);
        int pageCount=0;//總頁(yè)數(shù)
        int rowCount=0;//rs的總記錄條數(shù)
        if(pageSize<=0) //每頁(yè)記錄條數(shù)不正確
            return(returnString);
        try{
            //------得到總記錄條數(shù)------
            rs.last();
            rowCount=rs.getRow();
            rs.beforeFirst();
            //------記錄指針定位--------
            int RecordPosition=(currentPage-1)*pageSize;
            if(RecordPosition==0) rs.beforeFirst();
            else rs.absolute(RecordPosition);
        }catch(Exception e){
            System.out.println(e);
            return(returnString);
        }
        //---------得到總頁(yè)數(shù)----------
        if(rowCount%pageSize==0) pageCount=rowCount/pageSize;
        else pageCount=rowCount/pageSize+1;
        //---------得到返回字符串--------
        returnString="共"+pageCount+"頁(yè)，當(dāng)前第"+currentPage+"頁(yè)&nbsp;&nbsp;";
        if(currentPage!=1&&pageCount!=0){//不是首頁(yè)且總頁(yè)數(shù)不為0
            returnString=returnString+"<a href='"+returnJSP+"?currentPage=1";
            for(int i=0;i<refName.length;i++)
                returnString=returnString+"&"+refName[i]+"="+refValue[i];
            returnString=returnString+"'>首頁(yè)</a>&nbsp;";
            returnString=returnString+"<a href='"+returnJSP+"?currentPage="+(currentPage-1);
            for(int i=0;i<refName.length;i++)
                returnString=returnString+"&"+refName[i]+"="+refValue[i];
            returnString=returnString+"'>上一頁(yè)</a>&nbsp;";
        }
        if(currentPage!=pageCount&&pageCount!=0){//不是末頁(yè)且總頁(yè)數(shù)不為0
            returnString=returnString+"<a href='"+returnJSP+"?currentPage="+(currentPage+1);
            for(int i=0;i<refName.length;i++)
                returnString=returnString+"&"+refName[i]+"="+refValue[i];
            returnString=returnString+"'>下一頁(yè)</a>&nbsp;";               
            returnString=returnString+"<a href='"+returnJSP+"?currentPage="+pageCount;
            for(int i=0;i<refName.length;i++)
                returnString=returnString+"&"+refName[i]+"="+refValue[i];
            returnString=returnString+"'>末頁(yè)</a>&nbsp;";               
        }   
        return returnString;
    }  
    public ResultSet getRs() {
        return rs;
    }
    public void setRs(ResultSet rs) {
        this.rs = rs;
    }
    public int getCurrentPage() {
        return currentPage;
    }
    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }
    public int getPageSize() {
        return pageSize;
    }
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }
}