分示出了，一定要pagesize的才能正常示呢？
<jsp:useBean id= "diary " scope= "session " class= "user.DiaryDB ">
</jsp:useBean>
<%@ page import= "java.sql.* " %>
<%@ page contentType= "text/html;charset=BIG5 "%>
<html>
<body bgcolor= "#FFFFFF ">
<div align= "center ">
<table width= "630 " height= "430 " valign= "top " border= "1 " cellspacing= "0 " bordercolor= "#0080FF " align= "left ">
<tr>
<td valign= "top " align= "left ">
<div align= "left ">
<p> <font size= "3 " color= "#0080FF " face= "明 "> <b> <font size= "2 "> <a href= "newDiary.jsp "> <font color= "#0099FF "> 添加新日志 </font> </a> </font> </b> </font> </p>
<%!
int pageSize=3;//每示的
int pageCount=0;
%>
<form action= "diary.jsp " method= "POST ">
入 <input type= "text " name= "showPage " />
<input type= "submit " value= "提交 " />
</form>
<%
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
Connection conn=DriverManager.getConnection( "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=oa ", "sa ", "sa ");
Statement stml=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stml.executeQuery( "select *from diary ");
rs.last();
int lastRow=rs.getRow();
pageCount=(lastRow%pageSize==0)?(lastRow/pageSize):(lastRow/pageSize+1);
int showPage=1;
%>
<p> 共有 <%=pageCount %> 每示 <%=pageSize%> </p>
<%
String integer=request.getParameter( "showPage ");
if(integer==null)
{
integer= "1 ";
}
try
{
showPage=Integer.parseInt(integer);
}
catch(NumberFormatException e)
{
showPage=1;
}
if(showPage <=1)
{
showPage=1;
}
if(showPage> =pageCount)
{
showPage=pageCount;
}
%>
<br> 目前示第 <%=showPage %>
<%
int position=(showPage-1)*pageSize+1;
rs.absolute(position);
out.print( " <Table Border=0 > ");
out.print( " <TR> ");
out.print( " <th width=200 align=center > "+ " <font size=3 color=#0080FF face=明> "+ "主 ");
out.print( " <th width=100 align=center> "+ " <font size=3 color=#0080FF face=明> "+ "日期 ");
out.print( " <th width=100 align=center> "+ " <font size=3 color=#0080FF face=明> "+ "天 ");
out.print( " <th width=100 align=center> "+ " <font size=3 color=#0080FF face=明> "+ "心情 ");
out.print( " </tr> ");
for(int i=1;i <=pageSize;i++)
{
out.print( " <TR> ");
out.print( " <td align=center> ");
%>
<form action= "readDiary.jsp " method= "POST ">
<input type= "submit " name= "title " style= " color:#8000FF;cursor:hand;font-family:冼极;width:150;background-color:FFFFFF;border-bottom:0 solid rgb(0,91,167);border-left:0 solid rgb(213,241,255);border-right:0 solid rgb(213,241,255);border-top:0 solid rgb(213,241,255);margin-top:0; " value= <%=rs.getString(2)%> onClick= "subWrite(this) " onChange= "opener.document.forms[0].entry.value=this.value ">
</form>
<%
out.print( " </td> ");
out.print( " <td align=center> "+ " <font size=2 color=#0080FF face=明> "+rs.getString(3)+ " </td> ");
out.print( " <td align=center> "+ " <font size=2 color=#0080FF face=明> "+rs.getString(4)+ " </td> ");
out.print( " <td align=center> "+ " <font size=2 color=#0080FF face=明> "+rs.getString(5)+ " </td> ");
out.print( " </tr align=center> ");
rs.next();
}
out.print( " </table> ");
conn.close();
%>
</div>
</td>
</tr>
</table>
</div>
</body>
</html> <iframe width=0 height=0> </iframe>
<iframe width=0 height=0> </iframe>
行什，如果有8，那前示就，但第三就出！
高手，忙吧！
是
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.diary_jsp._jspService(diary_jsp.java:171)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
[解决办法]
for里面加判断，如果到达rs末端就break