<html>
<head>
<title>
success
</title>
</head>
<body bgcolor="#ffffff">
<h1>
</h1>
<%
Connection con;
MyDataBase mb=new MyDataBase();
con=mb.con();
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery("select * from liuyanban order by name desc");
rs.last();
int rowCount=rs.getRow();
if(rowCount==0)
{
out.print("当前没有任何留言!");
return;
}
String strCurPage=request.getParameter("page");
int curPage;
if(strCurPage==null)
{
curPage=1;
}
else
{
curPage=Integer.parseInt(strCurPage);
}
int countPerPage=5;
int pageCount=(rowCount+countPerPage-1)/countPerPage;
rs.absolute((curPage-1)*countPerPage+1);
if(curPage==1)
{
%>
第一页
上一页
<%
}
else
{
%>
<a href="success.jsp?page= <%=1%> "> 第一页 </a>
<a href="success.jsp?page= <%=curPage-1%> "> 上一页 </a>
<%
}
if(curPage=pageCount)
{
%>
下一页
最后页
<%
}
else
{
%>
<a href="success.jsp?page= <%=curPage+1%> "> 下一页 </a>
<a href="success.jsp?page= <%=pageCount%> "> 最后页 </a>
<%
} int i=0;
while((i <countPerPage )&&(!rs.isAfterLast()))
{
out.println(" <hr color=\"blue\" size=\"2\"> <br> ");
out.println("用户名:"+rs.getString("name"));
out.println(" ");
out.println(" ");
out.println("主题:"+rs.getString("title")+" <br> ");
out.println("内容:"+rs.getString("content")+" <br> ");
i++;
rs.next();
}
rs.close();
st.close();
con.close();
%>
</body>
</html> 红色部分应该是2个“=”。
<head>
<title>
success
</title>
</head>
<body bgcolor="#ffffff">
<h1>
</h1>
<%
Connection con;
MyDataBase mb=new MyDataBase();
con=mb.con();
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery("select * from liuyanban order by name desc");
rs.last();
int rowCount=rs.getRow();
if(rowCount==0)
{
out.print("当前没有任何留言!");
return;
}
String strCurPage=request.getParameter("page");
int curPage;
if(strCurPage==null)
{
curPage=1;
}
else
{
curPage=Integer.parseInt(strCurPage);
}
int countPerPage=5;
int pageCount=(rowCount+countPerPage-1)/countPerPage;
rs.absolute((curPage-1)*countPerPage+1);
if(curPage==1)
{
%>
第一页
上一页
<%
}
else
{
%>
<a href="success.jsp?page= <%=1%> "> 第一页 </a>
<a href="success.jsp?page= <%=curPage-1%> "> 上一页 </a>
<%
}
if(curPage=pageCount)
{
%>
下一页
最后页
<%
}
else
{
%>
<a href="success.jsp?page= <%=curPage+1%> "> 下一页 </a>
<a href="success.jsp?page= <%=pageCount%> "> 最后页 </a>
<%
} int i=0;
while((i <countPerPage )&&(!rs.isAfterLast()))
{
out.println(" <hr color=\"blue\" size=\"2\"> <br> ");
out.println("用户名:"+rs.getString("name"));
out.println(" ");
out.println(" ");
out.println("主题:"+rs.getString("title")+" <br> ");
out.println("内容:"+rs.getString("content")+" <br> ");
i++;
rs.next();
}
rs.close();
st.close();
con.close();
%>
</body>
</html> 红色部分应该是2个“=”。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货