jsp分頁顯示完整實例

字號:


    這篇文章主要介紹了jsp分頁顯示完整實例,以文章管理頁面為例詳細(xì)分析了jsp的分頁顯示實現(xiàn)技巧,具有一定參考借鑒價值,需要的朋友可以參考下
    本文實例講述了jsp分頁顯示的實現(xiàn)方法。分享給大家供大家參考。
    具體實現(xiàn)方法如下:
    代碼如下:
    <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
    < file ="../inc/ChkPwd.jsp"%>
    < file="../DB.jsp"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
    <html xmlns="">
    <head>
    <meta name="robots" content="noindex,nofollow" />
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
    <title>文章管理</title>
    <link href="Style.css" rel="stylesheet" type="text/css" />
    </head>
    <body>
    <table width="98%" height="77%" cellpadding="0" cellspacing="0">
    <tr>
    <td height="26" background="images/admin_bg_1.gif"><strong><font color="#FFFFFF">--<span>內(nèi)容管理</span></font></strong></td>
    </tr>
    <tr>
    <td colspan="10">
    </td>
    </tr>
    <tr>
    <td height="25" background="images/admin_bg_1.gif">|
    <%
    String op;
    String ID = request.getParameter("id");
    op = request.getParameter("op");
    if(op==null){
    op = "my";
    }
    if (op.equals("del") && ID!=null){
    String bbb = new String(request.getParameter("BigClassName").getBytes("iso8859_1"));
    Statement stmt_ChannelDEL=conn.createStatement();
    String Sqldel="delete from hl_news where id=" + ID;
    int shan=stmt_ChannelDEL.executeUpdate(Sqldel);
    if (shan>0)
    {
    out.print("<script type="text/javascript"> alert("已成功刪除!"); window.location.href='Hanye_Manages.jsp?BigClassName="+bbb+"'; </script>");
    }
    stmt_ChannelDEL.close();
    return ;
    }
    Statement stmtA=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
    String SqlA="Select * from hl_smallclass WHERE bigname='行業(yè)新聞' order by id asc";
    ResultSet RsA=stmtA.executeQuery(SqlA);
    while (RsA.next()) {
    %>
    <a class='t2' href='Hanye_Manages.jsp?modi=新聞&BigClassName=<%=RsA.getString("smallname")%>'><%=RsA.getString("smallname")%></a> |
    <%
    }
    RsA.close(); //關(guān)閉記錄集對象
    stmtA.close(); //關(guān)閉語句對象
    %>
    </td>
    </tr>
    <tr>
    <td height="20"></td>
    </tr>
    <tr>
    <td valign="top" bgcolor="#ECF5FF">
    <form name="form2" action="list.asp?action=delall&modi=新聞" method="post">
    <table cellpadding="3" cellspacing="2" bgcolor="#FFFFFF">
    <tr>
    <td width="32" height="28" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" >ID</td>
    <td width="80" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" >新聞大類</td>
    <td width="88" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" >新聞小類</td>
    <td width="291" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" >新聞標(biāo)題</td>
    <td width="179" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" >新聞圖片</td>
    <td width="76" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" >發(fā)布時間</td>
    <td width="64" background="images/admin_bg_1.gif" bgcolor="#BBDAFF">操作</td>
    </tr>
    <%
    int pageSize=10; //每頁顯示的文章數(shù)
    int showPage=1; //當(dāng)前頁面顯示的頁號
    int recCount=0; //ResultSet中的文章總數(shù)
    int pageCount=0; //分頁后的總頁數(shù)
    String SqlArticle;
    String toPage = request.getParameter("page");
    String bgname = new String(request.getParameter("BigClassName").getBytes("iso8859_1"));
    Statement stmt_Article=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
    SqlArticle="Select * from hl_news where smallname='"+bgname+"' order by ID DESC";
    ResultSet RsArticle=stmt_Article.executeQuery(SqlArticle);
    if(RsArticle.next()) {
    RsArticle.last();//指針飛到最后
    recCount=RsArticle.getRow();//去除最后一行的行號
    pageCount=((recCount%pageSize)==0?(recCount/pageSize):(recCount/pageSize)+1);//得到一共可以分多少頁
    if(toPage!=null)
    showPage=Integer.parseInt(toPage);
    RsArticle.absolute((showPage-1)*pageSize+1);//跳到第showpage頁的第一條
    for(int i=1;i<=pageSize;i++){
    int NID=RsArticle.getInt("ID");
    String img = RsArticle.getString("img");
    String ttt = RsArticle.getString("times");
    //ttt=ttt.substring(0,10);
    %>
    <tr>
    <td width="32" height="22" bgcolor="#BBDAFF"><%=NID%></td>
    <td bgcolor="#BBDAFF" ><%=RsArticle.getString("bigname")%></td>
    <td bgcolor="#BBDAFF" ><%=RsArticle.getString("smallname")%></td>
    <td bgcolor="#BBDAFF" ><%=RsArticle.getString("Title")%></td>
    <td bgcolor="#BBDAFF" ><a href="/<%=img%>" target="_blank"><%=img%></a></td>
    <td bgcolor="#BBDAFF" ><%=ttt%></td>
    <td width="64" bgcolor="#BBDAFF"><a href="Hanye_edit.jsp?id=<%=NID%>&modi=新聞">修改</a>|<a href="Hanye_Manages.jsp?id=<%=NID%>&op=del&BigClassName=<%=bgname%>" onclick="return confirm('刪除后將不能恢復(fù),你確定刪除么?')">刪除</a></td>
    </tr>
    <%
    if(!RsArticle.next())
    break;
    }
    }
    %>
    <input name='AllID' type='hidden' value=>
    </table>
    <table cellpadding="0" cellspacing="0">
    <tr>
    <td width="50%" background="images/admin_bg_1.gif">
    <span><strong></strong>
    </span>
    <label>
    </label>
    </td>
    <td width="56%" background="images/admin_bg_1.gif">
    <div>
    共<%=pageCount%>頁 <% for(int i=1;i<=pageCount;i++){ %> <% if(i==showPage){ %><b><%=i %></b><% }else{ %>[<a href='Hanye_Manages.jsp?BigClassName=<%=bgname%>&page=<%=i %>&modi=新聞'><%=i %></a>] <% } } %>
    </div></td>
    </tr>
    </table>
    </form>
    <form name="form1" method="post" action="Hanye_Manage.jsp"> <table width="51%" cellspacing="0" cellpadding="0">
    <tr>
    <td width="34%" height="23"><span>查詢:</span>
    <label>
    <select name="select">
    <option value="ID">按ID查詢</option>
    <option value="title">按標(biāo)題查詢</option>
    <option value="times">按時間查詢</option>
    </select>
    </label>
    <label>
    <input type="text" name="k">
    <input name="Submit" type="submit" value="提交">
    </label> </td>
    </tr>
    </table>
    </form>
    <br></td>
    </tr>
    </table>
    <%
    RsArticle.close();
    stmt_Article.close();
    conn.close();
    %>
    </body>
    </html>
    希望本文所述對大家的jsp程序設(shè)計有所幫助。