jsp分頁顯示完整實(shí)例

當(dāng)前位置：首頁 > 范文|應(yīng)用文 > IT技術(shù)專欄 > 網(wǎng)絡(luò)編程

jsp分頁顯示完整實(shí)例

來源：易賢網(wǎng) 閱讀：1013 次日期：2015-02-04 15:07:44

溫馨提示：易賢網(wǎng)小編為您整理了“jsp分頁顯示完整實(shí)例”,方便廣大網(wǎng)友查閱！

這篇文章主要介紹了jsp分頁顯示完整實(shí)例,以文章管理頁面為例詳細(xì)分析了jsp的分頁顯示實(shí)現(xiàn)技巧,具有一定參考借鑒價(jià)值,需要的朋友可以參考下

本文實(shí)例講述了jsp分頁顯示的實(shí)現(xiàn)方法。分享給大家供大家參考。

具體實(shí)現(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 >

<head>

</head>

<body>

</tr>

<tr>

</td>

</tr>

<td height=25 background=images/admin_bg_1.gif class=t2>|

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)閉記錄集對(duì)象

stmta.close(); //關(guān)閉語句對(duì)象

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

int pagesize=10; //每頁顯示的文章數(shù)

int showpage=1; //當(dāng)前頁面顯示的頁號(hào)

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();//去除最后一行的行號(hào)

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);

<td align=center bgcolor=#bbdaff ><a href=/<%=img%> target=_blank><%=img%></a></td>

<td width=64 align=center bgcolor=#bbdaff class=style1><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;

}

</table>

</span>

<label>

</label>

</td>

共<%=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>

<label>

<option value=id>按id查詢</option>

</select>

</label>

<label>

</label> </td>

</tr>

</table>