先声明
下
本人也是刚学习JSP没多少时间期间得到了 何志强 先生
大力帮助解决了很多Java平台方面问题
对于分页这个问题
我试着以以前写ASP和PHP思路做了下是以纯JSP代码形式后来又写了个bean来实现实际结果发现2者速度没有多大差别(我是做了20000条记录分页:>)我还想试试servlet结果如何 有关分页
代码如下: //Author tar([email protected])
//您可以任意拷贝复制该代码,但请加上以上作者信息
//有任何问题请和我联系
//效果请看 http://210.77.144.64/kk/java/java/article.jsp
<%@ page import=\"java.sql.*\" %>
<%@ page import=\"java.io.*\" %>
<%@ page import=\"java.util.*\" %>
<jsp:useBean id=\"sqlconn\" scope=\"page\"
=\"kk.database.sqlconn\" /> <%! String aTitle,aAuthor,AType,ArticleType,InsertTime,Color; %>
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">
<HTML>
<HEAD>
<TITLE>ArticleList</TITLE>
<META NAME=\"Generator\" CONTENT=\"jBuilder3.5 && jEdit1.0\">
<META NAME=\"Author\" CONTENT=\"bigangell\">
<META NAME=\"Keywords\" CONTENT=\"Java,Servlet,Jsp,Beans,PHP\">
<META NAME=\"Description\" CONTENT=\"A Pure World For Programming Include C/C
,Java\"> <META HTTP-EQUIV=\"Content-Type\" CONTENT=\"text/html; CHARSET=gb2312\">
<link rel=\"stylesheet\" href=\"style.css\">
</head>
<body bgcolor=\"#FFFFFF\">
<table width=\"760\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
<tr>
<td>
<table width=\"750\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\" align=\"center\">
<tr align=\"center\">
<td> </td>
</tr>
<tr>
<td>
<table width=\"740\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" align=\"center\">
<tr align=\"center\" bgcolor=\"#CCCCCC\">
<td><b>标题</b></td>
<td><b>作者</b></td>
<td><b>类型</b></td>
<td><b>点击</b></td>
<td><b>加入时间</b></td>
</tr>
<%
i; ipage=10; //分页单位 allpage; //总页数 pages; //接受页码变量 cpage=1; //当前页 spage; //开始页 //数据库连接声明
java.lang.String sql,pagesql;
java.sql.ResultSet rs,pagers;
pagesql = \"select count(a_id) as A from article\";
//取总文章数
pagers = sqlconn.executeQuery(pagesql);
allCol = pagers.getInt(\"A\"); //获得总页面数
allpage = (
)Math.ceil((allCol + ipage-1) / ipage); //判断参数pages是否为空
(request.getParameter(\"pages\")
null) { pages=1;
}
{ pages =
Integer(request.getParameter(\"pages\")).Value
; }
//判断当前页
(pages > allpage // pages 0){ cpage = 1;
}
{ cpage = pages;
}
//判断起始页
spage=(cpage-1)*ipage;
sql = \"select a_id,a_title,a_author,aID,a_time,a_readtime,sID from article order by a_id desc limit \"+ spage +\",\"+ ipage;
rs = sqlconn.executeQuery(sql);
cu=1; //循环取数据库值
while (rs.next
) { aID = rs.getInt(\"a_id\"); aTitle = rs.getString(\"a_title\");
aAuthor = rs.getString(\"a_author\");
ArticleTypeID = rs.getInt(\"aID\"); ReadTime = rs.getInt(\"a_readtime\"); InsertTime = rs.getString(\"a_time\");
(cu % 2 0) { Color=\"#DBECFD\"; } { Color=\"#C6E1FD\"; } switch (ArticleTypeID) {
(1): ArticleType=\"小说\";
; (2): ArticleType=\"散文\";
; (3): ArticleType=\"诗歌\";
; (4): ArticleType=\"随笔\";
; }
%>
<tr bgcolor=\"<%= Color %>\">
<td width=\"300\"><a href=\"viewarticle.jsp?aID=<%= aID %>\"><%= aTitle %></a></td>
<td align=\"center\" width=\"100\"><%= aAuthor %></td>
<td align=\"center\" width=\"50\"><%= ArticleType %></td>
<td align=\"center\" width=\"50\"><%= ReadTime %></td>
<td align=\"center\" width=\"240\"><%= InsertTime %></td>
</tr>
<%
cu
; }
%>
<tr bgcolor=\"#CCCCCC\">
<td colspan=\"5\" align=\"right\" valign=\"middle\">共 <%= allCol %>条记录 共 <%= allpage %>页 <%
(cpage>1) { %><a href=\"article.jsp?pages=<%= cpage-1 %>\"><img src=\"http://www./Files/BeyondPic/2007-6/27/0762713033477735.g\" border=\"0\"></a><% } (cpage<allpage) { %><a href=\"article.jsp?pages=<%= cpage+1 %>\"><img src=\"http://www./Files/BeyondPic/2007-6/27/0762713033443937.g\" border=\"0\"></a><% } %> / <% for (i=1;i<=allpage;i) { (i != pages) {%><a href=\"article.jsp?pages=<%= i %>\"><%= i %></a> <% } }%></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
最新评论