Jsp分页

来源：互联网发布：怎么在淘宝修改评价编辑：程序博客网时间：2024/05/22 05:03

package common;
import java.sql.ResultSet;

public class rsFenYe {

private ResultSet rs = null;
private int pageSize = 10;//每页的记录条数,默认为10
private int currentPage = 1;//当前页码
/**
* 得到分页的字串，并把记录指针移动到当前页的第一条记录的当前位置
* 输入参数：返回的jsp页面，currentPage之后？参数名为对应的值
* 输出参数：字符串“共**页，当前第**页首页上一页下一页末页”
*/
public String earn_fenye_string(String returnJSP,int type){
   String returnString = new String("");
   if(rs == null) return (returnString);
   int pageCount = 0;//总页数
   int rowCount = 0;//rs的总记录条数
   if(pageSize <=0) return(returnString);
     try{
    //--------得到总记录条数
    rs.last();
    rowCount = rs.getRow();
    /*rs.beforeFirst();

    //--------记录指针定位
    int RecordPosition = (currentPage - 1)*pageSize;
    if(RecordPosition == 0)rs.beforeFirst();
    else rs.absolute(RecordPosition);*/
   }catch(Exception e){
    e.printStackTrace();
    return(returnString);
   }

   //--------得到总页数
   if(rowCount % pageSize == 0) pageCount = rowCount/pageSize;
   else pageCount = rowCount/pageSize + 1;
   if(rowCount == 0)pageCount = 1;

   //-------得到返回字符串
   returnString = "共" + pageCount + "页，当前第" + currentPage + "页 &nbsp";
   if(currentPage != 1 && pageCount !=1){//不是首页且总页数不为0
    returnString = returnString + "<a href='" + returnJSP + "?currentPage=1"
     + "&type="+ type +"'>首页</a> <a href='" + returnJSP + "?currentPage="+
     (currentPage - 1) + "&type="+ type +"'>上一页</a> ";
   }
   if(currentPage != pageCount && pageCount !=1){
    returnString = returnString + "<a href='" + returnJSP + "?currentPage="
    + (currentPage + 1)+ "&type="+ type + "'>下一页</a> <a href = '" + returnJSP + "?currentPage="+
    pageCount + "&type="+ type + "'>末页</a> ";
   }

   return returnString;
}

/**
* 得到分页的字串，并把记录指针移动到当前页的第一条记录的当前位置
<<<<<<< .mine
* 输入参数：返回的jsp也面，currentPage之后？参数名为对应的值无type
=======
* 输入参数：返回的jsp页面，currentPage之后？参数名为对应的值无level
>>>>>>> .r39
* 输出参数：字符串“共**页，当前第**页首页上一页下一页末页”
*/
public String earn_fenye_string(String returnJSP){
   String returnString = new String("");
   if(rs == null) return (returnString);
   int pageCount = 0;//总页数
   int rowCount = 0;//rs的总记录条数
   if(pageSize <=0) return(returnString);
   try{
    //--------得到总记录条数
    rs.last();
    rowCount = rs.getRow();
    /*rs.beforeFirst();

    //--------记录指针定位
    int RecordPosition = (currentPage - 1)*pageSize;
    if(RecordPosition == 0)rs.beforeFirst();
    else rs.absolute(RecordPosition);*/
   }catch(Exception e){
    e.printStackTrace();
    return(returnString);
   }
   //--------得到总页数
   if(rowCount % pageSize == 0) pageCount = rowCount/pageSize;
   else pageCount = rowCount/pageSize + 1;
   if(rowCount == 0)pageCount = 1;
   //-------得到返回字符串
   returnString = "共" + pageCount + "页，当前第" + currentPage + "页 &nbsp";
   if(currentPage != 1 && pageCount != 1){//不是首页且总页数不为0
    returnString = returnString + "<a href='" + returnJSP + "?currentPage=1'>首页</a> " +
      "<a href='" + returnJSP + "?currentPage="+ (currentPage - 1) + "'>上一页</a> ";
   }
   if(currentPage != pageCount && pageCount !=1){
    returnString = returnString + "<a href='" + returnJSP + "?currentPage=" + (currentPage + 1)+ "'>下一页</a> " +
      "<a href = '" + returnJSP + "?currentPage="+ pageCount + "'>末页</a> ";
   }

   return returnString;
}
public ResultSet getRs(){
   try{
    //--------得到总记录条数
    rs.beforeFirst();
    //--------记录指针定位
    int RecordPosition = (currentPage - 1)*pageSize;
    if(RecordPosition == 0)rs.beforeFirst();
    else rs.absolute(RecordPosition);
   }catch(Exception e){
    e.printStackTrace();
    return null;
   }
   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;
}
}