📄 0210.htm
字号:
<html>
<head>
<title>新时代软件教程:操作系统 主页制作 服务器 设计软件 网络技术 编程语言 文字编辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body, table {font-size: 9pt; font-family: 宋体}
a {text-decoration:none}
a:hover {color: red;text-decoration:underline}
.1 {background-color: rgb(245,245,245)}
-->
</style>
</head>
<p align="center"><script src="../../1.js"></script></a>
<p align="center"><big><strong>Jsp分页实例代码</strong></big></p>
<div align="right">---摘自互联网</div>
<br>//Author tar（bigangell@yesky.com）<br>
//您可以任意拷贝复制该代码,但请加上以上作者信息<br>
//有任何问题请与我联系<br>
//效果请看 http://210.77.144.64/kk/java/java/article.jsp<br>
<br>
<br>
<%@ page import="java.sql.*" %> <br>
<%@ page import="java.io.*" %> <br>
<%@ page import="java.util.*" %><br>
<jsp:useBean id="sqlconn" scope="page" class="kk.database.sqlconn" /><br>
<%! String aTitle,aAuthor,AType,ArticleType,InsertTime,Color; %> <br>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><br>
<HTML><br>
<HEAD><br>
<TITLE>ArticleList</TITLE><br>
<META NAME="Generator" CONTENT="jBuilder3.5 && jEdit1.0"><br>
<META NAME="Author" CONTENT="bigangell"><br>
<META NAME="Keywords" CONTENT="Java,Servlet,Jsp,Beans,PHP"><br>
<META NAME="Description" CONTENT="A Pure World For Programming Include C/C++,Java"><br>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=gb2312"><br>
<link rel="stylesheet" href="style.css"><br>
</head><br>
<br>
<body bgcolor="#FFFFFF"><br>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center"><br>
<tr><br>
<td><br>
<table width="750" border="0" cellspacing="2" cellpadding="2" align="center"><br>
<tr align="center"><br>
<td> </td><br>
</tr><br>
<tr><br>
<td><br>
<table width="740" border="0" cellspacing="1" cellpadding="1" align="center"><br>
<tr align="center" bgcolor="#CCCCCC"> <br>
<td><b>标题</b></td><br>
<td><b>作者</b></td><br>
<td><b>类型</b></td><br>
<td><b>点击</b></td><br>
<td><b>加入时间</b></td><br>
</tr><br>
<%<br>
int i;<br>
int ipage=10; //分页单位<br>
int allpage; //总页数<br>
int pages; //接受的页码变量<br>
int cpage=1; //当前页<br>
int spage; //开始页 <br>
<br>
<br>
//数据库连接声明<br>
java.lang.String sql,pagesql; <br>
java.sql.ResultSet rs,pagers; <br>
pagesql = "select count(a_id) as A from article";<br>
<br>
//取总文章数<br>
pagers = sqlconn.executeQuery(pagesql);<br>
int allCol = pagers.getInt("A");<br>
<br>
//获得总页面数<br>
allpage = (int)Math.ceil((allCol + ipage-1) / ipage);<br>
<br>
//判断参数pages是否为空<br>
if (request.getParameter("pages")==null) {<br>
pages=1;<br>
} else {<br>
pages = new Integer(request.getParameter("pages")).intValue();<br>
}<br>
<br>
//判断当前页<br>
if(pages > allpage // pages == 0){<br>
cpage = 1;<br>
} else {<br>
cpage = pages;<br>
}<br>
<br>
//判断起始页<br>
spage=(cpage-1)*ipage; <br>
<br>
sql = "select a_id,a_title,a_author,aID,a_time,a_readtime,sID from article order by a_id desc limit "+ spage +","+ ipage; <br>
rs = sqlconn.executeQuery(sql);<br>
int cu=1;<br>
<br>
//循环取数据库值<br>
while (rs.next()) {<br>
int aID = rs.getInt("a_id");<br>
aTitle = rs.getString("a_title");<br>
aAuthor = rs.getString("a_author");<br>
int ArticleTypeID = rs.getInt("aID");<br>
int ReadTime = rs.getInt("a_readtime"); <br>
InsertTime = rs.getString("a_time"); <br>
if (cu % 2 == 0) { Color="#DBECFD"; }<br>
else { Color="#C6E1FD"; }<br>
switch (ArticleTypeID) {<br>
case(1):<br>
ArticleType="小说";<br>
break;<br>
case(2):<br>
ArticleType="散文";<br>
break;<br>
case(3):<br>
ArticleType="诗歌";<br>
break;<br>
case(4):<br>
ArticleType="随笔";<br>
break; <br>
} <br>
%><br>
<tr bgcolor="<%= Color %>"> <br>
<td width="300"><a href="viewarticle.jsp?aID=<%= aID %>"><%= aTitle %></a></td><br>
<td align="center" width="100"><%= aAuthor %></td><br>
<td align="center" width="50"><%= ArticleType %></td><br>
<td align="center" width="50"><%= ReadTime %></td><br>
<td align="center" width="240"><%= InsertTime %></td><br>
</tr><br>
<%<br>
cu++;<br>
}<br>
%> <br>
<tr bgcolor="#CCCCCC"><br>
<td colspan="5" align="right" valign="middle">共 <%= allCol %>条记录 共 <%= allpage %>页 <% if (cpage>1) { %><a href="article.jsp?pages=<%= cpage-1 %>"><img src="images/prev.gif" border="0"></a><% } if (cpage<allpage) { %><a href="article.jsp?pages=<%= cpage+1 %>"><img src="images/next.gif" border="0"></a><% } %> / <% for (i=1;i<=allpage;i++) { if (i != pages) {%><a href="article.jsp?pages=<%= i %>"><%= i %></a> <% } }%></td><br>
</tr><br>
</table><br>
</td><br>
</tr><br>
</table><br>
</td><br>
</tr><br>
</table><br>
</body><br>
</html>
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -