论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-03-24 14:30 |只看该作者 |倒序浏览

<%@ page contentType="text/html; charset=GBK" %>;
<%@page import="java.sql.*"%>;
<html>;
<head>;
<title>;
text
</title>;
</head>;
<body bgcolor="#ffffff">;

<table border="1" cellspacing="0" cellpadding="0">;
<tr>;
<th>;Id:</th>;
<th>;Name:</th>;
<th>;Description:</th>;
<th>

rice:</th>;
<th>;Stock:</th>;
</tr>;

<%
   int rowCount;
   int pageCount;
   int currPage;
   int pageSize;
   int i;
   currPage=1;
   java.sql.Connection con=null;
   Statement stm =null;
   ResultSet rs =null;
   Class.forName("com.pointbase.jdbc.jdbcUniversalDriver"

;
con=DriverManager.getConnection("jdbc:pointbase:server://localhost:9092/demo","

BPUBLIC", "

BPUBLIC"

;
stm =con.createStatement(rs.TYPE_SCROLL_INSENSITIVE,rs.CONCUR_READ_ONLY);
rs =stm.executeQuery("select * from item"

;
   rs.last();
   rowCount =rs.getRow();
   pageSize =10;

   pageCount =(rowCount-1+pageSize)/pageSize;
   if(currPage>;pageCount) currPage = pageCount;
%>;

<%
int theo =(currPage-1)*pageSize;

   rs.absolute(theo+1);

   i = 0;
   while(i<pageSize && !rs.isAfterLast()){
%>;
<tr>;
<td>;<%=rs.getInt(1)%>;</td>;
<td>;<%=rs.getString(2)%>;</td>;
<td>;<%=rs.getString(3)%>;</td>;
<td>;<%=rs.getDouble(4)%>;</td>;
<td>;<%=rs.getInt(5)%>;</td>;
</tr>;
<%
rs.next();
i++;
}

%>;

第<%=currPage%>;页  共<%=pageCount%>;页
<%if(currPage<pageCount+1){%>;<a href="text.jsp?page=<%=currPage+1%>;">;下一页</a>;<%}%>;  <%if(currPage>;1){%>;<a href="text.jsp?page=<%=currPage-1%>;">;上一页</a>;<%}%>;
                        <a href="text.jsp?page=<%=pageCount%>;">;尾页</a>;

<%

rs.close();

stm.close();

con.close();
%>;
</table>;
</body>;
</html>;

总是在第一页显示,怎么翻就是不动.