while.jsp

网上购物系统

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
int EveryPage=8;//每页显示的记录数；
int OnPage=1; //当前显示的页数；
int Total=0;//记录的总数；
int TotalPage=0;//记录的总页数；
ResultSet rs = stmt.executeQuery("SELECT name,convert(varchar(19),shijian,120)as thisdate,neirong FROM jsp8_mess_hui WHERE messid = '"+id+"' order by id");
rs.last();//移到最后一条记录;
Total=rs.getRow();//记录的总数；
if(Total%EveryPage==0)
TotalPage=Total/EveryPage;
else
TotalPage=Total/EveryPage+1;
String Pages=request.getParameter("Pages");
if(Pages!=null)
{
 OnPage=Integer.parseInt(Pages);
if(OnPage>TotalPage)
 {
  OnPage=TotalPage;
 }
 else if(OnPage<=0)
 {
  OnPage=1;
 }
}
rs.absolute((OnPage-1)*EveryPage+1);//指定指针的位置；
if(Total == 0){
}else{
for(int i=0;i<=EveryPage;i++){
out.println("<table width=90% height=103 border=1 align=center cellpadding=0 cellspacing=0 bordercolor=#0177AF>");
out.println("<tr><td width=48% height=16 bgcolor=#0177AF><span class=style3>");
out.println(rs.getString("name"));
out.println("</span> &nbsp;</td><td width=52% bgcolor=#0177AF class=style1>");
out.println(rs.getString("thisdate"));
out.println("</td></tr><tr><td height=85 colspan=2>");
out.println(rs.getString("neirong"));
out.println("</td></tr></table>");
if(!rs.next())
break;
}
rs.close();
out.println("<table width=90% border=1 align=center cellpadding=0 cellspacing=0 bordercolor=#0177AF bgcolor=#FFCC00>");
out.println("<tr><td bgcolor=#CCCCCC>");
int tt =TotalPage+1; 
for(int iq=1;iq<tt;iq++){
out.println("<a href=viewmess.jsp?id="+id+"&Pages="+iq+">"+iq+"</a>&nbsp;&nbsp;");
}
out.println("</td></tr></table>");
}
if(tie.equals("no")){ //查询是否结帖,是就就直接退出完成;
}else{
out.println("<table width=90% height=61 border=0 align=center cellpadding=0 cellspacing=0>");
out.println("<FORM name=frmLogin action=messadd.jsp method=post><tr>");              
out.println("<td height=45><textarea name=nr cols=55 rows=10 id=nr></textarea></td>");
out.println("</tr><tr><td height=16><input type=button name=Submit value=\"回   复\" onclick=\"datacheck()\">");
out.println("<input name=messid value="+id+" type=hidden><input name=name value="+session.getAttribute("adminuser")+" type=hidden>");
out.println("<input name=sjr value="+faxinren+" type=hidden><input type=checkbox name=hf value=yes>禁止回复</td></tr></form></table>");  
}%>