java分页显示完整实例

互联网
努力从来不是为了证明自己努力，而是为了拥有更好的生活，能够保持向上的目标，生活才会是一部进化史。——杨熹文《请尊重一个女孩的努力》尽管生活带给我们的大多是失意，但失意不可怕，可怕的是失去自己。

本文实例讲述了jsp分页显示的实现方法。分享给大家供大家参考。

具体实现方法如下：

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>

<%@include file ="../inc/ChkPwd.jsp"%>

<%@include file="../DB.jsp"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta name="robots" content="noindex,nofollow" />

<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />

<title>文章管理</title>

<link rel="nofollow noopener noreferrer" href="Style.css" rel="stylesheet" type="text/css" />

</head>

<body>



<table width="98%" height="77%" border="0" cellpadding="0" cellspacing="0">

<tr class="STYLE1"> 

 <td width="100%" height="26" background="images/admin_bg_1.gif"><strong><font color="#FFFFFF">--<span class="STYLE1">内容管理</span></font></strong></td>

 </tr>

 <tr>

 <td colspan="10">

 </td>

 </tr>

 

 <tr class="title"> 

 <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.rel="nofollow noopener noreferrer" 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='行业新闻' order by id asc";

ResultSet RsA=stmtA.executeQuery(SqlA);

while (RsA.next()) {

 

%>

 <a class='t2' rel="nofollow noopener noreferrer" href='Hanye_Manages.jsp?modi=新闻&BigClassName=<%=RsA.getString("smallname")%>'><%=RsA.getString("smallname")%></a> | 

<%

}

RsA.close(); //关闭记录集对象

stmtA.close(); //关闭语句对象

%> 

</td>

 </tr>

 

<tr>

<td height="20"></td>

</tr>

 <tr> 

 <td align="center" valign="top" bgcolor="#ECF5FF">

 

<form name="form2" action="list.asp?action=delall&modi=新闻" method="post">

 <table width="100%" cellpadding="3" cellspacing="2" bgcolor="#FFFFFF" style="word-break:break-all">

 <tr class="t2"> 

 <td width="32" height="28" align="center" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" class="STYLE1" >ID</td>

 

 <td width="80" align="center" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" class="STYLE1" >新闻大类</td>

 

 <td width="88" align="center" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" class="STYLE1" >新闻小类</td>

 

 <td width="291" align="center" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" class="STYLE1" style="word-break:break-all" >新闻标题</td>

 

 <td width="179" align="center" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" class="STYLE1" >新闻图片</td>

 

 <td width="76" align="center" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" class="STYLE1" >发布时间</td>

 

 <td width="64" align="center" background="images/admin_bg_1.gif" bgcolor="#BBDAFF" class="STYLE1">操作</td>

 </tr>

<%

int pageSize=10; //每页显示的文章数

int showPage=1; //当前页面显示的页号

int recCount=0; //ResultSet中的文章总数

int pageCount=0; //分页后的总页数

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 class="STYLE1"> 

 <td width="32" height="22" align="center" bgcolor="#BBDAFF"><%=NID%></td>

 

 <td align="center" bgcolor="#BBDAFF" ><%=RsArticle.getString("bigname")%></td>

 

 <td align="center" bgcolor="#BBDAFF" ><%=RsArticle.getString("smallname")%></td>

 

 <td align="left" bgcolor="#BBDAFF" ><%=RsArticle.getString("Title")%></td>

 

 <td align="center" bgcolor="#BBDAFF" ><a rel="nofollow noopener noreferrer" href="/<%=img%>" target="_blank"><%=img%></a></td>

 

 <td align="center" bgcolor="#BBDAFF" ><%=ttt%></td>

 

 <td width="64" align="center" bgcolor="#BBDAFF" class="STYLE1"><a rel="nofollow noopener noreferrer" href="Hanye_edit.jsp?id=<%=NID%>&modi=新闻">修改</a>|<a rel="nofollow noopener noreferrer" href="Hanye_Manages.jsp?id=<%=NID%>&op=del&BigClassName=<%=bgname%>" onclick="return confirm('删除后将不能恢复，你确定删除么？')">删除</a></td>

 </tr>

<%

if(!RsArticle.next())

 break;

} 

}

%> 

 

 <input name='AllID' type='hidden' value=>

 

 </table>

 <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">

 <tr class="STYLE1"> 

 <td width="50%" align="left" background="images/admin_bg_1.gif">

 <span class="t2"><strong></strong>

 

 </span>

 <label>

 

 </label>

 </td>

 <td width="56%" align="center" background="images/admin_bg_1.gif">

 <div align="left" class="t2">

 共<%=pageCount%>页 <% for(int i=1;i<=pageCount;i++){ %> <% if(i==showPage){ %><b><%=i %></b><% }else{ %>[<a rel="nofollow noopener noreferrer" 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%" border="0" cellspacing="0" cellpadding="0">



 <tr class="t4">

 <td width="34%" height="23"><span class="STYLE1">查询：</span>

 <label>

 <select name="select">

 <option value="ID">按ID查询</option>

 <option value="title">按标题查询</option>

 <option value="times">按时间查询</option>

 </select>

 </label>

 <label>

 <input type="text" name="k">

 <input name="Submit" type="submit" class="t5" value="提交">

 </label> </td>

 </tr>

 </table>

</form> 

 <br></td>

 </tr>

</table>


<%

RsArticle.close();

stmt_Article.close();

conn.close();

%>

</body>

</html>

希望本文所述对大家的jsp程序设计有所帮助。

到此这篇关于javascriptp分页显示完整实例就介绍到这了。没有口水与汗水，就没有成功的泪水。更多相关javascriptp分页显示完整实例内容请查看相关栏目，小编编辑不易，再次感谢大家的支持！

您可能有感兴趣的文章
Java 实例 - 字符串反转
Java实例--字符串替换
Java实例--删除字符串中最后一个字符
Java实例--查找字符串最后一次出现的位置
Java实例--字符串比较