给你个bean,根据总数据量得到每页开始和结束的条数,
配合这个/**
* 分页sql语句封装
* @param search 查询语句
* @param startpage 开始条数
* @param everypage 每次显示条数
* @author zhaobing
* */
public String getPageSql(String search,int startpage,String everypage)
{
int every =Integer.parseInt(everypage); //每页最大显示
StringBuffer sql = new StringBuffer() ;
sql.append("select * from (select ROWNUM as rid,taba.* from( " ) ;
sql.append(search) ;
sql.append(" ) taba where ROWNUM < ") ; //每页条数
sql.append(startpage+every) ; //止
sql.append(" ) where rid >= " ) ; //开始条数
sql.append(startpage) ; //起
String allsql = sql.toString() ;
LogManage.print("SQL语句"+allsql) ;
return allsql;
}/**
* 分页pagebean方法封装
* @author zhaobing
* @param temp 页数
* @param count 查询总条数sql语句
* @param everypage 每次显示条数
* */
public PageBean getPageBean(String temp,String count,String everypage)
{
int pageno=Integer.parseInt(temp); //页数
int every =Integer.parseInt(everypage); //每页最大显示
UserDaoImple ud = new UserDaoImple() ;
int sumpage = ud.init(count) ;
PageBean pb = new PageBean() ;
pb.setEveryPage(every) ;
pb.setCurrentPage(pageno) ;
pb.setTotalItem(sumpage) ;
LogManage.print("----------------------分页记录:没页显示:"+every+" 页数"+pageno+" 总条数:"+sumpage+" 开始条数:"+pb.getBeginPosition()) ;
return pb;
}import java.io.*;public class PageBean implements Serializable
{
private int currentPage;
private int totalItem;
private int everyPage;
//设置当前页
public void setCurrentPage(int currentPage)
{
int totalPage = this.getTotalPage();
if(currentPage <= 0)
{
this.currentPage = 1;
} else if(currentPage >= totalPage)
{
this.currentPage = totalPage ;
}
this.currentPage = currentPage;
}
//取得当前页
public int getCurrentPage()
{
if(totalItem <= 0)
{
return 1;
}
return this.currentPage;
}
//取得当前页码
public int getCurrentPageNum() {
if(totalItem <= 0) {
return 1;
}
return this.currentPage ;
}
public void setEveryPage(int everyPage)
{
this.everyPage = everyPage;
}
public int getEveryPage()
{
return this.everyPage;
}
public int getTotalPage()
{ if(totalItem % everyPage == 0) {
return totalItem / everyPage;
} else {
return totalItem / everyPage + 1;
}
}
public void setTotalItem(int totalItem) {
this.totalItem = totalItem;
}
public int getTotalItem() {
return this.totalItem;
}
public int getBeginPosition()
{
return((currentPage-1)*everyPage);
}
public int getEndPosition() {
return currentPage * everyPage ;
}
public boolean isFirstPage() {
return (currentPage <= 1);
}
public boolean isLastPage() {
int totalPage;
totalPage = getTotalPage();
if(currentPage >= totalPage) {
return true;
} else {
return false;
}
}
public boolean isEmptyItem() {
return (totalItem <= 0);
}
}
算了我都给你弄好算了
给分就行了
配合这个/**
* 分页sql语句封装
* @param search 查询语句
* @param startpage 开始条数
* @param everypage 每次显示条数
* @author zhaobing
* */
public String getPageSql(String search,int startpage,String everypage)
{
int every =Integer.parseInt(everypage); //每页最大显示
StringBuffer sql = new StringBuffer() ;
sql.append("select * from (select ROWNUM as rid,taba.* from( " ) ;
sql.append(search) ;
sql.append(" ) taba where ROWNUM < ") ; //每页条数
sql.append(startpage+every) ; //止
sql.append(" ) where rid >= " ) ; //开始条数
sql.append(startpage) ; //起
String allsql = sql.toString() ;
LogManage.print("SQL语句"+allsql) ;
return allsql;
}/**
* 分页pagebean方法封装
* @author zhaobing
* @param temp 页数
* @param count 查询总条数sql语句
* @param everypage 每次显示条数
* */
public PageBean getPageBean(String temp,String count,String everypage)
{
int pageno=Integer.parseInt(temp); //页数
int every =Integer.parseInt(everypage); //每页最大显示
UserDaoImple ud = new UserDaoImple() ;
int sumpage = ud.init(count) ;
PageBean pb = new PageBean() ;
pb.setEveryPage(every) ;
pb.setCurrentPage(pageno) ;
pb.setTotalItem(sumpage) ;
LogManage.print("----------------------分页记录:没页显示:"+every+" 页数"+pageno+" 总条数:"+sumpage+" 开始条数:"+pb.getBeginPosition()) ;
return pb;
}import java.io.*;public class PageBean implements Serializable
{
private int currentPage;
private int totalItem;
private int everyPage;
//设置当前页
public void setCurrentPage(int currentPage)
{
int totalPage = this.getTotalPage();
if(currentPage <= 0)
{
this.currentPage = 1;
} else if(currentPage >= totalPage)
{
this.currentPage = totalPage ;
}
this.currentPage = currentPage;
}
//取得当前页
public int getCurrentPage()
{
if(totalItem <= 0)
{
return 1;
}
return this.currentPage;
}
//取得当前页码
public int getCurrentPageNum() {
if(totalItem <= 0) {
return 1;
}
return this.currentPage ;
}
public void setEveryPage(int everyPage)
{
this.everyPage = everyPage;
}
public int getEveryPage()
{
return this.everyPage;
}
public int getTotalPage()
{ if(totalItem % everyPage == 0) {
return totalItem / everyPage;
} else {
return totalItem / everyPage + 1;
}
}
public void setTotalItem(int totalItem) {
this.totalItem = totalItem;
}
public int getTotalItem() {
return this.totalItem;
}
public int getBeginPosition()
{
return((currentPage-1)*everyPage);
}
public int getEndPosition() {
return currentPage * everyPage ;
}
public boolean isFirstPage() {
return (currentPage <= 1);
}
public boolean isLastPage() {
int totalPage;
totalPage = getTotalPage();
if(currentPage >= totalPage) {
return true;
} else {
return false;
}
}
public boolean isEmptyItem() {
return (totalItem <= 0);
}
}
算了我都给你弄好算了
给分就行了
解决方案 »
- Hibernate4.1异常,实在没找出原因请教坛神!hibernate.cfg.xml not found
- 正则,或者其他方式来获取网页的内容
- Hibernate 中 知道一个表名称 如何得到 这个表中所有的字段名称
- java加密解密的问题
- jsp 怎样操作 word
- hibernate与mysql开发中的问题?
- CachedRowSet 更新结果集????
- SPRINGMVC 无法取得查询结果
- 埃,失业中,郁闷,写了几个连接数据库的类,请高手们帮我看看?
- 一个关于hibernate配置id的问题,请高手指教一下,谢谢
- 我是北大青鸟的学生,马上要分方向了( j2ee,.net)
- j2sdkee1.3.1环境变量配置 错误
还有1楼的朋友不是我不想写而是我刚刚学j2ee,想找一个好点的代码好自己研究!放心吧我不会拿加就用的,而是研究明白这后再用!4楼的朋友看来是看出来漏洞了就指点一下嘛!不要总想着黑别人啊!