<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../incoming/connDB.jsp"%>
<html>
<head></head>
<body>
<%
//数据库连接
int curpage=1;//当前页
int page_record=20;//每页显示的记录数
curpage=Integer.parseInt(request.getParameter("page"));//获取传递的值,需要显示的页
smt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//Statement smt_fy=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//smt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //ResultSet rs_fy=smt_fy.executeQuery("select count(*) from message");
rs=smt.executeQuery("select top "+page_record+" * from message where id not in (select top "+(curpage*page_record)+" id from message order by id desc) order by id desc");
//本查询语句得到的是所要显示的1000页的20条记录,大致思路为——子查询排除
//需要显示的记录前的所有记录,父查询则对余下的记录进行降序排列
rs.last();
while(rs.next()) {
%>
<table width="75%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">标题:<%=rs.getString("title")%></div></td>
</tr>
<tr>
<td><div align="center"></div></td>
</tr>
<tr>
<td><hr width="85%"></td>
</tr>
</table>
<%}
rs.close();
%>
</body>
</html>
<%@ include file="../incoming/connDB.jsp"%>
<html>
<head></head>
<body>
<%
//数据库连接
int curpage=1;//当前页
int page_record=20;//每页显示的记录数
curpage=Integer.parseInt(request.getParameter("page"));//获取传递的值,需要显示的页
smt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//Statement smt_fy=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
//smt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //ResultSet rs_fy=smt_fy.executeQuery("select count(*) from message");
rs=smt.executeQuery("select top "+page_record+" * from message where id not in (select top "+(curpage*page_record)+" id from message order by id desc) order by id desc");
//本查询语句得到的是所要显示的1000页的20条记录,大致思路为——子查询排除
//需要显示的记录前的所有记录,父查询则对余下的记录进行降序排列
rs.last();
while(rs.next()) {
%>
<table width="75%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">标题:<%=rs.getString("title")%></div></td>
</tr>
<tr>
<td><div align="center"></div></td>
</tr>
<tr>
<td><hr width="85%"></td>
</tr>
</table>
<%}
rs.close();
%>
</body>
</html>
while(rs.next())
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ include file="../incoming/connDB.jsp"%>
<%! String aTitle,aAuthor,AType,ArticleType,InsertTime,Color; %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>ArticleList</TITLE>
</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 pagesql;
java.sql.ResultSet pagers;
pagesql = "select count(id) as A from message";//取总文章数
pagers = smt.executeQuery(pagesql);
int allCol = pagers.getInt("A");//获得总页面数
allpage = (int)Math.ceil((allCol + ipage-1) / ipage);//判断参数pages是否为空
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 id from message order by a_id desc limit "+ spage +","+ ipage;
rs = smt.executeQuery(sql);
int cu=1;//循环取数据库值
while (rs.next()) {
int aID = rs.getInt("id");
aTitle = rs.getString("title");
aAuthor = rs.getString("username");
//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"; }
%>
<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>