源代码如下:
<%
int PageSize=5; //每一页显示的记录数
int ShowPage=1; //当前显示的页面
int RowCount=0; //总的记录数
int PageCount=0; //总的页数
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String jNo=null;
jNo=request.getParameter("JINGHAO");
String sql="select * from djcbb where jh='"+jNo+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{
rs.last();
RowCount=rs.getRow();
PageCount=((RowCount%PageSize)==0?(RowCount/PageSize):(RowCount/PageSize)+1);
%>
<html>
<body bgcolor="#FFFFFF" text="#000000">
<%
String ToPage=request.getParameter("ToPage");
if(ToPage!=null)
{
ShowPage=Integer.parseInt(ToPage);
if(ShowPage>PageCount)
{
ShowPage=PageCount;
}
else if(ShowPage<=0)
{
ShowPage=1;
}
}
rs.absolute((ShowPage-1)*PageSize+1);
%>
<div align="center"><font size="2">找到相关记录<%=RowCount%>条,共<%=PageCount%>页,
当前是第<%=ShowPage%>页</div>
<hr>
<table width="100%" cellspacing=2>
<tr bgcolor="#FFCCCC">
<td width="12%" height="19" bgcolor="#FFCCCC">
<div align="center"><font size="2"><b>日期</b></font></div>
</td>
<td width="11%" height="19">
<div align="center"><font size="2"><b>井号</b></font></div>
</td>
<td width="10%" height="19">
<div align="center"><font size="2"><b>费用编码</b></font></div>
</td>
<td width="12%" height="19">
<div align="center"><font size="2"><b>费用名称</b></font></div>
</td>
<td width="10%" height="19">
<div align="center"><font size="2"><b>费用金额</b></font></div>
</td>
<td width="12%" height="19">
<div align="center"><font size="2"><b>科室</b></font></div>
</td>
</tr>
</table>
<%
for(int i=1;i<=PageSize;i++)
{
%>
<table width="100%" cellspacing=2 cellpadding=2>
<tr bgcolor=#F2F2F2>
<td height="19" width="12%">
<%
String data;
data = rs.getString("rq");
data = data.substring(0, data.indexOf(" "));//去掉datetime类型后面的时分秒
%>
<div align="center"><font size="2"><%=data%></font></div>
</td>
<td height="19" width="11%">
<div align="center"><font size="2"><%=rs.getString("jh")%></font></div>
</td>
<td height="19" width="10%">
<div align="center"><font size="2"><%=rs.getString("fybm")%></font></div>
</td>
<td height="19" width="12%">
<div align="center"><font size="2"><%=rs.getString("fymc")%></font></div>
</td>
<td height="19" width="10%">
<div align="center"><font size="2"><%=rs.getString("fyje")%></font></div>
</td>
<td height="19" width="12%">
<div align="center"><font size="2"><%=rs.getString("zrks")%></font></div>
</td>
</tr>
</table>
<%
if(!rs.next()) break;
}
%>
<form method=post action=result1.jsp>
<table align="center" cellspacing="8">
<tr>
<%
if(ShowPage!=1)
{
%>
<td> <a href=result1.jsp?ToPage=<%=1%> class="a"><font size="2">第一页</font></a>|
</td>
<td> <a href=result1.jsp?ToPage=<%=ShowPage-1%> class="a"><font size="2">上一页</font></a>|
</td>
<%
}
else
{
%>
<td><font size="2">第一页</font>|</td>
<td><font size="2">上一页</font>|</td>
<%
}
if(ShowPage!=PageCount)
{
%>
<td> <a href=result1.jsp?ToPage=<%=ShowPage+1%> class="a"><font size="2">下一页</font></a>|
</td>
<td> <a href=result1.jsp?ToPage=<%=PageCount%> class="a"><font size="2">最后一页</font></a>
</td>
<%
}
else
{
%>
<td><font size="2">下一页</font>|</td>
<td><font size="2">最后一页</font>|</td>
<%
}
%>
<td>
<font size="2">页次:</font>
<font size="2" color=red><%=ShowPage%></font>/<font size="2"><%=PageCount%></font>
</td>
</tr>
</table>
</form>
<%
}
else
{
out.print("<br/>"+"<div align=center>"+"没有相关记录!"+"</div>");
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
<%
int PageSize=5; //每一页显示的记录数
int ShowPage=1; //当前显示的页面
int RowCount=0; //总的记录数
int PageCount=0; //总的页数
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String jNo=null;
jNo=request.getParameter("JINGHAO");
String sql="select * from djcbb where jh='"+jNo+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next())
{
rs.last();
RowCount=rs.getRow();
PageCount=((RowCount%PageSize)==0?(RowCount/PageSize):(RowCount/PageSize)+1);
%>
<html>
<body bgcolor="#FFFFFF" text="#000000">
<%
String ToPage=request.getParameter("ToPage");
if(ToPage!=null)
{
ShowPage=Integer.parseInt(ToPage);
if(ShowPage>PageCount)
{
ShowPage=PageCount;
}
else if(ShowPage<=0)
{
ShowPage=1;
}
}
rs.absolute((ShowPage-1)*PageSize+1);
%>
<div align="center"><font size="2">找到相关记录<%=RowCount%>条,共<%=PageCount%>页,
当前是第<%=ShowPage%>页</div>
<hr>
<table width="100%" cellspacing=2>
<tr bgcolor="#FFCCCC">
<td width="12%" height="19" bgcolor="#FFCCCC">
<div align="center"><font size="2"><b>日期</b></font></div>
</td>
<td width="11%" height="19">
<div align="center"><font size="2"><b>井号</b></font></div>
</td>
<td width="10%" height="19">
<div align="center"><font size="2"><b>费用编码</b></font></div>
</td>
<td width="12%" height="19">
<div align="center"><font size="2"><b>费用名称</b></font></div>
</td>
<td width="10%" height="19">
<div align="center"><font size="2"><b>费用金额</b></font></div>
</td>
<td width="12%" height="19">
<div align="center"><font size="2"><b>科室</b></font></div>
</td>
</tr>
</table>
<%
for(int i=1;i<=PageSize;i++)
{
%>
<table width="100%" cellspacing=2 cellpadding=2>
<tr bgcolor=#F2F2F2>
<td height="19" width="12%">
<%
String data;
data = rs.getString("rq");
data = data.substring(0, data.indexOf(" "));//去掉datetime类型后面的时分秒
%>
<div align="center"><font size="2"><%=data%></font></div>
</td>
<td height="19" width="11%">
<div align="center"><font size="2"><%=rs.getString("jh")%></font></div>
</td>
<td height="19" width="10%">
<div align="center"><font size="2"><%=rs.getString("fybm")%></font></div>
</td>
<td height="19" width="12%">
<div align="center"><font size="2"><%=rs.getString("fymc")%></font></div>
</td>
<td height="19" width="10%">
<div align="center"><font size="2"><%=rs.getString("fyje")%></font></div>
</td>
<td height="19" width="12%">
<div align="center"><font size="2"><%=rs.getString("zrks")%></font></div>
</td>
</tr>
</table>
<%
if(!rs.next()) break;
}
%>
<form method=post action=result1.jsp>
<table align="center" cellspacing="8">
<tr>
<%
if(ShowPage!=1)
{
%>
<td> <a href=result1.jsp?ToPage=<%=1%> class="a"><font size="2">第一页</font></a>|
</td>
<td> <a href=result1.jsp?ToPage=<%=ShowPage-1%> class="a"><font size="2">上一页</font></a>|
</td>
<%
}
else
{
%>
<td><font size="2">第一页</font>|</td>
<td><font size="2">上一页</font>|</td>
<%
}
if(ShowPage!=PageCount)
{
%>
<td> <a href=result1.jsp?ToPage=<%=ShowPage+1%> class="a"><font size="2">下一页</font></a>|
</td>
<td> <a href=result1.jsp?ToPage=<%=PageCount%> class="a"><font size="2">最后一页</font></a>
</td>
<%
}
else
{
%>
<td><font size="2">下一页</font>|</td>
<td><font size="2">最后一页</font>|</td>
<%
}
%>
<td>
<font size="2">页次:</font>
<font size="2" color=red><%=ShowPage%></font>/<font size="2"><%=PageCount%></font>
</td>
</tr>
</table>
</form>
<%
}
else
{
out.print("<br/>"+"<div align=center>"+"没有相关记录!"+"</div>");
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
<form name=form action="result1.jsp">
<input name="ToPage">
</form>
<input name="ToPage">
<input type="hidden" name="JINGHAO" value="<%=jNo%>">
</form>
<a href="CharterInfoQuery.jsp?page=<%=intPage+1%>&a=<%=queryString1%>&b=<%=queryString2%>&flag=<%=flag%>">下一页></a>>
<a href="CharterInfoQuery.jsp?page=1&a=<%=queryString1%>&b=<%=queryString2%>&flag=<%=flag%>">首页></a>>
<a href="CharterInfoQuery.jsp?page=<%=intPageCount%>&a=<%=queryString1%>&b=<%=queryString2%>&flag=<%=flag%>">末页></a>> 跳转到
你可以不写一句java代码实现分页,方法通用,特简单。