把一年前写的代码帖出来,有些写的很烂,能实现分页功能,请勿见笑.
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.math.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:guestbook","sa","");
Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=sql.executeQuery("select * from info ");
int intId=0;
String strUsername;
String strTitle;
String strQq;
String strSex;
String strEmail;
String strWeb;
String strContent;
int intAllPage=0;//总页数
int intPage=5;//每页显示5条记录
int intNowPage=1;//当前页
int intAllNo=0;//总记录
String strFirstPage;//
int intFirstPage=0;//每页显示的第一条记录是数据库的第几条记录
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>index</title>
</head>
<body>
<div align="center">
<p align="left"> </p>
</div>
<table width="771" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#000000">
<tr>
<td height="56" align="center" bgcolor="#FFFFFF"><a href="add.jsp"><img src="images/new.jpg" width="50" height="49" border="0"></a>
<a href="index.jsp"><img src="images/read.jpg" width="50" height="49" border="0"></a> <a href="mailto:[email protected]"><img src="images/email.jpg" width="50" height="49" border="0"></a>
<a href="update.jsp"><img src="images/uuser.jpg" width="50" height="49" border="0"></a> </td>
</table>
<%try{
rs.last();
intAllNo=rs.getRow();
if(intAllNo%intPage==0)
intAllPage=intAllNo/intPage;//得到总页数
else
intAllPage=intAllNo/intPage+1;
String strNowPage=request.getParameter("id");
if(strNowPage==null){
strNowPage="1";
}
try{intNowPage=Integer.parseInt(strNowPage);
}
catch(NumberFormatException e){
intNowPage=1;
}
if(intNowPage<=1)
intNowPage=1;
if(intNowPage>intAllPage)
intNowPage=intAllPage;
intFirstPage=(intNowPage-1)*intPage+1;
rs.absolute(intFirstPage);
%>
<%for(int i=1;i<=intPage;i++){%>
<%
intId=rs.getInt("id");
strUsername=rs.getString("username");
strTitle=rs.getString("title");
strQq=rs.getString("qq");
strSex=rs.getString("sex");
strEmail=rs.getString("email");
strWeb=rs.getString("web");
strContent=rs.getString("content");
%>
<table width="771" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr bgcolor="#FFFFFF">
<td width="181" height="42" rowspan="3" align="center"><br>
<br>
网友性别:<%=strSex%> <br>
网友大名:<%=strUsername%><br>
OICQ :<%=strQq%></td>
<td colspan="4" align="left" valign="top" class="gl">留言内容:
<%
if(strContent!="")
{
out.println(strContent);
}%>
</td>
<tr>
<td width="157" height="19" align="center" bgcolor="#F7F7F7"><a href="http://<%=strWeb%>">主页</a>
</td>
<td width="139" height="19" align="center" bgcolor="#F7F7F7"><a href="mailto:<%=strEmail%>">邮件</a>
</td>
<td width="139" height="19" align="center" bgcolor="#F7F7F7"><a href="reinfo.jsp?id=<%=intId%>">回复</a></td>
<td width="143" height="19" align="center" bgcolor="#F7F7F7"><a href="del.jsp?id=<%=intId%>">删除</a></td>
</tr>
</table>
<%
try{
rs.next();
}
catch(SQLException e1){}
%>
<%}%>
<%rs.close();%>
第<%=intNowPage%>页/共<%=intAllPage%>页/共有<%=intAllNo%>记录
<%if(intNowPage!=1){%>
<a href="index.jsp?id=<%=intNowPage-1%>">上一页</a>
<%}%>
<%if((intAllPage-intNowPage)!=0){%>
<a href="index.jsp?id=<%=intNowPage+1%>">下一页</a>
<%}%>
<%}catch(SQLException e1){}%>
</body>
</html>
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.math.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:guestbook","sa","");
Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=sql.executeQuery("select * from info ");
int intId=0;
String strUsername;
String strTitle;
String strQq;
String strSex;
String strEmail;
String strWeb;
String strContent;
int intAllPage=0;//总页数
int intPage=5;//每页显示5条记录
int intNowPage=1;//当前页
int intAllNo=0;//总记录
String strFirstPage;//
int intFirstPage=0;//每页显示的第一条记录是数据库的第几条记录
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>index</title>
</head>
<body>
<div align="center">
<p align="left"> </p>
</div>
<table width="771" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#000000">
<tr>
<td height="56" align="center" bgcolor="#FFFFFF"><a href="add.jsp"><img src="images/new.jpg" width="50" height="49" border="0"></a>
<a href="index.jsp"><img src="images/read.jpg" width="50" height="49" border="0"></a> <a href="mailto:[email protected]"><img src="images/email.jpg" width="50" height="49" border="0"></a>
<a href="update.jsp"><img src="images/uuser.jpg" width="50" height="49" border="0"></a> </td>
</table>
<%try{
rs.last();
intAllNo=rs.getRow();
if(intAllNo%intPage==0)
intAllPage=intAllNo/intPage;//得到总页数
else
intAllPage=intAllNo/intPage+1;
String strNowPage=request.getParameter("id");
if(strNowPage==null){
strNowPage="1";
}
try{intNowPage=Integer.parseInt(strNowPage);
}
catch(NumberFormatException e){
intNowPage=1;
}
if(intNowPage<=1)
intNowPage=1;
if(intNowPage>intAllPage)
intNowPage=intAllPage;
intFirstPage=(intNowPage-1)*intPage+1;
rs.absolute(intFirstPage);
%>
<%for(int i=1;i<=intPage;i++){%>
<%
intId=rs.getInt("id");
strUsername=rs.getString("username");
strTitle=rs.getString("title");
strQq=rs.getString("qq");
strSex=rs.getString("sex");
strEmail=rs.getString("email");
strWeb=rs.getString("web");
strContent=rs.getString("content");
%>
<table width="771" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr bgcolor="#FFFFFF">
<td width="181" height="42" rowspan="3" align="center"><br>
<br>
网友性别:<%=strSex%> <br>
网友大名:<%=strUsername%><br>
OICQ :<%=strQq%></td>
<td colspan="4" align="left" valign="top" class="gl">留言内容:
<%
if(strContent!="")
{
out.println(strContent);
}%>
</td>
<tr>
<td width="157" height="19" align="center" bgcolor="#F7F7F7"><a href="http://<%=strWeb%>">主页</a>
</td>
<td width="139" height="19" align="center" bgcolor="#F7F7F7"><a href="mailto:<%=strEmail%>">邮件</a>
</td>
<td width="139" height="19" align="center" bgcolor="#F7F7F7"><a href="reinfo.jsp?id=<%=intId%>">回复</a></td>
<td width="143" height="19" align="center" bgcolor="#F7F7F7"><a href="del.jsp?id=<%=intId%>">删除</a></td>
</tr>
</table>
<%
try{
rs.next();
}
catch(SQLException e1){}
%>
<%}%>
<%rs.close();%>
第<%=intNowPage%>页/共<%=intAllPage%>页/共有<%=intAllNo%>记录
<%if(intNowPage!=1){%>
<a href="index.jsp?id=<%=intNowPage-1%>">上一页</a>
<%}%>
<%if((intAllPage-intNowPage)!=0){%>
<a href="index.jsp?id=<%=intNowPage+1%>">下一页</a>
<%}%>
<%}catch(SQLException e1){}%>
</body>
</html>
先了解一下con.createStatement()函数中的参数代表什么意义。至于编程,easy