> WENDY'S HOUSE <

< %@ page contentType="text/html;charset=gb2312" %> < %@ page import="DatabaseConnection" %> < %@ page import="java.sql.*" %> < %@ page import="java.math.*" %> 用户:< %=session.getAttribute("name")%> < % int pagerow=5;//每页的行数 int cpage=0;//当前页 int maxpage=0;//总页数 int maxrow=0;//总行数 int pages; Connection con=null;//定义连接 PreparedStatement st=null; ResultSet rs=null; try { con=DatabaseConnection.getConnection(); st=con.prepareStatement("select count(*) from product"); rs=st.executeQuery(); rs.next(); maxrow=rs.getInt(1); maxpage=(int)Math.ceil((maxrow+pagerow-1)/pagerow); } catch(Exception e) { System.out.println(e.getMessage()); } if(request.getParameter("page")==null) { pages=1; } else { pages=Integer.parseInt(request.getParameter("page")); } try { st=con.prepareStatement("select * from product"); rs=st.executeQuery(); int i=0; %> < % while(rs.next()) { if( (i>(pages-1)*5-1)&&(i< (pages*5))){ %> < %}i++;}%>

物品号:	物品名:	物品数量:	物品价格:
">	< %=rs.getString(2)%>	1	< %=rs.getString(4)%>

< %} catch(Exception e) { System.out.println(e.getMessage()); } %>

---

共< %=maxrow%>行  共< %=maxpage%>页
">首页 ">上一页 ">下一页 ">尾页