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 + "页  ";
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 + "页  ";
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;
}
}