日期:2014-05-20 浏览次数:20717 次
<% if(!rs.next()) break; } %> <tr> <td width="786" height="30" colspan="9" align="right"> <table width="786" align="center"> <tr> <td width="786" height="30" colspan="9" align="right"> 共<%=pagecount%>页 <a href="/Manager/Placard/placard.jsp?topage=<%=1%>">第一页</a> <a href="/Manager/Placard/placard.jsp?topage=<%=showpage-1%>">上一页</a> <a href="/Manager/Placard/placard.jsp?topage=<%=showpage+1%>">下一页</a> <a href="/Manager/Placard/placard.jsp?topage=<%=pagecount%>">最后一页</a> <span class="bgcolor"> <input name="topage" type="text" class="txt_grey" size="3" value="<%=showpage%>">页</span> </td> </tr> </table> </td> </tr> <% } condata.close(con); }catch(Exception e) {e.printStackTrace();} %> </table> </body> </html>
------解决方案--------------------
<%@ page contentType="text/html; charset=gb2312" %> <%@ page import="java.sql.*"%> <jsp:useBean id="condata" scope="page" class="com.crm.util.DB"/> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title> placard page </title> </head> <%! Connection con=null; Statement stmt = null; ResultSet rs=null; String sql; int code; int pagesize=10; int rowcount=0; int pagecount=1; %> <body bgcolor="#ffffff"> <table width="785" height="117" border="1" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="786" height="38" align="center" colspan="6"><font face="隶书" size="7">网站公告信息</font></td> </tr> <tr> <td width="85%" height="29" align="right" colspan="6"> <a href="/Manager/Placard/placard_show.jsp">发布公告信息</a></td> </tr> <tr> <td width="10%" height="29" align="center">ID</td> <td width="10%" height="29" align="center">标题</td> <td width="10%" height="29" align="center">发布日期</td> <td width="10%" height="29" align="center">作者</td> <td width="10%" height="29" align="center">接收者</td> <td width="10%" height="29" align="center">内容</td> <td width="10%" height="29" align="center">修改</td> <td width="15%" height="29" align="center">删除</td> </tr> <% sql="select ID,Title,publishtime,publisher,accepter,content from notice "; try { con=condata.getCon(); stmt=condata.getStmt(con); rs=condata.executeQuery(stmt,sql); if(!rs.next()) { %> <script language="javascript"> //alert("没有公共信息"); // history.back(); </script> <% }else { rs.last(); rowcount=rs.getRow(); int showpage=1; pagecount=((rowcount%pagesize)==0?(rowcount/pagesize):(rowcount/pagesize)+1); String topage=request.getParameter("topage"); if(topage!=null) { showpage=Integer.parseInt(topage); if(showpage>pagecount){ showpage=pagecount; }else if(showpage<=0){ showpage=1; } } rs.absolute((showpage-1)*pagesize+1); for(int i=1;i<=pagesize;i++) { code=rs.getInt("ID"); %> <tr> <td width="10%" height="32" align="center"><%=code%></td> <td width="10%" height="32" align="center"><%=rs.getString("Title")%></td> <td width="10%" height="32" align="center"><%=rs.getDate("publishtime")%></td> <td width="10%" height="32" align="center"><%=rs.getString("publisher")%></td> <td width="10%" height="32" align="center"><%=rs.getString("accepter")%></td> <td width="10%" height="32" align="center"><%=rs.getString("content")%></td> <td width="10%" height="32" align="center"> <a href="/Manager/Placard/placard_change.jsp?id=<%=code%>">修改</a></td> <td width="15%" height="32" align="center"> <a href="/Manager/Placard/placard_delete.jsp?id=<%=code%>">删除</a></td> </tr> <% if(!rs.next()) break; } %> <tr> <td width="786" height="30" colspan="9" align="right"> <table width="786" align="center"> <tr> <td width="786" height="30" colspan="9" align="right"> 共<%=pagecount%>页 <a href="/Manager/Placard/placard.jsp?topage=<%=1%>">第一页</a> <a href="/Manager/Placard/placard.jsp?topage=<%=showpage-1%>">上一页</a> <a href="/Manager/Placard/placard.jsp?topage=<%=showpage+1%>">下一页</a> <a href="/Manager/Placard/placard.jsp?topage=<%=pagecount%>">最后一页</a> <span class="bgcolor"> <input name="topage" type="text" class="txt_grey" size="3" value="<%=showpage%>">页</span> </td> </tr> </table> </td> </tr> <% } condata.close(con); }catch(Exception e) {e.printStackTrace();} %> </table> </body> </html>