程序如下:
<jsp:useBean id="sqlBean" scope="page" class="guestbook.Sql"/>
<%
String name,email,content,ptime,sql,p;
int i=0,pagesize=5,tpage,pagecount,a=1,count=0;
p=request.getParameter("page");
if (p==null)
tpage=1;
else
tpage=Integer.parseInt(p);
if(tpage<=0)
tpage=1;
sql="select name,email,content,ptime from guestbook order by id desc";
ResultSet rs;
rs=sqlBean.pageselect(sql,"sa","55555",pagesize,tpage);
count=sqlBean.getCount();
pagecount=sqlBean.getPageCount();
while(rs!=null && !rs.isAfterLast() && i<pagesize){
name=new String(rs.getString("name").getBytes("8859_1"));
email=new String(rs.getString("email").getBytes("8859_1"));
content=new String(rs.getString("content").getBytes("8859_1"));
ptime=new String(rs.getString("ptime").getBytes("8859_1"));
%>
<tr>
<td style="border-bottom:1px solid #000000">
<div><%=name%> 于 <%=ptime%> 留言到:</div>
<div><textarea name="" rows="" cols="60" style="font-size:12px;overflow-y:visible;line-height:150%;padding:5;font-family:verdana" readonly><%=content%></textarea></div>
</td>
</tr>
<%
rs.next();
i+=1;
}
%>
<tr bgcolor=#EAB68A>
<td style="padding-top:8">共有 <%=count%> 条记录 共 <%=pagecount%> 页
<span style="background-color:#cccccc;padding-top:2;padding-left:5;border:1px solid #000000">
<%
for(a=1;a<pagecount+1;a++){
String u="",eu="";
if (a!=tpage){
u="<a href=index.jsp?page="+a+">";
eu="</a>";
}
out.print(u+String.valueOf(a)+eu+" ");
}
%></span></td>
</tr>
<jsp:useBean id="sqlBean" scope="page" class="guestbook.Sql"/>
<%
String name,email,content,ptime,sql,p;
int i=0,pagesize=5,tpage,pagecount,a=1,count=0;
p=request.getParameter("page");
if (p==null)
tpage=1;
else
tpage=Integer.parseInt(p);
if(tpage<=0)
tpage=1;
sql="select name,email,content,ptime from guestbook order by id desc";
ResultSet rs;
rs=sqlBean.pageselect(sql,"sa","55555",pagesize,tpage);
count=sqlBean.getCount();
pagecount=sqlBean.getPageCount();
while(rs!=null && !rs.isAfterLast() && i<pagesize){
name=new String(rs.getString("name").getBytes("8859_1"));
email=new String(rs.getString("email").getBytes("8859_1"));
content=new String(rs.getString("content").getBytes("8859_1"));
ptime=new String(rs.getString("ptime").getBytes("8859_1"));
%>
<tr>
<td style="border-bottom:1px solid #000000">
<div><%=name%> 于 <%=ptime%> 留言到:</div>
<div><textarea name="" rows="" cols="60" style="font-size:12px;overflow-y:visible;line-height:150%;padding:5;font-family:verdana" readonly><%=content%></textarea></div>
</td>
</tr>
<%
rs.next();
i+=1;
}
%>
<tr bgcolor=#EAB68A>
<td style="padding-top:8">共有 <%=count%> 条记录 共 <%=pagecount%> 页
<span style="background-color:#cccccc;padding-top:2;padding-left:5;border:1px solid #000000">
<%
for(a=1;a<pagecount+1;a++){
String u="",eu="";
if (a!=tpage){
u="<a href=index.jsp?page="+a+">";
eu="</a>";
}
out.print(u+String.valueOf(a)+eu+" ");
}
%></span></td>
</tr>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货