这需要写代码的,一种方法是你直接用循环取到你想要的那一页的纪录,另一种方法是通过参数把要显示出来的纪录范围指定到sql文中,只取出需要显示的纪录。
解决方案 »
- Hibernate hbm配置文件,配置order by,为何没有排序
- 高手问一下关于struts.xml的 action配置
- MINA最大连接数问题
- 查询时候报错 请高手解决
- 急急急,struts如何获取表单数据
- strus2 中 select 标签 的传值问题
- 请问我用struts2+hibernate3+spring2开发,最好用什么服务器?
- 求助:spring+struts集合出错(急死人啦)
- jboss3.22+eclipse2.1中运行测试出现的错误,帮忙了~~~~~~~~~~~~
- java小白,求大神指教
- Jboss可以建立两个以上的数据源吗?
- 想通过用一个Main函数调用自编的类.class来测试它,高人请帮忙看看!多谢!
{
/*
total: all rows count;
pagenum: present page no;
pagesize: rows/each page.
*/
public static long getPage(long total, long pagenum, int pagesize)
{
long pn,pnmax;
if(pagenum<=0)
pn=1;
else
pn = pagenum;
pnmax = (total + pagesize - 1)/pagesize;
if(pn>=pnmax)
pn=pnmax;
return pn;
} /*
sql: the real sql string;
pagenum: present page no;
pagesize: rows/each page.
*/
public static String getPageSql(String sql, long pagenum, int pagesize)
{
String sqlstring;
sqlstring ="";
sqlstring = "SELECT * FROM ";
sqlstring = sqlstring + "( " + sql + " ) ";
sqlstring = sqlstring + "WHERE row_num BETWEEN ";
sqlstring = sqlstring + ((pagenum - 1)*pagesize + 1);
sqlstring = sqlstring + " AND ";
sqlstring = sqlstring + (pagenum*pagesize);
return sqlstring;
}
public static long getNextPageNumber(long total, long pagenum, int pagesize)
{
if(total<pagesize) return -1;
if(total<pagesize*pagenum) return -1;
return (pagenum+1);
}
public static long getPrePageNumber(long total, long pagenum, int pagesize)
{
if(total<pagesize) return -1;
if(pagenum<2) return -1;
return pagenum - 1;
}
public static String getSumReport(long total, long pagenum, int pagesize)
{
String ret="";
long pn, start, end;
if(total==-1||total==0) return "共0条";
if(pagenum==-1||pagenum<1)
pn=1;
else
pn=pagenum;
start = (pn-1) * pagesize+1;
end = Math.min(pn*pagesize,total);
ret = "共"+total+"条,这是第"+start+"条到第"+end+"条";
return ret;
}
public static String getNextPageButton(String url, long total, long pagenum, int pagesize)
{
long temp;
String ret="";
temp = getNextPageNumber(total, pagenum, pagesize);
if(temp!=-1)
{
ret = "<input type=\"button\" name=\"nextpage\" value=\"下一页\" ";
ret = ret + " onClick=\"javascript:window.open('"+url+"page="+temp+"','_self');\">";
}
return ret;
}
public static String getPrePageButton(String url, long total, long pagenum, int pagesize)
{
long temp;
String ret="";
temp = getPrePageNumber(total, pagenum, pagesize);
if(temp!=-1)
{
ret = "<input type=\"button\" name=\"prepage\" value=\"上一页\" ";
ret = ret + " onClick=\"javascript:window.open('"+url+"page="+temp+"','_self');\">";
}
return ret;
}
}