分页遇到的问题请各位大哥帮帮忙

wowochen 2008-05-06 11:30:21

第一页可以正确显示应该是在传值中出现问题望大家指点一下
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312"%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">

</style>
</head>

<body>
<table width="605" height="189" border="0" >
<tr>
<td height="29" colspan="4"><span class="STYLE2">最近热销的商品欢迎选购</span><img src="../pic/pic17.gif" width="21" height="17" /><img src="../pic/pic17.gif" width="21" height="17" /><img src="../pic/pic17.gif" width="21" height="17" /><img src="../pic/pic17.gif" width="21" height="17" /><br />
<hr width="45%" align="left" color="#009966"></td>
</tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:ecn","","");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs1=stmt.executeQuery("select count(*) from goods_info");
rs1.next();
int rowCount=rs1.getInt(1);
rs1.close();
int pageCount=(rowCount+6-1)/6;
int prepage=0;
String tmp_page=(String)request.getParameter("prepage");
if((tmp_page==null)||(tmp_page.length()<0))
tmp_page="1";
prepage=Integer.parseInt(tmp_page);
if(prepage<1)
prepage=1;
if(prepage>pageCount)
prepage=pageCount;
ResultSet rs=stmt.executeQuery("select * from goods_info");
if(pageCount>0)
{
rs.absolute((prepage-1) * 6+1);
int i=0;
while(i<6&& !rs.isAfterLast())
{
String id=rs.getString(1);

%>
<tr>
<td width="152" height="130"><img src="../pic/pic12.jpg" width="128" height="128" /></td>
<td width="201">
<table width="200" height="68" border="0">
<tr>
<td height="15"><div align="left"><span class="STYLE3">【商品ID】</span><font color="#CD0000"><%=id%> </font></div></td>
</tr>
<tr>
<td height="15"><div align="left"><span class="STYLE3">【商品序列号】</span><font color="#CD0000"><%=rs.getString(2)%></font></div></td>
</tr>
<tr>
<td height="15"><div align="left"><span class="STYLE3">【商品名称】</span><font color="#CD0000"><%=rs.getString(3)%></font></div></td>
</tr>
<tr>
<td><div align="left"><span class="STYLE3">【商品类型】</span><font color="#CD0000"><%
String model=rs.getString(4);
String Model="";
if(model.equals("phone")) Model="手机";
if(model.equals("computer")) Model="电脑";
if(model.equals("DVD")) Model="影像唱片";
if(model.equals("book")) Model="图书";
if(model.equals("others")) Model="生活用品";
%>
<%=Model%></font>
</div></td>
</tr>
<tr>
<td><div align="left"><span class="STYLE3">【一口价】<font color="#CD0000"><%=rs.getString(5)%></font></div></td>
</tr>
</table>
</td>
<td width="108"> </td>
<td width="150"><a href="../user/buy/buy.jsp? GID=<%=id%>"><img src="../pic/pic16.jpg" width="98" height="26" border="0" /></a></td>
</tr>
<tr>
<td height="13" colspan="4"><hr color="#6B8E23"></td>
</tr>
<%
rs.next();
i++;
}
}
%>
</table>
<div align="right"><font color="#CD0000">
第<%=prepage%>页共<%=pageCount%>页</font>
<a href="goodview.jsp? prepage=<%=prepage-1%>">上一页</a>
<a href="goodview.jsp? prepage=<%=prepage+1%>">下一页</a>
</div>
<%
rs.close();
stmt.close();
conn.close();
}catch(Exception e){e.printStackTrace();}
%>
</body>
</html>

...全文

53 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

westwood0013 2008-05-06

打赏
举报

路过顺便帮顶
对了问下楼主 java写web应用都是嵌在代码里的马？
要用分页的话不论什么语言思想应该是一样的
楼主准备每页显示多少记录 perpage
判断当前页是哪一页因为不加链接 temppage
然后两种模式：一种是 12345
另一种则是 tempage-2 tempage-1 tempage tempage+1 tempage+2
不知道楼主看懂了没有希望对你有帮助~~