这样行了吧,求求各位了
<%
String herbid=request.getParameter("herbid");
String strPage=request.getParameter("page");
int intPageCount; //总页数
int intPage; //待显示页码
int i,j,k; //设置一页显示的记录数
int intPageSize = 14; //取得待显示页码
//out.print(strPage);
if(strPage==null||strPage==""){
//表明在QueryString中没有page这一个参数,此时显示第一页数据
intPage =1;
}
else
{
//将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
String sql="select * from video where herbid='"+herbid+"' order by id desc";
ResultSet rs=connBean.executeQuery(sql);
String sql0="select count(*) from video where herbid='"+herbid+"' ";
ResultSet rs0=connBean.executeQuery(sql0);
rs0.next();
int rowcount=rs0.getInt(1);
rs0.close();
if(intPageSize>rowcount)intPageSize=rowcount;//计算总页数
if(rowcount>1)
intPageCount = (rowcount+intPageSize-1) / intPageSize;
else
intPageCount=0;//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;//将记录指针定位到待显示页的第一条记录上
i = (intPage-1) * intPageSize;
for(j=0;j<i;j++) rs.next();
%>
。<div align="center">共有<font color="#FF0000">
<%out.print(java.lang.Integer.toString(rowcount));%></font>条记录
<%
String herbid=request.getParameter("herbid");
String strPage=request.getParameter("page");
int intPageCount; //总页数
int intPage; //待显示页码
int i,j,k; //设置一页显示的记录数
int intPageSize = 14; //取得待显示页码
//out.print(strPage);
if(strPage==null||strPage==""){
//表明在QueryString中没有page这一个参数,此时显示第一页数据
intPage =1;
}
else
{
//将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
String sql="select * from video where herbid='"+herbid+"' order by id desc";
ResultSet rs=connBean.executeQuery(sql);
String sql0="select count(*) from video where herbid='"+herbid+"' ";
ResultSet rs0=connBean.executeQuery(sql0);
rs0.next();
int rowcount=rs0.getInt(1);
rs0.close();
if(intPageSize>rowcount)intPageSize=rowcount;//计算总页数
if(rowcount>1)
intPageCount = (rowcount+intPageSize-1) / intPageSize;
else
intPageCount=0;//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;//将记录指针定位到待显示页的第一条记录上
i = (intPage-1) * intPageSize;
for(j=0;j<i;j++) rs.next();
%>
。<div align="center">共有<font color="#FF0000">
<%out.print(java.lang.Integer.toString(rowcount));%></font>条记录
翻页的算法有点问题
记录为1条时,页次显示0/0页次:<font color="#FF0000"><%=intPage%><font color="#000000">/</font><%= intPageCount %></font>页 求高手帮忙修改一下.
感激涕零!!!!
<%@ page import="java.sql.*,java.io.*,java.util.*" %>
<%@ page language="java" pageEncoding="Big5" %>
<%! String au_id,au_lname,au_fname,phone,address,city,state;%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>ArticleList</TITLE>
<link rel="stylesheet" href="style.css">
</head>
<body bgcolor="#FFFFFF"><table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table width="750" border="0" cellspacing="2" cellpadding="2" align="center">
<tr align="center">
<td> </td>
</tr>
<tr>
<td>
<table width="740" border="0" cellspacing="1" cellpadding="1" align="center">
<tr align="center" bgcolor="#CCCCCC">
<td><b>標題</b></td>
<td><b>作者</b></td>
<td><b>類型</b></td>
<td><b>點擊</b></td>
<td><b>加入時間</b></td>
</tr>
<%
int i;
int ipage=5; //分頁單位
int allpage; //總頁數
int pages; //接受的頁碼變數
int cpage=1; //當前頁
int spage; //開始頁
int allCol=0;
Vector v=null;//資料庫連接聲明
Connection conn=null;
java.lang.String sql,pagesql;
java.sql.ResultSet rs,pagers;
Statement statement=null;
String kmsdb="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=DBName";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection(kmsdb, "user", "pwd");
pagesql = "SELECT COUNT(*) FROM Authors"; //取總文章數
statement = conn.createStatement();
pagers = statement.executeQuery(pagesql);
while(pagers.next())
{
allCol = pagers.getInt(1);
System.out.println(allCol); }
//獲得總頁面數
allpage = (int)Math.ceil((allCol + ipage-1) / ipage);
//判斷參數pages是否空
if (request.getParameter("pages")==null) {
pages=1;
} else {
pages = new Integer(request.getParameter("pages")).intValue();
System.out.println(pages);
}
//判斷當前頁
if(pages > allpage || pages == 0)
{cpage = 1;}
else
{
cpage = pages;
}
//判斷起始頁
sql = "select Top "+ipage+" au_id,au_lname,au_fname,address,phone from authors where au_id not in (select top "+(cpage-1)*ipage+" au_id from authors order by au_id desc)order by au_id desc";
rs = statement.executeQuery(sql);
while (rs.next())
{
au_id=rs.getString("au_id");
au_lname=rs.getString("au_lname");
au_fname=rs.getString("au_fname");
phone=rs.getString("phone");
address=rs.getString("address");%>
<td width="300"><%= au_id %></a></td>
<td width="300"><%= au_lname %></a></td>
<td width="300"><%= au_fname %></a></td>
<td width="300"><%= phone %></a></td>
<td width="300"><%= address %></a></td>
</tr>
<%
}%>
<tr bgcolor="#CCCCCC">
<td colspan="5" align="right" valign="middle">共 <%= allCol %>條記錄 共 <%= allpage %>頁 <% if (cpage>1) { %><a href="fy.jsp?pages=<%= cpage-1 %>"><img src="images/prev.gif" border="0"></a><% } if (cpage<allpage) { %><a href="fy.jsp?pages=<%= cpage+1 %>"><img src="images/next.gif" border="0"></a><% } %> / <% for (i=1;i<=allpage;i++) { if (i != pages) {%><a href="fy.jsp?pages=<%= i %>"><%= i %></a> <% }} %></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>