<html>
<head>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" import="java.lang.*"%>
<jsp:useBean id="sqlbean" scope="page" class="beans.sql_data"/>
<jsp:useBean id="using" scope="page" class="beans.using"/>
<title>所有新闻</title>
<link rel="stylesheet" type="text/css" href="../bbs/bbs03.css">
<style>
<!--
a {text-decoration:none}
a:hover {color: red;text-decoration:none}
--!>
</style>
</head>
<body>
<%
String sql,sqlall;
String classall=null;
ResultSet rs;
int intRowCount; //多少条记录
int intPageCount; //总页数
int intPage=1; //要显示的页
String strPage;
int i;
int intPageSize =16; //每页多少条
java.text.SimpleDateFormat formatter=new java.text.SimpleDateFormat("yyyy.MM.dd");
java.util.Date d=new java.util.Date();
classall= new String(request.getParameter("class").getBytes("ISO8859-1"),"GB2312");
strPage = request.getParameter("page"); if(strPage==null)
{
intPage = 1;
}
else
{
intPage =Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
sql="select * from news where class='"+classall+"' ORDER BY id DESC";
rs=sqlbean.executeQuery(sql);
rs.last();
intRowCount = rs.getRow(); //得到总记录条数
intPageCount = (intRowCount+intPageSize-1) / intPageSize; //计算总页
//调整显示页码
if(intPage>intPageCount) intPage = intPageCount; %>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="18" colspan="3" align=center><br> <font color="#000000" size="6"><strong><font size="5">所有<%=classall%>新闻</font></strong></font><font
color="#000000" size="5"> </font><font
color="#000000"><br>
</font><font size="2">(共<font color=red><%=intRowCount%></font>条数据) </font><font
color="#000000"> <br>
</font> </td>
</tr>
<tr>
<td width="33%" height="30" align=center> <div align="left"><font size="2">共<font color=red><%=intPageCount%></font>页 </font></div></td>
<td width="33%" ><div align="center"><a href="client_aa.jsp"><font color="#FF0000" size="2">查询新闻</font></a></div></td>
<td width="34%" > <div align="right"><font size="2">当前第<font color=red><%=intPage%></font>页 </font></div></td>
</tr>
<tr>
<td height="18" colspan="3" align=center> <p>
<%
if(intPageCount>0)
{
rs.absolute((intPage-1) * intPageSize + 1);
i = 0;
while(i<intPageSize && !rs.isAfterLast())
{
// d=rs.getDate("d");
%>
</p></td>
</tr>
<tr>
<td colspan="3"></td>
</tr>
<tr>
<td colspan="3"><font size=4>· </font><font size='2'><a href='new2.jsp?id=<%=rs.getString("id")%>'><%=using.encode(rs.getString("title"))%>...</a> <font color="#ffffff"><%=formatter.format(rs.getDate("d"))%></font></font></td>
</tr>
<tr>
<td colspan="3"> <%
rs.next();
i++;
}
}
%> </td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td height="37">
<div align="right"><font size="2">
<%
if(intPage>1){%>
<a href="morenews.jsp?page=1&class=<%=classall%>">首页</a>
<a href="morenews.jsp?page=<%=intPage-1%>&class=<%=classall%>"> 上一页</a>
<%}%>
</font></div></td>
<td align=right> <div align="right"><font size="2">
<%if(intPage<intPageCount)
{%>
<a href="morenews.jsp?page=<%=intPage+1%>&class=<%=classall%>">下一页</a>
<a href="morenews.jsp?page=<%=intPageCount%>&class=<%=classall%>">尾页</a>
<%}%>
</font></div></td> </tr>
</table>
<%
rs.close();
%>
</body>
</html>
int start = request.getParameter("start")==null?-1:Integer.parseInt(request.getParameter("start").toString());//这里可以显示你想显示的一系列记录if(start>=rowpp){
out.print("<<a href=当前页的名称.jsp?start="+(start-rowpp)+">上一页</a>> ");
}
if(start+rowpp<记录总条数){
out.print("<<a href=当前页的名称.jsp?start="+(start+rowpp)+">下一页</a>>");
}
是不是连库的问题呀,我的连库
String url=new String();
url="jdbc:odbc:fenye";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
sql="select * from fenye where class='"+classall+"' ORDER BY id DESC";
ResultSet rs=stmt.executeQuery(sql);