IDC资讯中心
//author tar（bigangell@yesky.com）
//您可以任意拷贝复制该代码,但请加上以上作者信息
//有任何问题请与我联系
//效果请看 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” class=”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>
<%
int i;
int ipage=10;
int allpage;
int pages;
int cpage=1;
int spage;
java.lang.string sql,pagesql;
java.sql.resultset rs,pagers;
pagesql = “select count(a_id) as a from article”;
pagers = sqlconn.executequery(pagesql);
int allcol = pagers.getint(“a”);
allpage = (int)math.ceil((allcol + ipage-1) / ipage);
if (request.getparameter(“pages”)==null) {
pages=1;
} else {
pages = new integer(request.getparameter(“pages”)).intvalue();
}
if(pages > allpage // pages == 0){
cpage = 1;
} else {
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);
int cu=1;
while (rs.next()) {
int aid = rs.getint(“a_id”);
atitle = rs.getstring(“a_title”);
aauthor = rs.getstring(“a_author”);
int articletypeid = rs.getint(“aid”);
int readtime = rs.getint(“a_readtime”);
inserttime = rs.getstring(“a_time”);
if (cu % 2 == 0) { color=”#dbecfd”; }
else { color=”#c6e1fd”; }
switch (articletypeid) {
case(1):
articletype=”小说”;
break;
case(2):
articletype=”散文”;
break;
case(3):
articletype=”诗歌”;
break;
case(4):
articletype=”随笔”;
break;
}
%>
<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 %>页 <% 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>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
